Data Engineer (Senior)

About the Client One of our agency’s US-based clients is focused on improving access and outcomes for their users. Their platform is used across the US to support key operational workflows and planning at scale.

Role Overview We are hiring a Senior Data Engineer to own the data platform that powers both product features and analytics. This is a hands-on role: you will design, build, and operate pipelines, warehouse models, quality layers, and the serving surfaces that feed Looker dashboards and AI agents. You will work closely with the full-stack engineering team (Node.js / NestJS, React / Next.js, PostgreSQL, MongoDB) and with product and customer-facing teams in a remote, async-first environment.

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines and transformation workflows (BigQuery + Dataform/dbt) that keep operational stores (PostgreSQL, MongoDB) and the warehouse in sync.
• Own data modeling, schema design, indexing strategies, validation, quality checks, change management, auditing, and traceability.
• Build and maintain aggregated / denormalized serving layers used by Looker and by AI agents; keep the semantic layer (descriptions, tags, golden queries) accurate and trusted.
• Partner with Solutions Engineering and Customer Success on customer data integrations, reporting, migrations, and backfills.
• Review and improve ingestion patterns from external/source systems; optimize performance and cost.
• Collaborate with full-stack engineers on data contracts, real-time needs, and production services that touch the data platform.
• Mentor teammates on data modeling, pipeline patterns, and warehouse best practices.
• Contribute TypeScript / Node code where pipeline orchestration or data contracts live in application services.

Required Skills and Experience

• 5–8 years of professional experience in data engineering or backend engineering with a strong data focus.
• Production experience with BigQuery (or equivalent cloud warehouse) and a transformation framework (Dataform or dbt).
• Strong relational and NoSQL skills (PostgreSQL required; MongoDB highly preferred), including schema design, indexing (partial unique indexes, soft deletes), and query optimization.
• Comfortable working in a remote, async-first US-based team.
• Professional English fluency.

Nice to Have

• Looker / LookML experience.
• TypeScript / Node.js / NestJS exposure.
• Domain or customer-facing product experience.
• Familiarity with AWS or GCP.