At a Glance
- Tasks: Create and maintain reports and dashboards in Power BI for finance decision-making.
- Company: Leading professional services organisation with a focus on innovation.
- Benefits: Enhance your analytics skills and gain valuable experience in a dynamic environment.
- Other info: Collaborative team culture with opportunities for professional growth.
- Why this job: Make an impact by supporting senior management with data-driven insights.
- Qualifications: Experience in reporting, SQL knowledge, and strong analytical skills required.
The predicted salary is between 35000 - 45000 £ per year.
This leading professional services organisation are looking for a Data Reporting Analyst to support their finance function in the creation of advanced modelling and analytics capabilities. You will collaborate with both the management information and IT development teams to create and maintain a range of reports and dashboards in Power BI to support senior management decisioning and strategy.
You will work across a range of platforms and applications to extract data from various sources (using SQL), applying logic and calculations and presentation of the results in a meaningful way. The role will also include an element of modelling in Excel, assisting with forecasts and day-to-day maintenance of the Power BI platform.
Key Responsibilities- Working within the finance team and liaising with other Business Services areas to create and maintain a library of reports
- Ongoing maintenance and development of our data visualisation software
- Assisting with budget modelling within Excel
- Need to be able to interrogate and link data from multiple systems and pull together in understandable ways
- Look at ways to standardise reporting to enable month-on-month reporting without need for technical input
- Working with the IT development team and external solution providers to understand sources of data and what is available
- Work effectively with stakeholders to translate requirements that will inform the implementation of effective and efficient systems and processes
- Ensure reporting governance is in place and followed, such as documenting requirements, data staging/treatments and assumptions effectively
- Analytical in approach, strong attention to detail, including relating to escalation
- Strong communication skills across a wide user base
- Experience of producing management information & statistical information
- Ability to deal with ambiguity and bring clarity
- Advanced Excel including macros and VBA
- Previous experience in a reporting role, with experience of working with large/complex data sets
- A good working knowledge of SQL
- Customer and delivery focused, meeting and exceeding customer expectations
- Good knowledge of Power Query / DAX / Power Pivot and Power BI
- Accounting experience is highly desirable but not essential
- Opportunity to enhance analytics capability in a Professional Services company
- Opportunity to develop Power BI / SQL skills
Data Analyst - Power BI / SQL (Finance Function) in Bath employer: Michael Page
Contact Detail:
Michael Page Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst - Power BI / SQL (Finance Function) in Bath
✨Tip Number 1
Network like a pro! Reach out to people in the finance and data analytics space, especially those who work with Power BI and SQL. Attend industry events or webinars, and don’t be shy about asking for informational interviews – you never know where a chat might lead!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best reports and dashboards. Use Power BI to visualise your projects and share them on platforms like LinkedIn. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on your technical skills. Be ready to discuss your experience with SQL, Excel, and Power BI in detail. Practice explaining complex data concepts in simple terms – this will show your strong communication skills and ability to work with diverse stakeholders.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that match your skills. Plus, it’s a great way to get noticed by our hiring team. So, get your application in and let’s get you on the path to landing that Data Analyst role!
We think you need these skills to ace Data Analyst - Power BI / SQL (Finance Function) in Bath
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the role of Data Reporting Analyst. Highlight your experience with Power BI, SQL, and any relevant finance functions. We want to see how your skills align with 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 data analytics and how you can contribute to our finance function. Keep it engaging and personal – we love a good story!
Showcase Your Analytical Skills: In your application, don’t forget to mention specific examples where you've used your analytical skills to solve problems or improve processes. We’re all about data-driven decision-making, so show us what you’ve got!
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you get the best experience possible. Plus, it’s super easy!
How to prepare for a job interview at Michael Page
✨Know Your Tools Inside Out
Make sure you’re well-versed in Power BI, SQL, and Excel. Brush up on your knowledge of DAX, Power Query, and any relevant macros or VBA. Being able to discuss specific projects where you've used these tools will show your practical experience.
✨Showcase Your Analytical Skills
Prepare examples that highlight your analytical approach and attention to detail. Think about times when you’ve turned complex data into clear insights or reports. This will demonstrate your ability to handle ambiguity and provide clarity in your work.
✨Communicate Effectively
Practice explaining technical concepts in simple terms. You’ll need to collaborate with various teams, so being able to communicate your findings clearly is crucial. Consider role-playing with a friend to refine your communication style.
✨Understand the Business Context
Research the company and its finance function. Understand their reporting needs and how your role as a Data Reporting Analyst fits into their strategy. This will help you tailor your answers and show that you’re genuinely interested in contributing to their success.