Senior Data Engineer & AI Specialist

Pharma Medica Research Inc.; Mississauga; On-site; CAD 110,000 - 130,000; Full time

Job summary

Join a forward-thinking organization as a Senior Data Engineer & AI Specialist, where innovation meets technology. In this dynamic role, you will leverage your expertise in Azure cloud services and data engineering to design and maintain scalable data solutions. Your work will drive AI-driven automation and enhance data architectures, making a significant impact on healthcare research. With a commitment to inclusivity and professional growth, this company offers a supportive environment where your contributions will be valued. If you're passionate about optimizing data for actionable insights, this is the perfect opportunity for you.

Benefits

Fully paid benefit plan including healthcare

Generous Employee Milestones Awards Program

Corporate Discounts Program

Learning Support Programs

Opportunities for advancement

Qualifications

• 7+ years experience in data engineering and analytics.
• Strong understanding of modern data architectures and governance frameworks.

Responsibilities

• Design and implement scalable data solutions using Azure and Databricks.
• Optimize data ingestion and transformation workflows for efficiency.

Skills

Python (PySpark, Pandas, NumPy)

SQL (T-SQL, Spark SQL, Snowflake SQL)

Databricks

Snowflake

Data Engineering

AI & Machine Learning Integration

ETL/ELT Pipelines

Data Visualization

Azure Cloud Services

Education

Bachelor's degree in Computer Science

Tools

Azure Data Factory

Power BI

Tableau

Azure DevOps

Delta Lake

Job description

Get AI-powered advice on this job and more exclusive features.

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.

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

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

• Programming: Python (PySpark, Pandas, NumPy), SQL (T-SQL, Spark SQL, Snowflake SQL), and Scala.
• Databricks & Snowflake Expertise: Performance optimization, security, and data management.

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.
• Preferred Azure certifications:
• Azure Solutions Architect
• Power BI Data Analyst
• 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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering and Information Technology

Referrals increase your chances of interviewing at Pharma Medica Research Inc. by 2x

Get notified about new Data Engineer jobs in Mississauga, Ontario, Canada.

Richmond Hill, Ontario, Canada 6 days ago

Mississauga, Ontario, Canada CA$110,000.00-CA$130,000.00 4 hours ago

Software Engineer, Backend (All Levels / All Teams)

Software Engineer I, Entry Level (Fall 2024-Spring 2025) - Toronto

Toronto, Ontario, Canada CA$120,000.00-CA$190,000.00 1 month ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.