Data Engineer

Cardinal Health Canada; Vaughan; Hybrid; CAD 89,000 - 119,000; Full time

Job summary

Cardinal Health Canada is seeking a Data Engineer to develop and support reliable data solutions for reporting, analytics, and business decision-making. You will work within established architecture and own pipelines, data models, and deliverables with senior engineers and stakeholders.

The ideal candidate has hands-on SQL, data integration, data modeling, and cloud-based data platform experience to deliver scalable, well-documented solutions.

Qualifications

• Bachelor’s degree in Computer Science, Data Science, Information Systems, Engineering, or equivalent practical experience.
• 5+ years in data engineering, data integration, SQL development, or related field.
• Strong SQL skills and experience with data transformations.
• Experience with cloud-based data platforms such as GCP, AWS or Azure.
• Experience with version control and structured development practices.
• Excellent communication and ability to collaborate with technical and business teams.
• Experience with Python or similar data processing languages.

Responsibilities

• Develop, maintain, and support reliable data pipelines extracting data from multiple sources into the data warehouse.
• Build scalable data models applying standards for data consistency and performance.
• Automate recurring data-processing activities and improve workflows.
• Partner with analysts and stakeholders to understand requirements and deliver fit-for-purpose solutions.
• Document transformation rules, data lineage, and data quality issues; perform root-cause analysis.
• Write, test, and optimize SQL queries and data processing logic.
• Apply data security, privacy, governance, and compliance standards.
• Monitor pipelines and implement corrective actions; participate in code reviews and deployments.
• Create technical documentation for data assets and processes.

Skills

SQL development

Data integration

Data modeling

Cloud platforms

Education

Bachelor's degree or equivalent

Tools

Google Cloud Platform

BigQuery

Power BI

ETL tools

Job description

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.

For more information on what it is like to work for us, please watch our Cardinal Health - Wings.

This position is an 8-month contract role and a hybrid model with two days reporting to our head office in Vaughan, Ontario.

Your Contributions To The Organization Will Be

• 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
• undefined

This Job 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

Anticipated pay range:

$89,400 - $119,300

Bonus:

No

Position currently vacant:

Yes

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.

Candidates who are back-to-work, people with disabilities, without a college degree, and Veterans are encouraged to apply.

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/Affirmative Action 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.