At a Glance
- Tasks: Join our team to deliver innovative Power ON solutions and enhance data visualisation.
- Company: Insightsoftware, a global leader in financial data solutions for the CFO office.
- Benefits: Gain hands-on experience, mentorship, and opportunities for career growth in tech.
- Other info: Supportive environment with excellent training and development opportunities.
- Why this job: Kickstart your tech career while solving real business problems with data.
- Qualifications: Recent graduates in Maths, Computer Science, or related fields are encouraged to apply.
The predicted salary is between 28800 - 43200 £ per year.
PS Consultant - Junior Power ON Functional Consultant
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
Are you a recent graduate with 2 years of work experience as a Power BI developer? Do you have 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.
You will have at least 2 years of experience of working with Power BI (DAX, Power Query, M-Query). You will be passionate about Business Intelligence, 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 who enjoys engaging with non-technical stakeholders. They 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
Preferred Qualifications & Experience:
- Bachelor’s or Master’s degree in Mathematics, Computer Science, Data Analytics, Business Intelligence, or a related field
- Experience working with Power BI (Power Query, Power BI Desktop, Power BI Service, DAX, and M Query)
- Data/Statistical analysis experience (e.g. R or SPSS)
- Programming experience beyond simple 'selects' (e.g. SQL, Python, Java)
- Excellent communication and presentation skills for client-facing interactions
- High attention to detail and good organisational skills
- Strong analytical skills able to understand processes, gather and shape requirements, articulate visualisations as wireframes
- 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)
- Experience of financial reporting, FP&A and Excel modelling
- 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.
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.
PS Consultant - Junior Power ON Functional Consultant employer: insightsoftware
At insightsoftware, we pride ourselves on being an exceptional employer that fosters a collaborative and innovative work culture. As a Junior Power ON Functional Consultant, you will benefit from hands-on experience in software delivery while working alongside experienced professionals who are dedicated to your growth. Our commitment to employee development, coupled with our focus on accessible financial data solutions, makes this an ideal environment for recent graduates eager to make a meaningful impact in the technology sector.
StudySmarter Expert Advice🤫
We think this is how you could land PS Consultant - Junior Power ON Functional Consultant
✨Tip Number 1
Network like a pro! Reach out to your connections on LinkedIn or at university. Let them know you're on the hunt for a role as a Junior Power ON Functional Consultant. You never know who might have a lead or can introduce you to someone at insightsoftware.
✨Tip Number 2
Get familiar with Power BI and Power ON! Even if you don’t have prior experience, dive into online tutorials or courses. Showing that you’re proactive about learning these tools can really impress potential employers.
✨Tip Number 3
Practice your problem-solving skills! Try tackling some real-world data challenges or case studies. This will not only boost your confidence but also give you solid examples to discuss during interviews.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining the insightsoftware team.
We think you need these skills to ace PS Consultant - Junior Power ON Functional Consultant
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences that align with the PS Consultant role. Highlight any relevant projects or coursework in Mathematics, Computer Science, or data analysis to catch our eye!
Craft a Compelling Cover Letter:Use your cover letter to showcase your passion for problem-solving and technology. Share specific examples of how you've tackled challenges in the past, and let us know why you're excited about joining insightsoftware.
Show Off Your Communication Skills:Since this role involves client engagement, it's crucial to demonstrate your communication prowess. Use clear and concise language in your application, and don’t shy away from showcasing your ability to explain complex concepts simply.
Apply Through Our Website:We encourage you to apply directly through our website for the best chance of getting noticed. It’s the easiest way for us to keep track of your application and ensure it reaches the right people!
How to prepare for a job interview at insightsoftware
✨Know Your Tech
Familiarise yourself with Power BI and its functionalities, even if you haven't used it before. Brush up on the basics of data visualisation and analytics, as this will show your enthusiasm for the role and your willingness to learn.
✨Showcase Problem-Solving Skills
Prepare examples from your studies or previous experiences where you've tackled complex problems. Highlight your analytical thinking and how you approached finding solutions, as this is key for a junior functional consultant.
✨Engage with Questions
During the interview, don’t hesitate to ask insightful questions about the company’s projects or the technologies they use. This demonstrates your interest in the role and helps you understand how you can contribute effectively.
✨Communicate Clearly
Practice articulating your thoughts clearly and concisely. Since excellent communication skills are essential for client-facing roles, ensure you can explain technical concepts in a way that’s easy to understand.
