Senior Data Engineer & Platform Lead - Hybrid

Vantage Risk Ltd.; New York, Northern (NY, KY); Híbrido; USD 175.000 - 210.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Performance-based bonus

Health & welfare benefits

Retirement plans with company match

Flexible work environment

Descripción de la vacante

Vantage Group Holdings Ltd. seeks an AVP, Data Engineer to ingest and transform replicated data into data products for the Reporting team. Hybrid role with commutable NY or Chicago location, reporting to the VP Data Engineering & ETL Lead.

Base salary $175,000–$210,000 with bonus potential and strong benefits. Requires 8+ years in data engineering, expertise in SQL, Python, dbt, and hands-on with Dagster/Airflow.

Formación

• Bachelor's degree in Computer Science or equivalent combination of education and professional experience.
• 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, with experience developing and optimizing large-scale ETL/ELT solutions.
• Hands-on experience with Dagster, Airflow, or similar workflow orchestration tools.
• Experience building and managing data ingestion and replication pipelines from relational databases (PostgreSQL, Oracle), NoSQL sources, and file-based data feeds into Snowflake, Databricks, or comparable modern data platforms.
• Deep understanding of data modeling concepts, 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.
• Demonstrated ability to mentor junior engineers, conduct code reviews, and drive technical best practices across a team.
• Proven success operating in a player-coach capacity, balancing hands-on development with technical leadership and team guidance.
• Experience within the Property & Casualty Insurtech, or Financial Services industry is preferred.
• 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.

Responsabilidades

• Translate requirements and data mapping documents into a technical design.
• 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.

Conocimientos

SQL

Python

dbt

Dagster

Airflow

Kubernetes

Data modeling

CI/CD

Git

Mentoring

Data warehousing

Educación

Bachelor's degree in Computer Science or equivalent

Herramientas

Snowflake

Databricks

PostgreSQL

Oracle

ETL/ELT

GitOps

Descripción del empleo

Vantage Group Holdings Ltd. seeks an AVP, Data Engineer to ingest and transform replicated data into data products for the Reporting team. Hybrid role with commutable NY or Chicago location, reporting to the VP Data Engineering & ETL Lead.

Base salary $175,000–$210,000 with bonus potential and strong benefits. Requires 8+ years in data engineering, expertise in SQL, Python, dbt, and hands-on with Dagster/Airflow.