Technical data engineering lead

Topgear Consultants; Chennai District; On-site; INR 3,000,000 - 5,200,000; Full time

Job summary

Topgear Consultants in Karapakkam, Chennai, is seeking aTechnical Data Engineering Lead to drive design, development and delivery of enterprise data platforms for insurance systems. You will integrate data from policy administration, claims, finance and CRM sources to build a governed analytics ecosystem.

The role emphasizes leadership, SQL/PLSQL, Python-based processing, and enabling analytics for underwriting, claims, actuarial, and finance teams.

Qualifications

• Experience leading data engineering for insurance platforms.
• Strong SQL/PLSQL, Python, and data warehouse design.
• Knowledge of policy administration, claims and finance data sources.
• Familiar with analytics visualization tools and data governance.

Responsibilities

• Design and evolve enterprise data warehouse, data mart, and analytics architectures for insurance domains.
• Lead ETL/ELT development using SQL, PL/SQL, and Python to integrate data sources.
• Develop insurance-focused data models, including star/snowflake schemas and ODS/core models.
• Enable analytics and BI with dashboards in Qlik Sense, Power BI, Tableau.
• Ensure data quality, governance, and validation for regulatory and financial reporting.
• Drive performance tuning of queries and batch jobs for timely data availability.
• Lead and mentor data engineers, manage delivery timelines and reviews.

Skills

SQL/PLSQL

Python

Data warehousing

ETL/ELT pipelines

Insurance data models

Data governance

Data quality checks

Analytics & BI enablement

Leadership

Team management

Tools

Qlik Sense

Power BI

Tableau

Job description

Role & responsibilities

Technical Data Engineering Lead Insurance Data Platforms

Location: Karapakkam, Chennai

Department: IT

Role Overview

Insurance
data engineering extends beyond data movement and requires accurate handling of
highfrequency claims data, complex policy schemas, and strict regulatory
requirements (IRDA, IFRS 17).

This role
is responsible for leading the design, development, and delivery of
enterprise data management, data warehouse, and analytics platforms for
insurance systems. The position focuses on integrating data from policy
administration systems, claims platforms, finance, CRM, and thirdparty sources
into a reliable and governed analytics ecosystem.

The role
places strong emphasis on technical leadership, team management, deep SQL /
PLSQL expertise, Python-based data processing, and enabling analytics
platforms to support reporting, dashboards, and business insights for
underwriting, claims, actuarial, and finance teams.

Key Responsibilities

• Data
  Architecture & Design:

Design and evolve enterprise data warehouse, data mart, and analytics
architectures, supporting operational, historical, and analytical use cases
across insurance domains.

• Data
  Engineering & Integration:

Lead development of complex ETL / ELT pipelines using SQL, PL/SQL, and
Python to integrate multiple internal and external data sources across business
functions.

• Data
  Modeling:

Develop insurancefocused data models, including:

• Star / Snowflake schemas for claims, premiums, and profitability analytics
• ODS and core models for policy, endorsements, renewals, and claims lifecycle tracking
• Analytics
  & BI Enablement:

Collaborate with reporting and business teams to enable analytics and
visualization platforms such as Qlik Sense, Power BI, and Tableau,
ensuring optimized data models and trusted datasets for dashboards and MIS
reporting.

• Data
  Quality & Governance:

Implement data quality checks, reconciliations, audit controls, and validation
frameworks to support regulatory, actuarial, and financial reporting.

• Performance
  Optimization:

Drive performance tuning of SQL / PLSQL queries, stored procedures, batch
jobs, and data extracts to ensure scalability and timely data availability.

• Delivery
  & Stakeholder Management:

Partner with business stakeholders across Claims, Underwriting, Actuarial,
Finance, and Sales to translate business requirements into robust data and
analytics solutions across multiple programs.

• Leadership
  & Team Management:

Lead and mentor a team of data engineers and developers, conduct code
and design reviews, manage delivery timelines,