Patient iCare Exchange Snowflake Engineer

Reference No . R

Position Title :
Patient Experience iCare Exchange Snowflake Engineer

Department: Patient ENGINEERING Lead

Location :
Toronto, ON

Join the digital engine driving Sanofi’s transformation – where AI, automation, and bold experimentation power faster science and smarter decisions. Here, you’ll help build the first biopharma company powered by AI at scale.

Sanofi is dedicated to chasing the miracles of science to improve people's lives. As a Patient Experience iCare Exchange Snowflake Engineer, you will play a critical role in building and maintaining secure, scalable, and compliant data solutions that directly support our patient services mission. This position combines deep technical expertise in Snowflake with a strong commitment to patient privacy, data security, and healthcare compliance standards.

You will be responsible for architecting, developing, and optimizing Snowflake-based data solutions that enable Sanofi to deliver exceptional patient experiences while maintaining the highest standards of data protection and regulatory compliance.

About Sanofi: We’re an R&D‑driven, AI‑powered biopharma company committed to improving people’s lives and delivering compelling growth. Our deep understanding of the immune system – and innovative pipeline – enables us to invent medicines and vaccines that treat and protect millions of people around the world. Together, we chase the miracles of science to improve people’s lives.

• Snowflake Platform Engineering
• Design and maintain robust Snowflake data solutions with strong SQL expertise and comprehensive knowledge of Snowflake architecture.
• Implement and optimize data models, schemas, and pipelines within the Snowflake environment.
• Translate complex technical concepts into understandable terms for non‑technical audiences.
• Participate in agile ceremonies including sprint planning, daily standups, and retrospectives.
• Leverage Snowflake features including streams, tasks, stored procedures, and user‑defined functions (UDFs).
• Manage Snowflake objects including databases, schemas, tables, views, and stages.
• Optimize warehouse configurations and resource monitors for performance and cost efficiency.
• Explore and implement Cortex Agents for automated data workflows.
• Stay current with emerging Snowflake AI/ML capabilities and evaluate applicability to patient services.
• Drive Data Mesh adoption to empower business domains with decentralized data ownership while ensuring interoperability and governance at scale.
• Deploy enterprise‑grade agentic solutions using Snowflake Cortex to enable self‑service analytics through conversational AI, natural language data exploration, and intelligent query assistance.
• Good to have:
  Design multi‑agent architectures incorporating Model Context Protocol (MCP), retrieval‑augmented generation, vector embeddings, agent orchestration frameworks, and observability tools for enterprise‑grade autonomous AI solutions.
• Code Quality and Best Practices
• Conduct thorough user story reviews to ensure technical feasibility and alignment with business requirements.
• Perform comprehensive code reviews and pull request reviews to maintain code quality standards.
• Enforce data engineering best practices, coding standards, and design patterns across the team.
• Establish and maintain documentation standards for all data solutions and processes.
• Implement data quality frameworks and validation processes.
• Participate in architectural design sessions and provide technical recommendations.
• Ensure solutions align with enterprise architecture standards and strategic technology roadmap.
• CI/CD and Infrastructure as Code
• Implement and maintain CI/CD pipelines using Schema Change and Terraform.
• Automate deployment processes for Snowflake objects and configurations.
• Manage version control and change management processes.
• Ensure deployment consistency across development, testing, and production environments.
• Data Transformation and DBT
• Utilize DBT (Data Build Tool) for data transformation workflows and analytics engineering.
• Develop and maintain DBT models, tests, and documentation.
• Implement modular and reusable data transformation logic.
• Leverage DBT…