Lead Data Engineer - Sapphire

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’s 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’s 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’s 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.
• World Class Mentorship and Training: Working with renowned, published leaders and academics in machine learning to further develop your skillsets.
• Leading Edge Tech Stack: Experience build products that will be deployed globally on a leading-edge tech stack.

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

• Enable unified Sanofi US data environment integrating all data across GBU and customers.
• Excellence with latest Sanofi-wide technologies and right design
• Ensure operational with drastic 80% reduction of reports.
• Simplify analytics Transform Vaccines US data & analytics with DASH modernization.

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’s 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:

• Partner with Data Engineering Manager, Product Owner and Data Analysts to create implementation plan, including assessments of timelines and complexity.
• Work with business and products teams to understand and decompose high level business requirements, and translate them into technical needs.
• Create design and development documentation based on standards for knowledge transfer, training, and maintenance.
• Optimize solutions (ETL / data pipelines) to balance performance, functionality, cost, and other operational requirements.
• Lead data engineering efforts to modernize and replace legacy solutions and platforms.
• Define and promote best practices and standards for code management, automated testing, and deployments.
• Mentor and train junior team members.
• Communicate results and findings in a clear, structured manner to stakeholders at various levels.
• Establish technical designs to meet business and technical requirements as a prime data engineering lead.
• Assess and fix data pipeline issues to ensure performance and timeliness of execution.
• Remains up to date on the company’s standards, industry practices and emerging technologies.
• Develop automated tests for CI/CD pipelines.
• Actively contribute to Data Engineering community and define leading practices and frameworks.
• Develop and maintain all components of data engineering solutions and pipelines based on requirements and design specifications using appropriate tools and technologies.
• Conduct peer reviews for quality, consistency, and rigor for production level solution.
• Leverage existing or create new standard data pipelines within Sanofi to bring value through business use cases.
• Gather/organize large & complex data assets, and perform relevant analysis.
• Test and validate developed solution to ensure it meets requirements and design specifications.

Key Requirements:

• Strong proficiency in relevant technologies such as databases (relational and NoSQL), distributed systems, and microservices.
• Demonstrated ability to learn new data and software engineering technologies in short amount of time.
• Demonstrated experience in scripting languages (Python, Shell scripting).
• Familiarity with Project Management Tools (JIRA, Confluence a plus).
• Familiarity with data ingestion through batch, near real-time, and streaming environments.
• Experience working cross-functional teams to solve complex data architecture and engineering problems.
• Experience with job scheduling and orchestration (Airflow is a plus).
• Experience working with large data sets, and performance and query optimization.
• Familiarity with Visualization Tools (PowerBI, Tableau a plus).
• Proficiency in data structures and algorithms.
• Excellent written, verbal, and interpersonal skills with ability to communicate ideas, concepts and solutions to stakeholders at all levels.
• Familiarity with Source Code Management Tools (GitHub a plus).
• Bachelor’s Degree or equivalent in Computer Science, Engineering, or relevant field.
• Familiarity with data warehouse concepts and architectures (data mesh a plus).
• Service-oriented, flexible, and approachable team player.
• Pragmatic and capable of solving complex issues, with technical intuition and attention to detail.
• Demonstrated technical analysis and problem-solving skills related to data and technology solutions.
• 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.
• Fluent in English (Other languages a plus).
• Experience with agile/scrum development processes and concepts.
• Able to work in a fast-paced, constantly evolving environment and manage multiple priorities.
• Experience working in life sciences/pharmaceutical industry is a plus.

Pursue Progress
Discover Extraordinary
Better is out there. Better medications, better outcomes, better science. But progress doesn’t happen without people – people from different backgrounds, in different locations, doing different roles, all united by one thing: a desire to make miracles happen. So, let’s be those people.
Watch our ALL IN video and check out our Diversity, Equity and Inclusion actions at sanofi.com!
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: @SanofiCanada and on LinkedIn: https://www.linkedin.com/company/sanofi
#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.