Hybrid Data Engineer, Finance Data Warehouse & ETL

Ascot Group; Hartford (CT); Hybrid; USD 95,000 - 110,000; Full time

Benefits offered by this job

Health and Welfare Benefits

Paid holidays & PTO

401k retirement plan

Job summary

Ascot Group is seeking a Data Engineer to join the Data Integration & Delivery Team. You will analyze, develop, implement, test, and support data warehouse projects including Phinsys and the Data & Integration Hub. The role requires hands-on development with a hybrid in-office schedule.

Ideal candidates have 2+ years in data engineering/analyst roles, strong SQL skills, and ETL experience using SSIS, Informatica, or ADF. Familiarity with insurance data models is a plus.

Qualifications

• Bachelor’s degree in information systems, Computer Science, Data Analytics, or related field.
• 2+ years of experience as a Data Analyst/Engineer for a large Data Warehouse.
• Some ETL Tool experience; SSIS, Informatica, ADF
• Some experience in the Commercial and/or Specialty insurance industry is desired.
• An understanding of financial data and concepts.
• Analytical, rigorous, with attention to detail.
• Proven SQL skills
• Proven experience using SQL to identify and correct data issues.
• Some Database knowledge, preferably SQL Server, Synapse
• Capable scripting/SQL skills to perform ETL, data/file validation, analysis, and profiling.
• Minimal ability to create, read, understand, and interpret Data Models
• Code maintenance and review experience in one or more general purpose languages.
• Understanding insurance domain data models, desired

Responsibilities

• Serve as a Data Engineer Level 1 for projects, enhancements, and production support.
• Be responsible for all analysis and support of assigned projects to include hands-on development.
• Assist in establishing work estimates based on business requirements through participation in project feasibility, scoping, and estimating activities.
• Assist in the high/low level designs and technical specifications that can be accurately executed.
• Validate accuracy/quality of data integrations generated from ETL specifications. Ensure data model specifications are met.
• Assist with hands-on design, development and testing for the most complex data related work.
• Coordinate/lead production implementations to ensure smooth, quality releases.
• Participate in the delivery of new warehouse sources/tables/mart etc. while leveraging existing company standards.
• Coordinate Ascot and Vendor resources to ensure high quality and timely deliverables.
• Think independently and creatively to streamline work and root out inefficiencies.
• Find opportunities to increase speed and quality of output. Must be able to articulate ideas and turn those ideas into new capabilities, performance improvements, and quality improvements.
• Anticipate and report technical and organizational roadblocks.
• Commitment to The Ascot Way: Embody The Ascot Way in their daily interaction with colleagues, fostering colleague engagement and development, collaboration, inclusivity, and individual accountability.

Skills

SQL

Analytical thinking

Attention to detail

Collaboration

Scripting/SQL

Education

Bachelor's degree in information systems, Computer Science, Data Analytics, or related field

Tools

SSIS

Informatica

ADF

SQL Server

Synapse

Job description

Ascot Group is seeking a Data Engineer to join the Data Integration & Delivery Team. You will analyze, develop, implement, test, and support data warehouse projects including Phinsys and the Data & Integration Hub. The role requires hands-on development with a hybrid in-office schedule.

Ideal candidates have 2+ years in data engineering/analyst roles, strong SQL skills, and ETL experience using SSIS, Informatica, or ADF. Familiarity with insurance data models is a plus.