AVP, Data Engineer

Vantage Risk Companies•New York, NY

2d•$175,000 - $210,000•Hybrid

About The Position

Vantage Group Holdings Ltd. (Vantage) is a re/insurance partner established in late 2020. Its operating subsidiaries in Bermuda and the U.S. provide specialty re/insurance. Vantage has approximately 365 colleagues across the United States and Bermuda, with offices in several U.S. cities and Hamilton, Bermuda. The company supports remote and hybrid work arrangements. The AVP, Data Engineer is primarily responsible for ingesting and transforming replicated source data into data products that can be readily consumed by the Reporting team and other downstream users. The position requires expertise in data modeling and pipeline development within an analytical, column-oriented data warehouse. It reports to the VP, Data Engineering & ETL Lead. This is a hybrid opportunity for a candidate within commuting distance of a Vantage office; New York or Chicago is preferred. The base salary expectation is $175,000 to $210,000. Vantage also offers performance-based bonus potential, health and welfare benefits, retirement plans with company match, competitive time off plans, and a highly flexible work environment.

Requirements

Bachelor's degree in Computer Science or an equivalent combination of education and professional experience.
At least 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, including experience developing and optimizing large-scale ETL/ELT solutions.
Hands-on experience with Dagster, Airflow, or similar workflow orchestration tools.
Experience building and managing ingestion and replication pipelines from relational databases such as PostgreSQL and Oracle, NoSQL sources, and file-based data feeds into Snowflake, Databricks, or comparable modern data platforms.
Deep understanding of data modeling, 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.
Ability to mentor junior engineers, conduct code reviews, and promote technical best practices across a team.
Demonstrated ability to balance hands-on development with technical leadership and team guidance in a player-coach capacity.
Ability to adapt to change in a rapid-growth company environment; Vantage associates are expected to be curious, thrifty, and resourceful.