Data Engineer
Cardinal Health, Inc.15 days ago
Vaughan, CanadaSenior
Responsibilities
- Develop, maintain, monitor, and troubleshoot reliable data pipelines that extract, transform, validate, and load data from multiple source systems into a data warehouse.
- Build and maintain scalable, accurate, performant, and accessible data models using established modeling standards.
- Automate recurring data-processing activities and improve existing workflows.
- Partner with analysts, business stakeholders, source-system teams, and engineering teams to define requirements and deliver data solutions.
- Perform source-to-target analysis, document transformation rules and data lineage, reconcile results, and investigate data discrepancies.
- Write, test, and optimize SQL queries, transformations, and data-processing logic.
- Apply data security, privacy, governance, and compliance standards.
- Investigate pipeline failures and data-quality issues, perform root-cause analysis, and implement corrective and preventive actions.
- Create and maintain technical documentation for data assets, processes, dependencies, and operational procedures.
- Participate in code reviews, testing, deployment, and continuous improvement of data engineering practices.
Requirements
- 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, 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 with version control and structured development, testing, and deployment practices.
- Ability to analyze data issues, identify root causes, and implement practical solutions.
- Effective written and verbal communication skills and 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 with appropriate validation of generated outputs.
- Preferred experience with Google Cloud Platform, BigQuery, Looker, Tableau, Power BI, Celonis or similar process-mining platforms, SAP data structures, data orchestration, data quality, metadata management, CI/CD practices, machine learning, generative AI, agentic AI, or relevant healthcare, pharmaceutical, distribution, supply-chain, or commercial analytics environments.
Benefits
- Hybrid work model requiring two days reporting to the head office in Vaughan, Ontario.
- Eligible for a performance-based annual bonus; awards are not guaranteed and depend on individual performance, company performance, and other business factors.
- Cardinal Health Canada provides an inclusive workplace and accommodations throughout the hiring process.
Tech Stack
Categories
Data Engineering
About Cardinal Health, Inc.
Cardinal Health is a public healthcare services company that distributes pharmaceuticals and medical products to hospitals, pharmacies, and healthcare providers, and manufactures a range of medical and laboratory supplies. It also operates nuclear pharmacies and offers data and performance solutions for healthcare operations. Founded in 1971 and headquartered in Dublin, Ohio, Cardinal Health trades on the NYSE under the ticker CAH and serves customers globally across care settings.