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