Analytics Engineer (Forward Deployed)

When Strattum steps into a new client, someone has to dive into their data and make it make sense. Bases nobody documented, schemas inherited from years of ERP, tables with names only the old team understood. Your job is to turn that chaos into a clean, cataloged, trustworthy data model — the foundation the whole platform and the client's AI will run on.

This isn't a back-end or "plumbing" role (our connectors team handles that). It's the role of someone who understands the business through its data and models it: marts, catalog, lineage, data dictionary, ontology. It's customer-facing: you sit with the client, ask the right questions, map their reality, and deliver a model they recognize and trust.

What you'll do:

• Step into new clients and map the data catalog — understand which systems exist, what data they produce, and how they relate
• Model the data — design marts and models (dimensional / star schema / entities and relationships) that answer the real business questions
• Build and maintain the data catalog and lineage — where each datum comes from, how it was transformed, where it's consumed
• Write modeling transforms — from raw tables to trustworthy, documented marts
• Define the dictionary and data contracts — names, types, semantics, quality
• Translate business into model and design the client's ontology — how their entities (customers, orders, products…) connect into a knowledge graph

On the stack: we work with dbt and knowledge-graph modeling. In the AI era, the tool's syntax matters least, and what matters is your modeling reasoning and business sense. Bring experience from any modern analytics stack (dbt, Looker, Snowflake, BigQuery…) and you'll pick up the rest fast.

Required:

• Real experience in data modeling — dimensional, normalization, mart design
• Strong SQL — it's your main tool
• Experience stepping into unknown bases and making sense of them fast
• Catalog, lineage, and data governance in your repertoire
• Customer-facing profile — comfort talking to the client and translating answers into a model

Nice to have:

• dbt and data testing
• Having modeled ontologies / knowledge graphs
• Background in BI / Analytics or classic dimensional modeling (Kimball, Data Vault)
• Customer-facing / data consulting experience
• Having used Claude Code or AI codegen tools day to day

How to apply: record a video of up to 5 min showing some data modeling you've done, explaining what you did and why. Paste the video link in the application form.