Data Engineer, Finance

Ascot Group’s Data Integration & Delivery Team is seeking a Data Engineer to design, build, test, and support data warehouse initiatives. The role centers on Phinsys and the Data & Integration Hub, with a hybrid in-office schedule in Iselin, NJ and a salary range of USD 95,000 to 110,000 per year. A bachelor’s degree and at least two years of relevant experience are required.

Position Overview

Based in Iselin, NJ with a hybrid work arrangement, the Data Engineer will contribute to analysis, development, implementation, testing, and ongoing support of data warehouse projects, including Phinsys and the Data & Integration Hub. The compensation range for this role is USD 95,000 to 110,000 annually, and a Bachelor's degree is required.

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 daily interactions, fostering colleague engagement, collaboration, inclusivity, and accountability.

Requirements

• Bachelor’s degree in information systems, Computer Science, Data Analytics, or a related field (or equivalent experience).
• 2+ years of experience as a Data Analyst/Engineer for a large Data Warehouse working with large data sets.
• 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

Technologies

• Phinsys
• Data & Integration Hub
• SQL
• SSIS
• Informatica
• ADF
• SQL Server
• Synapse

Benefits

• Health and welfare benefits
• Leave benefits
• Retirement benefits