No longer accepting applications

Data Warehouse Engineer

HR PLACEMENT CONSULTANTS (HRPC)Thrissur, IN

2 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

shraddha@hrpc.in | 63542 77612 - Whatsapp

Create a job alert for this search

Data Engineer • Thrissur, IN

Related jobs

Promoted

Azure Data Engineer

People Prime WorldwideMalappuram, IN

Azure Data Lake Storage (Gen1 / Gen2).Show moreLast updated: 30+ days ago

Promoted

Data Engineer

HCLTechPalakkad, IN

We’re Expanding Our Digital & Data Talent Pool.Are you a professional ready to take on enterprise-scale transformation journey? We are on a mass hiring drive and looking for experts who can bring i...Show moreLast updated: 30+ days ago

Promoted
New!

Data Engineer | Bangalore | Leading Big 4 Consulting Firm

Acme ServicesPalakkad, IN

Design, develop, and maintain scalable and robust data pipelines (ETL / ELT) using PySpark on the Databricks platform.Implement data ingestion strategies to load data from various sources (e.APIs, da...Show moreLast updated: 7 hours ago

Promoted
New!

Senior Data Engineer

TEKsystems Global Services in IndiaPalakkad, IN

Develop and manage data pipelines using ADF and Azure data bricks.Expert knowledge in data warehousing, data modeling and ETL. Good to have datastage exposure.Expertise in on-prem to azure cloud mig...Show moreLast updated: 7 hours ago

Promoted

Data Engineer

BayOne SolutionsThrissur, 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 moreLast updated: 30+ days ago

Promoted
New!

Data Engineer

NexionPro ServicesPalakkad, IN

PySpark-based data processing workflows.Collaborate with data architects, analysts, and cross-functional teams to understand business requirements and translate them into technical solutions.Optimi...Show moreLast updated: 7 hours ago

Promoted

Data Engineer

DigitalzoneMalappuram, IN

As a Data Engineer, you will design, build, and optimize data pipelines and real-time systems that power AI-driven decisioning and analytics. Develop and maintain scalable ETL / ELT pipelines using Py...Show moreLast updated: 16 days ago

Promoted
New!

Data Engineer

MyData Insights Pvt LtdMalappuram, IN

The ideal candidate has a strong background in building scalable data solutions on.CI / CD pipelines, infrastructure automation using Terraform, and cloud-native data engineering practices.Design, bu...Show moreLast updated: 7 hours ago

Promoted

Data Engineer

Insight GlobalMalappuram, IN

GCP DATA ENGINEER - Contract (Long term).Data Engineer with hands-on support for Google Looker.Strong experience in data modeling and building data marts. Proficiency in ETL / ELT pipeline development...Show moreLast updated: 30+ days ago

Promoted

Data Engineer

OWOWThrissur, IN

Data Engineer – AI-Powered Marketing Personalization Platform.AI-powered marketing personalization platform (V2.You’ll design and implement a robust multi-database infrastructure that enables real-...Show moreLast updated: 30+ days ago

Promoted

AWS Data Engineer

Vista Applied Solutions Group IncPalakkad, 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 moreLast updated: 2 days ago

Promoted

Data Engineer

Randstad EnterpriseThrissur, 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 moreLast updated: 30+ days ago

Promoted
New!

Senior Data Engineer

MindlanceMalappuram, IN

We’re looking for a strong, hands-on Sr Data Engineer who can independently drive client conversations, collaborate with SMEs, and deliver high-quality data solutions in a cloud-native environment....Show moreLast updated: 7 hours ago

Promoted

Data Engineer - Palantir Foundry

NP GroupMalappuram, 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 moreLast updated: 30+ days ago

Promoted
New!

Databricks Engineer

TTC GroupThrissur, IN

We are seeking a Mid-Level Databricks Engineer with strong data engineering fundamentals and hands-on experience building scalable data pipelines on the Databricks platform.The ideal candidate will...Show moreLast updated: 7 hours ago

Promoted

Data Engineer

RecroPalakkad, IN

Data Pipeline Engineering : Design, build, and maintain ingestion, transformation, and storage pipelines using Azure Data Factory, Synapse Analytics, and Data Lake. AI Data Enablement : Collaborate wi...Show moreLast updated: 30+ days ago

Promoted
New!

Principal Data Engineer

KPI PartnersThrissur, IN

We are seeking a highly skilled Principal Data Engineer to join our dynamic team at KPI Partners.Lead data engineering initiatives and projects from conception to delivery.Design and implement scal...Show moreLast updated: 7 hours ago

Promoted
New!

Sr Data Engineer

Futran SolutionsPalakkad, IN

Job Title : Senior Data Engineer / Data Engineer Lead.We are seeking a highly skilled and experienced Senior Data Engineer with a strong background in Microsoft Azure data platforms.The ideal candida...Show moreLast updated: 7 hours ago