Job title: Data Modeler

• Location: Mumbai
• Job type: Permanent

About the job

At Sanofi Consumer Healthcare, we have one overarching mission - to work passionately, challenging ourselves and our industry every day, to build a healthier future by helping people, help themselves, bringing “Health in Your Hands”.

Our teams are building trusted & loved brands that connect with hundreds of millions of consumers worldwide, enabling better self-care for individuals and communities, while also contributing to a healthier planet. To fulfill this mission, we are embarking our consumers, our customers, healthcare professionals, and our employees in this journey because this is what will make us become the “Best Fast-Moving Consumer Healthcare (FMCH) Company In & For the World”.

We strive to act as a force for good by integrating sustainability along our business and employees’ mission and operate responsibly from both a social and environmental point of view.

To achieve this, we need strong talent who will help us shape the future of our Consumer Healthcare business and challenge our industry. At Sanofi Consumer Healthcare, we aspire to create a work environment where people can thrive, grow, and be at their best every day. Our priority is working with integrity to improve the health and well-being of people and communities where we operate, working towards making a positive impact in the world.

Main responsibilities:

• This position reports to the Senior Data Architect in the Consumer Healthcare business unit (Opella) at Sanofi.
• This position will collaborate with multiple business functions to provide guidance in implementing the right data model and practices that meet their needs.
• S/he will closely work with the data engineering team, Architects and the data governance team to create a logical data model architecture for various data objects.
• S/he will work on modern data architecture techniques and cloud data technologies.
• The candidate must be able to work independently and collaboratively.
• s/he will work with a diverse team of business analysts, data scientists, technical engineers, data architects, and project managers to deliver outcomes aligned with our business needs.

About you

KEY RESPONSIBILITIES:

• The Data Modeler will be responsible for:
• Work with Data Architect to develop data architecture & modeling within Snowflake and related cloud data products, including the design of data structures and the implementation of business transformation logic.
• Analyzing and creating logical data models based on existing applications and databases.
• Transform the logical representation of the model into a physical representation and work with database administrators to instantiate and manage the data.
• Contribute to the assessment of appropriate data platform(s) for solution efforts.
• Contribute to development of cloud-native RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL)
• Management of existing data architecture and the optimization of data query performance via best practices.
• Maintain the metadata - describing the data model, its structure, and semantics.

QUALIFICATIONS

• 5 years or more experience in Data base development and Modeling. 3+ years’ experience in Snowflake
• Strong experience in Snowflake related cloud data products.
• Python Experience is good to have.
• Strong knowledge of data modeling principles, methodologies, and tools (e.g., ERwin, ER/Studio).
• Good working knowledge of IICS, dbt ETL/ELT technologies.
• Advanced SQL Skills
• Experience in Data strategies and developing logical and physical data models on RDBMS, NoSQL, and Cloud native databases.
• Agile ways of working and large projects phased delivery.
• Excellent analytical, problem-solving, and communication skills.

Education

• Bachelor’s degree in computer science, Information Technology, or a related field.
• Fluent in English
• Work with multicultural and multi-sourced teams

#LiCHC

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.

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

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