Data Engineer

Ascot Group; Phoenix (AZ); On-site; USD 95,000 - 110,000; Full time

Benefits offered by this job

Health and welfare benefits

Leave benefits

Retirement benefits

Job summary

Ascot Group in Phoenix, AZ is seeking a Data Engineer to support data warehouse projects, including Phinsys and the Data & Integration Hub. The role involves analysis, development, testing, and ongoing support in a hybrid office setting.

The position requires 2+ years of data engineering/analysis experience, strong SQL, ETL tooling (SSIS/Informatica/ADF), and a solid understanding of financial data concepts within insurance. Collaboration and problem solving are key.

Qualifications

• Bachelor’s degree in information systems, Computer Science, Data Analytics, or a related field.
• 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.

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.

Skills

SQL

ETL

Data warehouse

Data modeling

Scripting/SQL

Synapse

SQL Server

Proven SQL skills

Data analysis

Financial data concepts

Education

Bachelor’s degree in information systems, Computer Science, Data Analytics, or related field

Tools

SSIS

Informatica

Azure Data Factory (ADF)

SQL Server

Synapse

Job description

Job Description

This is an opportunity to join Ascot Group - one of the world’s preeminent specialty risk underwriting organizations.

Designed as a modern-era company operating through an ecosystem of interconnected global operating platforms, we’re bound by a common mission and purpose: One Ascot. Our greatest strength is a talented team who flourishes in a collaborative, inclusive, and entrepreneurial culture, steeped in underwriting excellence, integrity, and a passion to find a better way, The Ascot Way.

The Ascot Way guides our people and our organization. Our underwriting platforms collaborate to find creative ways to deploy our capital in a true cross-product and cross-platform approach. These platforms work as one, deploying our capital creatively through our unique Fusion Model: Client Centric, Risk Centric, Technology Centric.

Built to be resilient, Ascot maximizes client financial security while delivering bespoke products and world class service — both pre- and post-claims. Ascot exists to solve our clients’ brightest tomorrow, through agility, collaboration, resilience, and discipline.

Ascot is embedding artificial intelligence (AI) and automation across the organization to enhance decision making, efficiency, and quality of outcomes. In this role, you will be expected to work confidently alongside AI enabled tools, apply sound judgment when interpreting insights, and adapt as technology continues to evolve. We value curiosity, critical thinking, and a willingness to embrace change as part of how we work.

Position Overview

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

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.

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

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

Compensation

Actual base pay could vary and may be above or below the listed range based on factors including but not limited to experience, subject matter expertise, and skills. The base pay is just one component of Ascot’s total compensation package for employees. Other rewards may include annual cash bonus and other forms of discretionary compensation awarded by the Company.

The annualized base pay range for this role is: $95,000 - $110,000

Company Benefits

The Company provides a competitive benefits package that includes the following (eligibility requirements apply):

• 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)