AVP, Data Engineer

Vantage Risk Companies; New York (NY); Hybrid; USD 175,000 - 210,000; Full time

Benefits offered by this job

Health benefits

Job summary

Vantage Group Holdings Ltd. is seeking an AVP, Data Engineer to ingest and transform replicated source data into consumable data products for the Reporting team and downstream users.

The role emphasizes data modeling and pipeline development within an analytical, column-oriented data warehouse, reporting to the VP, Data Engineering & ETL Lead. Hybrid work arrangement with preferred location in New York or Chicago; base salary expectation ranges from $175,000 to $210,000 plus performance-based

Qualifications

• Bachelor’s degree in computer science or equivalent professional experience.
• 5+ years of ELT development within a Data Warehouse.
• 5+ years working with Dimensional Data Modeling (Kimball, Data Vault, or Medallion Architecture).
• Strong familiarity with dbt and dagster/airflow.
• Strong familiarity with Git and CI best practices.
• Expertise in Python and SQL.
• Expertise in column-oriented SQL modeling.
• Experience in P&C Insurance or Financial Services is a plus.
• Ability to adapt to a rapid growth company environment.

Responsibilities

• Translate requirements and data mapping documents into a technical design.
• SQL development using dbt.
• Pipeline development using dagster.
• Identify specific records 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

ELT development

Data Warehouse

Dimensional Modeling

dbt

dagster

Airflow

Git

CI/CD

Python

SQL

Kubernetes

Append-only modeling

Data Marts

Education

Bachelor’s degree in computer science or equivalent

Tools

dbt

Dagster

Airflow

Job description

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.

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.

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

Ideal Candidate Profile

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

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.