Business Intelligence Engineer

Ascot Group • Chicago, IL

3h • Hybrid

About The Position

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.

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.

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.

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

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)

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level