Position - Data Warehouse Developer
Location - Mumbai
Total Experience - 5 Years
Qualifications Educational - B.Sc / M.Sc / BCA / MCA – IT or Computer Science
Domain / Vertical - Insurance and / or Finance (preferred)
Relevant Experience :
- 3+ years of experience into a similar role
- Experience in Microsoft BI Stack : SQL Server, SSIS, SSAS (Tabular)
- Strong SQL / T-SQL development
- Experience into ETL design, optimization, and production.
- Data modelling : star schema, snowflake, HR data structures
Responsibilities :
Data Engineering & ETL Development (HR / HC Focused)
Design, build, and maintain ETL pipelines that ingest and transform data from PeopleSoft, HRIS platforms, cloud applications, SQL databases, APIs, and flat files.Develop, schedule, and optimise SSIS / ETL jobs ensuring high availability and zero-defect processing.Implement data quality rules, reconciliation checks, audits, and exception frameworks to reduce manual interventions and ensure reliable HR data.Data Warehouse & Cube Development
Design and maintain HR data marts, star schemas, dimensional models, and SSAS Tabular cubes across domains such as Workforce, Headcount, Attrition, Absence, Leave, Payroll, Talent, Rewards, and HR Operations.Develop and optimise database objects including tables, views, stored procedures, and functions.Perform SQL optimisation, ETL tuning, and cube refresh performance improvements.Power BI Data Enablement
Build certified semantic layers and clean datasets for Power BI dashboards.Partner with Power BI developers to resolve model issues, refresh failures, and performance bottlenecks.Prepare analytics-ready datasets, including flattened views, calculated tables, and optimised structures for reporting.Data Governance & Standards
Enforce data validation, referential integrity, naming standards, and data lineage practices.Maintain clear and complete documentation : data dictionaries, transformation logic, business rules, and Git-based version control.Ensure secure handling of sensitive HR data in line with compliance and privacy standards.Stakeholder Collaboration
Work closely with Business Analysts, People Analytics teams, HR Operations, DevOps, and Human Capital leadership to convert HR requirements into scalable technical solutions.Participate in sprint ceremonies, impact analysis, and release readiness.Proactively reduce technical debt, rework, and production issues.Mandatory Technical Skills :
Strong SQL / T-SQL developmentMicrosoft BI Stack : SQL Server, SSIS, SSAS (Tabular)ETL design, optimisation, and productionisingData modelling : star schema, snowflake, HR data structuresExperience building HR / People Analytics data marts or cubesExposure to Power BI, semantic models, and DAX fundamentalsFamiliarity with Git, DevOps pipelines, and job schedulersOptional Skills :
Understanding of Power BI development lifecyclePython or R for data automation / validationExperience with PeopleSoft HR tables or major HRIS (Workday, SAP SuccessFactors, Oracle HCM, ADP)Knowledge of HR processes : Recruitment, Absence, Payroll, Employee Lifecycle, Attrition, Talent Management.Please contact - Shraddha Mahajan
shraddha@hrpc.in | 63542 77612 - Whatsapp