Michael Page
Business Intelligence / Power BI Analyst (Finance Function)
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Job Title
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
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Job Offer
- Opportunity to work in a newly created role
- Opportunity to lead on reporting capability enhancement with career progression
Desired Skills and Experience
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
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Key Skills:
- 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
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location