What are the responsibilities and job description for the Assistant Vice President, Data Transformation & Integration Manager position at Ascot Group?
Job Description
The Assistant Vice President, Data Transformation & Integration Manager plays a pivotal role in leading the optimization of our data transformation efforts, ensuring seamless data integration while supporting enterprise-wide data governance initiatives. 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.
Key Responsibilities
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)
The Assistant Vice President, Data Transformation & Integration Manager plays a pivotal role in leading the optimization of our data transformation efforts, ensuring seamless data integration while supporting enterprise-wide data governance initiatives. 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.
Key Responsibilities
- Lead the strategy, design, and execution of data transformation solutions, ensuring high performance and data integrity.
- Oversee and manage integration and transformation initiatives, ensuring accurate, timely, and secure data movement across systems.
- Implement and maintain robust data governance frameworks, enforcing policies for data quality, security, and compliance.
- 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.
- Bachelor’s degree in a related field or equivalent work experience.
- 10 years of experience in Data Engineering/Data Analysis 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.
- 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
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)
Salary : $165,000 - $185,000
