Principal Engineer Data Solutions
$120k - $150k per yearAffinity
Location : Preference to have candidates based in Toronto, next best, candidates would be located in Vancouver. Hybrid work environment of 1 - 2 days onsite.
On behalf of our client, Affinity is seeking a Principal Engineer, Data Solutions who will hold a senior technical leadership position, responsible for ensuring the quality, scalability, and effectiveness of data and analytics solutions within Enterprise Data & Analytics function. This role serves as the technical right-hand. You will set standards, mentor team members, evaluate complex solutions, and deliver hands‑on technical work for the organization's most challenging data problems.
Individual contributor role
Key ResponsibilitiesTechnical Leadership & Standards (40%)
Set the Technical Bar : Define and enforce standards for data modeling, analytics engineering, and BI development across all Data Solutions squads
Solution Evaluation : Review and validate technical designs for major initiatives, ensuring architectural soundness and alignment with enterprise patterns
Vendor Management : Evaluate proposals from consulting partners and technology vendors;
hold vendors accountable for quality and delivery
Quality Assurance : Conduct code reviews, model reviews, and technical assessments to maintain high standards in alignment with governance best practices
Hands‑On Technical Delivery (35%)
Build Reference Implementations : Create exemplary data models, dbt projects, and BI dashboards that serve as templates for the organization
Solve Complex Problems : Tackle technical challenges beyond current team capabilities, from advanced SQL optimization to complex dimensional modeling
Develop Data Models : Design and implement scalable, well‑documented data models using dbt, Snowflake/Fabric, and modern analytics engineering practices
Hands‑On Coding : Write production SQL, Python, and data transformation logic daily (60%+ hands‑on work)
Upskill Data Analysts/Product Managers : Teach effective due diligence, solution design, and technical requirement translation
Mentor Analytics Engineers : Provide structured guidance on data modeling patterns, dbt best practices, and analytical thinking
Conduct Training : Lead technical workshops, lunch‑and‑learns, and documentation initiatives
Foster Technical Culture : Build a culture of engineering excellence, continuous learning, and quality‑first thinking
Qualifications
6-8+ years in analytics engineering, data engineering, business intelligence, or related technical roles
Vendor/partner management experience evaluating and holding consulting firms or technology vendors accountable
Mentorship experience upleveling junior and mid‑level data professionals
Core Technical Expertise
Expert‑level SQL (complex queries, optimization, window functions, CTEs)
Data modeling and dimensional design (star schema, snowflake, data vault)
dbt (data build tool) or equivalent transformation frameworks
Modern cloud data warehouses (Fabric, Databricks)
Power BI or Tableau (DAX, calculated fields, performance optimization)
Python for data analysis and automation
Apache Airflow or similar orchestration tools
Git/version control and CI/CD practices
Data quality, testing, and observability frameworks
Data governance and security best practices
Technical Judgment : Can evaluate solutions and articulate trade‑offs clearly;
knows when to be pragmatic vs. principled
Teaching Ability : Can explain complex technical concepts to non‑technical audiences and mentor others effectively
Hands‑On Mindset : Prefers writing code to drawing diagrams;
leads by example
Intellectual Curiosity : Stays current with modern data practices;
eager to learn and experiment
Ownership Mentality : Takes pride in quality;
doesn't ship "good enough" when excellence is achievable
Enterprise Data Architecture & Delivery Excellence
7+ years of experience designing, building, and operationalizing enterprise‑scale data platforms within large, complex organizations (ideally $1B+ in annual revenue). Proven ability to translate business strategy into scalable data architectures that support analytics, reporting, and advanced use cases across multiple stakeholder groups.
Advanced Data Modeling & Semantic Design Expertise
7+ years of experience with modern data modeling approaches, including dimensional modeling, Data Vault, and metrics/semantic layers. Strong understanding of how to design models that balance performance, scalability, governance, and ease of consumption for downstream analytics, BI, and data science teams.
Modern Data Stack Implementation Experience
7+ years of production experience working with leading cloud data platforms and tools such as dbt, Snowflake, Databricks, or Microsoft Fabric (Preference given to candidates with direct Fabric and Azure ecosystem experience). Highly proficient in SQL and Python, with a proven track record of building reliable, testable, and maintainable data pipelines in production environments.
Stakeholder Management & Business Partnership
Strong stakeholder management skills with the ability to translate complex business requirements into practical, scalable technical solutions. Proven experience partnering with business leaders, product owners, and engineering teams, while confidently challenging assumptions, managing expectations, and pushing back when requirements conflict with architectural standards, timelines, or long‑term platform sustainability.
Salary range: $120K - $150K
Affinity is an equal‑opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.
#J-18808-Ljbffr
On behalf of our client, Affinity is seeking a Principal Engineer, Data Solutions who will hold a senior technical leadership position, responsible for ensuring the quality, scalability, and effectiveness of data and analytics solutions within Enterprise Data & Analytics function. This role serves as the technical right-hand. You will set standards, mentor team members, evaluate complex solutions, and deliver hands‑on technical work for the organization's most challenging data problems.
Individual contributor role
Key ResponsibilitiesTechnical Leadership & Standards (40%)
Set the Technical Bar : Define and enforce standards for data modeling, analytics engineering, and BI development across all Data Solutions squads
Solution Evaluation : Review and validate technical designs for major initiatives, ensuring architectural soundness and alignment with enterprise patterns
Vendor Management : Evaluate proposals from consulting partners and technology vendors;
hold vendors accountable for quality and delivery
Quality Assurance : Conduct code reviews, model reviews, and technical assessments to maintain high standards in alignment with governance best practices
Hands‑On Technical Delivery (35%)
Build Reference Implementations : Create exemplary data models, dbt projects, and BI dashboards that serve as templates for the organization
Solve Complex Problems : Tackle technical challenges beyond current team capabilities, from advanced SQL optimization to complex dimensional modeling
Develop Data Models : Design and implement scalable, well‑documented data models using dbt, Snowflake/Fabric, and modern analytics engineering practices
Hands‑On Coding : Write production SQL, Python, and data transformation logic daily (60%+ hands‑on work)
Upskill Data Analysts/Product Managers : Teach effective due diligence, solution design, and technical requirement translation
Mentor Analytics Engineers : Provide structured guidance on data modeling patterns, dbt best practices, and analytical thinking
Conduct Training : Lead technical workshops, lunch‑and‑learns, and documentation initiatives
Foster Technical Culture : Build a culture of engineering excellence, continuous learning, and quality‑first thinking
Qualifications
6-8+ years in analytics engineering, data engineering, business intelligence, or related technical roles
Vendor/partner management experience evaluating and holding consulting firms or technology vendors accountable
Mentorship experience upleveling junior and mid‑level data professionals
Core Technical Expertise
Expert‑level SQL (complex queries, optimization, window functions, CTEs)
Data modeling and dimensional design (star schema, snowflake, data vault)
dbt (data build tool) or equivalent transformation frameworks
Modern cloud data warehouses (Fabric, Databricks)
Power BI or Tableau (DAX, calculated fields, performance optimization)
Python for data analysis and automation
Apache Airflow or similar orchestration tools
Git/version control and CI/CD practices
Data quality, testing, and observability frameworks
Data governance and security best practices
Technical Judgment : Can evaluate solutions and articulate trade‑offs clearly;
knows when to be pragmatic vs. principled
Teaching Ability : Can explain complex technical concepts to non‑technical audiences and mentor others effectively
Hands‑On Mindset : Prefers writing code to drawing diagrams;
leads by example
Intellectual Curiosity : Stays current with modern data practices;
eager to learn and experiment
Ownership Mentality : Takes pride in quality;
doesn't ship "good enough" when excellence is achievable
Enterprise Data Architecture & Delivery Excellence
7+ years of experience designing, building, and operationalizing enterprise‑scale data platforms within large, complex organizations (ideally $1B+ in annual revenue). Proven ability to translate business strategy into scalable data architectures that support analytics, reporting, and advanced use cases across multiple stakeholder groups.
Advanced Data Modeling & Semantic Design Expertise
7+ years of experience with modern data modeling approaches, including dimensional modeling, Data Vault, and metrics/semantic layers. Strong understanding of how to design models that balance performance, scalability, governance, and ease of consumption for downstream analytics, BI, and data science teams.
Modern Data Stack Implementation Experience
7+ years of production experience working with leading cloud data platforms and tools such as dbt, Snowflake, Databricks, or Microsoft Fabric (Preference given to candidates with direct Fabric and Azure ecosystem experience). Highly proficient in SQL and Python, with a proven track record of building reliable, testable, and maintainable data pipelines in production environments.
Stakeholder Management & Business Partnership
Strong stakeholder management skills with the ability to translate complex business requirements into practical, scalable technical solutions. Proven experience partnering with business leaders, product owners, and engineering teams, while confidently challenging assumptions, managing expectations, and pushing back when requirements conflict with architectural standards, timelines, or long‑term platform sustainability.
Salary range: $120K - $150K
Affinity is an equal‑opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.
#J-18808-Ljbffr
Vacancy posted 58 minutes ago
Similar jobs that could be interesting for youBased on the Principal Engineer Data Solutions in Winnipeg, MB vacancy
- Transform the AEC industry as a Principal Software Engineer at Autodesk, specializing in data solutions for generative AI. Work in a hybrid model from our Boston or Toronto offices. You will lead the development of cutting-edge data pipelines that enable advanced AI capabilities...Suggested
- Excel in a hands-on leadership role as a Principal Engineer of Data Solutions with Affinity, offering a hybrid work model in Toronto. Drive quality and innovation in analytics engineering. Affinity invites applications for a Principal Engineer Data Solutions to oversee quality...Suggested
- ...opportunity Who We're Looking For We’re looking for a hands-on Data Solution Architect to design and deliver scalable, secure, and reusable... ...to project teams during implementation Work closely with engineering teams to ensure designs are delivered as intended...SuggestedInternship
- ...| SERVICE | COLLABORATION We are seeking an experienced Data Solutions Lead to join our growing Data & Analytics team. In this role... ...proof-of-concept prototypes by applying expertise in data engineering, advanced analytics, process modelling, and optimization tools...Suggested
- ...expanding telecommunications firm, is seeking a highly experienced Principal Data Engineer to establish and lead their data infrastructure initiatives.... ...design, development, and maintenance of data warehousing solutions, data lakes, and ETL processes. The ideal candidate will...SuggestedRemote workHome office
$105k - $120k per year
...yr - CA$120,000.00/yrThe Opportunity We are looking for a Principal Data Engineer to join our Data and Analytics Group within the Technology... ...decisions, enhance operational efficiency, and deliver innovative solutions to our clients. By leveraging cutting-edge technologies and...Long term contractInternship- About the RoleWe are seeking an experienced Principal Software Engineer (Data) to join our fast-paced, collaborative data team. In this role, you will... ...Design and implement data architectures and storage solutions to efficiently handle massive data volumes Collaborate...
- Data Solutions EngineerLocation: Mississauga, ON, ca Company DescriptionWHO ARE WE? Dexterra Group (TSX: DXT)is a leading provider... ...operates and makes decisions. As a Data Solutions Engineer, you will design, build, and support data-centric solutions...InternshipRemote work
- ~12–18 years of overall Data Engineering experience ~8+ years of experience with enterprise Data Warehouse and Data Lake platforms ~5+ years of hands‑on experience with Databricks and Apache Spark at scale ~ Strong experience modernizing legacy Cloudera platforms including...
- Principal Data Engineer – Databricks | Spark | Delta Lake | PySpark | Data Lakehouse | AWS/AzureJob DescriptionLocation: Toronto Work Model:... ...and implement enterprise Data Lakehouse and Data Warehouse solutions. Build scalable, high-performance data pipelines and modern...
- Lead AI and data product architecture as a Principal Software Engineer, working remotely from Canada on scalable clinical research systems.This principal-level engineering... ...intelligence. You will design production-ready solutions for intelligent document processing, information...Remote work
$85.5k - $114k per year
Position Title: Principal Data Quality and Governance EngineerPosition Type: Regular - Full-Time... ...Principal Data Quality and Governance Engineer is responsible for helping ensure that enterprise... ...will work with you to find appropriate solutions. Your privacy is important to us. By...Full timeWork at officeRemote workWork from home2 days per week- ...organization committed to leveraging big data and advanced analytics to drive... ...innovation. We are seeking a highly experienced Principal Data Engineer to lead the design and implementation... ...pipelines, optimizing data storage solutions, and ensuring data quality and accessibility...
- Join ZoomInfo as a Principal Software Engineer to drive innovative data architectures. In this role, you will focus on building and optimizing systems that process... ...data extraction and processing pipelines • Architect solutions for handling massive datasets • Collaborate with data...
- Lead the evolution of high-scale Access Control solutions at Motorola Solutions. As a Principal Software Engineer, leverage cloud-native technologies and edge hardware to enhance security in real-time. In this leadership role, you will shape the technical vision for innovative...
- Lead innovation with Motorola Solutions as a Principal Software Engineer. This hybrid role focuses on architecture, C++, and AI-driven solutions for a safer future. At Motorola Solutions, we seek a Principal Software Engineer in Vancouver, BC, to drive hands-on technical leadership...
$103k - $153k per year
...Summary: HOOPP's Information Technology teams deliver innovative technology solutions to help build a stronger financial future for the healthcare community. As a Senior Data Solution Engineer, you will help keep HOOPP's investment data ecosystem reliable, governed, and ready...Long term contractPermanent employmentImmediate start- Design data integrations and Power BI solutions at Dexterra Group, connecting business needs with reliable technical delivery in a hybrid work model.As a Data Solutions Engineer, you will build and support data-centric solutions for reporting, applications, automations, and...
- Lead AI and data product engineering remotely from Canada, shaping scalable software for critical clinical... ...-on architectural leadership.This Principal Software Engineer role focuses on... ...EngineeringShape production-ready AI and data solutions through technical leadership,...Remote work
- Shape the future of AI at RAVL as a Principal Engineer specializing in AI solutions for financial services. Leverage your expertise to drive impactful, scalable applications in a supportive environment. This senior position places you at the forefront of AI delivery, where...
- Join Inworld as a Principal Engineer specializing in Natural Language Processing, driving AI innovations for the gaming industry. Collaborate... ...Language Models, positioning you as a key player in generative AI solutions. Work in Vancouver, Canada, or remotely if you're located in...Remote work
- Join Acceldata as a Lead Principal Engineer, driving innovation and setting strategic direction for our Open Data Platform. Your leadership in distributed systems will empower enterprises to trust their data. As the Lead Principal Engineer, you will bring over 14 years of...Long term contract
- Principal Data Engineer work in Toronto centers on Databricks, Apache Spark, and Lakehouse modernization. This onsite role requires four days weekly.This principal-level position leads enterprise data engineering initiatives across Databricks, Spark, Delta Lake, PySpark, and...Work at office
- ...API design will be crucial. You will create solutions that enhance customer interactions across... ...architecture and design • Collaborate with engineers to implement production-quality changes • Establish guidelines for API and data contracts • Ensure a high standard of uptime...
$210k - $240k per year
Acceldata is the market leader in Enterprise Data Observability. Founded in 2018 and... ...Analytics, and DataOps. Delivered as a SaaS solution, Acceldata is trusted by leading global... ...ABOUT USABOUT THE ROLEWe are seeking a Principal Engineer with at least 14 years of experience to...Long term contractWork at office$180k - $243k per year
...applications and next steps. Our partner is looking for a Principal Software Engineer (AI & Data Products) based in Canada (Remote). As a Principal... ...innovation through robust, production-ready AI and data solutions. Accountabilities: As a Principal Software Engineer...Long term contractRemote workusd227.8k per year
...power innovation. We lead in intelligent data infrastructure - delivering unified storage, integrated data services, and solutions that help organizations unlock the full potential... ...and exabyte-scale enterprise data. As a Principal Engineer for Datapath / Performance, you will own...Contract workInternshipWork at officeLocal area- Senior Solutions Principal, Data ManagementOur field sales professionals rely on proactive technical support during the sales process - and our expert Systems Engineering team always steps up to the mark. We lead the development and implementation of complex and specialized...Internship
- ...applications and next steps. Our partner is looking for a Principal Software Engineer (AI & Data Products) based in Canada (Remote). As a Principal... ...an opportunity to advance healthcare innovation through robust, production-ready AI and data solutions. #J-18808-Ljbffr...Long term contractRemote work
$85k - $90k per year
...Description Design and maintain scalable data pipelines that collect, transform and... ...understand data needs and deliver fit-for-purpose solutions. Review existing data processes and... ...or Diploma in Computer Science, Data Engineering, Information Systems, or related field....Permanent employment
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Principal Engineer Data Solutions. Be the first to apply!
Related searches
- mechanical engineering director Winnipeg, MB
- mechanical engineering project manager Winnipeg, MB
- directeur ingénierie Winnipeg, MB
- chief power engineer Winnipeg, MB
- director software engineering Winnipeg, MB
- project engineer assistant project manager Winnipeg, MB
- engineering project manager Winnipeg, MB
- chief engineer Winnipeg, MB
- general engineer Winnipeg, MB
- conseiller principal Winnipeg, MB

