Data Engineer

Position Overview

The Data Engineer is critical to the ongoing development and support of Data Warehousing projects for Ascot US. This role will work closely with business partners across Underwriting, Operations, Finance, Actuarial, and Finance. The role is based in the office with a hybrid work schedule.

Responsibilities

• Partner with business stakeholders to understand data, reporting, and analytics requirements and translate them into actionable solutions.
• Design, develop, and maintain data pipelines, ETL/ELT processes, and data integrations supporting enterprise reporting and analytics.
• Develop and optimize SQL queries, datasets, and data models to support reporting, analysis, and operational decision-making.
• Build and maintain Power BI reports, dashboards, and semantic models that provide timely and meaningful business insights.
• Validate, reconcile, and monitor data to ensure accuracy, completeness, and consistency across source systems and reporting outputs.
• Collaborate with data engineers, business analysts, and subject matter experts to understand business processes, data structures, and reporting needs.
• Support the testing, deployment, and ongoing maintenance of data and reporting solutions, including issue resolution and enhancements.
• Participate in project planning, requirements gathering, estimation, and solution design activities for data-centric initiatives.
• Document business requirements, data transformations, reporting logic, and technical processes in accordance with established standards.
• Identify opportunities to improve data quality, automate manual processes, and enhance reporting capabilities across the organization.

Requirements

• A minimum of 3 years of experience in data analytics, business intelligence, reporting, or data engineering-related roles.
• Strong SQL development and data analysis skills.
• Experience with Power BI or similar business intelligence tools preferred.
• Familiarity with data warehouse concepts, ETL/ELT processes, and dimensional modeling.
• Experience working with enterprise data platforms, cloud data services, or modern analytics environments.
• Strong analytical, problem-solving, and stakeholder communication skills.
• Bachelor’s degree in information systems, Computer Science, Data Analytics, or a related field (or equivalent experience).
• Experience working within the insurance industry is highly preferred, including familiarity with insurance operations, policy, claims, underwriting, finance, or regulatory reporting data domains.

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.

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: $110,000 - $125,000.

Company 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).