Data Engineer

Ascot Group; Chicago (IL); On-site; USD 95,000 - 110,000; Full time

Benefits offered by this job

Health and Welfare Benefits

Paid Time Off

Retirement Benefits

Job summary

A leading specialty risk underwriting organization in Chicago is seeking a Business Intelligence Engineer. Your role will involve developing and maintaining Power BI reports while collaborating with data engineers and business partners. The ideal candidate should have 2-3 years of experience with Power BI, a strong understanding of SQL, and a keen attention to detail. This position offers a hybrid work schedule and opportunities for professional growth within a collaborative team environment.

Qualifications

• 2–3 years of experience working with Power BI in a professional environment.
• Some experience with relational databases and structured datasets.
• Ability to communicate clearly in writing and verbally.

Responsibilities

• Assist in the development and maintenance of Power BI reports and dashboards.
• Support Power BI semantic models by managing measures and relationships.
• Write SQL queries to retrieve and validate data from sources.

Skills

Power BI

SQL

Attention to detail

Analytical mindset

Problem-solving skills

Education

Bachelor’s degree in Information Systems, Data Analytics, Computer Science or related field

Tools

SQL Server

Power BI

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.

Position Overview

Reporting to the Business Intelligence Lead, the Business Intelligence Engineer supports the development and maintenance of Power BI reports and dashboards used across Ascot’s business, operations, and finance teams. This role works closely with senior BI engineers, data engineers, and business partners to deliver accurate, well-structured reporting solutions. The ideal candidate has a foundational understanding of Power BI and SQL, strong attention to detail, and a desire to continue developing technical and analytical skills in an enterprise data environment. This role will be in the office with a hybrid work schedule.

Responsibilities

• Assist in the development and maintenance of Power BI reports, dashboards, and datasets.
• Support Power BI semantic models by creating and maintaining basic measures, calculated columns, and relationships.
• Write and modify SQL queries to retrieve and validate data from enterprise data sources.
• Perform data validation and reconciliation to ensure reports are accurate and align with source systems.
• Work with senior developers and data engineers to understand data structures, definitions, and reporting standards.
• Help address report defects, enhancements, and routine maintenance requests.
• Participate in requirements discussions to understand reporting needs and assist in translating them into Power BI solutions.
• Follow established development standards, naming conventions, and documentation practices.
• Learn and apply best practices related to data modeling, report performance, and usability.
• 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, Data Analytics, Computer Science, or a related field (or equivalent experience).
• 2–3 years of experience working with Power BI in a professional or business setting.
• Some experience working with relational databases and structured datasets.
• Strong attention to detail and commitment to data accuracy.
• Ability to work effectively in a collaborative, team-based environment.
• Willingness to learn new tools, techniques, and business concepts.
• Power BI fundamentals, including:
  • Report and dashboard creation
  • Basic data modeling concepts
  • Introductory DAX measures and calculations
• Working knowledge of SQL for querying and validating data.
• Familiarity with relational databases (e.g., SQL Server or similar platforms).
• Basic understanding of data warehousing and ETL concepts.
• Ability to read and follow existing data models and report designs.
• Analytical mindset with strong problem-solving skills.
• High attention to detail and data quality.
• Clear written and verbal communication skills.
• Positive attitude and eagerness to grow technical capabilities.

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 an 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

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