Assistant Vice President, Data Transformation & Integration Manager

Ascot Group•Iselin, NJ

10d•$190,000 - $200,000•Hybrid

About The Position

The Assistant Vice President, Data Transformation and Integration Manager leads the optimization of data transformation efforts, oversees seamless data integration delivery, and supports enterprise-wide data governance. Reporting to the VP, Information Management, US, this role oversees the design, implementation, and maintenance of data pipelines while ensuring compliance with data governance policies. The position drives strategic data transformation, improves data quality and governance adherence, and collaborates with cross-functional teams to enhance enterprise data management. It is an in-office role with a hybrid work schedule. Ascot is embedding AI and automation across the organization. The person in this role is expected to work confidently with AI-enabled tools, apply sound judgment when interpreting insights, and adapt as technology evolves. Curiosity, critical thinking, and willingness to embrace change are valued.

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 within 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.
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.
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 managing data teams directly and leading efforts through matrixed reporting lines.

Nice To Haves

Experience with Guidewire.

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 transformation and integration workflows that support enterprise 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 to minimize disruption and maximize efficiency.
Enforce data governance, security, and compliance best practices in data integration processes.
Keep up to date on emerging data integration tools and governance technologies to drive continuous improvement.
Provide leadership, mentorship, and guidance to data engineers and integration specialists.
Collaborate across teams, embrace inclusivity, demonstrate accountability, and help build an engaged, high-performing culture.