Senior Data Architect
This position reports to the Head of Data Architecture & Modeling in the Consumer Healthcare business unit in Sanofi
A cornerstone of CHC transformation in the coming years, the Senior Data Architect will create relationships across the enterprise that help to understand CHC’s business model, current data environment and needs, and how data drives the success.
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 business partners, stakeholders, 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.
You 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 need.
The Senior Data Architect will be responsible for:
Lead data architecture & modeling efforts within Snowflake, AWS, and related cloud data products, including the design of data structures and the identification of business transformation logic.
Analyzing and translating business requirements into conceptual and detailed logical data models.
Creating logical data models based on existing applications and databases.
Working with business architects, data architects, and data stewards to capture business requirements in a Logical Data Model.
Transform the logical representation of the model into a physical representation and work with database administrators to instantiate and manage the data.
Contribute to assessment of appropriate data platform(s) for solutioning efforts.
Responsible for the development of on-prem and/or cloud native RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL)
Collaborate with the BI and Analytics teams on creating optimized, reusable semantic model, complete with metadata and lineage information.
Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices.
Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
Optimize the model to ensure predictable performance.
Maintain the metadata - describing the data model, its structure, and semantics.
10 years or more experience in Data Architecture and Modeling. 5+ years’ experience in Snowflake and AWS
Strong experience in Snowflake, AWS and related cloud data products
Working knowledge of IICS, dbt ETL/ELT technologies
Advanced SQL Skills
Experience working in FMCG.
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.
Experience of Interfacing heterogeneous systems and data sources
Working knowledge of procuring data from SAP
TOGAF certification or similar Data Architecture education preferred
Fluent in English
International program management skills
Work with multicultural and multi-sourced teams
Multi-country deployment, involving local stakeholders
Cross functional leadership and influencing
Contracting and contract managing software vendors and system integrators
Strategic development in a multi-dimensional and rapid changing environment
Sanofi Inc. and its U.S. affiliates are Equal Opportunity and Affirmative Action employers committed to a culturally diverse workforce. All qualified applicants will receive consideration for employment without regard to race; color; creed; religion; national origin; age; ancestry; nationality; marital, domestic partnership or civil union status; sex, gender, gender identity or expression; affectional or sexual orientation; disability; veteran or military status or liability for military status; domestic violence victim status; atypical cellular or blood trait; genetic information (including the refusal to submit to genetic testing) or any other characteristic protected by law.
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.