Kumaran Systems

Discussion

Data Engineer - DBT, Snowflake & SSIS

Summary

Builds and maintains ETL pipelines using Snowflake, DBT, and SSIS for insurance data, troubleshooting issues and mentoring junior team members.

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

Show
Kumaran Systems
2 weeks ago

QA Engineer - ETL & DWH

APAC

QA Engineer focused on ETL and Data Warehouse testing, performing source-to-target validation and data quality checks using SQL. Also involved in testing reports/dashboards like Tableau/Power BI.

automationclouddata-qualitydata-warehousingetl +5 skills
The Paper Store
2 weeks ago

Data Engineer

North America

Build and optimize ETL pipelines using Snowflake, Matillion, and SSIS. Ensure data quality and support data warehousing operations in a hybrid role.

analyticsclouddata-engineeringdata-governancedata-lake +10 skills
80 000 – 100 000 $
Bluelight Consulting
12 hours ago

Data Engineer (Senior) - ETL (Python+Snowflake) - Remote, Latin América

RemoteLATAMFull-timeSenior

Senior Data Engineer builds and maintains scalable ETL pipelines using Python, Snowflake, and Azure, focusing on data ingestion, transformation, and cloud-based analytics for enterprise clients.

agileanalyticsapiazureazure-data-factory +30 skills
Rush street interactive
last week

Data Engineer

Europe

Data Engineer to build and maintain scalable Snowflake-based data pipelines using Python, SQL, Airflow, and DBT on AWS, ensuring data quality, security, and performance for an online casino and sports betting platform.

aiairflowanalyticsapiautomation +23 skills
Experian
6 days ago

Junior Data Engineer

EuropeFull-timeSenior

Junior Data Engineer maintains and troubleshoots ETL/ELT pipelines using SQL, Scala, PySpark, and cloud tools like AWS and SQL Server to ensure accurate data processing for analytics.

agileanalyticsautomationawsbitbucket +13 skills
Simera
last week

Data Engineer NI

RemoteNorth America

Designs, builds, and maintains scalable data pipelines, ETL/ELT processes, and cloud-based data infrastructure to enable reliable, high-performance analytics and decision-making.

airflowawsazurebigquerycloud +15 skills