Data Specialist in Ottawa

Mc Kesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare.

We are known for delivering insights, products, and services that make quality care more accessible and affordable.

Here, we focus on the health, happiness, and well-being of you and those we serve ? we care.

What you do at Mc Kesson matters.

We foster a culture where you can grow, make an impact, and are empowered to bring new ideas.

Together, we thrive as we shape the future of health for patients, our communities, and our people.

If you want to be part of tomorrow?s health today, we want to hear from you.

Mc Kesson Provider Solutions is seeking a highly motivated and hands-on Data Specialistto support the design, development, and optimization of enterprise-scale healthcare data platforms.

This role will play a critical part in building scalable data pipelines, modern analytics solutions, and cloud-based data engineering capabilities that power reporting, insights, and data-driven decision making across the organization.

The ideal candidate combines deep technical expertise in Databricks, SQL, Python, and modern Business Intelligence platforms such as Power BI and Tableau with a strong understanding of healthcare data.

This individual will collaborate closely with engineering, analytics, product, and business stakeholders to deliver reliable, high-performing, and scalable data solutions while ensuring compliance with healthcare data governance and regulatory requirements.

Key Responsibilities

• Design, develop, and maintain scalable data pipelines using Databricks, Delta Lake, Apache Spark, SQL, and Python.
• Build and optimize ETL/ELT processes to support enterprise reporting, analytics, and operational data needs.
• Develop efficient data models and database solutions to enable high-performance analytics and business intelligence workloads.
• Partner with Forward Deployed Engineer, business stakeholders, product teams, and analytics teams to translate business requirements into scalable data solutions.
• Ensure data quality, integrity, governance, and security across healthcare data platforms.
• Support ingestion, transformation, and integration of datasets relevant to business use cases.
• Implement data validation, monitoring, and observability processes to ensure data reliability and operational excellence.
• Design and support workflow orchestration solutions using Databricks Workflows, Apache Airflow, or similar tools.
• Contribute to cloud-based data modernization initiatives and enterprise analytics platforms.
• Develop and maintain CI/CD pipelines and deployment processes utilizing Git Hub and modern Dev Ops practices.
• Apply AI-assisted development tools to improve engineering productivity, code quality, testing, documentation, and overall delivery efficiency.
• Participate in Agile ceremonies including sprint planning, backlog refinement, estimation, and retrospectives.
• Troubleshoot complex data and performance issues and implement sustainable solutions.
• Collaborate effectively with cross-functional teams across engineering, architecture, product management, analytics, and operations.
• Minimum Requirements
• Degree Bachelor’s degree in Computer Science, Software Engineering, Information Systems, Data Science, or a related field or equivalent experience
• 4 years of relevant experience.
• Critical Skills
• 4 years of experience in data engineering, database engineering, software engineering, or a related technical discipline.
• 3 years of hands‑on experience with SQL and relational database technologies.
• 2 years of experience with Python development and automation.
• 2 years of experience with Databricks, Spark, or modern cloud-based data engineering platforms.
• Experience with Power BI and/or Tableau.
• Experience working in Agile development environments.
• Experience using Git Hub and CI/CD processes.
• Strong analytical, troubleshooting, and problem‑solving capabilities.
• Technical Skills Data Engineering & Platform Technologies
• Strong hands‑on experience with

Databricks , including Delta Lake and Apache Spark.

• Advanced proficiency in

SQL for complex queries, performance tuning, data modeling, and optimization.

• Strong programming expertise in

Python for automation, data processing, integration, and analytics.

• Experience designing and maintaining enterprise‑scale data pipelines and data processing frameworks.
• Experience with workflow orchestration platforms such as
• Databricks Workflows ,

Apache Airflow , or equivalent technologies.

• Understanding of modern data warehousing, lakehouse architectures, and analytics best practices.
• Strong knowledge of

Git Hub-based source control including branch protection policies, pull request reviews, release management, and version control best practices

• Experience implementing and maintaining
• CI/CD pipelines using
• Git Hub Actions to automate build, testing, security validation, and deployment processes
• Familiarity with automated testing, deployment automation, and infrastructure best practices
• Experience working within
• Agile software development methodologies
• Experience leveraging AI development tools such as Claude Code, Git Hub Copilot or equivalent solutions.
• Preferred Qualifications
• Experience working in Azure cloud environments.
• Familiarity with Databricks, Delta Lake, Lakehouse architectures, and modern data platform design.
• Experience supporting large-scale healthcare analytics platforms.
• Experience with healthcare interoperability standards such as HL7 or FHIR.
• Experience implementing data quality frameworks and data observability solutions.
• Experience supporting enterprise reporting modernization initiatives.
• Exposure to machine learning, predictive analytics, or AI-enabled healthcare solutions.

Working Conditions

• In office requirement, we are Flex and Connect with 2 days a week in office

We are proud to offer a competitive compensation package at Mc Kesson as part of our Total Rewards.

This is determined by several factors, including performance, experience and skills, equity, regular job market evaluations, and geographical markets.

The pay range shown below is aligned with Mc Kesson’s pay philosophy, and pay will always be compliant with any applicable regulations.

In addition to base pay, other compensation, such as an annual bonus or long-term incentive opportunities may be offered.

• For more information regarding benefits at Mc Kesson, please
• Our Base Pay Range for this position
• $81,500 – $108,600
• Mc Kesson is an Equal Opportunity Employer

Mc Kesson provides equal employment opportunities to applicants and employees, without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age, genetic information, or any other legally protected category.

For additional information on Mc Kesson?s full Equal Employment Opportunity policies, visit our page.

Mc Kesson is committed to being an Equal Employment Opportunity Employer and offers opportunities to all job seekers including job seekers with disabilities.

If you need a reasonable accommodation to assist with your job search or application for employment, please contact us by sending an email to (United States) or (Canada).

Join us at Mc Kesson!

#J-18808-Ljbffr