Data Engineer

About the role

Join Ascot Group, a preeminent specialty risk underwriting organization designed as a modern-era company operating through an ecosystem of interconnected global platforms. We are united by a common mission and purpose: One Ascot. Our strength lies in a talented team that thrives in a collaborative, inclusive, and entrepreneurial culture, guided by underwriting excellence, integrity, and a passion for innovation—The Ascot Way.

The Data Engineer will be part of the Data Integration & Delivery Team, responsible for the analysis, development, implementation, testing, and ongoing support of data warehouse projects, including Phinsys and the Data & Integration Hub. This role operates on a hybrid work schedule.

Responsibilities

• Serve as a Data Engineer Level 1 for projects, enhancements, and production support.
• Perform analysis and hands-on development for assigned projects.
• Assist in establishing work estimates based on business requirements through project feasibility, scoping, and estimating activities.
• Contribute to high/low-level designs and technical specifications.
• Validate accuracy and quality of data integrations generated from ETL specifications, ensuring data model specifications are met.
• Design, develop, and test complex data-related work.
• Coordinate and lead production implementations to ensure smooth, quality releases.
• Deliver new warehouse sources, tables, or marts 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.
• Identify opportunities to increase speed and quality of output.
• Articulate ideas and turn them into new capabilities, performance improvements, and quality enhancements.
• Anticipate and report technical and organizational roadblocks.
• 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.
• Experience with ETL tools such as SSIS, Informatica, or ADF.
• Experience in the Commercial and/or Specialty insurance industry is desired.
• Understanding of financial data and concepts.
• Analytical, rigorous, with strong attention to detail.
• Proven SQL skills, including using SQL to identify and correct data issues.
• Database knowledge, preferably SQL Server or Synapse.
• Scripting/SQL skills to perform ETL, data/file validation, analysis, and profiling.
• Ability to create, read, understand, and interpret data models.
• Code maintenance and review experience in one or more general-purpose languages.
• Understanding of insurance domain data models is a plus.

This position may be filled at a different level, depending on experience.

Pay

The annualized base pay range for this role is $95,000 - $110,000. Actual base pay may vary based on factors including experience, expertise, and skills. Base pay is one component of Ascot’s total compensation package, which may also include annual cash bonuses and other discretionary rewards.

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 state/local paid leave where required), Short-term Disability, Long-term Disability, Bereavement, FMLA, Adoption, Maternity, Military, and Primary & Non-Primary Caregiver leave.
• Retirement Benefits: Contributory Savings Plan (401k).