The Team

JSM Group is a leading utility services provider delivering integrated power and communications solutions across the UK. As part of a systems transition and reporting optimisation project, we're seeking an experienced Power Suite Reporting Specialist for an initial 3-month fixed-term contract, with potential to extend.

You’ll be joining at a pivotal time to help the Commercial and Finance teams streamline our reporting processes and modernise our use of Microsoft Power tools. This is a hands-on role, ideal for a contractor or experienced interim looking to make an immediate impact.

Scope of The Role

This interim role is focused on replacing legacy Jet reports with automated Power Suite-driven reporting across Finance and Commercial functions. You'll act as the bridge between operational teams and data sources, using Power Automate, Power Query, and elements of Power BI to create fast, accurate, and reconcilable reports.

How You'll Succeed

Collaborate closely with the Commercial and Finance teams to understand business reporting needs

Use Power Automate to connect ERP data (Microsoft Dynamics Business Central) to Excel

Build and streamline complex data sets using Power Query

Support report delivery by understanding refresh cycles (daily/weekly/monthly)

Advice on transitioning from Jet reports to modern solutions

Deliver a working suite of reports with minimal supervision

Be available to work 4 days per week in the North London office to ensure collaboration and knowledge-sharing

Be flexible and focused, with the ability to quickly embed and deliver value

What it takes

Proven experience delivering reporting solutions using Power Automate and Power Query

Comfortable integrating data from ERP systems (preferably Dynamics Business Central)

Familiarity with Jet Reports (legacy knowledge helpful but not essential)

Strong communication and collaboration skills — especially with non-technical teams

Able to explain reporting logic and help stakeholders understand reconciliation issues

Available to start within 1–2 weeks

Able to work onsite 4 days/week in North London (free parking available)

Contract & Pay

3-Month Fixed-Term Contract (potential to extend to 6 months)

£30,000 for 3 months (pro-rata equivalent of £80–100K salary depending on experience)

Contractor/day rate option also available: £450–£500/day (outside IR35). 

No work/pay during company shutdown over Christmas (2 weeks)

What we offer

We truly value your work, time, and skills! In return, we will offer you a competitive salary and some additional benefits to support your professional growth, including:

• Participation in mentoring and coaching programmes
• 28 days of holiday (excluding bank holidays)
• 2 paid volunteering days a year
• Hybrid working pattern
• Continuous training and development, in both technical and business skills

Equal Opportunity Statement
JSM Group Services Ltd. is an equal opportunities employer and does not discriminate on the grounds of gender, sexual orientation, marital or civil partner status, pregnancy or maternity, gender reassignment, race, colour, nationality, ethnic or national origin, religion or belief, disability or age. Our ethos is to respect and value people’s differences, and to help everyone achieve more at work as well as in their personal lives so that they feel proud of the part they play in our success. We believe that all decisions about people at work should be based on the individual’s abilities, skills, performance and behaviour and our business requirements. JSM Group operates a zero-tolerance policy to any form of discrimination, abuse or harassment.