Implementation Architect; Data Platform

Overview

About Mother Duck:
Don’t let the quirky name fool you. At Mother Duck, we’re on a mission to make data warehousing fun, frictionless, and ducking awesome for developers and data practitioners building blazing fast internal and customer-facing analytics experiences. We're building a cloud-hosted version of DuckDB, working hand-in-hand with the creators of the fastest-growing and fastest-improving query engine on the planet. Unlike other databases, Mother Duck was architected to unify local development with cloud operations to bridge the gap between software and data engineering workflows.

Our team is a mix of thoughtful, passionate, and empathetic data industry veterans.

What you will do

We are seeking a highly capable Implementation Data Architect to join Mother Duck and guide customers through their most important data warehouse initiatives. This is an opportunity to be an early member of the Technical Engagement function and shape how customers adopt, scale, and succeed with Mother Duck. The ideal candidate brings depth in database architecture, data modeling, and data integration, paired with the agency to drive engagements forward, the thoughtfulness to simplify complex decisions, the unorthodoxy to challenge outdated patterns, and the flexibility to adapt to customers  realities.

You will design architectures that make good data work feel easy, remove blockers with clarity, and help customers reach production with confidence.

This role can be based in our Seattle, San Francisco or New York offices.

• Architecture Design and Scoping:
  Design and scope end-to-end architectures with a thoughtful approach to trade-offs. Define success metrics and craft pragmatic, flexible implementation roadmaps.
• Technical Leadership with Customers:
  Lead technical discussions with customer data and engineering teams. Apply unorthodox thinking when standard approaches fall short, and help teams rethink assumptions around warehouse design, schema decisions, and optimization strategies.
• Customer Success Ownership:
  Exercise agency by owning the customer journey from proof of concept to production. Anticipate risks, drive alignment, and allocate internal resources to keep momentum.
• Troubleshooting and Blocker Resolution:
  Diagnose technical blockers with precision and thoughtfulness. Navigate ambiguity with flexibility, and escalate nuanced architectural questions to Mother Duck engineering when needed.
• Data Integration and Modeling Guidance:
  Advise customers on ETL and ELT patterns, modeling choices, and integration practices. Use creativity and unorthodox perspectives to simplify complex data flows.
• Cross-functional Partnership:
  Collaborate with Sales, Customer Engineering, and Support to deliver cohesive, high-quality customer experiences. Demonstrate flexibility as customer needs evolve across the engagement lifecycle.
• Program Development:
  Create reusable artifacts, best practices, and reference architectures that reflect Mother Duck’s values of simplicity, clarity, and unorthodox efficiency.
• Customer Communication:
  Communicate complex technical concepts with clarity, empathy, and thoughtfulness for both technical and non-technical audiences.

• 5+ years designing, building, or implementing modern data warehouses such as Snowflake, Big Query, Redshift, or Databricks
• Mastery of SQL and data modeling, with the judgment to select the simplest viable approach
• Experience translating business requirements into architectural decisions that balance flexibility with long-term scalability
• Background in a customer-facing or solutions-oriented role such as solutions engineer or consulting data architect
• Evidence of agency in past roles. You proactively drive structure, unblock teams, and make progress without waiting for direction
• A thoughtful approach to ambiguity, bringing order where needed and staying flexible where it matters
• Willingness to challenge conventional approaches when they don t serve the customer or the mission
• Nice to have: experience with DuckDB or Mother Duck; familiarity with Fivetran, dbt, or Airflow; experience in consulting or professional services