Business Intelligence / Power BI Analyst (Finance Function)

This leading Retail organisation are looking to appoint a Business Intelligence / Power BI Analyst to support their finance function in developing Dashboards and Power BI Reports to support senior management decisioning and automate processes. Your primary focus turning data from multiple sources into clear, actionable insights for the business in Power BI.

Client Details

Leading Retail organisation

Description

This leading Retail organisation are looking to appoint a Business Intelligence / Power BI Analyst to support their finance function in developing Dashboards and Power BI Reports to support senior management decisioning and automate processes. Your primary focus turning data from multiple sources into clear, actionable insights for the business in Power BI. You will also provide ongoing support and training to end users, ensuring they can confidently and effectively use Power BI reporting solutions.

Alongside this core reporting focus, you will design, build and support automation tools (an interest in learning and developing skills in Power Automate / Power Apps is desirable) that improve business workflows. Working closely with Finance, over time you will help develop approval processes, identify automation opportunities, and support continuous process improvement through practical AI and automation solutions.

Key Responsibilities

Collaborating with stakeholders to gather and understand business requirements, ensuring alignment with business goals

Ensuring deliverables are completed to specification, and within agreed timelines

Implementing best practices for data visualisation and report design to enhance user experience and data comprehension

Create and maintain data models to ensure efficient performance and accurate data representation

Transform raw data from multiple sources (databases, APIs, Excel, etc.) into meaningful and visually appealing reports

Optimise Power BI reports and dashboards for performance, ensuring fast load times and responsiveness

Monitoring and maintaining data quality and integrity across all reports and dashboards

Conducting regular reviews and updates of PowerBI reports and dashboards to ensure they meet evolving business needs

Support the business with automation and developing workflows through suitable automation platforms

Work closely with Finance teams to identify reporting, control and process automation opportunities

Training and supporting end-users to effectively utilise PowerBI and other tools/reports

Staying updated with the latest PowerBI features and automation trends to continuously improve automation and reporting capabilities

Profile

Proven experience as a BI Developer, Power BI Developer, automation specialist or similar role.

Strong proficiency in Power BI Desktop, Power BI Service, and Power Query.

Solid understanding of data modelling concepts, including star schema, relationships, and normalisation.

Experience with DAX (Data Analysis Expressions) for creating complex measures and calculations

Familiarity with Power BI best practices, security, and sharing capabilities.

Proficient in SQL and experience with querying databases (SQL Server, Oracle, etc.).

Knowledge of ETL (Extract, Transform, Load) processes and tools.

Analytical thinker / problem solver

Keen to learn and understand what is available in the market to support the business with automation

Be proactive in flagging new tools and automation opportunities and willingness to explore the opportunities for the business.

Ability to manage time and prioritise workloads based on urgency and importance with minimal supervision

Willingness to see through complicated issues to resolution

Structured and detail-oriented, with a strong focus on data accuracy, reconciliation and auditability

Strong stakeholder management and communication skills, with experience working with finance teams

Finance background or prior experience supporting Finance reporting/processes is required; experience in multi-department environments is a plus

Experience building and supporting automation solutions is a plus. As an organisation we are keen to develop automation. We are looking for someone who is keen to develop their own skills in this area and support the business in their journey to automation of processes

Job Offer

Opportunity to work in a newly created role

Opportunity to lead on reporting capability enhancement with career progression