SQL Business Intelligence Developer

SQL Business Intelligence Developer

Salary range:       £41,503 - £49,792

Type of contract: Permanent, full time

Location:             London, Hybrid

Working hours:   37.5

About the role

We have an exciting opportunity for a SQL Business Intelligence Developer to join our team. This position is based in the Information Management and Technology department and answers to the Business Intelligence Development Manager.

The post holder will take a prominent role in developing a varied suite of Business Intelligence solutions as well as maintaining existing solutions, primarily using Microsoft SQL Server based tools. Work will span the full range of data processes, from system integration to developing and populating data warehouses through to developing user reports. They will work on the technical aspects of system integration and be involved in the development and maintenance of ETL (extract, transform, load) processes across all systems. The post holder will work closely with colleagues across the organisation to gather requirements and ensure data integrity is maintained. Whilst technical ability is key to this role, experience and aptitude in Business Analysis is also required to ensure that our technical solutions are fully integrated into business processes.

Responsibilities:

• Advanced T-SQL and SSIS development for the creation and maintenance of ETL and reporting solutions.
• To lead the development and maintenance of custom applications to provide bespoke functionality, for example using .NET Framework, C# or Python.
• Development of SSRS, Power BI and other data visualisations.
• To take an active technical role in a broad range of development projects, covering back office and website databases, from user requirements to implementation
• To work with a variety of technical tools such as APIs (Application Programming Interfaces) to query and maintain external datasources

About you

The role is dynamic and varied, requiring the post holder to act as an authority on data integration considerations and development of Business Intelligence solutions, as well as project managing development requests efficiently with all relevant stakeholders. The post holder must be able to work proficiently in an independent capacity on development projects, as well as working as part of matrix teams comprising a variety of stakeholders.

In addition to development work, performance optimisation, administration, troubleshooting and maintenance, the post holder will be a source of expertise to internal stakeholders for College supported databases.

Requirements:

• Experience of Advanced T-SQL querying and development: Stored Procedures, Views, functions etc.
• Experience of ETL development using SSIS or similar
• Knowledge of database and data warehouse design principles
• Experience of developing and maintaining custom applications to provide bespoke functionality, for example using .NET Framework, C# or Python.
• Experience of working with end users to develop SSRS, Power BI and other data visualisations.
• Experience of taking an active technical role in development projects, combining technical knowledge with practical problem solving and people management skills

Our culture and benefits

As a key member of the team, you will be located in our offices in London Bridge. We offer a friendly, values led working culture with an excellent benefits package that includes: 

• Agile and flexible working
• 25 days annual leave, plus bank holidays and office closure from 25 December to 1 January
• Up to 10% employer pension contribution after probation
• Enhanced occupational Maternity, Adoption, and Shared Parental leave policies
• Interest-free bike, season ticket after probation
• Tailored Learning and Development and study leave
• Affinity staff networks
• Free lunch (onsite only)
• Employee Support Service counselling
• Life Assurance Scheme
• Lifestyle discounts

 Apply Now!

Closing date: 10.00 am on Monday 10 June 2024

SQL Business Intelligence Developer