Talent.com
No longer accepting applications
Data Warehouse Engineer

Data Warehouse Engineer

HR PLACEMENT CONSULTANTS (HRPC)Amravati, IN
1 day 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 • Amravati, IN

    Related jobs
    • Promoted
    Data Engineer

    Data Engineer

    Insight GlobalAmravati, 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 - Palantir Foundry

    Data Engineer - Palantir Foundry

    NP GroupAmravati, 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
    Data Engineer

    Data Engineer

    Randstad EnterpriseAmravati, 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
    Principal Data Engineer

    Principal Data Engineer

    CodeMyMobileAmravati, 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 moreLast updated: 15 days ago
    • Promoted
    Senior Data Engineer

    Senior Data Engineer

    DonyatiAmravati, IN
    We are seeking a highly skilled Senior Data Engineer to join our team in building a modern data platform on AWS.You will play a key role in transitioning from legacy systems to a scalable, cloud-na...Show moreLast updated: 1 day ago
    • Promoted
    Data Engineer

    Data Engineer

    RecroAmravati, 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
    Azure Data Engineer

    Azure Data Engineer

    K&K Talents - IndiaAmravati, IN
    This position is with one of our.Location : Bangalore, Bhopal, Chennai, Gurugram, Hyderabad, Jaipur, Pune.Employment Type : Full-time Permanent. We are seeking an experienced Data Engineer with strong...Show moreLast updated: 30+ days ago
    • Promoted
    Data Engineer

    Data Engineer

    Tata Consultancy ServicesAmravati, IN
    Data Engineering & Azure ecosystem).We are looking for a passionate.This role involves working on ETL processes, data warehousing, and analytics solutions to enable high-quality insights for busine...Show moreLast updated: 30+ days ago
    • Promoted
    GCP Data Engineer

    GCP Data Engineer

    PamTen IncAmravati, IN
    You will work ongoing support activities and support project efforts as needed.You triage identified issues across Account source platforms, integrations and Customer Data Hub.You will analyze and ...Show moreLast updated: 8 days ago
    • Promoted
    AWS Data Engineer

    AWS Data Engineer

    Vista Applied Solutions Group IncAmravati, 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: 1 day ago
    • Promoted
    Data Engineer

    Data Engineer

    BayOne SolutionsAmravati, 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
    GCP Data Engineer

    GCP Data Engineer

    AdastraAmravati, IN
    We are looking for a proactive and solution-oriented GCP Data Engineer to join our team.This role requires hands-on experience in Google Cloud Platform (GCP), especially with BigQuery and Airflow, ...Show moreLast updated: 2 days ago
    • Promoted
    Senior AWS Data Engineer

    Senior AWS Data Engineer

    CYAN360Amravati, IN
    Position : Senior AWS Data Engineer.Work Timings : 2 : 30 PM to 11 : 30 PM IST.Need someone who can join immediately or in 15 days • • •. Design, develop, and deploy end-to-end data pipelines on AWS cloud in...Show moreLast updated: 30+ days ago
    • Promoted
    Azure Data Engineer

    Azure Data Engineer

    SystemBenderAmravati, IN
    Responsible for designing and maintaining scalable data pipelines on Microsoft Fabric and Azure.Focus includes ingesting structured, semi-structured, and unstructured data, managing OneLake / Delta L...Show moreLast updated: 9 days ago
    • Promoted
    Senior Data Engineer

    Senior Data Engineer

    HealthyMe AIAmravati, IN
    We are seeking a Senior Data Engineer with deep expertise in building data pipelines and integrating healthcare data.You will report to the Head of AI and Engineering and be responsible for designi...Show moreLast updated: 30+ days ago
    • Promoted
    Data Engineer

    Data Engineer

    TEKsystemsAmravati, IN
    Location - Remote or Delhi or Hyderabad or Bangalore or Pune.Proficiency in Python and experience maintaining data-driven applications. Hands-on experience with ETL pipeline development, schema desi...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Data Engineer

    Senior Data Engineer

    Intellify SolutionsAmravati, IN
    Total years of experience : 10+ years.Required : Bachelor’s degree or relevant experience.Required : Prior experience as a software engineer or data engineer in a. Required : Cloud Data Warehouse experi...Show moreLast updated: 6 days ago
    • Promoted
    Data Engineer

    Data Engineer

    DigitalzoneAmravati, 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: 15 days ago