Data Engineer - DBT, Snowflake & SSIS
Skills
About the role
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
Questions about this role
Want AI Applyd to auto-apply to roles like this?
We tailor your resume per posting, fill the forms, and track replies for you.