Patient Experience iCare Exchange Snowflake Engineer

Reference No. R2841710

Position Title: Patient Experience iCare Exchange Snowflake Engineer
Department:  Patient ENGINEERING Lead
Location: Toronto, ON

About the Job

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.

Main Responsibilities

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.

• Ability to 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 (PR) 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 SchemaChange 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 best practices for version control and collaboration.

Healthcare Compliance and Patient Data Protection

• Maintain strict adherence to Sanofi Patient Services standards and compliance requirements.

• Ensure all solutions comply with PHI (Protected Health Information) and PII (Personally Identifiable Information) regulations.

• Implement GDPR-compliant data handling, storage, and processing practices.

• Maintain patient data safety and privacy as the highest priority in all technical decisions.

• Participate in compliance audits and implement remediation actions as needed.

• Stay current with healthcare data regulations including HIPAA, GDPR, and other applicable standards.

About You

Technical Skills

• Snowflake Expertise: Advanced proficiency in Snowflake architecture, features, and capabilities (i.e., Micro Partitioning, zero copy cloning, Time Travel, Caching).

• Proficiency in working with business, reporting and engineering teams to develop the industry leading data models using Dimensional/Datavault approaches.  Hands on experience with data modelling tools like Erwin/SQLDBM.

• SQL: Expert-level SQL skills with ability to write complex queries and optimize performance.

• Data Engineering: Strong understanding of data warehousing concepts, ETL/ELT processes.

• Security: Deep knowledge of Snowflake security features, access control, and data governance.

• Performance Optimization: Proven experience in query optimization, warehouse tuning, and cost management.

• CI/CD Tools: Hands-on experience with Terraform, Schema Builder, or similar infrastructure-as-code tools.

• Version Control: Proficiency with GitHub and collaborative development workflows.

• Programming: Experience with Python, JavaScript, or other scripting languages for automation.

About You

• Bachelor's degree required; advanced degree (MS, MBA) preferred.

• Minimum 5 years of experience in data integration, data engineering, or similar roles.

• Snowflake certified.

• Experience implementing security and compliance controls in cloud data platforms.

• Track record of delivering scalable, high-performance data solutions.

• Proficiency in SQL and database design principles.

• Strong analytical and problem-solving skills.

• Excellent communication skills and ability to translate technical concepts to non-technical stakeholders.

• Advanced skills in Agile delivery, product collaboration, compliance, and digital strategy.

• Fluent in English; an additional language is a plus.

Why Choose Us?

• Bring the miracles of science to life alongside a supportive, future-focused team.

• Discover endless opportunities to grow your talent and drive your career, whether it’s through a promotion or lateral move, at home or internationally.

• Enjoy a thoughtful, well-crafted rewards package that recognizes your contribution and amplifies your impact.

• Take good care of yourself and your family, with a wide range of health and wellbeing benefits including high-quality healthcare, prevention and wellness programs

Applications received after the official close date will be reviewed on an individual basis.

This position is for a new vacant role that is now open for applications.

AI Usage

"Artificial Intelligence” refers to any systems that use automated processes, including algorithms and machine learning, to analyze data and make predictions, inferences, decisions, or recommendations without direct human involvement. These systems may process personal information to identify patterns, improve services, or support decision-making. The Company may use Artificial Intelligence for purposes including, but not limited to, resume screening and hiring, scheduling interviews or meetings, conducting surveys, matching skills with potential job openings, interview scoring, ensuring compliance with regulations applicable to our industry, and activities related to performance evaluation. Information collected and processed by the Company’s Artificial Intelligence systems may include the personal information detailed above and calendar availability. It excludes the information collected and processed for monitoring purposes. You should contact Human Resources if you have a question or concern regarding your personal information. You can also contact Canada’s Privacy Officer via Sanofi’s data subject request portal,  Data Subject Rights Webform. The Data Subject Rights Webform can also be used to request access or correction of your personal information and file a complaint.

Sanofi is an equal opportunity employer committed to diversity and inclusion. Our goal is to attract, develop and retain highly talented employees from diverse backgrounds, allowing us to benefit from a wide variety of experiences and perspectives. We welcome and encourage applications from all qualified applicants.  Accommodations for persons with disabilities required during the recruitment process are available upon request.

#GD-SP ​
#LI-SP                        

#LI-Onsite    
#DBBCA

All compensation will be determined commensurate with demonstrated experience. Employees may be eligible to participate in Company employee benefit programs, and additional benefits information can be found here.

Toute compensation sera déterminée en fonction de l'expérience démontrée. Les employés peuvent être admissibles à participer aux programmes d'avantages sociaux de l'entreprise. Des informations supplémentaires sur les avantages sociaux peuvent être trouvées ici.