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 flourish 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 for our clients’ brightest tomorrow, through agility, collaboration, resilience, and discipline.

The Global Data Delivery Lead plays a pivotal role in transforming data into actionable insights that support strategic decision-making. This role is central to enabling data-driven culture across the organization, particularly in high-impact environments like Ascot Group, where data modernization and AI integration are strategic priorities. The ideal candidate should be hands-on with ETL tools like Databricks, BI development and visualization using Power BI. This position will report to Senior AI Data Program Manager and will be an in-office position on a hybrid work schedule.

Responsibilities:
Data Integration & Architecture

• Design and maintain robust data pipelines using ETL tools.
• Integrate diverse data sources into a unified data warehouse or Lakehouse architecture in Databricks.
• Support the transformation of raw data into conformed enterprise models and data schemas for reporting in Power BI.
• Integrate Power BI with various data sources, including SQL Server, SharePoint, external APIs, Databricks.

BI Development & Visualization:

• Develop and maintain data models, including DAX calculations, to support Power BI reports and dashboards.
• Design and develop interactive power BI reports and dashboards using Power BI desktop.
• Ensure semantic models are optimized for self-service analytics and paginated reporting.

Analytics & Insights:

• Collaborate with business stakeholders to define KPIs and build analytical models.
• Work closely with Group data office to execute on our unified global data delivery strategy as well as ensuring our data delivery pipelines are optimized for AI use cases.
• Apply statistical and predictive modeling techniques to uncover trends and patterns.
• Support AI-driven initiatives by preparing structured data for modeling and insights.

Governance & Quality:

• Implement data quality rules and validation checks to ensure trusted reporting.
• Participate in data governance initiatives to align with compliance and regulatory standards.

Collaboration:

• Work closely with cross-functional teams including data stewards, architects, business analysts, data scientists and end users.
• Provide technical guidance as applicable to junior/offshore resources.
• Engage in stakeholder communication and triage data requests for prioritization.

Requirements:

• Bachelor’s degree in information technology, Computer Science, Business Analytics, or a related field.
• A minimum of 7 years of experience in progressive data delivery and Power BI development.
• Hands- on strong technical proficiency in SQL, data warehouse concepts and data integration techniques, with focus on Databricks.
• Strong understanding of data platforms, analytics tools, and AI technologies, with the ability to resolve issues related to data and reporting.
• Excellent communication and interpersonal skills, with the ability to engage effectively across all levels of the organization.
• Knowledge of Power BI best practices for data modelling and reporting.
• Knowledge on insurance business processes and terminologies including underwriting, claims, pricing, operations etc. preferred.
• 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.

***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 salary range for this position in Chicago and New York Metro is $155,000-$165,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)

#LI-Hybrid