Assistant Vice President, Data Transformation & Integration Manager

Ascot Group; Hartford (CT); Hybrid; USD 190,000 - 200,000; Full time

Benefits offered by this job

Health and Welfare Benefits

Paid holidays

401k

Job summary

Ascot Group, a premier risk underwriting organization, is seeking an Assistant Vice President, Data Transformation and Integration Manager to lead enterprise data transformation initiatives. You will oversee data pipelines, governance, and cross‑functional collaboration to improve data quality and regulatory compliance.

The role reports to the VP, Information Management, US, and is an in-office position with a hybrid work schedule, requiring strong leadership of data engineers and integration

Qualifications

• Ten years in data transformation delivery within large-scale data warehouses.
• Strong knowledge of governance, security, and regulatory requirements.
• Experience with third‑party data providers and vendor management.

Responsibilities

• Lead data transformation strategy, design, and execution with focus on quality and performance.
• Oversee data integration initiatives ensuring secure, timely data movement across systems.
• Establish governance workflows aligned with enterprise policies and regulatory needs.
• Collaborate with stakeholders to align transformations with business goals.
• Mentor and guide data engineers and integration specialists; drive continuous improvement.

Skills

Data governance

Data transformation

Data engineering

Data analysis

Project management

Vendor management

Leadership

Mentorship

Education

Bachelor’s degree or equivalent

Tools

SSIS

Informatica

Azure Data Factory

SQL Server

Azure Synapse Analytics

API integrations

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. 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 Client Centric, Risk Centric and Technology Centric strategies.

Built to be resilient, Ascot offers clients leading 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.

Ascot is embedding artificial intelligence (AI) and automation across the organisation to enhance decision‑making, efficiency, and quality of outcomes. In this role, you will be expected to work confidently alongside AI‑enabled tools, apply sound judgment when interpreting insights, and adapt as technology continues to evolve. We value curiosity, critical thinking, and a willingness to embrace change as part of how we work.

Job Summary

The Assistant Vice President, Data Transformation and Integration Manager plays a pivotal role in leading the optimization of our data transformation efforts, ensuring seamless data integration delivery while supporting enterprise-wide data governance. Reporting to the VP, Information Management, US, this role will be responsible for oversight in the design, implementation, and maintenance of data pipelines while ensuring compliance with data governance policies. The ideal candidate will drive strategic data transformation efforts, enhance data quality, drive data governance adherence and collaborate with cross-functional teams to improve enterprise data management. This role will be an in-office role with a hybrid work schedule.

Responsibilities

• Lead the strategy, design, and execution of data transformation solutions, ensuring high quality, performance and data integrity.
• Oversee and manage integration and transformation initiatives, ensuring accurate, timely, and secure data movement across systems.
• Establish and manage data transformation and integration workflows that support enterprise-wide data governance and regulatory requirements.
• Collaborate with business stakeholders, data governance teams, and IT teams to align data transformations with organizational objectives.
• Monitor, troubleshoot, and optimize data integration workflows, ensuring minimal disruption and maximum efficiency.
• Enforce best practices for data governance, security, and compliance in all data integration processes.
• Stay updated on emerging data integration tools and governance technologies to drive continuous improvement.
• Provide leadership, mentorship, and guidance to a team of data engineers and integration specialists.
• Demonstrate The Ascot Way by collaborating across teams, embracing inclusivity, and demonstrating accountability while helping build an engaged, high-performing culture.

Requirements

• Bachelor’s degree in a related field or equivalent work experience.
• A minimum of 10 years of experience including major Data Transformation delivery, Data Engineering, Data Analysis and Data Architecture within large-scale data warehouse environments.
• Proficiency in ETL tools such as SSIS, Informatica, or Azure Data Factory (ADF).
• Strong understanding of data governance principles, compliance, and security best practices.
• Extensive experience with database technologies, preferably SQL Server and Azure Synapse Analytics.
• Proven ability to design and implement scalable database solutions and data models.
• Experience in the Commercial and/or Specialty Insurance industry is required.
• Knowledge of financial data structures and business intelligence concepts.
• Experience working with third-party data providers and managing vendor relationships, with Guidewire experience preferred.
• Ability to translate complex technical concepts into clear, business-oriented insights.
• Strong analytical mindset, with excellent attention to detail and a focus on continuous improvement.
• Proven ability to manage multiple projects and meet deadlines effectively.
• Knowledge of API-based integrations and data streaming architectures.
• Experience managing both data teams directly and leading efforts through matrixed reporting lines.

This role can 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: $190,000 - $200,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)