Business Intelligence Developer

Job Description

We have a rare and exciting opportunity for an ambitious Business Intelligence Developer to join the ScS Reporting Team.

The successful candidate will be responsible for database management as well as creating complex queries to extract data for Power BI visualisation.

Please note - this position is based at our Customer Support Centre in Sunderland and you will be required to work from the office at least 2 days per week.

What does the role involve?

• Design, develop, and maintain SQL databases and data integration solutions to meet business requirements.
• Analyse and optimize SQL queries and stored procedures to improve performance and efficiency.
• Ensure data integrity and accuracy through regular maintenance, backup, and recovery processes.
• Work closely with business analysts, developers, and stakeholders to gather requirements and deliver data solutions that support business objectives.
• Develop and maintain reports using SQL Server Reporting Services (SSRS) and visualise data through Microsoft Power BI to provide insight on trends and opportunities.
• Create and maintain comprehensive documentation for database structures, processes, and procedures.
• Implement and maintain database security protocols to protect sensitive information and ensure compliance with data protection regulations.
• Play an active role in fault resolution (e.g. data pipeline failures) occurring in the operation of software, especially those requiring greater expertise.
• Responsible for end to end data lifecycle.
• Lead by example and role model the ScS RIGHT Values and Behaviours

Who are we looking for?

• Experience within a similar role
• Strong analytical and problem-solving skills.
• Excellent communication skills and interpersonal abilities.
• Ability to work in a fast-paced environment and multi-task as required
• Detail-oriented with a commitment to producing high-quality work.
• Good time management skills with the ability to work responsibly with or without direct supervision whilst managing a varied workload
• Customer focused in a constantly changing environment
• Bachelor's degree in Computer Science, Information Technology, or a related field or minimum of 3 years of experience as an SQL Developer or in a similar role.
• Proficiency in SQL and experience with Microsoft SQL Server with a strong knowledge of T-SQL, including writing complex queries, stored procedures, and functions
• Experience with SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services).
• Familiarity with database design principles and normalization.
• Understanding of indexing, query optimization, and performance tuning techniques.
• Ability to deliver data insights via Power BI or similar visualisation tools

What's in it for you?

• Competitive salary
• 33 days holidays including bank holidays
• Employee benefits platform – access to 100s of high street discounts and more – holiday discounts, gym discounts, cinema discounts, e-vouchers, cashback and more
• Colleague Discount
• Career progression
• Long service awards
• Enhanced Maternity, Paternity and Adoption Leave
• Access to our dedicated Employee Assistance Programme – to give you free access to advice and information on a range of topics
• Medicash – low cost health plans
• Virtual GP – Access to a GP service 24/7
• Salary finance scheme
• Pension Scheme
• Death in Service
• Life assurance
• Cycle to Work scheme
• Refer a friend scheme