O

Junior Business Intelligence Analyst

olive tree consulting group • United Kingdom
Remote
Apply
AI Summary

Support a West Midlands infrastructure group by organizing and interpreting operational data to create clear, actionable management information. Build simple dashboards and weekly reports that highlight task delays and unclear ownership using Power BI or Excel. Ensure data accuracy, document sources, and assist with ad hoc data requests in a fully remote, entry-level role.

Key Highlights
Create clear, readable dashboards prioritizing readability over visual flair
Clean and validate datasets to ensure accurate leadership information
Support remote advisory practice with ad hoc data requests and documentation
Key Responsibilities
Collect and organize data from project management and financial systems
Create weekly reports highlighting task delays and unclear ownership
Clean and validate datasets for accuracy and reliability
Build simple, clear dashboards using Power BI or Excel
Attend internal team meetings to understand key metrics
Document data sources and logic for reports
Identify patterns in meeting operations and decision recording
Support consulting team with ad hoc data requests
Technical Skills Required
Data visualization Microsoft Excel SQL
Benefits & Perks
Full-time permanent position
Remote work
Competitive pay
Nice to Have
Familiarity with Power BI, Tableau, or similar platforms
Strong grasp of Microsoft Excel including pivot tables and basic formulas
Introductory knowledge of SQL for querying databases
Interest in how large organizations or infrastructure projects operate
Experience from internship, university project, or personal portfolio
Degree or certificate in data science, mathematics, economics, or business

Job Description


Olive Tree Consulting is currently supporting a West Midlands infrastructure group to improve how their leadership teams manage complex projects. We are looking for a Junior BI Analyst to help us organize and interpret the data generated by these daily operations. This role focuses on making management information easy to see and simple to act upon in a way that supports better decision making.

About the Role
This position exists to help our consultants turn messy operational information into clear, readable records. In our work with the West Midlands infrastructure group, we often find that teams have plenty of data but lack the clarity needed to make quick decisions. You will support our advisory practice by building the tools that show where priorities are stalling and where responsibility might be unclear. This is not about building complex models for their own sake: it is about creating the smallest possible data record that helps a leadership team stay on track. This role is fully remote, allowing you to focus on producing high quality analysis from your own workspace while staying connected with our team through clear, written documentation.

What You Will Do
  • Collect and organize data from various project management and financial systems used by the infrastructure group.
  • Create weekly reports that highlight where tasks are falling behind or where ownership is not clearly assigned.
  • Clean and validate datasets to ensure the information we present to leadership is accurate and reliable.
  • Build simple, clear dashboards using tools like Power BI or Excel that prioritize readability over visual flair.
  • Attend internal team meetings to understand which metrics actually matter to the managers on the ground.
  • Document the data sources and logic used in your reports so that others can follow your work easily.
  • Assist in identifying patterns in how meetings are run and how decisions are recorded across different departments.
  • Support the broader consulting team with ad hoc data requests during intense phases of the project.


What We Are Looking For
We need someone who values accuracy and has an eye for when something does not look quite right. You should be comfortable working with numbers and have an understanding of how databases are structured. Clear communication is essential: we value people who can explain a data set in plain English without using unnecessary jargon. Since this is an entry level role, we prioritize a willingness to learn our specific way of working and a focused approach to problem solving. You should be able to manage your own time effectively in a remote environment and feel comfortable asking for clarification when a task is ambiguous.

Helpful Background
  • Familiarity with data visualization software such as Power BI, Tableau, or similar platforms.
  • A strong grasp of Microsoft Excel, including the use of pivot tables and basic formulas.
  • Introductory knowledge of SQL for querying databases or an interest in learning it quickly.
  • An interest in how large organizations or infrastructure projects operate.
  • Experience from an internship, university project, or personal portfolio that demonstrates how you handle data.
  • A degree or certificate in a related field like data science, mathematics, economics, or business.


What We Offer
This is a full time, permanent position that is conducted entirely in a remote setting. We provide an environment that favors deep work and clear written communication over endless video calls or corporate theatre. This is a paid role with competitive pay for the current market and your level of experience. You will have the chance to see how high level management decisions are made and how data can be used to make those processes smoother and more transparent.

About Olive Tree
Olive Tree Consulting Group is a focused advisory practice that helps leadership teams solve recurring management issues. We typically work on the space between strategy and daily execution. A team can have very capable people and still find that decisions keep reopening, priorities stall, or responsibility remains unclear. These are rarely personality problems: they are structural habits that have not kept up with the company's growth.
We favor practical changes over large scale transformation programs. Our work involves looking at how decisions are made, how meetings are run, and how ownership is recorded. We prefer useful written notes and clear ownership over polished presentations and vague alignment. Good advisory work should make things plainer and leave the team with a rhythm they can continue on their own.
The firm is built on the principle that memory is not a management system. We help teams create the smallest possible written record to support their work so that important follow up does not depend on who was in the room or who has the best memory. The goal is a quieter management pattern that makes the existing work easier to lead.

Similar Jobs

Explore other opportunities that match your interests

Data Analyst Intern

Data Science
•
1h ago
Visa Sponsorship Relocation Remote
Job Type Internship
Experience Level Internship

hawkroot

United Kingdom

AI/NLP/Data Engineer

Data Science
•
2h ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Not Applicable

Jobgether

United Kingdom

Business Analyst - Finance and Data

Data Science
•
2d ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Not Applicable

RNID

United Kingdom

Subscribe our newsletter

New Things Will Always Update Regularly