Data Modeler – Workday & People Analytics

Sanofi; Hyderabad; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Sanofi Hyderabad is hiring a Data Modeler to design enterprise data models for Workday HCM and People Analytics. You will develop conceptual, logical, and physical models, and build scalable dimensional structures to support workforce reporting and AI-driven insights.

Collaborating with HR, Data Engineering, and BI teams, you will ensure data quality, metadata standards, and governance across Workday and other enterprise systems, enabling global HR insights at scale.

Qualifications

• Proven experience with Workday data modelling and HCM data structures.
• Strong SQL and data warehousing knowledge for reporting and analytics.
• Experience building Power BI datasets and governance practices.

Responsibilities

• Design enterprise data models for Workday HCM and People Analytics.
• Develop conceptual, logical, and physical data models for workforce analytics.
• Build scalable dimensional models (Star/Snowflake) for analytics.
• Collaborate with HR, Data Engineering, and BI teams to deliver data solutions.
• Ensure data quality, lineage, and governance across HR systems.

Skills

Workday HCM architecture

Data modelling

SQL

Data warehouse concepts

Power BI datasets

Mentor teammates

Agile/Scrum

Data governance

HCM data structures

Cloud data platforms

Education

Bachelor's degree in Computer Science/Engineering/Data Modelling

Tools

Informatica/IICS

IBM InfoSphere

Erwin Data Modeler

SQL Database Modeler

Snowflake

Job description

Job Title: Data Modeler - Workday & People Analytics Job Location: Hyderabad Job Type: Fulltime

We are looking for an experienced Data Modeler with deep expertise in Workday data, HR data modelling, and People Analytics. The ideal candidate will design and maintain enterprise-grade data models that enable strategic workforce reporting, advanced analytics, and AI-driven insights. This role requires close collaboration with HR, People Analytics, Data Engineering, Data Governance, and Business Intelligence teams to build scalable and governed data solutions. The successful candidate should have strong technical expertise in Workday HCM data structures, dimensional modelling, cloud data platforms, and modern analytics technologies. 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.

About the Job

Main Responsibilities

• Design enterprise data models for Workday Human Capital Management (HCM) and People Analytics.
• Develop conceptual, logical, and physical data models supporting workforce reporting and analytics.
• Build scalable dimensional models (Star Schema and Snowflake Schema) optimized for analytics.
• Define data relationships, hierarchies, business rules, and metadata standards.
• Collaborate with HR stakeholders to understand reporting and workforce planning requirements.
• Translate business requirements into scalable and reusable data models.
• Work closely with Data Engineering teams to build trusted data products.
• Design data models supporting workforce planning, recruitment, learning, compensation, performance management, succession planning, and employee lifecycle analytics.
• Ensure data consistency across multiple HR systems including Workday and other enterprise applications.
• Perform source-to-target mapping and define transformation logic.
• Drive data quality, master data management, and governance initiatives.
• Establish standards for data modelling, naming conventions, documentation, and lineage.
• Support implementation of security models, including role-based access and sensitive HR data protection.
• Partner with BI teams to optimize datasets for Power BI and other reporting platforms.
• Optimize analytical models for performance and scalability within cloud data warehouses.
• Participate in solution architecture, design reviews, and governance forums.
• Mentor junior data modelers and contribute to enterprise data architecture best practices.

About You

Functional Skills & Experience Strong understanding of Workday HCM architecture. Experience with Workday data model and business objects. Experience extracting data from Workday using APIs, Workday Reports or Workday Prism Analytics. Understanding of Workday security and data access model. Proven experience in data warehouse modelling 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 modelling 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 Modelling, or a related field Background in data modelling, 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

Experience working with:

• Power BI or Tableau
• Workday Prism Analytics
• Workday Reporting
• Workforce Dashboards
• Executive HR Dashboards
• Self‑Service Analytics

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. Watchour ALL IN video and check out our Diversity Equity and Inclusion actions at sanofi.com! We are an R&D driven, AI-powered biopharma company committed to improving people’s lives and creating compelling growth. Our team is guided by one purpose: we chase the miracles of science to improve people’s lives. We want to build a healthier, more resilient world, and turn the impossible into the possible by discovering, developing, and delivering medicines and vaccines for millions of people around the world. Discover more about us visiting www.sanofi.com or via our movie We are Sanofi Start a career that makes a difference. Reinvention is in our DNA. It’s what drove our evolution from a small French enterprise to one of the world’s leading biopharma companies. Whether it’s using AI to shorten drug‑discovery times or building trust in healthcare, you could be helping our teams make life better for patients, partners, and communities. This is where you grow your career. We open the door for you to explore new opportunities, push your limits, and connect with people who are driven by a shared purpose: we chase the miracles of science to improve people’s lives.