Junior Analytics Engineer

Felix; Greater London; Hybrid; GBP 35,000 - 45,000; Full time

Job summary

Felix is seeking a Junior to Mid-level Analytics Engineer to grow into modelling and engineering work while building and maintaining data models and dashboards. You will bridge the data team with business units, turning requirements into reliable data and reports on a Fabric-based platform.

The role focuses on platform-level data modelling, governance and collaborating with cross-functional teams, with a strong emphasis on AI-assisted workflows and peer-reviewed delivery.

Qualifications

• SQL and data querying across relational databases with joins and aggregations.
• Understanding of dimensional modelling and star schemas.
• Experience with Python for data manipulation and basic ETL tasks.
• Power BI development, dashboarding and data visualisation.
• Ability to write and adapt DAX measures.
• Clear communication with non-technical colleagues to translate requirements.
• Attention to detail and accuracy in data reporting.
• High agency and initiative to explore better modelling approaches.
• Familiarity with AI-assisted tooling and workflow enhancements.
• Collaborative team player with transparent work practices.
• Exposure to Microsoft Fabric or similar lakehouse platforms.
• Knowledge of MCP-based tooling and agentic data workflows is a plus.
• Version control experience (Git) and deployment practices.
• Experience with Salesforce or Microsoft Dynamics is beneficial.
• Experience in charity or federated organisations is advantageous.

Responsibilities

• Design, build and maintain Power BI dashboards and reports.
• Develop and govern data models spanning Bronze/Silver/Gold layers.
• Collaborate with Impact & Insights and business teams to capture requirements.
• Document models, definitions and governance for repeatable use.
• Utilise AI-assisted tooling properly and ensure peer review of outputs.
• Contribute to data quality and upstream data transformations.
• Support the move to a shared Fabric platform across two organisations.
• Maintain visibility of what is built, for whom and why, through the triage process.
• Help manage timelines, data limitations and priorities with stakeholders.
• Collaborate with Finance, Fundraising, Operations and other teams to align on data needs.

Skills

SQL

Dimensional modelling

Python

Power BI

DAX

Clear communication

Attention to detail

High agency

AI fluency

Collaborative working

Engineering mindset

Microsoft Fabric

MCP tooling

Version control

Salesforce

Charity experience

Tools

Git

Microsoft Fabric

Salesforce

Dynamics 365

Job description

Salary Range: / Hourly Rate: £35000 - £45000

Contract Type: Permanent

Location: Hybrid

Requirements: Felix can only employ applicants who currently have the right to

work in the UK. As part of our safer recruitment policy, we do

ask questions regarding unspent criminal records.

We are Felix

We bring people together to rescue, repurpose, and share surplus food that would otherwise go to waste, turning an environmental problem into a social opportunity.

Together with 16 other independent charities, 18,000 volunteers, and thousands of partners, we are the UK’s food rescue network, supporting 1.5 million people across the country.

We're about fuller plates, fuller communities, and fuller lives.

Purpose of the Job

We are looking for a Junior to Mid-level Analytics Engineer who wants to grow into someone who can do three things equally well: build and maintain the data models that reporting sits on, work with people to understand what they actually need, and use AI-assisted tooling as a normal part of how the work gets done. You don't need to arrive doing all three confidently - you need to be strong in analysis and reporting today, and genuinely keen to develop into the modelling and engineering side with support from the team.

You will be part of the bridge between our small data team and the rest of the organisation. That means turning agreed requirements into reliable, well-modelled data and the reports that sit on top of it, working with our Impact & Insights colleagues who own metric definitions and outcome frameworks rather than duplicating that work.

The majority of the role sits on the platform side - building and maintaining the Bronze/Silver/Gold model alongside the Data Engineer, restructuring the data lake, and documenting what exists. Alongside that, you will support requirements and reporting work with business teams, so that what gets built reflects what people actually need. You will contribute to the team's data models, documentation and governance as we consolidate two organisations onto a shared Microsoft Fabric platform - and you will do it using the AI-assisted tools and workflows the team has adopted as standard, under a peer-review safety gate, which is also where a lot of your own learning will happen.

You will report to the BI Lead and work closely with our Data Engineer, who you'll pair with regularly as you build up the modelling and engineering side of the role. The team is small and deliberately focused - we aim to do fewer things better, rather than spread thin across every request.

Duties and Responsibilities

Data modelling and engineering (primary focus)

• Start contributing to work in the Fabric Lakehouse alongside the Data Engineer - supporting Bronze/Silver/Gold transformations before progressing to building and refactoring them independently.
• Write documented, testable logic for the pieces you own, growing into more complex transformation work as your confidence builds.
• Learn dimensional modelling in practice (fact/dimension design, star schemas) through paired work with the Data Engineer, rather than being expected to make these calls solo from day one.
• Help identify manual Excel-based consolidation processes across departments as candidates for automation, working with the Data Engineer to replace them.

Requirements and business partnering (supporting the wider process)

• Support requirements-gathering sessions with teams across Felix - including finance, fundraising operations, operations and distribution, food sourcing and digital marketing - working within the agreed triage process and alongside the Impact & Insights team rather than in parallel with it.
• Help translate agreed business requirements into clear, achievable technical briefs, learning when to flag constructively where requests outpace available data or team capacity.
• Maintain visibility of what is being built, for whom, and why - supporting the team as a technical point of contact for reporting and data requests routed through the agreed triage process.
• Help manage expectations around timelines, data limitations and priorities, communicating changes clearly and proactively.

Reporting and dashboards

• Design, build and maintain Power BI dashboards and reports that are accurate, well-documented and genuinely adopted by the teams they serve.
• Ensure reports are built on solid, governed data foundations rather than ad-hoc workarounds.
• Implement agreed KPI definitions consistently across models and reports, and keep the shared data glossary up to date as definitions are signed off.
• Use AI-assisted tooling as a normal part of the workflow from day one - Copilot-style code and DAX assistance, LLM-assisted documentation, and MCP-based agentic tools - with the team showing you how, in line with the permissive-but-reviewed approach.
• Develop judgement about when not to trust generated output: you'll be taught how to verify a model, a measure or a piece of documentation an AI tool produced, and everything goes through peer review before it reaches production, stakeholders or decisions - this is part of how you'll learn, not just a safety check.
• Contribute observations to the team's shared practice around AI-assisted work as you build experience with it.
• Work AI tools iteratively rather than one-shot - refine a brief, check the output against the source data, loop back and improve it, rather than taking the first draft a model gives you and moving on. This applies whether you're writing DAX, drafting documentation or preparing a stakeholder brief.

Data quality and governance

• Flag data quality issues as you encounter them and trace them to their source, working with the Data Engineer where needed.
• Document your models, reports, calculations and assumptions clearly so that others can understand, challenge and build on your work.
• Support consistent naming conventions, metadata practices and ownership models as part of the team's broader governance effort.
• Participate in regular team reviews of the Fabric environment, identifying opportunities to consolidate models, reduce compute costs and improve performance.
• Stay curious about what teams are doing with data and proactively surface opportunities where better modelling or analysis could support the charity's mission.
• Keep pace with new AI tools and model capabilities relevant to our stack, try them out, and bring back to the team what's actually worth adopting.

Person Specification

This section must be kept and filled in and do not alter title.

Guidance: Explain what you are looking for in your ideal candidate

This is your opportunity to set out a checklist of the skills, both technical and interpersonal, and the experience you expect applicants to possess.

Personality traits and soft, interpersonal skills that would help them succeed.

It should be clear enough that anyone reading the job specification who is considering applying can easily work out whether or not they are suitably experienced or the right type of person to carry out the job.

• SQL — the core day-to-day skill for this role. Comfortable writing and reading queries across relational databases, including joins and aggregation, and ready to build up to more complex transformation work.
• Dimensional modelling — you understand fact and dimension design, star schemas, keys and granularity, and what goes wrong downstream when they are off. We do not expect years of it, but you should be able to reason about a model rather than only consume one.
• Python — working exposure to data manipulation (pandas, PySpark or similar). You will use it here from early on, so some practical experience is needed even if it is not your strongest language.
• Power BI — able to build reports and dashboards from existing data models, and to interrogate why a visual looks wrong and trace it back to the model rather than patching the visual.
• DAX — comfortable writing straightforward measures and adapting existing ones; ready to build up to more complex time intelligence and row-context work with support.
• Clear communication with non-technical colleagues — you can explain a data limitation, a definition or a delay in plain language, and understand a requirement well enough to build the right thing.
• Attention to detail — you notice when numbers don't add up and you follow the thread until you understand why.
• High agency — when a tool, a dataset or an approach doesn't give you what you need first time, you try it a different way rather than shelving it or waiting to be told what to do next.
• AI fluency and judgement — you use Copilot-style, LLM and agentic (MCP-based) tools as a normal part of the workflow, and you work them properly: refining a prompt, checking the output, and going again rather than accepting the first answer. You have the humility to have that output peer reviewed.
• Collaborative working style — this team operates transparently and expects you to flag blockers early, share work in progress, and ask questions without hesitation.
• Appetite to grow into engineering — the single most important thing we are looking for. The role is weighted toward platform and modelling work, and we expect you to move steadily into pipeline and transformation work over your first year or two rather than staying in reporting.
• Microsoft Fabric or an equivalent lakehouse platform — any exposure to Lakehouses, Warehouses or pipelines, including from Synapse, Databricks or adjacent work.
• Agentic / MCP-based tooling — any prior exposure to Model Context Protocol or similar agentic tooling for data work; still rare, so a genuine plus rather than an expectation.
• Version control and deployment practice — any experience of Git, branching or CI/CD applied to data or reporting work.
• Salesforce or Microsoft Dynamics — understanding of CRM data structures helps, given our current landscape.
• Charity or federated organisation experience — comfort with mission-driven reporting, impact metrics and working across a dispersed network.

Equity Diversity Inclusion & Belonging

At Felix, we are committed to promoting equality, diversity, and inclusion in everything we do. We value the unique contributions of every individual and strive to create a respectful, inclusive environment free from discrimination or prejudice. Our commitment extends to all employees, and volunteers, ensuring equal opportunities for everyone, regardless of backgrounds or characteristics.

Recruitment timeline

We reserve the right to close advertisements early and we might assess candidates and arranging interview as applications come in, so please apply as soon as possible, to avoid missing out on this opportunity.

Due to the anticipated large number of applicants, if you do not hear from us within four weeks of your application , we regret to inform you that your application has been unsuccessful. Consequently, will not be able to provide feedback.