Functional Consultant - Power BI

insightsoftware; London; On-site; GBP 45,000 - 70,000; Full time

Job summary

A leading company in financial solutions is seeking a Power BI Functional Consultant in London to engage with clients and drive insights through powerful reporting solutions. This role involves working closely with stakeholders to define use cases and implement best practices in Power ON, enhancing business decision-making with effective data solutions. Candidates should have a strong technical background in Power BI, excellent communication skills, and a focus on client outcomes.

Benefits

Remote working flexibility

Training and development opportunities

Qualifications

• Strong expertise in Power BI and SQL, essential for business intelligence consulting.
• Experience in client engagement and delivering Power BI solutions.
• Knowledge of data visualization needs and business analytics.

Responsibilities

• Engage with business stakeholders to understand reporting needs and create use cases.
• Design and implement scalable Power ON solutions for business insights.
• Conduct training sessions for clients on Power ON functionality.

Skills

Power BI

SQL

DAX

Data Analysis

Client Engagement

Business Analysis

Education

Bachelor’s or Master’s degree in Mathematics, Computer Science, Data Analytics, Business Intelligence

Tools

Power ON

Azure

Job description

Get AI-powered advice on this job and more exclusive features.

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. Learn more at insightsoftware.com

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. Learn more at insightsoftware.com

Job Description

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
  
  

Qualifications

Preferred Qualifications & Experience:

• 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)

Technical Skills

• 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)

Business & Consulting Skills

• 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
  
  

Additional Information

** 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. **

insightsoftware About Us: Hear From Our Team - InsightSoftware (wistia.com)

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.

Seniority level

• Seniority level

  Associate

Employment type

• Employment type

  Full-time

Job function

• Job function

  Customer Service

• Industries

  Software Development

Referrals increase your chances of interviewing at insightsoftware by 2x

Sign in to set job alerts for “Functional Consultant” roles.

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 1 week ago

City Of London, England, United Kingdom 3 weeks ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 1 month ago

London, England, United Kingdom 1 week ago

Payments and Collections Business Analyst

London, England, United Kingdom 15 hours ago

Greater London, England, United Kingdom 1 month ago

London, England, United Kingdom 1 day ago

Functional Consultant - Microsoft Dynamics

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 6 days ago

London, England, United Kingdom 2 months ago

London, England, United Kingdom 1 day ago

London, England, United Kingdom 1 year ago

Senior Functional Consultant – Ironclad certified

Consultant - Business Transformation - Compliance Tech Sector

London, England, United Kingdom 3 weeks ago

London, England, United Kingdom 19 hours ago

SAP S/4 HANA MM and WM Functional Analyst

Functional Consultant - Subscriptions/ Contracts

Watford, England, United Kingdom 1 day ago

Payments Business Analyst - Banking - New Payments Engine

London, England, United Kingdom 1 month ago

London, England, United Kingdom 1 day ago

London, England, United Kingdom 2 weeks ago

Functional Consultant - D365 Field Service

London, England, United Kingdom 1 month ago

Greenwich, England, United Kingdom 2 weeks ago

D365 SCM Functional Consultant Outside IR35

London, England, United Kingdom 1 year ago

ERP Functional Consultant Professional Services

London, England, United Kingdom 1 week ago

Senior Consultant, Salesforce Functional Lead / Senior Business Analyst - GPS, Deloitte Digital

London, England, United Kingdom 2 weeks ago

Consultant - Business Transformation - Compliance Tech Sector

London, England, United Kingdom 3 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.