Our leading professional services organisation is 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 decision-making 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 presenting 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
* Work within the finance team and liaise with other Business Services areas to create and maintain a library of reports
* Ongoing maintenance and development of our data visualisation software
* Assist with budget modelling within Excel
* Interrogate and link data from multiple systems and consolidate it in understandable ways
* Standardise reporting to enable month-on-month reporting without technical input
* Work with the IT development team and external solution providers to understand data sources and availability
* Translate stakeholder requirements to inform implementation of effective and efficient systems and processes
* Ensure reporting governance is in place and followed, documenting requirements, data staging, treatments and assumptions
Key Skills
* Analytical, with strong attention to detail and ability to relate to escalation
* Strong communication skills across a wide user base
* Experience producing management information and statistical information
* Ability to deal with ambiguity and bring clarity
* Advanced Excel including macros and VBA
* Previous experience in a reporting role, handling large/complex data sets
* Working knowledge of SQL
* Customer and delivery focused, meeting and exceeding expectations
* Knowledge of Power Query, DAX, Power Pivot and Power BI
* Accounting experience highly desirable but not essential
Profile
* Analytical approach, strong attention to detail, ability to relate to escalation
* Strong communication skills across a wide user base
* Experience producing management information and statistical information
* Handling ambiguity and delivering clarity
* Advanced Excel with macros and VBA
* Reporting role experience managing large/complex data sets
* Working knowledge of SQL
* Customer and delivery focused, meeting/exceeding expectations
* Knowledge of Power Query, DAX, Power Pivot, Power BI
* Accounting experience desirable but not essential
Job Offer
Opportunity to enhance analytics capability in a professional services company.
Opportunity to develop Power BI and SQL skills.
#J-18808-Ljbffr