Job description

Key Objectives/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.
  • Identifies 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
  • Identify, manage, and document processes; review and coordinate testing, verify counts and ensure accuracy.
  • Mentor and support team members on best practices
  • Identify and incorporate automation into our existing and new processes.
  • Perform design review to ensure the solution will meet future growth and business requirements.
  • Work closely with BA, Architects, and QA Teams to execute unit testing, support integration testing, and regression testing for all business processes.
  • Create, configure, test, deploy, and maintain jobs for inbound and outbound processing.
  • Develop new or improve the existing ETL solutions as the company & data grow.



  • Experience with SSIS, SQL Server, SQL, relational database, etc.- 3 to 5 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 -resolution process.
  • Initiative-taking, collaborator with the ability to work and mentor junior resources in different regions Ability to work with the 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.
  • Experience with Snowflake - 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

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.