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: A degree in a related field and experience in Power BI are preferred.
- Other info: Background checks are required; equal opportunity employer.
The predicted salary is between 36000 - 60000 £ 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 Functional Consultant 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.
Functional Consultant - Power BI employer: insightsoftware
Contact Detail:
insightsoftware Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Functional Consultant - Power BI
✨Tip Number 1
Familiarise yourself with Power ON and its capabilities. Understanding how it extends Power BI's functionality will help you engage more effectively with clients and demonstrate your expertise during interviews.
✨Tip Number 2
Brush up on your business analysis skills. Being able to translate business needs into technical specifications is crucial for this role, so practice articulating how you've done this in past experiences.
✨Tip Number 3
Prepare to discuss your experience with data models and ETL processes. Highlight specific projects where you designed scalable solutions, as this will showcase your technical expertise and problem-solving abilities.
✨Tip Number 4
Demonstrate your communication skills by preparing examples of how you've successfully engaged with stakeholders at various levels. This will show that you can effectively convey complex information in a client-facing environment.
We think you need these skills to ace Functional Consultant - Power BI
Some tips for your application 🫡
Understand the Role: Before applying, make sure you fully understand the responsibilities and qualifications required for the Power BI Functional Consultant position. Tailor your application to highlight relevant experience and skills that align with the job description.
Craft a Tailored CV: Your CV should reflect your expertise in Power BI and business intelligence consulting. Emphasise your technical skills, such as DAX and SQL, and any relevant project experiences that demonstrate your ability to deliver end-to-end solutions.
Write a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Discuss how your background in data analytics and client engagement makes you a perfect fit for the position. Be sure to mention specific examples of past successes in similar roles.
Highlight Relevant Certifications: If you have any Microsoft Power BI certifications or other relevant qualifications, make sure to include them prominently in your application. This will help demonstrate your commitment to professional development and expertise in the field.
How to prepare for a job interview at insightsoftware
✨Understand Power BI Inside Out
Make sure you have a solid grasp of Power BI, including its features like Power Query, DAX, and M Query. Be prepared to discuss how you've used these tools in past projects and how they can be applied to meet business needs.
✨Showcase Your Business Acumen
Since the role involves engaging with stakeholders, demonstrate your understanding of business processes and how data-driven insights can enhance decision-making. Prepare examples of how you've translated business requirements into technical solutions.
✨Prepare for Client Engagement Scenarios
Anticipate questions about how you would handle client interactions. Think of scenarios where you've successfully gathered requirements or conducted workshops, and be ready to share these experiences during the interview.
✨Highlight Your Communication Skills
Excellent communication is key for this role. Practice explaining complex technical concepts in simple terms, as you may need to present ideas to non-technical stakeholders. Consider preparing a brief presentation on a past project to showcase your skills.
