Analytics Engineer

InvestEngine Limited; Greater London; Hybrid; GBP 70,000 - 110,000; Full time

Job summary

InvestEngine is hiring its first dedicated Analytics Engineer in London, hybrid. You’ll blend data engineering, analytics engineering, and business partnership to turn raw data into trusted models and semantic layers for decision-making.

You’ll collaborate with Product, Engineering, Risk, Finance, Investment, and Marketing to design pipelines, models, and governance, while shaping how AI-enabled tooling speeds analytics and ensures trust across data assets.

Qualifications

• Must-have: Hands-on production experience with dbt Core
• Must-have: Strong SQL expertise
• Must-have: Solid Python for data engineering and automation
• Must-have: Working knowledge of AWS data services
• Must-have: Experience with GitHub and GitHub Actions for testing and deploying data code
• Must-have: Experience with a modern BI tool (Lightdash, Omni, Looker, or Metabase)
• Must-have: Comfortable using AI tools as part of your day-to-day engineering workflow
• Must-have: Strong communication — explain trade-offs to non-technical stakeholders
• Must-have: Ownership — first analytics engineer, building from scratch

Responsibilities

• Design, build, and maintain dbt Core models transforming raw data into clean datasets
• Own and evolve the semantic layer with consistent metric definitions
• Establish data modelling standards, testing, and documentation
• Evaluate and roll out modern BI tools to enable self-serve analytics
• Structure data models, metrics, and documentation for governance and AI readiness
• Collaborate with Product, Engineering, Risk, Finance, and Marketing to solve real problems
• Support AI tooling adoption and ensure trustworthy AI-enabled analytics
• Work with engineering teams to ensure analytics requirements are captured at the source

Skills

Strong SQL

Python for data engineering

Excellent communication

Ownership mindset

Analytical thinking

Tools

dbt Core

AWS

GitHub Actions

Lightdash

Omni

Looker

Metabase

Job description

About InvestEngine

We’re a ~200-person, AI-first fintech. We move fast, we expect people to own things end to end, and we don’t have a lot of specialist support infrastructure to hide behind — if you spot a gap, you’re expected to close it, not esc

About the role

We’re hiring our first dedicated Analytics Engineer at InvestEngine. This is a foundational hire: you’ll sit at the intersection of data engineering, analytics engineering, and business partnership — turning raw, disparate data into governed, trustworthy models that the rest of the company makes decisions on.

You won’t just write dbt models in isolation. You’ll work directly with stakeholders across the business — Product, Engineering, Risk, Finance, Investment, Marketing — to understand the problems they’re actually trying to solve, then design and ship the pipelines, models, and semantic layer that solve them. You’ll also help shape how we use AI-enabled tooling to make the whole analytics function faster, and how we structure our data so that AI tooling can be trusted to answer questions about it.

We’re actively modernising our data stack, and we want the person in this role to shape it. Some of it is in place, some of it is being rebuilt, and some of it hasn’t been decided yet. If you have informed opinions about orchestration, ingestion, testing, semantic layers, or BI — we want to hear them.

Who thrives here

We’ve pitched this at mid to senior level, but the honest position is that the level matters less than the appetite. The ultimate test is hunger, and the desire to shape this space and have real impact. If you’re technically strong but hungrier than your years of experience suggest, apply anyway — we’d rather have someone who wants to own this than someone who has simply done it before somewhere bigger.

Beyond that, this role suits someone who:

• Operates well with ambiguity and limited structure. You’ll be the first analytics engineer here — no existing playbook, no dedicated data engineering team to lean on, no established BI function to slot into. You’ll be building a lot of it as you go.
• Wants a small, fast company on purpose — not just escaping bureaucracy elsewhere, but genuinely drawn to the trade‑off: more ownership and visibility, less process and hand‑holding.
• Lives in the tools, not in email chains. You default to GitHub, dbt, Slack/Notion, and automation over status meetings and Word docs.
• Can point to things they’ve actually built and shipped, not just designs or concepts they contributed to.
• Already uses AI to do the job better — Claude, Copilot, or similar — and is curious about where it can go further.
• Learns fast. We care more about how quickly you close a knowledge gap than how complete your CV looks today.
• Works well directly with Product, Marketing, Operations, and Engineering, not just with other analysts — this role sits right at that boundary.

Our values

Everyone at InvestEngine is expected to live these, and this role will be assessed against all five:

• Act like an owner — you take responsibility for outcomes, not just tasks
• Keep improving. Stay curious. — you push your own standards and the team’s, and you’re genuinely curious about better ways to work
• Achieve more together — you make the people around you (business stakeholders included) more effective, not just yourself
• Speak up. Share openly. — you flag risks, disagreements, and better ideas rather than sitting on them
• Put customers first. Create real value. — you build things because they solve a real problem, not because they’re interesting to build

What you’ll do

Analytics engineering & the semantic layer

• Design, build, and maintain dbt Core models that transform raw data into clean, well‑tested, well‑documented datasets
• Own and evolve our semantic layer — consistent metric definitions, business logic, and naming that the whole company can trust and query against
• Establish and enforce data modelling standards, testing practices, and documentation as the function scales
• Evaluate and help roll out modern BI tooling — experience with Lightdash, Omni, Looker, or Metabase all translates well — to make metrics genuinely self‑serve for non‑technical stakeholders

Building the AI context layer

• Structure our models, metric definitions, documentation, and lineage so they’re machine‑readable, not just human‑readable — because our semantic layer is what AI tooling reasons over
• Make AI‑driven analytics reliable: if two people (or two agents) ask the same business question, they should get the same answer, because the definition lives in one governed place
• Treat naming, documentation, and metric definitions as first‑class engineering deliverables rather than afterthoughts, since they directly determine how trustworthy our AI‑enabled BI is
• Use Claude to accelerate development — model scaffolding, code review, documentation, QA, and pipeline debugging — and Notion AI to keep documentation and runbooks current and genuinely useful
• Bring a point of view on where AI can responsibly speed up analytics engineering, and help the wider team adopt it well

Data engineering & the platform

• Build and maintain ingestion and transformation pipelines across our stack. We use a modern data stack, such as AWS, Redshift, and Airflow
• Write production‑quality Python for extraction, transformation, and automation tasks that fall outside dbt’s remit
• Help us modernise: we’re actively evolving this stack and expect you to challenge and improve it, not just operate it

Warehouse cost & performance

• Own the performance and cost profile of our Redshift warehouse — you should be able to read a query plan, choose sensible sort and distribution keys, and design incremental models without being asked
• Spot and act on opportunities to reduce complexity and cost across our models and pipelines, rather than letting spend and technical debt accumulate quietly
• Make deliberate trade‑offs between freshness, cost, and complexity — and explain those trade‑offs to the business in terms they care about

Data quality & observability

• Champion analytics engineering best practice across the company: testing, version control, code review, CI, and documentation applied to data the same way engineering applies them to software
• Build and own data quality, freshness, and pipeline monitoring so problems are caught by us before they’re caught by a stakeholder looking at a dashboard
• Set the standard for what “trustworthy data” means here, and hold the line on it as the volume of models and requests grows

Upstream influence

• Work with our engineering teams to make sure application and event design accommodates reporting and analytics requirements before data reaches the warehouse — good analytics starts at the source, not in the transformation layer
• Influence payload and schema design for new services and product features, so we’re not permanently reverse‑engineering business meaning out of operational tables
• Support analysts and business users with automation, tooling, and data engineering expertise, and provide training and guidance on how to use our data well

Business partnership

• Work directly with stakeholders to understand their problems, not just their requested outputs — translate ambiguous business questions into pipeline and modelling requirements
• Act as a trusted advisor on what’s possible with our data, and push back constructively when a request doesn’t solve the underlying problem
• Support financial, operational, and regulatory reporting needs appropriate to a regulated investment platform

Governance

• Apply our data classification and access model when onboarding sources: identify PII (including in free‑text fields), decide what belongs in the sanitised analytics layer versus a restricted dataset, and document the outcome
• Implement least‑privilege access across datasets, reports, and dashboards

What we’re looking for

Must‑haves

• Hands‑on production experience with dbt (we run dbt Core) — this is a hard requirement
• Strong SQL expertise
• Solid Python for data engineering and automation
• Working knowledge of AWS data services
• Experience with GitHub and GitHub Actions (or equivalent CI/CD tooling) for testing and deploying data code
• Experience with a modern BI tool (e.g., Lightdash, Omni, Looker, or Metabase), and a genuine interest in semantic layers (e.g., MetricFlow, Cube Core) and self‑serve analytics
• Comfortable using AI tools as part of your day‑to‑day engineering workflow
• Strong communication — you can sit with a non‑technical stakeholder, understand their real problem, and explain trade‑offs in plain language
• Ownership: you’re comfortable being the first and only person in this role, and building things properly from scratch

Nice‑to‑haves

• Airflow or similar orchestration tools, and familiarity with data ingestion tools such as dlt or Airbyte
• Warehouse cost and performance tuning, particularly on Redshift
• Fintech, investment management, or another regulated industry
• Handling PII responsibly in an analytics environment — sanitised vs. restricted datasets, role‑based access tiers, automated PII detection
• Experience with Notion AI or Asana automations

Day‑to‑day working style

• We favour clear thinking and simple, well‑tested solutions over cleverness
• We expect you to engage directly with the business, not hide behind tickets — understanding the “why” behind a request is part of the job
• We’re genuinely trying to use AI to work faster and better, not as a buzzword — we want people who’ll experiment, share what works, and level up the team
• As the first analytics engineer, you’ll define what “good” looks like here: process, standards, and tooling included
• We believe data should be as accessible as it can safely be, and as restricted as it needs to be — good judgement applied consistently, not blanket lockdown

Practical details

• Reports to: Chief Data Officer
• Team: Data & Analytics
• Level: Mid to Senior
• Location / working pattern: London / hybrid