At a Glance
- Tasks: Create and maintain reports and dashboards in Power BI for finance decision-making.
- Company: Join a leading professional services organisation with a focus on innovation.
- Benefits: Enhance your analytics skills and gain valuable experience in a dynamic environment.
- Other info: Collaborate with diverse teams and enjoy opportunities for professional growth.
- Why this job: Make an impact by supporting senior management with data-driven insights.
- Qualifications: Experience in reporting, SQL, and advanced Excel 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
Locations
Data Analyst - Power BI / SQL (Finance Function) in Bath, Somerset employer: Michael Page Technology
Contact Detail:
Michael Page Technology Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst - Power BI / SQL (Finance Function) in Bath, Somerset
✨Network Like a Pro
Get out there and connect with people in the industry! Attend meetups, webinars, or even casual coffee chats. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Show Off Your Skills
Create a portfolio showcasing your Power BI dashboards and SQL queries. This is your chance to shine! When you get an interview, bring it along to demonstrate your analytical prowess and how you can add value to their finance function.
✨Tailor Your Approach
When reaching out to potential employers, make sure to tailor your message. Highlight your experience with data visualisation and how you can help them standardise reporting. Personal touches go a long way!
✨Apply Through Our Website
Don’t forget to check out our website for the latest job openings! Applying directly through us not only shows your interest but also gives you a better chance of being noticed by the hiring team.
We think you need these skills to ace Data Analyst - Power BI / SQL (Finance Function) in Bath, Somerset
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the role of Data Analyst. Highlight your experience with Power BI, SQL, and any relevant projects that showcase your analytical skills. We want to see how you can bring value to our finance function!
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 your skills align with our needs. Don’t forget to mention your experience in producing management information and working with large datasets.
Showcase Your Technical Skills: We’re looking for someone with strong technical abilities, so make sure to list your proficiency in Excel, SQL, and Power BI clearly. If you’ve worked with DAX or Power Query, give us examples of how you’ve used these tools to solve problems.
Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It’s the best way for us to receive your application and ensure it gets the attention it deserves. We can’t wait to see what you bring to the table!
How to prepare for a job interview at Michael Page Technology
✨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 VBA. Being able to discuss specific projects where you've used these tools will show your practical experience.
✨Understand the Business Context
Familiarise yourself with the finance function and how data reporting supports decision-making. Research the company’s recent projects or reports to demonstrate your interest and understanding of their operations during the interview.
✨Prepare for Scenario Questions
Expect questions that assess your problem-solving skills, especially around ambiguity and data interpretation. Think of examples where you’ve successfully linked data from multiple sources or standardised reporting processes.
✨Showcase Your Communication Skills
Since you'll be liaising with various teams, practice explaining complex data concepts in simple terms. Prepare to discuss how you’ve effectively communicated insights to stakeholders in the past, highlighting your ability to translate technical jargon into actionable insights.