Data Modeler – Workday & People Analytics

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

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!