Hybrid Data Engineering Consultant - Client-Facing Lead

Vivanti Consulting; New York (NY); Hybrid; USD 115,000 - 145,000; Full time

Benefits offered by this job

Hybrid schedule

Medical coverage with firm-sponsored

Dental & vision for family

Health Reimbursement Account

401(k) with company match

Paid time off: 20 days + 10 holidays

Job summary

Vivanti Consulting seeks a Consultant in New York, NY (Hybrid) to architect and own complex data pipelines and models. You will work directly with client stakeholders, guiding engineers and delivering scalable data solutions across cloud platforms.

The role emphasizes technical independence, mentorship, and optimizing performance and cost. Hybrid work in New York with competitive base salary and strong benefits.

Qualifications

• 3+ years of hands-on data engineering experience.
• Production experience with SQL, Python, and Spark or dbt, plus Airflow.
• Depth in at least one cloud (AWS, Azure, or GCP) and one data platform (Snowflake or Databricks).
• Experience working directly with business or client stakeholders.
• Experience reviewing code or mentoring other engineers.

Responsibilities

• Design and build complex pipelines, data models, and integrations with minimal oversight.
• Translate client requirements into technical designs and estimates.
• Engage with client stakeholders: run sessions, present progress, manage expectations.
• Review code and mentor Analysts and Associate Consultants on the team.
• Improve performance, reliability, and cost of the platforms built.
• Spot client problems and raise them to the engagement lead.

Skills

Data engineering

SQL

Python

Spark/dbt

Airflow

Cloud (AWS/Azure/GCP)

Data platforms (Snowflake/Databricks)

Stakeholder collaboration

Code review/mentoring

Tools

Airflow

dbt

Spark

Snowflake

Databricks

Job description

Vivanti Consulting seeks a Consultant in New York, NY (Hybrid) to architect and own complex data pipelines and models. You will work directly with client stakeholders, guiding engineers and delivering scalable data solutions across cloud platforms.

The role emphasizes technical independence, mentorship, and optimizing performance and cost. Hybrid work in New York with competitive base salary and strong benefits.