Data Analyst in City of London

Data Analyst in City of London

City of London Trainee 25000 - 32000 £ / year (est.) No home office possible
S

At a Glance

  • Tasks: Analyse data and support finance transformations while working on real client projects.
  • Company: Boutique advisory firm specialising in Workday Financials with a collaborative culture.
  • Benefits: Competitive salary, structured training, early responsibility, and flexible working arrangements.
  • Other info: Join a supportive team where your contributions are valued and career growth is encouraged.
  • Why this job: Kickstart your career in consulting and finance with hands-on experience and mentorship.
  • Qualifications: Recent graduate in finance, accounting, or data engineering; strong Excel skills required.

The predicted salary is between 25000 - 32000 £ per year.

Location: London, Camden

Reports to: Consulting Manager/ Project Lead

Company Description: Sub One is a boutique advisory firm specialising in Workday Financials. Our vision is to support our clients in moving from a backward-looking, month-end close process to real-time accounting, enabling finance teams to focus on delivering insights and analytics that drive business decisions. With extensive practical experience in data, accounting, and systems, the company aims to deliver successful finance transformations using the latest technologies.

Looking to start your career in consulting, finance, and data? We are looking for a graduate or early-career data analyst or engineer who wants to develop into a consultant. You will start with a rigorous training and development plan and work alongside experienced consultants on real client projects.

You will support finance system implementations and data-driven improvements across finance and reporting, combining analytical work with client interaction, problem-solving, and consulting delivery.

What you’ll be doing:

  • Analysing and validating data to support finance transformation and reporting projects
  • Building data-driven solutions using Excel, with exposure to SQL and Power BI
  • Supporting the implementation, testing, documentation, and data migration of finance and ERP systems
  • Preparing client-ready deliverables, including reports and presentations
  • Participating in client meetings and workshops, developing consulting and communication skills

About you:

  • A recent graduate in finance, accounting, data engineering or a related field
  • Comfortable working with data and keen to build practical, real-world experience
  • Strong Excel skills and an analytical, detail-oriented mindset
  • Exposure to SQL or Power BI is a plus, but not essential
  • Curious, motivated, and eager to learn in a consulting environment
  • A positive team player with strong communication skills with the ability to build professional rapport with clients

What we offer:

  • Competitive salary
  • Structured training, mentoring, and support from experienced consultants
  • Early responsibility with hands-on exposure to real client projects
  • A clear career path focused on continuous learning and development
  • Exposure to finance systems, data tools, and transformation projects
  • A collaborative, inclusive culture where your contribution is valued
  • Flexible working arrangements within a supportive, trust-based environment

Right to work in the UK required (no visa sponsorship is available at this stage)

Data Analyst in City of London employer: Sub One Group Limited

Sub One is an exceptional employer located in the vibrant area of Camden, London, offering a unique opportunity for graduates to kickstart their careers in consulting and finance. With a strong focus on training and development, employees benefit from hands-on experience with real client projects, a clear career progression path, and a collaborative culture that values each contribution. The firm’s commitment to flexible working arrangements further enhances the supportive environment, making it an ideal place for those eager to grow and make a meaningful impact in the finance transformation space.
S

Contact Detail:

Sub One Group Limited Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Data Analyst in City of London

✨Tip Number 1

Network like a pro! Reach out to professionals in the finance and consulting sectors on LinkedIn. Join relevant groups, attend webinars, and don’t be shy about asking for informational interviews. We all know that sometimes it’s not just what you know, but who you know!

✨Tip Number 2

Prepare for those interviews! Research common data analyst interview questions and practice your answers. We recommend using the STAR method (Situation, Task, Action, Result) to structure your responses. Show them how your analytical skills can shine in real-world scenarios!

✨Tip Number 3

Don’t forget to showcase your projects! Whether it’s a university project or something you did on your own, having tangible examples of your work can set you apart. Create a portfolio or a GitHub repository to display your data-driven solutions and analyses.

✨Tip Number 4

Apply through our website! We’re always on the lookout for fresh talent, and applying directly can give you an edge. Plus, it shows your enthusiasm for joining our team at Sub One. Let’s get you started on that career path in consulting and finance!

We think you need these skills to ace Data Analyst in City of London

Data Analysis
Excel
SQL
Power BI
Analytical Skills
Attention to Detail
Problem-Solving Skills
Communication Skills
Client Interaction
Documentation Skills
Team Collaboration
Consulting Skills
Adaptability
Learning Agility

Some tips for your application 🫡

Tailor Your CV: Make sure your CV reflects the skills and experiences that match the Data Analyst role. Highlight any relevant coursework, projects, or internships that showcase your analytical abilities and familiarity with data tools like Excel, SQL, or Power BI.

Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to tell us why you're passionate about finance and data, and how you see yourself growing in a consulting environment. Be sure to mention any specific experiences that relate to our vision of real-time accounting.

Showcase Your Analytical Mindset: In your application, demonstrate your analytical skills by providing examples of how you've tackled data-related challenges in the past. Whether it's a project from university or a personal endeavour, we want to see your problem-solving approach!

Apply Through Our Website: We encourage you to apply directly through our website for the best chance of getting noticed. It’s super easy, and you’ll be able to attach all your documents in one go. Plus, it shows us you’re keen on joining our team!

How to prepare for a job interview at Sub One Group Limited

✨Know Your Data

Make sure you brush up on your data analysis skills, especially in Excel. Be ready to discuss how you've used data in your studies or any projects. If you've dabbled in SQL or Power BI, mention that too – it shows you're keen to learn and grow!

✨Understand the Company

Do a bit of homework on Sub One and their focus on finance transformations. Knowing their vision will help you tailor your answers and show that you're genuinely interested in what they do. Plus, it’ll give you some great talking points during the interview.

✨Prepare for Client Interaction

Since the role involves client meetings, think about how you can demonstrate your communication skills. Prepare examples of how you've worked in teams or interacted with clients in the past. This will highlight your ability to build rapport and work collaboratively.

✨Show Your Curiosity

Be ready to discuss what excites you about consulting and data analysis. Ask insightful questions about the role and the projects you'll be involved in. This not only shows your enthusiasm but also your eagerness to learn and contribute to the team.

Data Analyst in City of London
Sub One Group Limited
Location: City of London

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

>