BI Developer

Location – Central Northampton

Salary 50/55k

Hybrid – circa 3 office days, 2 at home

We are currently seeking a Mid to Senior BI/ SQL Developer to join the IT team.

This is a fantastic opportunity for a talented individual to take ownership of data-driven initiatives, build innovative solutions, and transform raw data into actionable insights that drive business success.

Our client believes in cultivating strong relationships and supporting Finance departments in the country offering a local and nationwide service to Local Authorities clients.

A professional, friendly service is at the core of everything they do, with a simple vision: To be the best at what we do today and in the future, for our staff, clients, and community.

Role Overview:

As a BI/ SQL Developer, you will play a crucial role in designing and implementing database solutions to support critical business and financial operations. You’ll collaborate with key stakeholders, translating data into meaningful insights and reports, and working on both existing and new system developments.

Reporting to the Director of IT, you’ll be an essential part of a dynamic team that thrives on innovation and continuous improvement.

Key Responsibilities:

• Lead system improvement projects and drive the development of new and existing solutions.
• Design and refine database structures and data processes.
• Utilise ETL tools such as SSIS to manage and create data pipelines.
• Develop and modify reports and dashboards using Power BI and SSRS.
• Collaborate with business users of varying technical expertise to deliver solutions that meet their needs.
• Write SQL queries to address data requests and troubleshoot system issues.
• Maintain and document system changes, keeping project documentation up to date.
• Perform routine database maintenance tasks.

About You:

• Strong communication skills, you will have an ability to communicate to users, why you have developed the reports you have the thinking behind this.
• Proficiency in SQL with 3+ years of experience in a development-focused role.
• Strong understanding of data structure and model design.
• Experience with data visualization tools (Power BI, SSRS).
• Hands-on experience with ETL tools, such as SSIS.
• Excellent problem-solving skills.
• Ability to communicate complex technical information to non-technical stakeholders.
• Bonus: Familiarity with Excel, VBA, and a passion for continuous learning.
• Any experience of Python and / or .Net would be desired, not essential