AVP, Data Engineer

Vantage Risk Companies•New York, NY

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

About The Position

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 warehouse. 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.

Requirements

Bachelor’s degree in computer science or equivalent professional experience required.
5+ years of experience in ELT development within a Data Warehouse required.
5+ years working with Dimensional Data Modeling, such as Kimball, Data Vault, or Medallion Architecture required.
Strong familiarity with dbt and dagster/airflow.
Good working knowledge of distributed data and Kubernetes.
Expertise in data modeling using append-only replication methods to produce point-in-time data marts.
Strong understanding of test-driven development applied to Enterprise Data.
Strong familiarity with git and CI best practices.
Expertise in Python and SQL.
Expertise in column-oriented SQL modeling.

Nice To Haves

Experience in P&C Insurance or Financial Services Industry is a plus.
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.
SQL development using dbt.
Pipeline development using dagster.
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.