Senior Data Engineer

3 weeks ago

Mississauga Ontario CW, Peel region, Canada Pharma Medica Research Inc. Full time

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.

  • Data Engineer

    4 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada Centrilogic Full time

    Data Engineer Purpose: Over 15 years, we have become a premier global provider of multi-cloud management, cloud-native application development solutions, and strategic end-to-end digital transformation services. Headquartered in Canada and with regional headquarters in the U.S. and the United Kingdom, Centrilogic delivers smart, streamlined solutions to...

  • Senior Data Engineer

    3 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada Q1 Technologies, Inc. Full time

    Role: Data Engineer with Python and Snowflake ResponsibilitiesHands-on development experience with Snowflake features such as Snow SQL; Snow Pipe; Python; Tasks; Streams; Time travel; Zero Copy Cloning; Optimizer; Metadata Manager; data sharing; and stored procedures.Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.Need to...

  • Senior Software Engineer

    4 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada Open Systems Technologies Full time

    Open Systems Tech is looking for a Senior Software Engineer for one of our financial services clients based out of Mississauga/ON. This is a time sensitive opportunity, please apply ASAP.Job Title: Senior Software EngineerLocation: Mississauga – Hybrid – 3 days/weekTerm: Long term contract plus extensionWhat you’ll be doing:You’ll develop and take...

  • Python Data Engineer

    3 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada Synechron Full time

    We areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • Lead Python Data Engineer

    3 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada Synechron Full time

    We areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • Senior Java Software Engineer

    3 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada Alquemy Search & Consulting Full time

    Alquemy's client is a leading global financial services organization, they are seeking multiple Senior Java Developers to join their growing team. They offer a hybrid work environment with 3 days/week on site in Mississauga.Our client has a great culture and work environment with lots of opportunities for advancement.Responsibilities:Develop and enhance...

  • Electrical Engineer

    3 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada Rise Technical Full time

    Electrical EngineerMississauga, Ontario$115,000 - $130,000 + Progression + Excellent BenefitsAn excellent role on offer for an Electrical Engineer looking to join a market leading company, where you will undergo excellent training and development, whilst progressing to a senior role long-term.Have you got your Professional Engineering licence? Are you...

  • Piping Analysis Engineer

    3 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada OG7GES Indigenous Group Inc. Full time

    This position requires an individual who is self-motivated and capable of working independently or under the instruction from a senior technical engineer and develop his/her career and experience in nuclear field. The candidate shall be able to follow the instructions from a qualified professional engineer to complete the assigned mechanical related scopes...

  • Senior Project Engineer

    3 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada CHEP Full time

    Position PurposeDevelop and execute Non-Hire Stock Capital Engineering projects in support of CHEP North American Operations.Major/Key AccountabilitiesAssist in developing business cases for project sponsors.Develop project plans and successfully execute them in accordance with established schedule, cost and performance standards.Develop standards for CHEP...

  • Data Analyst

    4 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada OSL Retail Services Full time

    It’s an exciting time to be at OSL Retail Services, working for a people focused company that’s at the top of its game. The momentum we’ve generated in recent years with our commitments to client customers, innovation, business results, and an entrepreneurial spirit has created energy, enthusiasm, and engagement among our employees that is pushing us...

  • Genomics Software Engineer for Spatial Omics

    4 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada CirrusLabs Full time

    Job Title: Genomics Software Engineer for Spatial OmicsPreferred location: USA or CanadaStart date: ASAPAbout Us: CirrusLabs is a leading consulting firm based in Alpharetta, GA, specializing in delivering innovative technical solutions to clients across various industries. We are committed to excellence, agility, and exceeding customer expectations.Position...

  • Director, Engineering

    3 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada AtkinsRéalis Full time

    AtkinsRéalis is one of Canada's largest private sector nuclear engineering groups. We have been providing a wide range of services to the nuclear industry in Canada and around the world since for more than 60 years. We are proud to be the steward of Canadian CANDU nuclear technology.Candu Energy Inc. is looking to hire a Buenos Aires office Engineering...

  • Senior Business Analyst

    3 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada Synechron Full time

    We areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • Procurement Engineering Analyst/Engineer, Design Support

    3 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada AtkinsRéalis Full time

    AtkinsRéalis is one of Canada's largest private sector nuclear engineering groups. We have been providing a wide range of services to the nuclear industry in Canada and around the world since for more than 60 years. We are proud to be the steward of Canadian CANDU nuclear technology.We are actively seeking qualified professionals to support engineering...

  • Senior Java Developer

    3 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada Synechron Full time

    We areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • Consultant, Transit Fleet Engineering

    3 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada City of Mississauga Full time

    Req ID: 25517 Vacancy Type: Permanent Number of Positions: 1 Closing Date: 03/14/2025 Job Summary The City of Mississauga is seeking a highly experienced and detail-oriented Consultant, Transit Fleet Engineering to lead MiWay Transit’s fleet operations, ensuring the safety, reliability, and sustainability of our transit vehicles. Under the direction of...

  • Senior Java Developer

    3 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada Iris Software Inc. Full time

    Iris's direct client, one of the Canada’s Top financial institutions, is looking to hire a Senior Java Full Stack Developer for a long contract opportunity in Mississauga, ON (Hybrid Position). Please apply with your most recent resume if you would be interested..!Role: Senior Java Full Stack DeveloperLocation: Mississauga, ON (Hybrid Position – 2...

  • Senior Business Analyst

    3 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada Open Systems Technologies Full time

    Open Systems Tech is looking for a Senior Business Analyst (OTC) for one of our financial services clients. This is a time sensitive opportunity, please apply ASAP.Job Title: Senior Business AnalystLocation: Mississauga – Hybrid – 3 days/weekTerm: Long term contract plus extension Responsibilities: • 10+ years in financial services experience....

  • Software Development Sr Staff Engineer

    3 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada Synopsys Full time

    We Are: At Synopsys, we drive the innovations that shape the way we live and connect. Our technology is central to the Era of Pervasive Intelligence, from self-driving cars to learning machines. We lead in chip design, verification, and IP integration, empowering the creation of high-performance silicon chips and software content. Join us to transform the...

  • Quality Assurance Automation Engineer

    4 weeks ago

    Mississauga, Ontario, C4W, Peel region, Canada Synechron Full time

    We areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...