Insurance Data Consultant

Kennect; Chennai District; On-site; INR 600,000 - 1,000,000; Full time

Job summary

Kennect is seeking an Insurance Data Consultant in Chennai to join our data engineering team. You will design and maintain data pipelines, ensuring seamless data transformations for our insurance clients.

The ideal candidate should have experience in data engineering, a strong understanding of insurance operations, and the ability to communicate complex technical findings clearly to stakeholders.

This on-site role requires 2–3 years of relevant experience and excellent skills in SQL and MongoDB.

Qualifications

• 2–3 years of experience in data engineering, analytics engineering, or a related data role.
• Good to have: prior experience in the insurance industry.
• Strong SQL skills; MongoDB proficiency highly preferred.
• Experience with Python or JavaScript for data processing; both is a plus.
• Excellent written and verbal communication skills in English.

Responsibilities

• Design, build, and maintain scalable data pipelines ingesting insurance operational data.
• Translate incentive structures and payout workflows into normalized data models.
• Prepare clean, analytics-ready datasets for dashboards and reporting.
• Integrate incentive outputs with downstream systems including journal entry generation.
• Act as the primary technical point of contact for data-related queries.

Skills

Strong understanding of insurance operations

Strong analytical mindset

Hands-on technical skills

Excellent communication

Detail-oriented

Education

Bachelor’s or Master’s degree in Computer Science, Statistics, Engineering, Mathematics

Tools

SQL

MongoDB

Python

JavaScript

Power BI

Tableau

Looker

Job description

Insurance Data Consultant

Experience: 2–3 years in data engineering, analytics engineering, or a related data role.

Location: Chennai, Tamil Nadu, India (On‑site)

The Role

We are looking for a sharp, insurance‑domain‑aware Data Consultant to join our data engineering team and work exclusively with one of our key insurance clients. This is a dedicated engagement, you will be embedded within the client’s data ecosystem, owning pipelines, driving data transformations, and translating complex insurance operations into structured, decision‑ready data products.

Key Responsibilities

• Data Pipeline Engineering: Design, build, and maintain scalable data pipelines ingesting insurance operational data (policy, employee details, CRM activities, training data). Develop and optimize ETL/ELT workflows across structured and semi‑structured sources. Ensure pipeline reliability, scheduling, monitoring, and alerting with minimal manual intervention.
• Insurance Domain Data Modelling: Translate incentive structures and payout workflows, including agent commissions, into clean, normalized data models. Document data dictionaries, schema definitions, and transformation logic for client‑facing deliverables.
• Analytics Enablement: Prepare clean, analytics‑ready datasets for dashboards, actuarial models, and management reporting. Support ad‑hoc analytical requests with SQL queries, MongoDB aggregations, and scripting (Python/JavaScript).
• System Integrations: Integrate incentive outputs with downstream systems (accounting/GL platforms, payroll, HRIS), including journal entry generation (tax handling where applicable) and payout file generation. Build and support workflow requirements to fulfill business requirements related to downstream data consumption.
• Client Engagement: Act as the primary technical point of contact for data‑related queries from the dedicated client. Communicate clearly with both technical and non‑technical insurance stakeholders. Produce regular status updates, pipeline documentation, and data health reports.

Our Ideal Candidate

• Strong understanding of insurance operations and at least one core insurance line (P&C, Life, Health, or Specialty).
• Familiarity with key operational data areas: incentive management, commission payouts, payout reconciliation, and incentive disbursement.
• Experience working with real‑world insurance data from legacy source systems.
• Strong analytical mindset: ask the right questions about data fields, relationships, and business insights.
• Hands‑on technical skills: comfortable writing and debugging code independently.
• Excellent communication: translate complex technical findings to non‑technical stakeholders with clarity.
• Detail‑oriented and high bar for data accuracy and documentation quality.
• Mentoring experience: review pipeline code and enforce data quality and auditability standards.

Qualifications

• 2–3 years of experience in data engineering, analytics engineering, or a related data role.
• Good to have: prior experience in the insurance industry.
• Bachelor’s or Master’s degree in Computer Science, Statistics, Engineering, Mathematics, or related field.
• Strong SQL skills; MongoDB proficiency highly preferred.
• Experience with Python or JavaScript for data processing; both is a plus.
• Excellent written and verbal communication skills in English.
• Based in Chennai or willing to relocate; on‑site dedicated engagement.

Nice to Have

• Experience with BI tools (Power BI, Tableau, Looker) for data validation and stakeholder reporting.
• Familiarity with cloud data platforms (AWS, GCP, Azure) and data warehousing solutions.
• Knowledge of actuarial data workflows or experience supporting actuarial teams.
• Certifications in cloud, data engineering, or insurance domain (ACII, AICPCU, etc.).

EEO Statement

We are an equal opportunity employer and encourage applicants from all backgrounds.