Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Engage with clients to understand their needs and deliver Power BI solutions.
- Company: Join insightsoftware, a global leader in financial data solutions for CFOs.
- Benefits: Enjoy flexible work options and a supportive team culture.
- Why this job: Make an impact by transforming data into actionable insights for businesses.
- Qualifications: Bachelor's degree in a relevant field and experience in Power BI required.
- Other info: Background checks are mandatory; equal opportunity employer.
The predicted salary is between 28800 - 42000 £ per year.
insightsoftware is a global provider of comprehensive solutions for the Office of the CFO. We believe an actionable business strategy begins and ends with accessible financial data. With solutions across financial planning and analysis (FP&A), accounting, and operations, we transform how teams operate, empowering leaders to make timely and informed decisions. With data at the heart of everything we do, insightsoftware enables automated processes, delivers trusted insights, boosts predictability, and increases productivity.
We are seeking an experienced Power BI Business Analyst to work closely with clients, understanding their business needs and translating them into use cases that can be implemented using Power ON. Power ON extends Power BI's functionality by providing write back capability. This role involves engaging with stakeholders to scope and define use cases, estimate implementation efforts, and deliver robust Power ON solutions that drive business insights and decision-making. The ideal candidate will have a strong mix of business acumen, technical expertise, and excellent communication skills.
Key Responsibilities:- Client Engagement & Business Analysis
- Engage with business stakeholders to understand their reporting, analytics, and data visualization needs
- Conduct discovery workshops to gather requirements, define use cases, and assess data sources
- Translate business requirements into clear functional and technical specifications
- Provide recommendations on Power ON best practices, governance, and adoption strategies.
- Solution Design & Implementation
- Design scalable and efficient Power ON solutions, including data models, dashboards, and reports
- Develop datasets, measures (DAX), and visuals to support business insights
- Maintain data accuracy, integrity, and security within the Power BI environment
- Optimise performance of reports and dashboards for a seamless user experience
- Implement Power ON configurations, including workspaces, security, and sharing policies
- Effort Estimation & Project Delivery
- Estimate project effort, timeline, and resource requirements for Power ON implementations
- Define project milestones and collaborate with project managers to ensure timely delivery
- Develop prototypes and proof-of-concepts to validate solutions before full implementation
- Support UAT (User Acceptance Testing) and gather feedback for refinements
- Client Training & Support
- Conduct training sessions for end-users to drive adoption of Power ON solutions
- Provide post-implementation support, troubleshooting, and performance tuning
- Act as a trusted advisor to clients on Power ON strategies and future enhancements
- Bachelor’s or Master’s degree in Mathematics, Computer Science, Data Analytics, Business Intelligence, or a related field
- Experience in Power BI development and business intelligence consulting
- Experience in industries such as finance, healthcare, retail, or manufacturing is a plus
- Microsoft Power BI certification (e.g., PL-300: Power BI Data Analyst)
- Strong expertise in Power BI (Power Query, Power BI Desktop, Power BI Service, DAX, and M Query)
- Experience designing data models and ETL processes within Power BI
- Proficiency in SQL for querying and transforming data from various sources
- Understanding of Azure services (e.g., Azure Synapse, Azure Data Factory, Azure SQL)
- Knowledge of Power Automate and Power Apps integration with Power BI
- Experience with non-Microsoft data sources (Snowflake, Oracle, PostgreSQL, MySQL, Synapse, Big Query) advantageous
- Row Level Security (Analysis Services, PowerBI.com, SQL Server)
- Performance optimisation (Partitioning, Understanding of columnar database concept, SQL indexing)
- Troubleshooting (SQL Profiler or other profiler tools, Tabular Editor, DAX Studio, Power BI datasets, RLS security)
- Strong ability to gather requirements and translate them into technical solutions
- Experience in estimating implementation efforts and defining project scopes
- Ability to work with stakeholders at all levels, including senior executives
- Excellent communication and presentation skills for client-facing interactions
- Proven track record of delivering end-to-end Power BI solutions in a consulting or business setting
- Willingness to travel to client sites as needed
At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located. Background checks are required for employment with insightsoftware, where permitted by country, state/province. At insightsoftware, we are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, national origin, gender, sex, gender identity or expression, sexual orientation, age, citizenship, marital or parental status, disability, veteran status, or other class protected by applicable law. We are proud to be an equal opportunity workplace.
Business Analyst - Power BI employer: insightsoftware
Contact Detail:
insightsoftware Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Analyst - Power BI
✨Tip Number 1
Familiarise yourself with Power BI and its functionalities, especially Power ON. Understanding how to extend Power BI's capabilities will give you an edge during interviews, as you'll be able to discuss specific use cases and solutions.
✨Tip Number 2
Engage in networking within the business intelligence community. Attend relevant meetups or webinars where you can connect with professionals in the field. This can lead to valuable insights and potential referrals for the position.
✨Tip Number 3
Prepare to showcase your problem-solving skills by developing a portfolio of Power BI projects. Highlight any case studies where you've successfully implemented data visualisation solutions, as this will demonstrate your practical experience to potential employers.
✨Tip Number 4
Brush up on your communication skills, particularly in translating technical jargon into layman's terms. Being able to effectively communicate with stakeholders at all levels is crucial for a Business Analyst role, and it will set you apart from other candidates.
We think you need these skills to ace Business Analyst - Power BI
Some tips for your application 🫡
Understand the Role: Before applying, make sure you fully understand the responsibilities and qualifications required for the Business Analyst - Power BI position. Tailor your application to highlight relevant experience in Power BI development and business intelligence consulting.
Highlight Relevant Skills: In your CV and cover letter, emphasise your technical skills related to Power BI, such as DAX, data modelling, and ETL processes. Mention any experience with Azure services and non-Microsoft data sources, as these are advantageous for the role.
Showcase Communication Skills: Since the role involves client engagement and training, demonstrate your excellent communication and presentation skills in your application. Provide examples of how you've successfully interacted with stakeholders or delivered training sessions in the past.
Tailor Your Cover Letter: Craft a personalised cover letter that addresses the specific needs of insightsoftware. Discuss how your background aligns with their mission of transforming financial data into actionable insights and how you can contribute to their team.
How to prepare for a job interview at insightsoftware
✨Know Your Power BI Inside Out
Make sure you have a solid understanding of Power BI, including its features like Power Query, DAX, and data visualisation techniques. Be prepared to discuss your previous projects and how you've used these tools to solve business problems.
✨Understand the Business Context
Familiarise yourself with the industry the company operates in, such as finance or healthcare. This will help you relate your technical skills to their specific business needs and demonstrate your ability to engage with stakeholders effectively.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to walk through how you would handle specific client scenarios or challenges. Practise articulating your thought process in gathering requirements, designing solutions, and delivering results.
✨Showcase Your Communication Skills
Since this role involves client engagement, be ready to demonstrate your communication and presentation skills. You might be asked to explain complex technical concepts in simple terms, so practice doing this beforehand.
