Original listing text, shown exactly as published by the company.
What you will be doing
- Assess the Postgres product database and design an analytics architecture appropriate for our current scale: operational data stores, extraction strategy, schema isolation, and semantic layer, without over-engineering
- Build reliable extraction pipelines from Postgres and other operational sources that are resilient to schema drift and isolated from the application layer
- Design and implement a well-structured operational data store: clean schemas, stable marts, and a semantic layer that teams across the business can query and trust
- Define canonical business metrics: product usage, customer health, LLM token and cost telemetry, document volume, workflow adoption, latency, and engineering KPIs, and make them consistently available across the business
- Stand up internal analytics for engineering, product, CS, and leadership, and customer-facing usage dashboards for law firm clients showing their own usage and cost data
- Evaluate and recommend tooling for transformation, the BI and semantic layer (Omni Analytics is being evaluated alongside Metabase), and cloud infrastructure: bring your own experience and opinions
- Set up secure data access, scheduled jobs, object storage, secrets management, monitoring, and cost-aware infrastructure in AWS or Azure independently
- Establish data quality checks and pipeline observability from the start
- Write documentation for AI coding agents: how to access, understand, and extend the systems you build, with context on the decisions you made
- Attend daily standup and work closely with Ciaran throughout, with a clean handover at the end of the engagement
You should apply if
- You have led or owned the architecture of a data platform: you have made the decisions on how data flows, where it lives, and how it is accessed, not just executed a design handed to you
- You have extracted from a live operational relational database (Postgres is ideal) and dealt with schema drift in production. This is the core of the technical challenge and the experience that matters most here
- You can independently set up a cloud data environment in AWS: data access, scheduled jobs, object storage, secrets, monitoring, and cost controls, without needing a platform team around you
- You have built a data platform from scratch or near-scratch before and can describe the decisions you made at the start
- You are strong in both data engineering (pipelines, infrastructure, operational data stores) and analytics engineering (semantic layer, metric definitions, clean queryable data models)
- You have deep SQL and data modelling capability: schema design, mart design, and semantic layer definition from scratch
- You understand BI and semantic-layer tooling (Omni Analytics, Looker, Metabase, Cube, or similar) and can make a justified recommendation
- You are pragmatic about tooling: you will not reach for a full lakehouse or managed warehouse when something lighter and more maintainable serves the purpose
- You write documentation that a coding agent can act on independently, not just a README for a human
- You are available to start by 1 July 2026
It would also be great if you have
- Experience building customer-facing or embedded analytics in a B2B SaaS product
- Experience instrumenting AI/LLM usage: token counts, cost tracking, latency, and evaluation datasets
- Familiarity with data residency requirements... we have strict UK/EU and US data residency obligations
- Experience in ISO 27001 or SOC 2 compliant environments
- Experience with multi-tenant reporting, row-level security, and customer data isolation
- Startup or early-stage background
- Experience with transformation tooling such as dbt or equivalent code-first approaches
🔒 Security is everyone’s responsibility at Orbital. We ask all team members to follow our security policies, complete regular awareness training, and handle sensitive data with care in line with ISO 27001 standards. Spot something unusual? Reporting risks or incidents quickly helps us maintain the strong culture of security and compliance we all depend on.
💡 At Orbital, we’re committed to building a diverse and inclusive team. We especially welcome applications from people who are traditionally underrepresented in tech. Even if you don’t meet every single requirement, or if the right role isn’t listed yet, we’d still love to hear from you.
💰 This hiring range is a reasonable estimate of the base pay range for this position at the time of posting. Pay is based on several factors, which may include job-related knowledge, skills, experience, and business requirements.
