Data Modeler

About the Job

Better is out there. Better data. Better insights. Better outcomes for patients around the world. And it's all down to people like you.

Sanofi is an R&D-driven, AI-powered biopharmaceutical company committed to chasing the miracles of science to improve people's lives. Across more than 100 countries, we are scaling AI across every part of our value chain — accelerating the journey from discovery to delivery. Data is at the heart of this transformation, and our Digital People & Culture (P&C) team is at the forefront of it.

As a Data Modeler within the Digital P&C team, you will design and maintain the data architecture that powers our People analytics and HR insights at a global scale. You will translate complex business needs into robust, high-performance data models — enabling smarter, faster, and more impactful decisions that touch millions of lives. This is your opportunity to Play to Win in a team that is data-obsessed, globally minded, and driven by purpose.

Main Responsibilities

• Guide Data Engineers in building data models designed for Data Warehouse/Lake environments, handling high-volume data for analytics use

• Organize and optimize data models to improve performance and simplify end-to-end KPI calculation

• Analyze and translate business requirements into scalable, long-term data model solutions

• Partner with business teams to gather requirements for database design and modeling

• Collaborate with stakeholders — data stewards, data engineers, and data scientists — to design and build database models fit for analysis

• Implement data strategies and develop physical data models

• Manage and optimize local and metadata models on an ongoing basis

• Define and oversee data cleaning requirements and processes

• Assess data security needs and implement appropriate security solutions

• Apply and champion coding best practices set by the enterprise Digital team to ensure system consistency and audit compliance

• Handle historical data requirements with appropriate modeling approaches

About You

Functional Skills & Experience

• Proven experience in data warehouse modeling and optimization

• Solid knowledge of relational and non-relational databases, data architecture, and SQL

• Strong understanding of Data Warehouse concepts: Kimball and Inmon methodologies

• Experience with data modeling tools such as SQL Database Modeler, IBM InfoSphere, or erwin Data Modeler

• Ability to mentor and share knowledge with fellow Data Modelers and Data Architects

• Experience collaborating across cross-functional teams to solve complex data architecture challenges

• Comfortable working in agile/scrum environments and managing multiple priorities

• Able to thrive in a fast-paced, matrix organization with a global footprint

• Strong analytical and problem-solving skills with sharp attention to detail

• Excellent communication skills — able to convey technical concepts clearly to both peers and senior stakeholders

• Pragmatic, service-oriented, and a collaborative team player

• Fluent in English (additional languages are a plus)

Technical Skills & Qualifications

• Bachelor's degree or equivalent in Computer Science, Engineering, Data Modeling, or a related field

• Background in data modeling, data engineering, data warehousing, business intelligence, or analytics — with hands-on experience with relevant tools (e.g., Informatica/IICS)

• Solid understanding of data structures and algorithms

• Familiarity with data model requirements for Power BI or similar reporting platforms

• Experience with cloud-based data platforms (Informatica IICS / Snowflake is a plus)

• Strong SQL skills and knowledge of both relational and non-relational database technologies

Why Choose Us?

• Global impact — work in an international environment where your models power people decisions that affect employees and patients worldwide

• Competitive rewards — attractive, market-aligned salary and benefits package

• Flexible working — hybrid model with up to 60% remote work

• Cutting-edge learning — access to training and certification pathways with AWS, Snowflake, Informatica, and more

• Structured onboarding — a dedicated Buddy and personalized onboarding program to set you up for success from day one

• Career ownership — a clear, supported career path within Sanofi, with purposeful investment in your professional and personal growth

• Protection & wellbeing — collective life and accident insurance coverage