2,391,362open jobs
149,182companies
289,228added this week
Browse all
Location
In office (Hyderabad)
Seniority
Staff · 10+ years exp
Visa
Sponsors visas in United States, United Kingdom; no register of this country names it

Confirmed on the employer's own hiring board on Nov 19, 2026. First seen by Alion on Oct 21, 2026. Mphasis scores B on the Alion truth index.

Overview
Company
Impact
Profile match
Mphasis is an Indian IT services and consulting company headquartered in Bengaluru, providing application development and maintenance, cloud and infrastructure services, data and AI, cybersecurity, DevOps and business process services. Its clients are concentrated in banking, capital markets and insurance, alongside healthcare, logistics, travel and technology firms, and Blackstone has been its majority shareholder since buying the stake of Hewlett Packard Enterprise in 2016, with subsidiaries including Blink UX and Datalytyx. Hiring covers software and AI engineers, data architects, cloud and infrastructure engineers, cybersecurity specialists, project leads, testers and support staff.

JOB DESCRIPTION - LEAD BI / DW / ETL ENGINEER

Azure Databricks | Data Warehousing | ETL/ELT | Power BI | Lakehouse

Experience

10-12 years

Role Level

Lead Engineer / Technical Lead

Primary Focus

BI, DW, ETL and Databricks

Domain

Insurance and Benefits Management

Role Summary

Seeking a hands-on Lead Engineer with 10-12 years of experience across Business Intelligence, Data Warehousing and ETL/ELT, including strong Azure Databricks expertise. The role will lead delivery of governed Lakehouse and warehouse solutions, scalable data pipelines, dimensional and semantic models, certified metrics and Power BI reporting for Insurance and Benefits Management use cases.

Key Responsibilities

  • Lead end-to-end design and delivery of BI, enterprise data warehouse, data-mart and Azure Databricks Lakehouse solutions.
  • Design Bronze, Silver and Gold layers using Delta Lake, dimensional models, star/snowflake schemas, facts, dimensions and slowly changing dimensions.
  • Develop and optimize ETL/ELT pipelines using Azure Databricks, Spark, PySpark, Spark SQL, Python, SQL and Azure Data Factory.
  • Implement batch, incremental and streaming ingestion from databases, APIs, files, HRIS, benefits platforms, CRM and external feeds.
  • Deliver curated datasets, semantic models, certified KPIs and reporting structures for Power BI, Databricks SQL and Genie.
  • Define source-to-target mappings, transformation rules, data-quality checks, reconciliation, lineage and audit controls.
  • Apply Unity Catalog governance, RBAC/ABAC, masking, access policies, employer isolation and secure data-sharing patterns.
  • Optimize Spark workloads, Delta tables, SQL queries, data models, Power BI datasets, refresh performance, compute and storage cost.
  • Establish engineering standards, reusable frameworks, automated testing, CI/CD, release controls, monitoring and production runbooks.
  • Lead technical reviews, estimates, sprint delivery, defect resolution, stakeholder communication and mentoring of distributed engineering teams.
  • Mandatory Technical Skills

    Azure Databricks; Apache Spark; PySpark; Spark SQL; Python; advanced SQL and T-SQL; Delta Lake; medallion architecture; data warehousing, ODS and data marts; dimensional modelling; star and snowflake schemas; SCD Types 1 and 2; ETL/ELT; Azure Data Factory; Auto Loader and Lakeflow; Databricks Workflows and SQL; Photon; Unity Catalog; ADLS Gen2; Power BI data modelling, DAX, Power Query, semantic models, gateways and refresh; SSIS, Informatica or equivalent ETL exposure; data profiling, quality, reconciliation and lineage; REST APIs; Git; Azure DevOps; CI/CD; Terraform awareness; monitoring, security and performance optimization.

    Experience and Qualifications

  • 10-12 years of experience in BI, data warehousing, ETL/ELT, data engineering or enterprise analytics, including technical leadership.
  • Proven experience delivering production BI and DW platforms using Azure Databricks, Delta Lake and modern cloud-data patterns.
  • Strong hands-on expertise in Spark/PySpark, SQL, dimensional modelling, ETL frameworks and Power BI integration.
  • Experience leading data-engineering workstreams, conducting design and code reviews and mentoring engineers.
  • Experience collaborating with architects, modellers, business users, QA, DevOps, security and reporting teams in Agile delivery.
  • Bachelor’s degree in Computer Science, Information Technology, Data Engineering or a related discipline; Azure, Databricks or Power BI certification is preferred.

    Domain Experience

  • Insurance or employee-benefits experience across employer, client, plan, member, enrollment, carrier, premium, claims and renewal data is preferred.
  • Experience delivering governed metrics, operational reports, analytical dashboards and role-specific views for sensitive data.
  • Familiarity with HRIS, EDI, benefits-administration, CRM, policy or document-derived data is advantageous.

    Core Competencies

    Hands-on technical leadership, BI and data-warehouse design, ETL delivery ownership, analytical problem-solving, data-quality discipline, stakeholder communication, mentoring and the ability to balance business value, scalability, governance, performance and cost.

  • Free account
    Stop reading job ads. Get the ones that fit.
    One free account turns this page into a shortlist built around your stack, your level and your pay.
    Match on every job. Stack, seniority, pay and location, scored against your profile.
    2,391,362 open roles. Read straight off company career pages, refreshed every day.
    Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
    3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
    Create a free account Continue with Google
    Free forever. No card. Under a minute.

    Your match

    How well do you fit this role?
    Two answers are enough for a real match. No account needed.
    Check my fit
    Answers stay in this browser until you create an account.

    Recommended for you based on this role

    Engineering
    Similar stack
    Same company
    Hyderabad
    In office · 8+ years exp · Hyderabad
    JavaScript
    TypeScript
    Frontend
    React.js
    Apply
    Chief Engineer 6 hours ago
    In office · Full-Time · Ahmedabad
    Apply
    In office · 10+ years exp · Bachelor's Degree · Pune
    SpaceTech
    CATIA
    Apply
    In office · Full-Time · 10+ years exp · Bengaluru
    Management
    Agile
    Scrum
    Apply
    Lead Piping Engineer 2 hours ago
    In office · Contractor · 15+ years exp · Kakinada
    Apply
    In office · 3+ years exp · Hyderabad
    Analytics
    Microsoft Excel
    SpaceTech
    GD&T
    Apply
    In office · 6+ years exp · Hyderabad
    SpaceTech
    GD&T
    MedTech
    CAPA
    Apply
    In office · Full-Time · Hyderabad
    Life Sciences
    Veeva
    Apply
    In office · Full-Time · 2+ years exp · Hyderabad
    JavaScript
    Frontend
    Web Components
    Design
    Figma
    Life Sciences
    Veeva
    Apply
    Account Manager 1 day ago
    In office · Full-Time · PhD · Hyderabad
    Apply
    See all jobs
    This is one of many
    2,391,362 more open roles from verified company boards, updated every day.