Junior Data Analyst

Brooks Macdonald; London; On-site; GBP 30,000 - 40,000; Full time

Job summary

A leading company is seeking a proactive Junior Data Analyst to join their Front Office Development Team in London. This role offers a unique opportunity to develop technical skills in C#, SQL, Python, and VB.NET while supporting team operations and enhancing data systems. The ideal candidate will have a passion for data, strong analytical skills, and a commitment to continuous learning in a dynamic environment.

Qualifications

• Background in technology, including data analysis or software development.
• Proficiency in SQL and/or Python highly desirable.
• Completion of relevant professional data science certifications preferred.

Responsibilities

• Support operations by maintaining and enhancing existing systems and dashboards.
• Develop, maintain, and enhance Power BI dashboards for actionable insights.
• Proactively analyze data to answer key questions for stakeholders.

Skills

Data analysis

Programming

SQL

Python

Excel

Communication

Analytical skills

Education

Relevant professional data science certifications

Tools

Power BI

Azure

AWS

Job description

We are seeking a proactive and detail-oriented Junior Data Analyst to join our Front Office Development Team. In this role, you will support the operations of the team by maintaining and enhancing existing systems, dashboards, and processes. This position offers a unique opportunity to develop your technical skills in C#, SQL, Python, and VB.NET while working closely with experienced software developers.

Role Responsibilities:

• Support the operations of the Front Office Development Team by providing technical assistance and maintenance for existing systems and processes
• Troubleshoot and resolve issues with current systems, ensuring minimal disruption to business operations
• Develop, maintain, and enhance Power BI dashboards to provide actionable insights for the business
• Collaborate with team members and stakeholders to ensure dashboards meet business needs and are effectively utilised
• Design, build, and maintain automation solutions to streamline data processing and improve team efficiency, identifying opportunities for automation within existing processes and proposing innovative solutions
• Evaluate internal systems for efficiency, problems, and inaccuracies, and develop processes for data handling, processing, and cleaning
• Proactively analyse data to answer key questions for stakeholders, focusing on business performance and identifying areas for improvement in efficiency and productivity
• Generate reports and present findings to stakeholders, providing clear recommendations based on data analysis
• Take the opportunity to learn and develop skills in C#, SQL, Python, and VB.NET through shadowing and hands-on experience
• Stay updated with the latest trends and best practices in data analysis and software development
• Perform role always ensuring adherence to the expected behaviours stated in the FCA Conduct Rules

Knowledge, Skills and Experience:

• Passionate about data, technology and programming.
• Background in technology, including data analysis, end-user support, or software development, with a demonstrable understanding of computer systems and software
• Understanding of computer programming languages such as SQL, Python, or others. Proficiency in SQL and/or Python highly desirable
• Advanced Excel skills preferable, particularly in data analysis and automation
• Strong analytical skills with a proven ability to identify and resolve issues effectively
• Excellent communication skills, with the ability to convey technical information clearly and concisely
• Completion of relevant professional data science certifications or courses is preferred, demonstrating a commitment to continuous learning and skill development
• Familiarity with data visualisation and business intelligence platforms, such as Power BI, advantageous
• Prior experience with cloud platforms like Azure or AWS advantageous