Data Engineer

Overview

On Site
Full Time

Skills

SQL
SSIS
Data Engineer
ETL/ELT
Snowflake
DBT

Job Details

Position: Data Engineer

Location: New Jersey City

Fulltime

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 grows

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-resolution process

  • Self-motivated, team player 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 -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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.