Analytics Engineer — AI-First Data & Semantic Layer(London)

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

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.