Talent.com
Senior Data Engineer & AI Specialist

Senior Data Engineer & AI Specialist

Pharma Medica Research Inc.Mississauga, ON, Canada
2 days ago
Job type
  • Full-time
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.
  • Preferred Azure certifications :
  • Azure Data Engineer Associate
  • Azure Solutions Architect
  • Power BI Data Analyst

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

    Create a job alert for this search

    Senior Data Engineer • Mississauga, ON, Canada