Job Description

Reference No. R2702110

Position Title: Lead Data Engineer - Sapphire

Department: Data Engineering

Location: Downtown area of Toronto, Ontario Canada

At Sanofi, we chase the miracles of science to improve people\xe2\x80\x99s lives. We believe our cutting-edge science and manufacturing, fueled by data and digital technologies, have the potential to transform the practice of medicine, turning the impossible into possible for millions of people.

As one of Canada\xe2\x80\x99s leading investors in life sciences, manufacturing and research and development, we focus on delivering new and better ways to address unmet medical needs. Our life-changing and lifesaving products are grounded in science that Canadians can trust. They empower self-care, prevent and treat diseases, and help people live better.

Our vision for digital, data analytics and AI

Sanofi has embarked into a vast and ambitious digital transformation program. A cornerstone of this roadmap is the acceleration of its data transformation and of the adoption of artificial intelligence (AI) and machine learning (ML) solutions. This has enabled us, to accelerate R&D, improve manufacturing and commercial performance, and bring novel drugs and vaccines to patients faster, all in order to improve health and save lives.

The Digital Team at Sanofi is a unique data-driven team. We pride ourselves on being data obsessed and highly focused on using state of the art processes along with global technologies to drive impact to our solutions. We measure our insights and products based on how they perform across the globe and hold ourselves to the highest regard as our solutions can impact millions of lives. When tackling a problem, we do not just ask how we will create a solution, but how we will create a solution that reaches across the world with the best possible societal outcome.

If you are passionate about improving the health and wellness of people across the globe using Data as your means, then you should look no farther than the Digital Team here at Sanofi. Join us on our journey in enabling Sanofi\xe2\x80\x99s Digital Transformation through becoming an AI first organization.

AI Factory - Versatile Teams Operating in Cross Functional Pods: Utilizing digital and data resources to develop AI products, bringing data management, AI and product development skills to products, programs and projects to create an agile, fulfilling and meaningful work environment.

Leading Edge Tech Stack: Experience build products that will be deployed globally on a leading-edge tech stack.

World Class Mentorship and Training: Working with renowned, leaders and academics in machine learning to further develop your skillsets.

What is Sapphire?

Sapphire is a global-level initiative with the following objective:

Excellence with latest Sanofi-wide technologies and right design

Simplify analytics Transform Vaccines US data & analytics with DASH modernization.

Ensure operational with drastic 80% reduction of reports.

Enable unified Sanofi US data environment integrating all data across GBU and customers.

Who You Are:

You are a dynamic Data Engineer interested in challenging the status quo to design and develop globally scalable solutions that are needed by Sanofi\xe2\x80\x99s advanced analytic, AI and ML initiatives for the betterment of our global patients and customers. You are a valued influencer and leader who has contributed to making key datasets available to data scientists, analysts, and consumers throughout the enterprise to meet vital business use needs. You have a keen eye for improvement opportunities while continuing to fully comply with all data quality, security, and governance standards.

Key Responsibilities:

Establish technical designs to meet business and technical requirements as a prime data engineering lead.

Develop and maintain all components of data engineering solutions and pipelines based on requirements and design specifications using appropriate tools and technologies.

Optimize solutions (ETL / data pipelines) to balance performance, functionality, cost, and other operational requirements.

Conduct peer reviews for quality, consistency, and rigor for production level solution.

Create design and development documentation based on standards for knowledge transfer, training, and maintenance.

Define and promote best practices and standards for code management, automated testing, and deployments.

Work with business and products teams to understand and decompose high level business requirements, and translate them into technical needs.

Leverage existing or create new standard data pipelines within Sanofi to bring value through business use cases.

Develop automated tests for CI/CD pipelines.

Test and validate developed solution to ensure it meets requirements and design specifications.

Mentor and train junior team members.

Assess and fix data pipeline issues to ensure performance and timeliness of execution.

Lead data engineering efforts to modernize and replace legacy solutions and platforms.

Partner with Data Engineering Manager, Product Owner and Data Analysts to create implementation plan, including assessments of timelines and complexity.

Gather/organize large & complex data assets, and perform relevant analysis.

Actively contribute to Data Engineering community and define leading practices and frameworks.

Communicate results and findings in a clear, structured manner to stakeholders at various levels.

Remains up to date on the company\xe2\x80\x99s standards, industry practices and emerging technologies.

Key Requirements:

Bachelor\xe2\x80\x99s Degree or equivalent in Computer Science, Engineering, or relevant field.

5+ years of experience in data engineering, integration, data warehousing, business intelligence, business analytics, or comparable role with relevant technologies and tools (Spark, Informatica/IICS or equivalent).

Experience in Big Data integration, including cloud-based platforms such as AWS, and Snowflake.

Proficiency in data structures and algorithms.

Demonstrated experience in scripting languages (Python, Shell scripting).

Experience with job scheduling and orchestration (Airflow is a plus).

Strong proficiency in relevant technologies such as databases (relational and NoSQL), distributed systems, and microservices.

Experience working with large data sets, and performance and query optimization.

Experience working cross-functional teams to solve complex data architecture and engineering problems.

Demonstrated ability to learn new data and software engineering technologies in short amount of time.

Experience with agile/scrum development processes and concepts.

Able to work in a fast-paced, constantly evolving environment and manage multiple priorities.

Demonstrated technical analysis and problem-solving skills related to data and technology solutions.

Excellent written, verbal, and interpersonal skills with ability to communicate ideas, concepts and solutions to stakeholders at all levels.

Pragmatic and capable of solving complex issues, with technical intuition and attention to detail.

Service-oriented, flexible, and approachable team player.

Fluent in English (Other languages a plus).

Experience working in life sciences/pharmaceutical industry is a plus.

Familiarity with data ingestion through batch, near real-time, and streaming environments.

Familiarity with data warehouse concepts and architectures (data mesh a plus).

Familiarity with Source Code Management Tools (GitHub a plus).

Familiarity with Visualization Tools (PowerBI, Tableau a plus).

Familiarity with Project Management Tools (JIRA, Confluence a plus).

Pursue Progress

Discover Extraordinary

Better is out there. Better medications, better outcomes, better science. But progress doesn\xe2\x80\x99t happen without people \xe2\x80\x93 people from different backgrounds, in different locations, doing different roles, all united by one thing: a desire to make miracles happen. So, let\xe2\x80\x99s be those people.

Watch our and check out our Diversity, Equity and Inclusion actions at !

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.

Thank you in advance for your interest.

Only those candidates selected for interviews will be contacted.

Follow Sanofi on Twitter: and on LinkedIn:

#DBBCA

At Sanofi diversity and inclusion is foundational to how we operate and embedded in our Core Values. We recognize to truly tap into the richness diversity brings we must lead with inclusion and have a workplace where those differences can thrive and be leveraged to empower the lives of our colleagues, patients and customers. We respect and celebrate the diversity of our people, their backgrounds and experiences and provide equal opportunity for all.

Sanofi