Assistant Vice President, Data Transformation & Integration Manager
About The Position
Ascot Group is seeking an Assistant Vice President, Data Transformation and Integration Manager to lead data transformation and integration delivery while supporting enterprise-wide data governance. Reporting to the VP, Information Management, US, this role oversees the design, implementation, and maintenance of data pipelines and ensures compliance with data governance policies. The successful candidate will drive strategic transformation initiatives, improve data quality and governance adherence, and collaborate with cross-functional teams to strengthen enterprise data management. This is an in-office role with a hybrid work schedule. Ascot is embedding AI and automation across the organization, and the role calls for confidence using AI-enabled tools, sound judgment when interpreting insights, curiosity, critical thinking, and adaptability as technology evolves. The role may be filled at a different level depending on experience.
Requirements
- Bachelor’s degree in a related field or equivalent work experience.
- At least 10 years of experience, including major data transformation delivery, data engineering, data analysis, and data architecture in large-scale data warehouse environments.
- Proficiency with 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.
- Ability to design and implement scalable database solutions and data models.
- Commercial and/or Specialty Insurance industry experience.
- Knowledge of financial data structures and business intelligence concepts.
- Experience working with third-party data providers and managing vendor relationships.
- Ability to translate complex technical concepts into clear, business-oriented insights.
- Strong analytical mindset, attention to detail, and focus on continuous improvement.
- Ability to manage multiple projects and meet deadlines effectively.
- Knowledge of API-based integrations and data streaming architectures.
- Experience directly managing data teams and leading efforts through matrixed reporting lines.
- Ability to work confidently with AI-enabled tools, interpret insights with sound judgment, and adapt as technology evolves.
Nice To Haves
- Guidewire experience.
Responsibilities
- Lead the strategy, design, and execution of data transformation solutions, ensuring quality, performance, and data integrity.
- Oversee integration and transformation initiatives to ensure 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 transformations with organizational objectives.
- Monitor, troubleshoot, and optimize data integration workflows to minimize disruption and maximize efficiency.
- Enforce data governance, security, and compliance best practices in data integration processes.
- Stay current on data integration tools and governance technologies to drive continuous improvement.
- Provide leadership, mentorship, and guidance to data engineers and integration specialists.
- Demonstrate The Ascot Way through cross-team collaboration, inclusivity, accountability, and contributions to an engaged, high-performing culture.
Benefits
- Competitive benefits package, subject to eligibility requirements.
- Medical insurance, including prescription coverage.
- Dental insurance.
- Vision insurance.
- Health Savings Account.
- Commuter Account.
- Health Care and Dependent Care Flexible Spending Accounts.
- Life insurance and AD&D coverage.
- Work/Life Resources, including an Employee Assistance Program.
- Paid holidays and annual Paid Time Off, including state/local paid leave where required.
- Short-term and long-term disability coverage.
- Other leaves, including bereavement, FMLA, adoption, maternity, military, and primary and non-primary caregiver leaves.
- Contributory Savings Plan (401k).
- Annual cash bonus and other forms of discretionary compensation may be awarded by the Company.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
