Data Analyst - Power BI / SQL (Finance Function)

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.

Client Details

Leading professional services organisation

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

• 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

Key Skills

• 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

Profile

• 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

Job Offer

Opportunity to enhance analytics capability in a Professional Services company

Opportunity to develop Power BI / SQL skills