Senior Data Engineer & AI Specialist

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.

Location: Mississauga, CA

Posted Date: 3/3/2025