AVP, Data Engineer

Vantage Risk Ltd.; New York, Northern (NY, KY); Hybrid; USD 175,000 - 210,000; Full time

Benefits offered by this job

Performance-based bonus

Health & welfare benefits

Retirement plans with company match

Flexible work environment

Job summary

Vantage Group Holdings Ltd. seeks an AVP, Data Engineer to ingest and transform replicated data into data products for the Reporting team. Hybrid role with commutable NY or Chicago location, reporting to the VP Data Engineering & ETL Lead.

Base salary $175,000–$210,000 with bonus potential and strong benefits. Requires 8+ years in data engineering, expertise in SQL, Python, dbt, and hands-on with Dagster/Airflow.

Qualifications

• Bachelor's degree in Computer Science or equivalent combination of education and professional experience.
• 8+ years of Data Engineering experience designing, building, and supporting enterprise data platforms, ingestion frameworks, and transformation pipelines.
• Strong expertise in SQL, Python, and dbt, with experience developing and optimizing large-scale ETL/ELT solutions.
• Hands-on experience with Dagster, Airflow, or similar workflow orchestration tools.
• Experience building and managing data ingestion and replication pipelines from relational databases (PostgreSQL, Oracle), NoSQL sources, and file-based data feeds into Snowflake, Databricks, or comparable modern data platforms.
• Deep understanding of data modeling concepts, including dimensional modeling, Medallion Architecture, Data Vault, and highly relational data structures.
• Experience transforming complex business data into trusted, consumable datasets for reporting, analytics, and downstream business users.
• Strong knowledge of data engineering best practices, including testing, code reviews, Git version control, and CI/CD processes.
• Familiarity with distributed data processing technologies, Kubernetes, and modern cloud-based data ecosystems.
• Demonstrated ability to mentor junior engineers, conduct code reviews, and drive technical best practices across a team.
• Proven success operating in a player-coach capacity, balancing hands-on development with technical leadership and team guidance.
• Experience within the Property & Casualty Insurtech, or Financial Services industry is preferred.
• Ability to process and adapt to change in a rapid growth company environment. Vantage associates are expected to be curious, thrifty, and resourceful to manage through the unknowns of growing a specialty (re)insurance business from the ground up.

Responsibilities

• Translate requirements and data mapping documents into a technical design.
• Talent for identifying the specific records that are produced from SQL bugs.
• Debug and troubleshoot issues found during testing or production.
• Communicate project status, issues, and blockers with the team.
• Contribute to continuous improvement by identifying and addressing opportunities.

Skills

SQL

Python

dbt

Dagster

Airflow

Kubernetes

Data modeling

CI/CD

Git

Mentoring

Data warehousing

Education

Bachelor's degree in Computer Science or equivalent

Tools

Snowflake

Databricks

PostgreSQL

Oracle

ETL/ELT

GitOps

Job description

Chicago, 123 N Wacker Dr, Chicago, Illinois, United States of America

New York, 12 E. 49th Street, New York, New York, United States of America

Job Description

Posted Thursday, September 3, 2026 at 4:00 AM

About the Company

Vantage Group Holdings Ltd. (Vantage) was established in late 2020 as a re/insurance partner designed for the future. Driven by relentless curiosity, our team of trusted experts provides a fresh perspective on our clients’ risks. We add creativity to tech-enabled efficiency and robust analytics to address risks others avoid. Vantage provides specialty re/insurance through its operating subsidiaries in Bermuda and the U.S.

Vantage has approximately 365 colleagues in both the United States and Bermuda. We have offices in Chicago, IL, Norwalk, CT, West Hartford, CT, Washington, DC, Boston, MA, New York, NY, Atlanta, GA and Hamilton, Bermuda. Additionally, we are a highly geographically diverse workforce with colleagues based in 35 states and counting. We fully support work flexibility including remote and hybrid work arrangements.

About the role:

At Vantage, the AVP, Data Engineer is mainly responsible for ingesting and transforming replicated source data into data products that are easily consumed by the Reporting team and other downstream users. The role requires an expertise in Data Modeling and Data Pipeline development within an Analytical, column-oriented data warehosue. This role reports to our VP, Data Engineering & ETL Lead and is a hybrid opportunity where the candidate is in a commutable distance to one of Vantage’s office locations, with a preferred location in New York or Chicago.

The base salary expectation for this role is between $175,000 and $210,000. Additionally, Vantage offers its colleagues performance-based bonus potential, strong health & welfare benefits, retirement plans with company match, competitive time off plans, a highly flexible work environment, and much more.

Responsibilities & Accountabilities:

• Translate requirements and data mapping documents into a technical design.
• Talent for identifying the specific records that are produced from SQL bugs.
• Debug and troubleshoot issues found during testing or production.
• Communicate project status, issues, and blockers with the team.
• Contribute to continuous improvement by identifying and addressing opportunities.

Ideal Candidate Profile:

• Bachelor's degree in Computer Science or equivalent combination of education and professional experience.
• 8+ years of Data Engineering experience designing, building, and supporting enterprise data platforms, ingestion frameworks, and transformation pipelines.
  
• Strong expertise in SQL, Python, and dbt, with experience developing and optimizing large-scale ETL/ELT solutions.
  
• Hands-on experience with Dagster, Airflow, or similar workflow orchestration tools.
  
• Experience building and managing data ingestion and replication pipelines from relational databases (PostgreSQL, Oracle), NoSQL sources, and file-based data feeds into Snowflake, Databricks, or comparable modern data platforms.
  
• Deep understanding of data modeling concepts, including dimensional modeling, Medallion Architecture, Data Vault, and highly relational data structures.
  
• Experience transforming complex business data into trusted, consumable datasets for reporting, analytics, and downstream business users.
  
• Strong knowledge of data engineering best practices, including testing, code reviews, Git version control, and CI/CD processes.
  
• Familiarity with distributed data processing technologies, Kubernetes, and modern cloud-based data ecosystems.
  
• Demonstrated ability to mentor junior engineers, conduct code reviews, and drive technical best practices across a team.
  
• Proven success operating in a player-coach capacity, balancing hands-on development with technical leadership and team guidance.
  
• Experience within the Property & Casualty Insurtech, or Financial Services industry is preferred.
• Ability to process and adapt to change in a rapid growth company environment. Vantage associates are expected to be curious, thrifty, and resourceful to manage through the unknowns of growing a specialty (re)insurance business from the ground up.

Our Vantage Values

Do What’s Right – be a force for good, for our customers, shareholders, colleagues, industry and communities.
Be Relentlessly Curious – ask questions, listen to understand, challenge the status quo, look for ways to say YES, drive innovation, be opportunistic and disciplined.
We’re Better Together – collaborate, be inclusive, supportive, respectful and humble, be a trusted partner internally and externally.
Be Transparent – in who you are, what you think, and how you work, seek and provide alternative points of view, be true to yourself.
Make A Difference – focus on impact, embrace technology, leverage data and analytics as critical assets, act intentionally to deliver on our mission.

We value diversity and are committed to creating an inclusive environment for all employees. At Vantage, we strive to build and foster a culture where inclusiveness is ingrained, not just an initiative. All colleagues support building an inclusive environment where employees feel empowered to share their experiences and ideas to foster an environment which encourages you to "Be You!" We are proud to be an equal opportunity employer.

In connection with our business, Vantage may collect and process your personal data. For further information regarding how we use this data, please see our online privacy notice at Vantage Recruiting Privacy Notice .

ADA Notice: All applications shall be submitted online through our applicant tracking system. Candidates needing reasonable disability accommodation to enable them to apply and/or fully participate in the selection process are encouraged to email [e-mail] with the subject Candidate ADA Request detailing their needs. Please note the above email box is for candidates needing reasonable disability accommodation only, emails submitting resumes will not be considered and those seeking application status updates will go unanswered.

Chicago, 123 N Wacker Dr, Chicago, Illinois, United States of America,

New York, 12 E. 49th Street, New York, New York, United States of America