Data warehouse engineerHR PLACEMENT CONSULTANTS • Mumbai, Maharashtra, India

No longer accepting applications

Data warehouse engineer

HR PLACEMENT CONSULTANTS • Mumbai, Maharashtra, India

6 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 People Soft, 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, Dev Ops, 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, Dev Ops pipelines, and job schedulers

Optional Skills :

Understanding of Power BI development lifecycle

Python or R for data automation / validation

Experience with People Soft HR tables or major HRIS (Workday, SAP Success Factors, 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

Principal Data Engineer

Nexuspoint Consultant • Mumbai, IN

We are looking for an accomplished Principal Data Engineer to lead the ideation, architecture,.You will work closely with cloud, security, and infrastructure architects to ensure seamless.Lead the ...Show more

Last updated: 5 hours ago • Promoted • New!

Azure Data Engineer

Paritas Recruitment • Mumbai, IN

Azure Data Engineer - 6 Month+ Rolling Contract.Remote - (Sunday to Thursday working days).Paritas is working with a global IT Consultancy & leading Energy client who are seeking an experienced and...Show more

Last updated: 5 hours ago • Promoted • New!

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

TerraGiG • Mumbai, IN

Lead the design, development, and implementation of data solutions using AWS and Snowflake.Collaborate with cross-functional teams to understand business requirements and translate them into techni...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: 9 days ago • Promoted

Data Engineer

Tata Consultancy Services • Mumbai, IN

TCS has been a great pioneer in feeding the fire of Techies like you.We are a global leader in the technology arena and there’s nothing that can stop us from growing together.Your role is of key im...Show more

Last updated: 30+ days ago • Promoted

Azure Data Engineer

Tata Consultancy Services • Mumbai, Maharashtra, India

TCS PAN INDIA hiring for Azure Data Engineer on 22nd Nov(Saturday) through Virtual Mode of Interview !!!!!.Involved in the design, build and integration of data from various sources and the managem...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: 16 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

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

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: 13 days ago • Promoted

Principal Data Engineer

CodeMyMobile • Mumbai, IN

Experience Required - 7 to 10 Years.Are you a Data Engineer who cares about clean engineering, autonomy, and solving real data challenges? If this sounds like you, we’d love to connect!.Email your ...Show more

Last updated: 28 days ago • Promoted

Data Engineer

CodeVyasa • Mumbai, Maharashtra, India

Data Engineer l Mumbai ll 4+ yrs.CodeVyasa is a mid-sized product engineering company that works with top-tier product and solutions organizations such as McKinsey, Walmart, RazorPay, Swiggy, and o...Show more

Last updated: 28 days ago • Promoted

Lead Data Engineer

Guidanz Inc • Mumbai, IN

BI Connector is the industry leading solution for integrating Oracle Fusion Cloud data into modern BI platforms like Power BI, Tableau, and Data Warehouse, without complex ETL.Our Data Architecture...Show more

Last updated: 5 hours ago • Promoted • New!

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: 19 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

Senior Data Engineer (DBA & Data Warehouse)

TeamLease Edtech • Mumbai, Maharashtra, India

TeamLease EdTech, part of TeamLease Services, focuses on making India employable through online, work-integrated, and distance learning programs. It partners with 50+ universities and 4,000+ corpora...Show more

Last updated: 27 days ago • Promoted