Find your next job. Start today.

From the employer's own careers site

Senior Specialist - Data Engineering

Date Posted: Aug 06, 2026
Apply on company website
Sign in to keep track of your applications.
Get jobs like this sent to you
Your own AI Job Agent checks every new job against your CV and sends only the ones that fit, on WhatsApp. ₹199 a month, GST included. Full refund if it does nothing.
Start my Job Agent on WhatsApp

Job Detail

  • location_on
    Location Kolkata, West Bengal, India
  • desktop_windows
    Job Type: Full Time/Permanent
  • schedule
    Shift:
  • analytics
    Career Level:
  • group
    Positions:
  • calendar_view_day
    Experience:
  • male
    Gender: No Preference
  • school
    Degree:
  • calendar_month
    Apply Before: Dec 30, 2026

Job Description

Work Timings 2PM to 11 PM IST

Working Model Hybrid 3 days work from LTIM office

Location Offshore

Responsibilities

Design and develop Logical Physical Data Models for Data Warehouse Data Mart layers in Snowflake

Create and maintain SourcetoTarget Mapping STM documents ensure accurate data mapping for policy claims and financial domains

Define data entities attributes and relationships based on business requirements data sources and analytical needs

Validate transformation logic for downstream consumption layers used by DBT pipelines and Power BI models

Conduct indepth data analysis and profiling including JSON payload understanding and complex domain structures

Ensure conformance to dimensional modeling normalization denormalization practices

Collaborate closely with Data Engineers to design optimized structures supporting DBT pipelines and Snowflake performance considerations

Technical Primary Skills

12 years of extensive handson experience in Data modeling with Insurance domain background

Experience working in Data warehousing environment

Experience in translating business requirements into logical and physical data model

Design and implement effective data models in Snowflake optimizing for analytical and operational reporting needs

Ability to perform data analysis on source data to come up with relevant models

Experience in developing SCD1SCD2SCD3 Dimension Data models and data warehouse

Strong experience working with Erwin Data Modeler for conceptual logical and physical models

Strong in Snowflake data warehousing concepts staging curated layers marts

Strong SQL skills with the ability to validate transformations and model outputs

Knowledge of handling JSONXML structures schema interpretation and source payload analysis

Strong understanding of data integration issues validation and cleaning familiarity with complex data and structures

Experience working with agile methodology

Secondary Skills

Insurance Domain Expertise in LOB like Workers Compensation WC Commercial Multi Peril CMP Excess Surplus ES Excess Casualty XS Casualty

Soft Skills

Strong analytical thinking and ability to interpret complex business logic

Proactive communication and documentation skills

Ability to work in fast paced multi LOB data programs

Qualifying Questions

1Do you have data modeling experience for building Insurance Data warehouse

2Do you have experience on Data Profiling

3Do you have experience working Erwin tool

4Do you have experience in designing models for Snowflake data warehouse

Skills and qualifications

Mandatory Skills : ERWIN, GCP BigQuery, Microsoft Fabric, MS SQL Server, Redshift

Source: LTIMindtree careers — Read the original posting and apply

This role is listed by the employer on its own careers site. Kaam Ki Khoj does not process applications for it.

See how well you match this job

Make a free profile in a minute — no CV needed — and we score every job against it.

Make my profile

Already registered? Sign in

Company Overview

LTIMindtree
LTIMindtree · Mumbai, Maharashtra, India
610 open roles

LTIMindtree is an employer in the IT/Computers - Software, Software Services sector with operations in India. This is a directory listing maintained by Kaam Ki Khoj so that candidates can find the organisation; it is not an official company page and... Read More

Apply safely

From the employer's own careers site. Kaam Ki Khoj reads this job from ltimindtree.ripplehire.com. You apply there, on the employer's own website.

Applying is free. A genuine employer never asks you to pay: no registration fee, deposit, training fee or kit charge, and never your OTP or bank PIN. If anyone asks for money for this job, it is a scam.

How to spot a fake job · Check an offer free

Report this job

Related Jobs

One upload, every employer

Let the right employer find you

Upload your CV once — we read it, build your profile and put you in front of every employer hiring on Kaam Ki Khoj. No forms, no fees.

Upload your CV Browse jobs