SSIS Finance Jobs

1 job found

2mo ago

Data Engineer, Finance

ASCOT GROUP Iselin, NJ

Iselin, NJ

2mo ago Closed

$95k - $110k/yr Full time Azure Data Factory Azure Synapse Analytics Data

This position is no longer accepting applications (closed Jul 2, 2026).

Job Description

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

View full job page →

Get SSIS Finance Jobs alerts

New SSIS Finance Jobs, daily.