Stuut is seeking a Lead Data Engineer to establish and grow the data engineering team and to drive the end-to-end order-to-cash data lifecycle in Snowflake. This role focuses on ingestion, modeling, transformation, monitoring, and serving data used by product dashboards and AI agents.
Role Overview
The Lead Data Engineer will own the data roadmap in partnership with product, engineering, and leadership, guiding what the team delivers and the sequencing of initiatives. You will lead ingestion pipelines that bring client data into Snowflake, define modeling standards using dbt, ensure data quality and observability, and build mechanisms that serve warehouse data back to the product and AI-enabled experiences.
Key Responsibilities
- Manage, hire, and grow the data engineering team, establishing expectations through design leadership and code review.
- Own the data roadmap with cross-functional stakeholders, defining scope and priorities.
- Build and operate ingestion pipelines into Snowflake, including CDC from Postgres via Estuary, along with backfills and schema change handling.
- Own Snowflake modeling standards using dbt, including how models are structured, tested, reviewed, and deployed.
- Monitor and alert on pipeline health, including replication lag, failed or late runs, stale tables, and unexpected volume changes.
- Track data completeness and accuracy for each customer to detect issues early.
- Maintain consistency of core receivables metrics across product surfaces, dashboards, and Ask Stuut.
- Improve data latency and warehouse cost as volume and customer count increase.
- Build pipelines that serve warehouse data back to the product, including datasets required by AI agents and models.
Required Qualifications
- 5+ years of hands-on experience building and running production data pipelines in Python and SQL.
- Experience leading a data team as a manager or tech lead, including hiring and scaling engineers.
- Deep, hands-on production experience with Snowflake (required), plus strong dbt knowledge.
- Experience running CDC from a production database into a warehouse, including understanding common failure modes.
- Proven experience performing large-scale data cleanup end to end, including root-cause tracing, backfilling millions of rows without blocking live syncs, and adding checks to prevent recurrence.
- Ability to define standardized derived rules when source systems lack required fields, ensuring consistent computation across teams.
- Experience setting data contracts with customers for files and data shares, including escalation when submissions fall short.
- Strong focus on data quality and observability, including testing, freshness, lineage, and alerting.
- Experience working with multi-tenant data where customer data differs.
- Ability to prioritize among multiple stakeholders and communicate trade-offs clearly.
Technologies
Python, Postgres, PostgreSQL, Estuary CDC, Snowflake, dbt, Sigma, Ask Stuut, Inngest, DBOS
Location and Experience
- Location: New York, NY (onsite)
- Minimum experience: 5 years
- Salary: USD 275,000 - 315,000 per yearly
Benefits
- 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: invoices, payments, ERP exports, 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.
US Compensation Details
- 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
- Compensation Range: $275K - $315K