Data Engineer - DBT, Snowflake & SSIS

Job Information

Department Name

Insurance

Date Opened

07/12/2026

Industry

IT Services

Job Type

Full time

Skills

Data and Business Intelligent Specialist

Work Experience

5+ years

Required Skills

sql server integration se...

microsoft sql server

+14

Role Type

Database Consultant

City

Siruseri, Chennai

State/Province

603103

Country

India

Zip/Postal Code

603103

About Us

Kumaran Systems: Engineering Future-Ready Transformations Since 1992, Kumaran Systems has been helping enterprises bridge the past and the future, reimagining legacy systems and embracing AI-led possibilities. With over 34 years of delivery excellence, we specialise in re-engineering core applications, driving cloud transformation, and building automation-first, GenAI-enabled ecosystems across the Banking and Financial Services, Insurance, Telecom, and Automotive sectors. We help organisations not just upgrade their systems but reimagine what’s possible.

Why Kumaran?

We blend engineering discipline with AI innovation, helping clients modernise with confidence, automate with clarity, and scale with purpose. Our global delivery model ensures agility, responsiveness, and seamless collaboration, with clients always at the heart of every engagement. At Kumaran, we don’t just solve problems, we engineer future-ready transformations.

Job Description

Key Responsibilities

• A strong understanding of common data integration challenges within the insurance industry, as well as the best-practice technical approaches & solutions available through data integration, data warehouse, and data lake technologies

•

Ability to lead by example, having worked as a technical build resource

•

Experience in how technology solutions can enable business transformation

•

Incorporate and implement ETL/ELT best practices within the group

•

Identify and recommend new ETL/ELT features/tools and design and develop the optimal solution to address business requirements

•

Responsible for the development and maintenance of CAESAR (i.e. EDW) ETL/ELT Processes

•

Translate functional requirements into technical specifications and solutions

•

Perform ad hoc analysis using SQL to extract data sets

•

Research innovative technologies and provide ideas for technological or workflow/process improvements

•

Identify opportunities to re-engineer existing solutions to utilize technology better, optimize performance, and simplify support

•

Analyze current processes to determine or update Key Performance Metrics

Requirements

Qualifications/Skills

•

Experience with Snowflake, DBT - 1 to 2 years - Required

• Experience with SSIS, SQL Server, SQL, relational database, etc. - 1 to 3 years - Required

•

Knowledge of the Property and casualty

•

Insurance industry is a plus

•

Ability to recognize past issue patterns and apply them to the existing problem-resolutionprocess

•

Self-motivated team player with the ability to work with and mentor junior resources across different regions.

•

Ability to work with other groups and lead the ETL solution

•

Excellent analytical, problem-solving, written, and oral communication skills

•

Experience with Azure - 0-2 years - good to have

•

Comfortable working with complex ETL solutions and large data sets

•

Organized with strong written and Verbal communication skills

•

Familiar with Jira, Confluence, and Agile Processes

Kumaran Systems is an Equal Opportunity Employer and does not discriminate on the basis of race or ethnicity, religion, sex, national origin, age, veteran disability or genetic information or any other reason prohibited by law in employment.