Lead Data Engineer
Manager
Change Data Capture
Cloud
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Architecture
Data Build Tool
Data Engineer
Data Engineering
Data Integration
Data Integration Tools
Data Management
Data Modeling
Data Operations
Data Pipeline
Data Pipelines
Data Platform
Data Processing
Data Transforms
Data Warehouse
Data Warehousing
Database
Databases
ETL
Informatica
Ingestion
Integration
PostgreSQL
Programming
Reporting and Analytics
Snowflake
Software Development
SQL
Job Description
Stuut is building an order-to-cash data foundation that powers product dashboards and AI agents. As the Lead Data Engineer in New York, you’ll lead the data engineering team and take end-to-end ownership of ingestion, modeling, transformation, monitoring, and serving in Snowflake.
This is a hands-on leadership role focused on reliable data flow from client systems into analytics-ready models, with strong emphasis on data quality, observability, and performance as scale increases.
What you’ll do
- Manage, hire, and grow the data engineering team, setting expectations through design and code review.
- Own the data roadmap in partnership with product, engineering, and leadership, including sequencing of team deliverables.
- Build and run ingestion pipelines that land client data in Snowflake, including CDC from Postgres through Estuary, plus backfills and schema change handling.
- Set standards for how data is modeled in Snowflake using dbt, including structure, testing, review, and deployment practices.
- Monitor and alert on pipeline health, covering replication lag, failed or late runs, stale tables, and unexpected volume changes.
- Track data completeness and accuracy per customer to detect issues before they impact downstream users.
- Ensure core receivables metrics remain consistent across product, dashboards, and Ask Stuut.
- Improve data latency and warehouse cost as volume and customer count grow.
- Build pipelines that serve warehouse data back to the product, including data used by AI agents and models.
What you bring
- 5+ years of hands-on experience building and operating production data pipelines in Python and SQL.
- Experience leading a data team as a manager or tech lead, including hiring and growth.
- Deep, hands-on Snowflake experience in production (required), plus strong dbt knowledge and practical opinions on quality.
- Production experience running CDC from a production database into a warehouse, with awareness of common failure modes.
- Proven ability to execute end-to-end large-scale data cleanup: trace gaps to root cause, backfill millions of rows without blocking live syncs, and add checks to prevent recurrence.
- Experience defining derived logic when source systems lack required fields, with the rule documented so teams calculate consistently.
- Ability to establish data contracts with customers for files and data shares, including escalation or pushback when inputs are insufficient.
- Strong focus on data quality and observability, including testing, freshness, lineage, and alerting.
- Experience with multi-tenant data where customer datasets vary.
- Ability to prioritize across stakeholders and explain trade-offs clearly.
Tools you’ll work with
- Python, Postgres / PostgreSQL, Estuary CDC, Snowflake, dbt, Sigma, Ask Stuut, Inngest, DBOS
Compensation and benefits
- Salary range: USD 275,000 - 315,000 per year
- Top-of-market salary and equity package
- Benefits for U.S.-based full-time employees
- Medical, dental & vision insurance coverage
- 401(k) & Match
- Equity
- Flexible PTO
- Parental Leave
Big plus
- Experience with financial data such as invoices, payments, ERP exports, and order-to-cash.
- Experience building pipelines that feed ML models or AI agents.
- Experience shipping customer-facing analytics such as embedded dashboards or data shares.