AVP, Data Engineer

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.

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.

Qualifications

• Ability to process and adapt to change in a rapid growth company environment.

Skills

• Curiosity
• Thrifty
• Resourceful

Benefits

• Performance-based bonus potential.
• Strong health & welfare benefits.
• Retail plans with company match.
• Competitive time off plans.
• A highly flexible work environment.
• and much more.

Pay

The base salary expectation for this role is between $175,000 and $210,000.

Schedule

This role 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.