Junior BI Analyst in London

Junior BI Analyst in London

London Full-Time 30000 - 40000 £ / year (est.) No working from home possible
Systematica Investments

At a Glance

  • Tasks: Design and develop Power BI dashboards, build data pipelines, and support reporting processes.
  • Company: Join Systematica Investments, a tech-driven firm with a focus on innovation and excellence.
  • Benefits: Enjoy 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.

About Systematica Investments

Systematica Investments, launched in January 2015 after a decade of experience within BlueCrest Capital Management, is an innovative technology-driven firm focused on a quantitative and systematic approach to investing. The firm was founded by Leda Braga and manages assets across a number of futures, equity and OTC based strategies. The philosophy of the firm is one of innovation, excellence in research and a commitment to fostering a strong alignment with investors. Systematica Investments has a global presence with offices in Jersey, Geneva, London, New York, Singapore and Shanghai.

Junior BI Analyst in London employer: Systematica Investments

At Systematica Investments, we pride ourselves on being an excellent employer, offering a dynamic work environment in London where innovation and collaboration thrive. Our commitment to employee growth is evident through mentorship from experienced professionals, alongside competitive benefits such as private medical insurance, attractive bonuses, and a focus on work-life balance with paid parental leave. Join us to be part of a diverse team that values excellence and fosters meaningful contributions to the world of data and reporting.

Systematica Investments

Contact Details:

Systematica Investments Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Junior BI Analyst in London

Tip Number 1

Network like a pro! Reach out to current employees at Systematica Investments on LinkedIn. A friendly message can go a long way in getting your foot in the door and showing your genuine interest in the company.

Tip Number 2

Prepare for those interviews! Brush up on your Power BI skills and be ready to discuss your experience with data modelling and SQL. We want to see how you can contribute to our team, so come armed with examples of your past work.

Tip Number 3

Show off your problem-solving skills! During interviews, be prepared to tackle some real-world data issues. We love candidates who can think on their feet and demonstrate their analytical prowess.

Tip Number 4

Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re serious about joining our awesome team at Systematica Investments.

We think you need these skills to ace Junior BI Analyst in London

Power BI
Data Modelling
Data Extraction
Data Transformation
SQL
Troubleshooting
Problem Resolution

Some tips for your application 🫡

Tailor Your CV:Make sure your CV is tailored to the Junior BI 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 any cool projects or reports you've created, don’t hesitate to mention them! We’re keen to see your hands-on experience with data analysis and reporting, so let us know what you've done.

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!

How to prepare for a job interview at Systematica Investments

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.

SQL Skills Are Key

Since SQL is a crucial part of the role, ensure you're comfortable with data extraction and analysis. Prepare to answer questions about your experience with SQL, and maybe even do a quick coding exercise. Familiarise yourself with common SQL queries and be ready to explain your approach to troubleshooting data issues.

Understand the Business Context

Research Systematica Investments and understand their business model and the types of reports they might need. This will help you tailor your answers to show how you can contribute to their goals. Think about how your skills can help improve data quality and reporting standards.

Show Off Your Team Spirit

This role requires collaboration with stakeholders and team members, so be prepared to discuss your teamwork experiences. Share examples of how you've worked in a team setting, tackled problems together, and communicated effectively. Highlight your proactive mindset and willingness to learn from others.