Data Warehouse EngineerHR PLACEMENT CONSULTANTS (HRPC) • Mumbai, Maharashtra, India

Data Warehouse Engineer

HR PLACEMENT CONSULTANTS (HRPC) • Mumbai, Maharashtra, India

30+ days ago

Job description

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 development

Microsoft BI Stack : SQL Server, SSIS, SSAS (Tabular)

ETL design, optimisation, and productionising

Data modelling : star schema, snowflake, HR data structures

Experience building HR / People Analytics data marts or cubes

Exposure to Power BI, semantic models, and DAX fundamentals

Familiarity with Git, DevOps pipelines, and job schedulers

Optional Skills :

Understanding of Power BI development lifecycle

Python or R for data automation / validation

Experience 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

| - Whatsapp

Create a job alert for this search

Data Engineer • Mumbai, Maharashtra, India

Related jobs

AWS Data Engineer

Vista Applied Solutions Group Inc • Mumbai, IN

Job Summary for AWS Data Engineer : .Job Qualification and Responsibilities for AWS Data Engineer : .Advanced SQL (performance tuning, joins, windows functions). Hands-on with AWS : Glue, Lambda, Redshif...Show more

Last updated: 11 days ago • Promoted

Data Engineer

Randstad Enterprise • Mumbai, IN

Shift Timing : 2 : 00 Pm - 11 : 00 Pm.Experience : 2- 4 years relevant Experience only ( this is a Junior position with us ). GCP - 2 years minimum working Experience.Worked with global stakeholders.Ran...Show more

Last updated: 30+ days ago • Promoted

Data Engineer

System Soft Technologies • Mumbai, IN

Location : Remote (3–4-hour time zone overlaps with EST if off shore).Experience with next flow is required, as the consultant will make targeted enhancements to existing workflows and pipelines.Whi...Show more

Last updated: 5 days ago • Promoted

Data Engineer

Tata Consultancy Services • Mumbai, IN

Big Data / Hadoop Experience particularly in ingesting data and implementing Data ingestion pipelines, SQOOP, HADOOP, HDFS, HIVE, IMPALA, Java, Scala, Spark. Data Engineer with below responsibilities : ...Show more

Last updated: 30+ days ago • Promoted

Data Engineer - Parametric

Morgan Stanley • Mumbai, India

Morgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, wealth management and investment management services. With offices in more than 4...Show more

Last updated: 30+ days ago • Promoted

Data Engineer - Palantir Foundry

NP Group • Mumbai, IN

Data Engineer - Palantir Foundry, Workshop, Pyspark & Typescript.Long Term (initially 6 months) full time contract.We have an immediate requirement for an experienced Data Engineer to join the glob...Show more

Last updated: 30+ days ago • Promoted

AWS Data Engineer

ACL Digital • Mumbai, Maharashtra, India

We have urgent openings for AWS Data Engineer.The ideal candidate will have a strong background in designing, deploying, and maintaining data pipelines using industry-leading tools such as.Familiar...Show more

Last updated: 13 days ago • Promoted

Senior Data Warehouse Engineer

HR PLACEMENT CONSULTANTS (HRPC) • Mumbai, Maharashtra, India

Qualifications Educational - B.Sc / BCA / MCA – IT or Computer Science.Domain / Vertical - Insurance and / or Finance (preferred). Experience of SQL and Databases (MS SQL Server, DB2, Postgres, Mongo).Exp...Show more

Last updated: 10 days ago • Promoted

Data Engineer

Epergne Solutions • Mumbai, Maharashtra, India

Quick Apply

The ideal candidate will combine strong technical skills with leadership experience, ensuring that agile squads deliver scalable, reliable, and value-driven data products aligned with business goal...Show more

Last updated: 30+ days ago

Data Engineer

N53 Tech • Mumbai, Maharashtra, India

Our client is expanding their Data Engineering function and hiring across multiple levels (3 to 10 years).You will help build and scale their data architecture, data pipelines, data platform govern...Show more

Last updated: 13 hours ago • Promoted • New!

Data Engineer

Collinson • Mumbai, Maharashtra, IN

Quick Apply

We use our expertise and products to craft customer experiences.Our range of services helps global brand acquire, engage and retain choice-rich customers. Collinson International Limited.Registered ...Show more

Last updated: 30+ days ago

Senior Data Engineer

Straive • Mumbai, Maharashtra, India

Analyse relevant internally and externally sourced data (raw data) to generate BI and Advanced.Analytics datasets based on your stakeholders’ requirements. Design data pipelines to curate sourced da...Show more

Last updated: 30+ days ago • Promoted

Data Engineer

Deloitte • Mumbai, Maharashtra, India

India’s impact on the global economy has increased at an exponential rate and Deloitte presents an opportunity to unleash and realise your potential amongst cutting edge leaders, and organisations ...Show more

Last updated: 30+ days ago • Promoted

Data Engineer

Modulr • Mumbai, Maharashtra, India

The Data Engineer is a vital role within Modulr and this role will support the continuous improvement and innovation of our data platform, ensuring processes are robust, efficient and scalable.Extr...Show more

Last updated: 16 days ago • Promoted

Data Warehouse Engineer

HR PLACEMENT CONSULTANTS (HRPC) • Mumbai, Maharashtra, India

Position - Data Warehouse Developer.Qualifications Educational - B.Sc / BCA / MCA – IT or Computer Science.Domain / Vertical - Insurance and / or Finance (preferred). Experience in Microsoft BI Stack : SQL...Show more

Last updated: 30+ days ago • Promoted

Data Engineer- Dataverse

Capco • Mumbai, Maharashtra, India

We are seeking a highly skilled and experienced.The ideal candidate will combine strong hands-on data engineering expertise with the ability to coordinate and provide leadership for Capco’s.This ro...Show more

Last updated: 24 days ago • Promoted

Senior Data Engineer

VRIZE • Mumbai, IN

Design, architect, administer, and manage large database systems, particularly on Microsoft platforms such as SQL Server and Azure Database. Develop and optimize complex SQL queries for data extract...Show more

Last updated: 4 days ago • Promoted

Data Engineer

BayOne Solutions • Mumbai, IN

We are seeking a highly experienced Data Engineer to join our MarTech team and play a pivotal role in driving innovation within our microservices architecture, with a strong emphasis on data engine...Show more

Last updated: 30+ days ago • Promoted