Hybrid Data Engineer — Finance Data & Analytics

Ascot Group; New York (NY); Hybrid; USD 95,000 - 110,000; Full time

Benefits offered by this job

Health benefits

401k

Paid time off

Job summary

Ascot Group in the United States is seeking a Data Engineer Level 1 to join the Data Integration & Delivery Team. You will analyze, develop, test, and support data warehouse projects, including Phinsys and the Data & Integration Hub, with a hybrid office-based schedule.

The role emphasizes hands-on ETL and SQL work, collaboration with engineers, and adherence to Ascot Way—fostering collaboration, integrity, and excellence while applying AI-enabled tools.

Qualifications

• Bachelor’s degree in a related field or equivalent experience.
• 2+ years of data warehouse experience with large data sets.
• Experience with ETL tools (SSIS, Informatica, ADF).
• Strong SQL skills and data modeling understanding.
• Ability to work in a hybrid office setting.

Responsibilities

• Serve as 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

Data Modeling

ETL Development

Scripting

Education

Bachelor’s degree

Tools

SSIS

Informatica

ADF

SQL Server

Job description

Ascot Group in the United States is seeking a Data Engineer Level 1 to join the Data Integration & Delivery Team. You will analyze, develop, test, and support data warehouse projects, including Phinsys and the Data & Integration Hub, with a hybrid office-based schedule.

The role emphasizes hands-on ETL and SQL work, collaboration with engineers, and adherence to Ascot Way—fostering collaboration, integrity, and excellence while applying AI-enabled tools.