Junior Business Intelligence Analyst
Junior Business Intelligence Analyst

Junior Business Intelligence Analyst

Full-Time 30000 - 40000 £ / year (est.) No home office possible
Systematica Group

At a Glance

  • Tasks: Design and develop Power BI dashboards, maintain data pipelines, and support reporting processes.
  • Company: Join a leading investment firm with a focus on innovation and teamwork.
  • Benefits: Private medical insurance, competitive salary, bonuses, and free snacks from day one.
  • Other info: Dynamic work environment with opportunities for growth and learning.
  • Why this job: Gain hands-on experience in BI while working with industry experts and making impactful contributions.
  • Qualifications: Up to 2 years of BI experience, strong SQL skills, and a proactive mindset.

The predicted salary is between 30000 - 40000 £ per year.

We are looking for a Junior Business Intelligence developer to join the Reporting Technology team in London. The position focuses on supporting the delivery of data and reporting initiatives, helping produce accurate and meaningful insights into business performance. You will work closely with experienced Business Intelligence professionals and senior stakeholders, contributing to the development of reports, dashboards, data processes, and reporting solutions.

Key Responsibilities

  • Design, develop, and maintain Power BI dashboards and reports, following best practices for usability and performance.
  • Build and maintain data pipelines to ingest, transform and prepare the data required for the reports.
  • Build and maintain semantic models ensuring they are clean, accurate, and ready for consumption.
  • Develop and maintain Power Automate workflows to support reporting processes.
  • Work with stakeholders to understand business requirements and translate these into data and reporting deliveries.
  • Investigate data issues, support troubleshooting activities, and help ensure accurate reporting data.
  • Contribute to improving data quality, reporting standards, and system efficiency.
  • Track assigned tasks in Jira and ensure the Kanban status is kept up to date.
  • Maintain appropriate level of documentation in Confluence.

Skills, Knowledge and Expertise

  • Up to 2 years’ experience supporting BI, reporting, or data-related activities (internship, placement, or professional experience).
  • Hands‑on experience analysing data and producing reports using Power BI.
  • Understanding of data modelling, data extraction, and data transformation concepts.
  • Working knowledge of SQL for data extraction and analysis (at least 1 year experience using SQL).
  • Ability to troubleshoot issues, investigate data queries, and support problem resolution.
  • Team‑oriented with a proactive mindset and willingness to learn.
  • Excellent attention to detail and problem‑solving skills.
  • Strong communication skills with the ability to work effectively with stakeholders and team members.

Beneficial

  • Experience using Python for data analysis or transformation is highly advantageous.
  • Experience building reports related to investment funds performance, risk or PnL.
  • Experience working with Microsoft Fabric.
  • Working knowledge of JIRA and Confluence.

Educational & Professional Qualifications

  • Bachelor’s degree in computer science or related field from a leading university; Master’s degree preferred.
  • Power BI certifications is a plus.

Benefits

Systematica Investments provides you with excellent benefits from day 1. We provide private medical insurance for you and your immediate family. We offer competitive salaries combined with an attractive bonus and pension plus free drinks and snacks at the office. We also offer paid parental leave with enhanced leave for mothers/primary carers. We are an equal opportunity employer and value diversity at our company.

Junior Business Intelligence Analyst employer: Systematica Group

At Systematica Investments, we pride ourselves on being an exceptional employer, offering a vibrant work culture in the heart of London. Our commitment to employee growth is evident through our supportive environment, where you will collaborate with seasoned professionals and have access to comprehensive benefits from day one, including private medical insurance, competitive salaries, and generous parental leave. Join us to not only advance your career in Business Intelligence but also to be part of a diverse team that values innovation and excellence.
Systematica Group

Contact Detail:

Systematica Group Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Junior Business Intelligence Analyst

✨Network Like a Pro

Get out there and connect with people in the industry! Attend meetups, webinars, or even just grab a coffee with someone who works in BI. Building relationships can open doors that job applications alone can't.

✨Show Off Your Skills

Create a portfolio showcasing your Power BI dashboards and reports. This is your chance to shine! When you get an interview, bring it along to demonstrate your hands-on experience and problem-solving skills.

✨Ace the Interview

Prepare for common BI interview questions and be ready to discuss your experience with SQL and data modelling. Practice explaining your thought process when troubleshooting data issues – it shows you're proactive and detail-oriented!

✨Apply Through Our Website

Don't forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are genuinely interested in joining our team.

We think you need these skills to ace Junior Business Intelligence Analyst

Power BI
Data Analysis
Data Modelling
Data Extraction
Data Transformation
SQL
Troubleshooting
Problem-Solving Skills
Communication Skills
Teamwork
Attention to Detail
JIRA
Confluence
Power Automate
Python

Some tips for your application 🫡

Tailor Your CV: Make sure your CV is tailored to the Junior Business Intelligence Analyst role. Highlight your experience with Power BI, SQL, and any relevant projects you've worked on. We want to see how your skills match what we're looking for!

Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about business intelligence and how you can contribute to our team. Keep it concise but engaging – we love a good story!

Show Off Your Skills: If you've got hands-on experience with data analysis or reporting, make sure to showcase that in your application. Mention specific tools and techniques you've used, especially if they relate to the job description. We’re keen to see your practical knowledge!

Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way to ensure your application gets into the right hands. Plus, it shows us you’re serious about joining our awesome team at StudySmarter!

How to prepare for a job interview at Systematica Group

✨Know Your Power BI Inside Out

Make sure you brush up on your Power BI skills before the interview. Be ready to discuss your previous projects, how you designed dashboards, and any challenges you faced. Practising with sample datasets can help you articulate your thought process during the interview.

✨Understand Data Modelling Concepts

Since the role involves data modelling, it’s crucial to have a solid grasp of the concepts. Prepare to explain how you would approach building semantic models and why accuracy is key. This will show that you’re not just familiar with the tools but also understand the underlying principles.

✨Communicate Clearly with Stakeholders

The job requires working closely with stakeholders, so practice how you would gather requirements and translate them into actionable insights. Think of examples where you successfully communicated complex data findings in a simple way. This will demonstrate your strong communication skills.

✨Familiarise Yourself with Jira and Confluence

Since tracking tasks in Jira and maintaining documentation in Confluence are part of the role, it’s a good idea to get comfortable with these tools. If you have experience using them, be prepared to share specific instances where they helped you manage your work effectively.

Junior Business Intelligence Analyst
Systematica Group

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>