← Back to jobsJob ID col-cmv8bhdr301looz01i9kxsv3q

Ascot GroupPosted 30+ days ago

Data Engineer

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

Ascot Group is a specialty risk underwriting organization using data, artificial intelligence, and automation to improve decision-making and business outcomes. The Data Engineer will develop and support data warehousing, pipelines, ETL/ELT processes, SQL solutions, reporting assets, and analytics initiatives while collaborating with stakeholders across the organization.

Posted
30+ Days Ago
Source
fa-emkq-saasfaprod1.fa.ocs.oraclecloud.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

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
  • Some may 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
  • 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

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

Preferred

  • Experience with Power BI or similar business intelligence tools preferred
  • Experience working within the insurance industry is highly preferred, including familiarity with insurance operations, policy, claims, underwriting, finance, or regulatory reporting data domains

Required skills

SQLData WarehousingETL/ELTDimensional ModelingPower BIData AnalyticsBusiness IntelligenceInsurance Operations Data

Full job description

Ascot Group is a specialty risk underwriting organization using data, artificial intelligence, and automation to improve decision-making and business outcomes. The Data Engineer will develop and support data warehousing, pipelines, ETL/ELT processes, SQL solutions, reporting assets, and analytics initiatives while collaborating with stakeholders across the organization.

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
  • Some may 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
  • 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

  • Experience with Power BI or similar business intelligence tools preferred
  • Experience working within the insurance industry is highly preferred, including familiarity with insurance operations, policy, claims, underwriting, finance, or regulatory reporting data domains
  • Power BI
  • Insurance Industry
  • Insurance Operations
  • Policy Data
  • Claims Data
  • Underwriting Data
  • Finance Data
  • Regulatory Reporting

Benefits

  • The role will be in the office with a hybrid work schedule.
  • Medical benefits, including prescription coverage.
  • Dental benefits.
  • Vision benefits.
  • Health Savings Account.
  • Commuter Account.
  • Health Care and Dependent Care Flexible Spending Accounts.
  • Life Insurance.
  • AD&D insurance.
  • Work/Life Resources, including Employee Assistance Program.
  • Paid holidays.
  • Annual Paid Time Off, including paid state/local paid leave where required.
  • Short-term Disability.
  • Long-term Disability.
  • Other leaves, including Bereavement, FMLA, Adoption, Maternity, Military, Primary Caregiver, and Non-Primary Caregiver leave.
  • Contributory Savings Plan (401k).
  • Annual cash bonus and other forms of discretionary compensation awarded by the Company.

Company

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

Qualifications

  • 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
  • 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 with Power BI or similar business intelligence tools preferred
  • Experience working within the insurance industry is highly preferred, including familiarity with insurance operations, policy, claims, underwriting, finance, or regulatory reporting data domains
  • A minimum of 3 years of experience in data analytics, business intelligence, reporting, or data engineering-related roles.

Required skills

  • SQL, Data Warehousing, ETL/ELT, Dimensional Modeling, Power BI, Data Analytics, Business Intelligence, Insurance Operations Data

Experience

  • 3+ years

Job details

Employment type

Full-time

Seniority level

3+ years

Date posted

Oct 9, 2026

Work mode

Hybrid

Job source

fa-emkq-saasfaprod1.fa.ocs.oraclecloud.com

Company

Ascot Group

Information Technology & AI

Global specialty insurance and reinsurance provider

See all 4 jobs from Ascot Group →
  • Chicago, IL
  • 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 Chicago

Numerator

1d ago

New

Data Engineer II

Full-timeOn-siteChicago, IL$106K – $146K/yr

Numerator is hiring a Data Engineer II to develop resilient data pipelines and infrastructure for data products, analytics, and data science models.

Why similarSame roleData WarehousingChicago

Coinbase

1d ago

New

Senior Software Engineer, Data Engineering Platform

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

Coinbase is hiring a Senior Software Engineer for its Data Platform team. The role builds and maintains SDKs, self-service applications, reusable abstractions, and security and observability tooling that help internal teams create, manage, and use data…

Why similarSame roleBusiness IntelligenceRemote

GTECH LLC

1d ago

New

Microsoft Fabric Data Engineer (Mid-Level):::Hybrid in Golden Valley, MN

Full-timeHybridGolden Valley, MNCompetitive

GTECH LLC is adding mid-level Microsoft Fabric data engineers to its Process, Data, and Technology team.

Why similarSame roleDimensional ModelingPower BI

Get new Data Engineer jobs in Chicago by email

Create job alert

Data Engineer

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

Apply on company site