Data Engineering Consultant

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

New York, NY (Hybrid) · $115,000 – $145,000 base salary

Work authorization: Applicants must be currently authorized to work in the United States on a full-time basis. Vivanti will not sponsor applicants for work visas, now or in the future.

About Vivanti

Vivanti is a home for high-performing technologists who drive measurable impact for clients. Our mission is to transform businesses and build a smarter, more connected world through the power of data, cloud, and modern technology. Global enterprise leaders rely on us to design, architect, and deliver cutting-edge data and AI solutions.

The Role

As a Consultant, you work with full technical independence. You design and own complex pipelines and data models, work directly with client stakeholders, and help less experienced engineers grow. You are a trusted technical voice on the engagement.

What You'll Do

• Design and build complex pipelines, data models, and integrations with minimal oversight.
• Turn client requirements into technical designs and estimates for your area of the work.
• Work directly with client stakeholders: run working sessions, present progress, and manage expectations.
• Review code and support Analysts and Associate Consultants on your team.
• Improve the performance, reliability, and cost of the platforms you build.
• Spot client problems we could help solve and raise them with your engagement lead.

What You Bring

Must Have

• 3+ years of hands-on data engineering experience.
• Production experience with SQL, Python, and Spark or dbt, plus an orchestration tool such as 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.

Nice to Have

• An associate- or professional-level certification such as AWS Certified Data Engineer – Associate, Google Professional Data Engineer, Databricks Certified Data Engineer Associate, or SnowPro Core. If you don't have one yet, we fund it.
• Experience with a second cloud or data platform.
• Data pipelines for ML or AI use cases.
• Prior consulting experience.

How We Level

We level on the scope of work you have already done, not years alone. In your first call, your recruiter will share a provisional level and its salary range, and we will tell you before the final round if the level changes.

• Still building independence on production work? Our Associate Consultant (L2) role may be a better fit.
• Already leading a workstream or small team for a client? See our Senior Consultant (L4) role.
• Access to Vivanti Academy, our proprietary knowledge platform and internal training resources.
• Structured mentorship and career support.
• Fully funded professional certifications across major cloud and data platforms.
• Regular team socials, events, interest groups, and gatherings.
• Flexible hybrid schedule: choose your days at home or in the office.
• Coffee, tea, and premium snacks in the office daily.
• Medical coverage with 80% firm-sponsored premiums for employees and registered dependents.
• 100% employer-covered dental and vision for your entire family.
• $3,000 Health Reimbursement Account for out-of-pocket medical costs.
• Retirement plan with a 4% company match.
• 20 days of paid time off plus 10 company holidays.