BI Developer

Spott; Newton-le-Willows; On-site; GBP 40,000 - 60,000; Full time

Job summary

Spott is seeking a BI Developer to join its data and technology team, delivering across BI, reporting and data solutions. The role is hands-on, requiring solid SQL and database development foundations while expanding expertise in SSRS, Power BI and BI development.

You will collaborate with internal stakeholders to understand reporting needs, develop data solutions and turn business data into clear insights, building and optimizing data models, dashboards and reports.

Qualifications

• Strong hands-on SQL skills and a good understanding of relational databases.
• Experience writing queries, stored procedures and working with data for reporting or analysis.
• Experience with SSRS and report development.
• Experience or exposure to Power BI, including dashboards and data visualisation.
• A good understanding of data structures and the ability to optimise queries and processes.
• Exposure to SSIS / ETL development.

Responsibilities

• Develop and maintain SQL queries, stored procedures and scripts to support reporting and data requirements.
• Work with relational databases and data structures, ensuring solutions are efficient, reliable and scalable.
• Develop and maintain reports using SSRS and Power BI.
• Build and maintain data models and structures to support business reporting and analysis.
• Troubleshoot and resolve issues relating to data accuracy, performance and reporting.
• Work with ETL processes, including SSIS packages and bespoke ETL solutions.
• Collaborate with stakeholders to understand requirements and translate them into effective technical solutions.
• Support improvements to existing BI and reporting processes, identifying opportunities to improve efficiency and data quality.
• Keep up to date with developments and best practices across BI, reporting and data visualisation.

Skills

SQL

SSRS

Power BI

ETL

Data modelling

Relational databases

Data analysis

Tools

SSIS

Job description

A growing organisation is looking for a BI Developer to join its data and technology team, working across business intelligence, reporting and data solutions.

This is a hands-on opportunity for someone with a strong foundation in SQL and database development, who is looking to build further experience across SSRS, Power BI and BI development.

You'll work closely with internal stakeholders to understand reporting requirements, develop data solutions and help turn business data into clear, useful insights.

The Role:

Develop and maintain SQL queries, stored procedures and scripts to support reporting and data requirements.

Work with relational databases and data structures, ensuring solutions are efficient, reliable and scalable.

Develop and maintain reports using SSRS and Power BI.

Build and maintain data models and structures to support business reporting and analysis.

Troubleshoot and resolve issues relating to data accuracy, performance and reporting.

Work with ETL processes, including SSIS packages and bespoke ETL solutions.

Collaborate with stakeholders to understand requirements and translate them into effective technical solutions.

Support improvements to existing BI and reporting processes, identifying opportunities to improve efficiency and data quality.

Keep up to date with developments and best practices across BI, reporting and data visualisation.

Key Requirements:

Strong hands-on SQL skills and a good understanding of relational databases.

Experience writing queries, stored procedures and working with data for reporting or analysis.

Experience with SSRS and report development.

Experience or exposure to Power BI, including dashboards and data visualisation.

A good understanding of data structures and the ability to optimise queries and processes.

Exposure to SSIS / ETL development.

What the Role Offers:

The opportunity to develop your technical skills across SQL, BI, reporting, databases and data integration.

A collaborative environment where you'll work alongside both technical teams and wider business stakeholders.

The opportunity to take on greater responsibility and ownership as your experience develops.

Ongoing learning and development, with a clear opportunity to progress your career within BI, data and database development.