Analytics Engineer

BCB Group; City of Westminster; Hybrid; GBP 40,000 - 50,000; Full time

Benefits offered by this job

Salary sacrifice pension scheme

AXA health insurance

Income protection

Life assurance

Enhanced parental support and leave

Salary sacrifice nursery scheme

Cycle to work scheme

Hybrid working (1-2 days in the office

Job summary

BCB Group is seeking a data professional to own reports and dbt models end-to-end, collaborating with the Head of Data & Analytics. You will move reporting onto Omni, run AI-augmented workflows, and work in a small team from our London office 1-2 days per week.

You will use BigQuery, dbt, Omni, n8n, and Git to build dashboards, validate data, and deliver regulatory reports with stakeholder involvement. 2+ years in analytics/data roles are expected.

Qualifications

• 2+ years in an analytics/data role within a Modern Data Stack.
• Hands-on SQL, dbt and git; meticulous with numbers.
• Comfortable using AI to streamline work.
• Able to explain a technical data problem to a non-technical colleague.

Responsibilities

• Build and maintain dbt models and Omni dashboards.
• Take loosely defined requests from business teams, work out what they actually need, and deliver it.
• Investigate data issues down to the root cause and fix them at the source.
• Write tests and documentation so others can trust your numbers.
• Deliver regulatory reports with live SQL and stakeholder sessions; onsite interview with Head of Data and CTO.
• Hands-on experience with Omni.
• Work in a small team with clear communication.
• Commute to our London office 1-2 days per week.

Skills

SQL

dbt

git

Python

Education

Degree in Economics/Math/CS

Tools

BigQuery (GCP)

Omni

n8n

Job description

You'll be the second person in BCB's data function, working directly with the Head of Data & Analytics. You'll own reports and dbt models end-to-end, from source to dashboard, and help move our reporting onto Omni. We run AI-heavy workflows, which means less time on repetitive coding and more time directing and reviewing work, and collaborating on problems that need thinking through. Stack: BigQuery (GCP), dbt, Omni, n8n, git. What you'll do

• Build and maintain dbt models and Omni dashboards
• Take loosely defined requests from business teams, work out what they actually need, and deliver it
• Investigate data issues down to the root cause and fix them at the source
• Write tests and documentation so others can trust your numbers
• Update and deliver regulatory reports, 1. a technical and behavioural conversation with the Head of Data including live SQL 2. a session with stakeholders from the teams you would work with 3. a final, onsite interview with the Head of Data and Chief Technology Officer
• Hands-on experience with Omni
• 2+ years in an analytics/data role within a Modern Data Stack
• Hands-on SQL, dbt, and git, Meticulous with numbers: you check your own work, and when something looks off, you can't leave it alone until you know why
• Comfortable using AI to streamline work
• You can explain a technical data problem to a non-technical colleague
• Comfortable with ambiguity and operating in a small team
• Can commute to our London office 1-2 days per week
• Bonus points for
• A degree in a relevant field (e.g. Economics, Maths, Computer Science)
• Python or other programming languages
• n8n or other low-code automation
• Payments, banking, fintech or crypto domain knowledge
• Experience with regulatory or financial reporting
• Basic statistics
• Salary range: £40,000 - £50,000pa
• 30 days holiday, plus 4 wellbeing days, 1 volunteering day, and flexible bank holiday options
• Salary sacrifice pension scheme
• AXA health insurance
• Income protection
• Life assurance
• Hybrid working (1-2 days in the office)
• Enhanced parental support and leave
• Salary sacrifice nursery scheme, and cycle to work scheme