1. Opportunity to enhance analytics capability in a Professional Services company
2. Opportunity to develop Power BI / SQL skills
About Our Client
Leading professional services organisation
Job Description
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 of 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
3. Working within the finance team and liaising with other Business Services areas to create and maintain a library of reports
4. Ongoing maintenance and development of our data visualisation software
5. Assisting with budget modelling within excel
6. Need to be able to interrogate and link data from multiple systems and pull together in understandable ways
7. Look at ways to standardise reporting to enable month on month reporting without need for technical input
8. Working with the IT development team and external solution providers to understand sources of data and what is available
9. Work effectively with stakeholders to translate requirements that will inform the implementation of effective and efficient systems and processes
10. Ensure reporting governance is in place and followed, such as documenting requirements, data staging/treatments and assumptions effectively
Key Skills
11. Analytical in approach, strong attention to detail, including relating to escalation
12. Strong communication skills across a wide user base
13. Experience of producing management information & statistical information
14. Ability to deal with ambiguity and bring clarity
15. Advanced Excel including macros and VBA
16. Previous experience in a reporting role, with experience of working with large/complex data sets
17. A good working knowledge of SQL
18. Customer and delivery focused, meeting and exceeding customer expectations
19. Good knowledge of Power Query / DAX / Power Pivot and Power BI
20. Accounting experience is highly desirable but not essential
The Successful Applicant
21. Analytical in approach, strong attention to detail, including relating to escalation
22. Strong communication skills across a wide user base
23. Experience of producing management information & statistical information
24. Ability to deal with ambiguity and bring clarity
25. Advanced Excel including macros and VBA
26. Previous experience in a reporting role, with experience of working with large/complex data sets
27. A good working knowledge of SQL
28. Customer and delivery focused, meeting and exceeding customer expectations
29. Good knowledge of Power Query / DAX / Power Pivot and Power BI
30. Accounting experience is highly desirable but not essential
What's on Offer
Opportunity to enhance analytics capability in a Professional Services companyOpportunity to develop Power BI / SQL skills