AVP, IT Data

Job Description - AVP, IT Data & Analytics, Data Engineering (25000067)Job DescriptionAVP, IT Data & Analytics, Data Engineering-(25000067)DescriptionAVP, IT Data & Analytics, Data EngineeringTake the next step in your career with us.Allied World is an ideal place for talented professionals who are driven by a belief in the value of collaboration and the power of knowledge.We believe that when our great people work together and support one another, our clients receive the best solutions. We embrace unique perspectives and empower each person to grow through professional development, career training and mentoring programs.Our people are our most important asset, and we are very proud of the quality of our team members.Position SummaryAVP Data Engineering will manage and optimize the existing SQL Server data warehouse, oversee a team of 2 FTEs and 7 consultants, and ensure the delivery of high-quality, reliable data solutions aligned with business goals. This role provides technical leadership, drives process improvements, and maintains robust data engineering practices.Key ResponsibilitiesData Warehouse Management: Maintain and optimize the SQL Server data warehouse, ensuring performance, reliability, and data integrity.Process Optimization: Identify and implement enhancements to ETL processes, data pipelines, and operational workflows.Technical Leadership: Serve as the technical lead for data engineering initiatives, collaborating with Product Owners, Managers, and agile teams to deliver on sprint and program objectives.Project Delivery: Oversee all aspects of data engineering activities, including design, development, testing, documentation, deployment, and production support.Stakeholder Collaboration: Work closely with business and technology teams to understand requirements and deliver effective data solutions.Standards & Compliance: Ensure adherence to data governance, security policies, and best practices across all data engineering activities.Continuous Improvement: Stay up to date with technology changes, particularly in cloud platforms and data privacy.QualificationsProfessional Experience / Qualifications:Experience: 10+ years of IT experience with a focus on hands-on development and data architecture.Technical Skills: Proficient in data modeling, pipeline creation, and merging datasets.Client-Facing: Experienced in leading client engagements and translating technical concepts to non-technical stakeholders.Data Warehousing: 6+ years of real-world data warehousing project experience, with a deep understanding of architectural principles and design patterns.Snowflake & Spark: Strong hands-on experience with Snowflake for data warehousing and Spark for data processing.ETL/ELT Workflow Design: Proven experience in designing efficient and robust ETL/ELT workflows and job scheduling.Performance Tuning: Expertise in performance tuning of SQL queries and Spark jobs.Tool Proficiency: Experience with Git, Jira, and Agile methodologies.Communication Skills: Strong written and verbal communication skills, with the ability to convey complex technical concepts to non-technical stakeholders.Analytical Skills: Excellent analytical and problem-solving abilities, with a self-driven attitude and the ability to work both independently and as part of a team.Soft Skills: Strong attention to detail, collaborative mindset, and curiosity.EducationEducational Background: Bachelor's degree in computer science or a related technical field, or equivalent experience.Allied World Assurance Company Holdings, Ltd, through its subsidiaries, is a global provider of insurance and reinsurance solutions. We operate under the brand Allied World and have supported clients, cedents and trading partners with thoughtful service and meaningful coverages since 2001. We are a subsidiary of Fairfax Financial Holdings Limited and benefit from a strong capital base and a worldwide network of affiliated entities that allow us to think and respond in non-traditional ways.Our generous benefits package includes: Health, Dental and Disability Insurance, a company match 401k plan, and Group Term Life Insurance. Allied World is an Equal Opportunity Employer. All qualified applicants will be considered for employment without consideration of any disability, veteran status or any other characteristic protected by law.To learn more, visit awac.com, or follow us on Facebook at facebook.com/alliedworld and LinkedIn at linkedin.com/company/allied-world.Primary Location:US-CT-FarmingtonWork Locations:Farmington1690 New Britain AvenueSuite 101Farmington06032Job:Information TechnologyEmployee Status:RegularJob Type:StandardJob Posting:Dec 16, 2025, 1:15:21 PMPay BasisYearly