Reporting Services Developer

As a Reporting Services Developer within our iSAMS business, you'll build and deliver high-quality reporting solutions that help schools turn their data into clear, useful information.

This is a hands-on technical role where SSRS and SQL are at the heart of what you'll do. You'll create and maintain reports using Microsoft SQL Server Reporting Services (SSRS), T-SQL, Power BI and our in-house Report Designer, while working directly with customers to understand their reporting needs and provide practical solutions.

You'll work across custom reports, catalogue/templates and built-in reporting, taking requirements through from initial request to successful delivery.

Responsibilities

• Design, build and maintain professional reports using Microsoft SSRS, T-SQL, Power BI and our in-house reporting tools.
• Work directly with customers to understand reporting requirements and translate them into practical technical solutions.
• Develop custom reports alongside catalogue/template and built-in reporting solutions.
• Write and work confidently with SQL/T-SQL to retrieve, manipulate and present data.
• Take ownership of reporting requests, managing your workload and delivering agreed work to deadlines.
• Investigate and resolve technical reporting issues using remote access tools, diagnostic information and internal knowledge resources.
• Keep our Service Desk system accurate and up to date, including clear technical notes and progress updates.
• Work closely with other Report Developers and iSAMS teams to resolve more complex customer requirements.
• Proactively suggest better or more efficient ways of meeting customer reporting needs.
• Identify recurring reporting issues or requests and help the team improve the wider service.
• Support customers and colleagues with technical and non-technical reporting queries.
• Maintain useful technical documentation, internal guidance and knowledge resources.
• Contribute to team projects focused on improving report quality, processes and service efficiency.
• Keep your knowledge of iSAMS and its reporting capabilities up to date as the platform develops.
• Regularly review internal processes and suggest improvements where appropriate.
• Attend occasional in-person team meetings or events.

There is also the opportunity to take additional responsibility as the team's SSRS Trainer, if this is an area you are interested in developing.

This could include:

• Delivering structured online SSRS training to customers.
• Running customer consultancy sessions around SSRS and reporting.
• Helping customers understand how to build and manage their own reports.
• Keeping training materials aligned with current SSRS functionality and best practice.
• Adapting technical explanations and training styles for different audiences and levels of experience.

Requirements

• Hands-on experience creating reports using Microsoft SQL Server Reporting Services (SSRS).
• Strong SQL / T-SQL skills and confidence working with relational data.
• Experience gathering requirements and turning them into effective reporting solutions.
• A good understanding of Microsoft Power BI.
• Experience working directly with customers, clients or internal stakeholders.
• Experience investigating, diagnosing and resolving technical problems.
• Strong analytical and problem-solving skills.
• Excellent attention to detail, particularly when working with data.
• The ability to explain technical information clearly to people who may not have a technical background.
• Strong written and verbal communication skills.
• Good organisation skills and the confidence to manage your own workload and deadlines.
• A proactive approach - you look for solutions rather than waiting to be told what to do.
• The ability to work independently while still collaborating closely with a wider team.
• Flexibility when priorities or customer requirements change.
• An interest in continuing to learn new reporting technologies, tools and techniques.
• If you're interested in the training element of the role, the ability to adapt your communication and training style for different audiences and learning needs would be particularly valuable.