Data warehouse engineer Jobs in Vaughan, ON

Cardinal Health Canada, with over 1,300 employees nationwide, is an essential link in the Canadian healthcare supply chain, providing over 70,000 products to healthcare facilities and medical professionals across the country.

The Data & Analytics Function manages the analytics lifecycle, from data platforms and access through reporting, business intelligence, and advanced quantitative modeling. The function delivers relevant insights that inform business decisions, anticipate opportunities, and strengthen competitive advantage.

Data Engineering transforms raw data into trusted, accessible data products for reporting, analytics, and business decision‑making. The discipline includes data acquisition, integration, transformation, modeling, quality, and provisioning. Data Engineers combine technical expertise with an understanding of business processes to deliver timely, accurate, relevant, and actionable data solutions.

We are seeking a Data Engineer to develop and support reliable data solutions for reporting, analytics, and business decision‑making. This role works within established architecture and engineering standards while taking ownership of assigned pipelines, data models, and technical deliverables.

The ideal candidate has hands‑on experience with SQL, data integration, data modeling, and cloud‑based data platforms, and can collaborate effectively with senior engineers, analysts, and business stakeholders to deliver scalable, well‑documented solutions.

This position is a hybrid model with two days reporting to our head office in Vaughan, Ontario.

Job Responsibilities

• Develop, maintain, and support reliable data pipelines that extract, transform, and load data from multiple source systems into the data warehouse, including appropriate validation, error handling, and monitoring
• Build and maintain scalable data models that apply established modeling standards and promote data consistency, accuracy, performance, and accessibility
• Automate recurring data‑processing activities and improve the efficiency of existing workflows
• Partner with analysts and business stakeholders to understand data requirements and deliver fit‑for‑purpose solutions
• Collaborate across business, analytics, source‑system, and engineering teams to perform source‑to‑target analysis, document transformation rules and data lineage, reconcile results, and identify the root causes of data discrepancies
• Write, test, and optimize SQL queries, transformations, and data‑processing logic
• Apply established data security, privacy, governance, and compliance standards
• Monitor data pipelines, investigate failures and data‑quality issues, perform root‑cause analysis, and implement corrective and preventive actions with guidance on complex issues when needed
• Create and maintain technical documentation for data assets, processes, dependencies, and operational procedures
• Participate in code reviews, testing, deployment activities, and continuous improvement of data engineering practices

This role might be for you if:

• Bachelor’s degree in Computer Science, Data Science, Information Systems, Engineering, or a related field, or equivalent practical experience, preferred
• 5+ years of experience in data engineering, data integration, SQL development, or a related technical field, preferred
• Strong SQL skills and experience developing, testing, and troubleshooting data transformations
• Working knowledge of data warehousing concepts, dimensional data modeling, and ETL or ELT processes
• Experience developing or supporting data solutions on at least one cloud‑based data platform, such as Google Cloud Platform, Amazon Web Services, or Microsoft Azure
• Experience using version control and participating in structured development, testing, and deployment practices
• Ability to analyze data issues, identify root causes, and implement practical solutions
• Effective written and verbal communication skills, with the ability to collaborate across technical and business teams
• Ability to manage assigned work independently while seeking guidance on complex or ambiguous problems
• Experience with Python or another programming language used for data processing, automation, testing, or integration
• Experience using AI‑assisted development tools responsibly to support activities such as code generation, documentation, testing, troubleshooting, or technical research, with appropriate validation of generated outputs

Preferred Qualifications

• Experience with Google Cloud Platform, BigQuery, or comparable cloud data technologies
• Experience supporting business intelligence tools such as Looker, Tableau, or Power BI
• Experience integrating, modeling, or preparing data for process mining platforms such as Celonis or similar solutions
• Experience working with SAP data structures, master and transactional data, and enterprise business processes
• Exposure to data orchestration, data quality, metadata management, or CI/CD practices
• Knowledge of machine learning, generative AI, agentic AI, and the data architectures needed to support emerging analytics use cases
• Experience in healthcare, pharmaceutical, distribution, supply chain, or commercial analytics environments

Compensation

• Anticipated pay range: $89,400 - $119,300
• Bonus: Yes (performance‑based annual bonus, not guaranteed & determined by performance, company performance, and other business factors, in accordance with the company's bonus plan)
• Position currently vacant: Yes
• The salary range listed is an estimate. Pay at Cardinal Health is determined by multiple factors including, but not limited to, individual and company performance, experience, skills, and other business factors.

Equal Opportunity and Inclusion

• Cardinal Health is committed to employment equity and encourages applications from women, visible minorities, Indigenous peoples, and persons with disabilities.
• Cardinal Health is committed to accommodating applicants with disabilities throughout the hiring process, in accordance with the Accessibility for Ontarians with Disabilities Act (AODA).
• Our Human Resources team is responsible for working with applicants requesting accommodation at any stage of the hiring process.
• Cardinal Health Canada is proudly recognized as a Great Place to Work® in Canada. As an essential partner in Canadian healthcare, we strive every day to build a culture of inclusion and collaboration, where team members can be their authentic selves, grow in their careers, and be proud to serve our customer partners.
• Cardinal Health supports an inclusive workplace that values diversity of thought, experience and background. We celebrate the power of our differences to create better solutions for our customers by ensuring employees can be their authentic selves each day.
• Cardinal Health is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, ancestry, age, physical or mental disability, sex, sexual orientation, gender identity/expression, pregnancy, veteran status, marital status, creed, status with regard to public assistance, genetic status or any other status protected by federal, state or local law.

Privacy Notice

To read and review this privacy notice click here

Company Overview

• Headquartered in Dublin, Ohio, Cardinal Health, Inc. (NYSE: CAH) is a distributor of pharmaceuticals, a global manufacturer and distributor of medical and laboratory products, and a provider of performance and data solutions for healthcare facilities.
• We are a crucial link between the clinical and operational sides of healthcare, delivering end‑to‑end solutions and data‑driving insights that advance healthcare and improve lives every day.
• With deep partnerships, diverse perspectives and innovative digital solutions, we build connections across the continuum of care.
• With more than 50 years of experience, we seize the opportunity to address healthcare's most complicated challenges — now, and in the future.

View Cardinal Health on YouTube

#J-18808-Ljbffr