Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

The AVP, Data Engineer is responsible for ingesting and transforming source data into consumable data products for the Reporting team and other downstream users. This role requires expertise in Data Modeling and Data Pipeline development within an Analytical, column-oriented data warehouse.

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.

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

Skills

• dbt
• dagster
• airflow
• Kubernetes
• Python
• SQL
• git
• CI best practices

Location

• New York
• Chicago

Work Type

• Hybrid

Experience Level

• 5+ years of experience in ELT development
• 5+ years working with Dimensional Data Modeling

Education Level

• Bachelor’s degree in computer science or equivalent professional experience

Salary/Compensations

• $175,000 - $210,000

Benefits

• Performance-based bonus potential
• Strong health & welfare benefits
• Retirement plans with company match
• Competitive time off plans
• Highly flexible work environment

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.
• Our Vantage Values: Do What’s Right, Be Relentlessly Curious, We’re Better Together, Be Transparent, Make A Difference.