Senior Data Engineer & AI Specialist

ZipRecruiter; Mississauga; On-site; CAD 100,000 - 130,000; Full time

Job summary

A leading company in the healthcare sector is seeking a Senior Data Engineer & AI Specialist. The ideal candidate will design and maintain scalable data solutions using Azure technologies, focusing on ETL processes, AI integration, and data visualization. This role offers a dynamic environment for innovation and career growth, with a commitment to inclusivity and employee well-being.

Benefits

Healthcare

Dentalcare

Vision care

Life Insurance

Learning Support Programs

Qualifications

• 7+ years of experience in data engineering or analytics.
• Experience with ETL/ELT pipelines and cloud architectures.

Responsibilities

• Develop scalable ETL/ELT pipelines using Azure Data Factory.
• Design data lake architecture and optimize storage performance.
• Build interactive Power BI dashboards and advanced Tableau visualizations.

Skills

Data Engineering

AI & machine learning integration

Programming

Data Visualization

Education

Bachelor’s degree in Computer Science

Tools

Azure Data Factory

Databricks

Snowflake

Power BI

Tableau

Job description

Job Description

Pharma Medica Research (PMRI) Inc. is a Contract Research Organization that strives for innovation and original solutions in a highly regulated and competitive industry. If your career goals align with innovation and original thinking you will be the perfect candidate to be part of an inclusive, adaptable, and forward-thinking organization. Our reputation for delivering high quality research is outstanding. At PMRI we are committed to making a difference in healthcare and people’s lives. Come join our team!

About the Role

We are looking for an experienced Senior Data Engineer & AI Specialist to join our dynamic team. In this role, you will design, implement, and maintain scalable data solutions leveraging Azure cloud services, Databricks, Snowflake, and BI tools. Your expertise in ETL/ELT pipelines, AI-driven automation, and data visualization will be essential in driving innovation and delivering actionable insights for the business.

This is an exciting opportunity for a data expert who thrives in complex data environments, has a passion for AI & machine learning integration, and enjoys optimizing data architectures for performance and efficiency.

Key Responsibilities

Data Pipeline Development & Management

• Develop scalable ETL/ELT pipelines using Azure Data Factory to process diverse data sources.
• Optimize data ingestion, transformation, and orchestration workflows.
• Implement error handling, monitoring, and logging mechanisms for data reliability.
• Develop custom Azure Functions for specialized data processing.

Azure Data Lake Storage (ADLS) Gen2 Management

• Design data lake architecture following best practices (bronze, silver, gold layers).
• Implement data partitioning strategies and lifecycle management.
• Optimize storage performance and cost, ensuring secure access control.

Data Transformation & Processing

• Develop and optimize data transformations using Databricks (PySpark, Scala, SQL) & Snowflake.
• Implement Delta Lake for efficient data storage and reliability.
• Create dbt models, reusable macros, and automated dbt tests to ensure data quality.
• Optimize SQL & Spark queries for performance.

Process Automation & CI/CD

• Design automated workflows using Azure Logic Apps & Power Automate.
• Implement CI/CD pipelines using Azure DevOps for automated testing and deployment.
• Manage schema changes, infrastructure as code (IaC), and automated data quality checks.

Data Visualization & Reporting

• Build interactive Power BI dashboards and advanced Tableau visualizations.
• Implement row-level security (RLS) & optimized data models for reporting.
• Enhance report performance and semantic layer configurations.

What We’re Looking For

Required Technical Skills

• Azure Technologies: Azure Data Factory, Azure Data Lake (ADLS Gen2), Azure DevOps.
• Data Engineering & Development: ETL/ELT pipelines, big data processing, cloud architectures.
• Programming: Python (PySpark, Pandas, NumPy), SQL (T-SQL, Spark SQL, Snowflake SQL), and Scala.
• Databricks & Snowflake Expertise: Performance optimization, security, and data management.
• Visualization & Reporting: Power BI (DAX, Power Query, Dataflows) & Tableau (dashboarding, modeling).
• DevOps & Automation: Azure DevOps, Git, YAML pipelines, PowerShell, CLI automation.

Required Experience & Qualifications

• 7+ years of experience in data engineering, analytics, or related fields.
• Bachelor’s degree in Computer Science, Engineering, or a related discipline.
• Azure certifications:
• Azure Data Engineer Associate
• Azure Solutions Architect
• Power BI Data Analyst

Skills (Nice to Have)

• Experience in AI/ML integration, including NLP, Generative AI, or predictive analytics.
• Familiarity with data governance frameworks and privacy regulations (GDPR, HIPAA, etc.).
• Understanding of modern data architectures (Data Mesh, ELT vs. ETL, Snowflake best practices).
• Strong agile project management and leadership skills.

We offer:

• Competitive compensation plan
• A benefit plan that is fully paid for by PMRI, including healthcare, dentalcare, vision care, LTD, Life Insurance, AD&D, along with a Health Spending and Wellness Spending Accounts and a voluntary RRSP Contribution Plan
• Opportunities for advancement and career progression
• A generous Employee Milestones Awards Program
• Corporate Discounts Program
• Learning Support Programs
• Friendly atmosphere, culture of learning

Please note all applications must be eligible to work within Canada.

PMRI is an Equal Opportunity Employer; promoting accessibility and inclusivity at work and offering accommodation for applicants as required and requested.

We thank all applicants for their interest; however, only those selected to proceed in the interview process will be contacted.