Senior Data Engineer

ShiftbaseZoetermeerHybridFull-time4 weeks ago

Senior Data Engineer needed to build and own the data warehouse foundation at Shiftbase, a company creating a self-driving assistant for shift-based businesses. The role focuses on designing layered warehouse architectures in BigQuery and Dataform, building reliable ELT/ETL pipelines, and ensuring data quality and governance. Requires advanced SQL, hands-on BigQuery, and Python experience.

What you'll do

Architect the warehouse. Design and own our BigQuery and Dataform warehouse from the ground up. Build a layered, well-modeled foundation, medallion staging through marts, not only the models that sit on top. Ask every day whether the whole company can trust and reuse it.
Make the data flow reliably. Build ELT and ETL with incremental, idempotent loads, orchestration, and retries, so pipelines run on time without anyone watching them. Ship monitored pipelines that hold up in production.
Take the transform layer. Own the Dataform model-building and transform layer, taking full responsibility for the transformation layer and freeing up capacity for semantic modeling and business definitions. This unblocks the whole team.
Build trust into the data. Make validation, freshness monitoring, alerting, and lineage the default. Diagnose failures at the root cause. leadscorev2 is the outcome this role exists to prevent.
Serve the whole company. Feed clean, governed datasets to Metabase, HubSpot, and the ML and AI work the product ML team owns. Push modeled data back into the tools business teams act on, including HubSpot and Customer.io.
Own the Platform handshake. Run the day-to-day collaboration with the Platform team on our GCP foundation, a bridge that only gets part-time attention today.
Treat the warehouse like a product. Keep documentation, lineage, and discoverability current so departments trust the data assets, and handle sensitive HR and workforce data to GDPR standards.

What you need

Must-have

BigQueryDataformSQLELTETLPythonGitGCP

Nice-to-have

SnowflakeAmazon RedshiftAirbytedbtMachine LearningLLMAgentic Use CasesB2B SaaS Metrics

Soft skills

TransparencyOwnershipCollaborationCommunication

Data EngineeringBigQueryDataformGCPSQLPythonELTETLData WarehouseSenior

/What you'll do

/What you need

Must-have

Nice-to-have

Soft skills

What you'll do

What you need