← Back to jobsJob ID col-cmv8cx0xh03bcoz01p0gtm7t9

Ascot GroupPosted 30+ days ago

Data Engineer

Full-time
Hybrid
2+ years
$95K – $110K/yr
Posted 30+ days ago

Ascot Group is one of the world’s preeminent specialty risk underwriting organizations. They are seeking a Data Engineer to join their Data Integration & Delivery Team, responsible for the analysis, development, implementation, testing, and ongoing support of data warehouse projects.

Posted
30+ Days Ago
Source
Ethic Leaf recruiter
Sector
Information Technology & AI

No employer link yet — an Ethic Leaf recruiter forwards your application

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

Qualifications

  • 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
  • An understanding of financial data and concepts
  • Analytical, rigorous, with attention to detail
  • 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

Preferred

  • Some experience in the Commercial and/or Specialty insurance industry is desired
  • Understanding insurance domain data models, desired
  • Commercial insurance experience
  • Specialty insurance experience
  • Insurance domain data models

Required skills

Data WarehouseETL ToolsSSISInformaticaAzure Data FactoryCommercial InsuranceSpecialty InsuranceFinancial DataSQLSQL ServerAzure SynapseData ModelingCode Maintenance

Full job description

Ascot Group is one of the world’s preeminent specialty risk underwriting organizations. They are seeking a Data Engineer to join their Data Integration & Delivery Team, responsible for the analysis, development, implementation, testing, and ongoing support of data warehouse projects.

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

Preferred

  • Some experience in the Commercial and/or Specialty insurance industry is desired
  • Understanding insurance domain data models, desired
  • Commercial insurance experience
  • Specialty insurance experience
  • Insurance domain data models

Benefits

  • Health and Welfare Benefits: Medical (including prescription coverage), Dental, Vision, Health Savings Account, Commuter Account, Health Care and Dependent Care Flexible Spending Accounts, Life Insurance, AD&D, Work/Life Resources (including Employee Assistance Program), and more.
  • Leave Benefits: Paid holidays, annual Paid Time Off (includes paid state /local paid leave where required), Short-term Disability, Long-term Disability, Other leaves (e.g., Bereavement, FMLA, Adoption, Maternity, Military, Primary & Non-Primary Caregiver)
  • Retirement Benefits: Contributory Savings Plan (401k)

Company

  • Global specialty insurance and reinsurance provider
  • Hamilton, Hamilton, BMU
  • https://ascotgroup.com/
  • Founded in 2001
  • 1001-5000 employees

Qualifications

  • 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
  • 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
  • Some experience in the Commercial and/or Specialty insurance industry is desired
  • Understanding insurance domain data models, desired
  • 2+ years of experience as a Data Analyst/Engineer for a large Data Warehouse working with large data sets.

Required skills

  • Data Warehouse, ETL Tools, SSIS, Informatica, Azure Data Factory, Commercial Insurance, Specialty Insurance, Financial Data, SQL, SQL Server, Azure Synapse, Data Modeling, Code Maintenance, General Purpose Programming Languages

Preferred skills

  • Understanding insurance domain data models, desired

Experience

  • 2+ years

Job details

Employment type

Full-time

Seniority level

2+ years

Date posted

Oct 9, 2026

Work mode

Hybrid

Job source

Ethic Leaf recruiter

Company

Ascot Group

Information Technology & AI

Global specialty insurance and reinsurance provider

See all 4 jobs from Ascot Group →
  • Woodbridge Township, NJ
  • Information Technology & AI
  • 1001-5000 employees
  • Founded 2001
  • ascotgroup.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in Woodbridge Township

Curana Health

1d ago

New

Data Engineer

Full-timeRemoteUnited StatesCompetitive

Curana Health is hiring a Data Engineer to build, optimize, and maintain data pipelines supporting clinical, operational, and analytical reporting.

Why similarSame roleAzure Data FactoryRemote

Airbnb

1d ago

New

Data Engineer Tech Foundations

Full-timeRemoteUnited States$162K – $186K/yr

Airbnb is hiring a Data Engineer to build and operate reliable, reusable datasets and pipelines that support AI usage and cost measurement, Unit Economics, enterprise application data, and critical financial metrics.

Why similarSame roleData ModelingRemote

eTeam

1d ago

New

Data Engineer

TemporaryRemoteUnited StatesCompetitive

SMBC US is hiring a Data Engineer to build systems that gather, store, and process large volumes of data for analysis. The role focuses on developing ETL pipelines, ensuring data quality, and optimizing data storage solutions.

Why similarSame roleAzure Data FactoryRemote

Get new Data Engineer jobs in Woodbridge Township by email

Create job alert

Data Engineer

Ascot Group · $95K – $110K/yr

Apply via Ethic Leaf