PS Consultant - Junior Power ON Functional Consultant

insightsoftware; City Of London; On-site; GBP 30,000 - 40,000; Full time

Job summary

A global technology provider in London is seeking a Junior Functional Consultant to engage with clients and help deliver Power BI solutions. Ideal candidates will have a background in Mathematics or Computer Science, along with strong analytical and communication skills. This role provides a great opportunity for recent graduates looking to start their career in technology and software delivery.

Qualifications

• Bachelor’s or Master’s degree in Mathematics, Computer Science or related field.
• Excellent communication and presentation skills for client interactions.
• Data/Statistical analysis experience (e.g. R or SPSS).
• Programming experience (e.g. SQL, Python, Java).
• Willingness to travel to client sites as needed.

Responsibilities

• Engage with clients to understand data visualisation needs.
• Design scalable Power ON solutions including dashboards.
• Support user acceptance testing and gather feedback.
• Conduct training sessions for end-users.

Skills

Communication skills

Analytical thinking

Problem-solving

Education

Bachelor’s or Master’s degree in Mathematics or Computer Science

Tools

SQL

Python

Microsoft Power BI

Excel

Job description

Company Description

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

Overview

Are you a recent graduate with a passion for problem solving and technology? We are looking for bright, ambitious individuals with a background in Mathematics, Computer Science or a related discipline to join our team as a junior functional consultant.

This is a fantastic opportunity to start your career in technology and software delivery. The role centres around the delivery of Power ON which extends Power BI's functionality by providing write back capability.

Prior experience with Power BI is an advantage but not a pre-requisite. You should be eager to learn, comfortable working with data, and motivated to develop practical solutions that address real business problems.

You will work closely with experienced colleagues and client stakeholders to help deliver business use cases gaining hands on-experience in software delivery and data visualisation. You will develop technical, analytical and problem-solving skills in a supportive environment.

The ideal candidate will have excellent communication skills, will be analytical and a logical thinker. They will have a keen interest in pursuing a career as a software delivery consultant.

Key Responsibilities

• Client Engagement & Business Analysis
  
  
  
  • Work with experienced colleagues and client stakeholders to understand reporting, analytic and data visualisation needs
  
  
  • Assist in the delivery of discovery workshops to gather requirements, define use cases, and assess data sources
  
  
  • Provide support to project leaders with stakeholder management
  
  
  
  


• 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
  
  
  
  • Adhere to project budgets and timelines
  
  
  • 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

• Bachelor’s or Master’s degree in Mathematics, Computer Science, Data Analytics, Business Intelligence, or a related field


• Excellent communication and presentation skills for client-facing interactions


• Data/Statistical analysis experience (e.g. R or SPSS)


• Programming experience (e.g. SQL, Python, Java)


• Experience with the Microsoft Office (Excel, Word, Powerpoint, Outlook)


• Willingness to travel to client sites as needed

Nice to have

• Microsoft Power BI certification (e.g., PL-300: Power BI Data Analyst)


• Knowledge of Power Query, Power BI Desktop, Power BI Service, DAX, and M Query


• Knowledge of data model design principles and ETL


• Understanding of Azure services (e.g., Azure Synapse, Azure Data Factory, Azure SQL)


• Knowledge of Power Automate and Power Apps integration with Power BI


• Knowledge of non-Microsoft data sources (Snowflake, Oracle, PostgreSQL, MySQL, Synapse, Big Query)


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

Additional Information

All your information will be kept confidential according to EEO guidelines.

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.