At a Glance
- Tasks: Join us to build and maintain data models while collaborating with teams to meet their needs.
- Company: Felix, a leading charity focused on food rescue and sustainability.
- Benefits: Flexible working hours, supportive team culture, and opportunities for personal growth.
- Other info: Be part of a small, dynamic team with a focus on impactful work.
- Why this job: Make a real difference by turning surplus food into social opportunities while developing your analytics skills.
- Qualifications: Strong analytical skills and a desire to learn data modelling and engineering.
The predicted salary is between 63000 - 77000 Β£ per year.
Working days/hours per week: 35 hours, Monday to Friday, 9am - 5pm
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
Your normal duties and responsibilities will be set out in your job description. However, the charity may require you to perform other duties from time to time.
- 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.
- 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, Py Spark 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.
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 background or characteristics.
Junior Analytics Engineer employer: The Felix Project
The Felix Project is an exceptional employer that fosters a collaborative and supportive work culture, where you can make a meaningful impact in the community. With opportunities for personal and professional growth, you will be part of a dedicated team in Greater London, working alongside passionate individuals committed to food quality and safety. Enjoy the unique advantage of leading volunteers and staff in a dynamic kitchen environment, all while contributing to a vital cause.
StudySmarter Expert Adviceπ€«
We think this is how you could land Junior Analytics Engineer
β¨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like The Felix Project!
β¨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Junior Analytics Engineer at The Felix Project.
β¨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like The Felix Project.
β¨Apply Directly through Our Website
When you find a suitable opening like Junior Analytics Engineer at The Felix Project, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesnβt love a direct application? Itβs easier than navigating through job boards!
We think you need these skills to ace Junior Analytics Engineer
Some tips for your application π«‘
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Donβt forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at The Felix Project, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why youβre a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at The Felix Project. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at The Felix Project
β¨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
β¨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, itβll really make us stand out!
β¨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at The Felix Project!
β¨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how weβd approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.