Data Engineering Specialist

About the job

• We are seeking an experienced Data Engineering Specialist interested in challenging the status quo to ensure the seamless creation and operation of the data pipelines that are needed by Sanofi’s advanced analytic, AI and ML initiatives for the betterment of our global patients and customers.

• Sanofi has recently 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, to accelerate R&D, manufacturing and commercial performance and bring better drugs and vaccines to patients faster, to improve health and save lives

Main Responsibilities:

• Establish technical designs to meet Sanofi requirements aligned with the architectural and Data standards

• Ownership of the entire back end of the application, including the design, implementation, test, and troubleshooting of the core application logic, databases, data ingestion and transformation, data processing and orchestration of pipelines, APIs, CI/CD integration and other processes 

• Fine-tune and optimize queries using Snowflake platform and database techniques 

• Optimize ETL/data pipelines to balance performance, functionality, and other operational requirements. 

• Assess and resolve data pipeline issues to ensure performance and timeliness of execution 

• Assist with technical solution discovery to ensure technical feasibility. 

• Assist in setting up and managing CI/CD pipelines and development of automated tests 

• Developing and managing microservices using python 

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

• Design application architecture for efficient concurrent user handling, ensuring optimal performance during high usage periods 

• Own all areas of the product lifecycle: design, development, test, deployment, operation, and support 

About you 

• Qualifications:

• 5+ years of relevant experience developing backend, integration, data pipelining, and infrastructure  

• Expertise in database optimization and performance improvement 

• Expertise in Python, PySpark, and Snowpark 

• Experience data warehousing and object-relational database (Snowflake and PostgreSQL) and writing efficient SQL queries 

• Experience in cloud-based data platforms (Snowflake, AWS) 

• Proficiency in developing robust, reliable APIs using Python and FastAPI Framework 

• Expert in ELT and ETL & experience working with large data sets and performance and query optimization. IICS is a plus

• Understanding of data structures and algorithms

• Understanding of DBT is a plus

• Experience in modern testing framework (SonarQube, K6 is a plus) 

• Strong collaboration skills, willingness to work with others to ensure seamless integration of the server-side and client-side 

• Knowledge of DevOps best practices and associated tools is a plus, especially in the setup, configuration, maintenance, and troubleshooting of associated tools: 

• Containers and containerization technologies (Kubernetes, Argo, Red Hat OpenShift) 

• Infrastructure as code (Terraform) 

• Monitoring and Logging (CloudWatch, Grafana) 

• CI/CD Pipelines (JFrog Artifactory) 

• Scripting and automation (Python, GitHub, Github actions) 

• Experience with JIRA & Confluence 

• Workflow orchestration (Airflow)

• Message brokers (RabbitMQ)

• Education: Bachelor’s degree in computer science, engineering, or similar quantitative field of study  

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 and at least 14 weeks’ gender-neutral parental leave.

• Opportunity to work in an international environment, collaborating with diverse business teams and vendors, working in a dynamic team, and fully empowered to propose and implement innovative ideas. 

PursueProgress. Discover Extraordinary.

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. You can be one of those people. Chasing change, embracing new ideas and exploring all the opportunities we have to offer. Let’s pursue Progress. And let’s discover Extraordinary together.

At Sanofi, we provide equal opportunities to all regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, or gender identity.

Watch our ALL IN video and check out our Diversity Equity and Inclusion actions at sanofi.com!

Languages: English is a must