SQL & Power BI Developer

Sandwell Children's Trust; Oldbury; On-site; GBP 80,000 - 100,000; Full time

Job summary

A local government organization in Oldbury is seeking a skilled SQL and Power BI Developer to improve their performance framework. The role involves developing reporting systems and operational management in Microsoft SQL Server. Ideal candidates will have a degree in IT/statistics and at least 3 years of relevant experience. This position offers extensive annual leave, career progression opportunities, and a generous pension scheme.

Benefits

Generous annual leave up to 31 days

Paid birthday off

Local Government Pension Scheme

Flexible working patterns

Relocation package up to £6,500

Qualifications

• Experience with electronic systems for case recording.
• Extensive knowledge of social care systems.
• Ability to mentor others in SQL expertise.

Responsibilities

• Develop, implement, and maintain Power BI and SQL reporting.
• Operational management of Social Care Systems.
• Deputise for management at meetings when necessary.

Skills

SQL

Power BI

Data management

Change management

Teamwork

Education

Degree in IT/Statistics

3 years experience in SQL or Power BI

Tools

Microsoft SQL Server

LCS

EHM

Job description

Overview

Sandwell Children's Trust is seeking a skilled and proactive SQL and Power BI Developer to enhance and expand our performance framework, ensuring it reflects the requirements of the Families First Partnership programme. You will work as a Power BI, SQL and SAP Developer to support reporting and data management across Social Care Systems and Performance Reporting.

Responsibilities

• Lead responsibility for the development, implementation and maintenance of Power BI and SQL reporting requirements within Sandwell Children's Trust.
• Lead the development, implementation and maintenance of Power BI to ensure reporting requirements for the Families First Partnership programme.
• Operational management (primarily in Microsoft SQL Server), including robust back-up and data recovery arrangements and the integrity of data across all Social Care Systems and Performance Reporting.
• Plan, test and implement technical upgrades to Social Care Systems and Power BI.
• Develop and maintain highly complex automated data using Microsoft SQL Server and other tools, focusing on importing, categorising and presenting data within the Trust's reporting systems.
• Identify, specify, plan and implement a range of highly complex technical systems and performance development projects.
• Deputise for Management at meetings and in team management where necessary.
• Develop and maintain CONTROCC Financial Systems.
• Develop Power BI reporting for Families First.

Qualifications and Experience

• Educated to degree standard in IT/statistics or minimum 3 years experience within SQL or Power BI reporting.
• At least two years experience of:
• working within a role which involves the extensive use of electronic systems for case recording;
• working on systems projects requiring a significant amount of change management;
• developing, supporting, managing and implementing social care systems;
• extensive knowledge of creating objects and form design with LCS, EHM or relevant systems;
• working with LCS, EHM equivalent systems.

• Supporting social care practitioners and managers in making effective use of social care systems.
• Working with performance team, system administrators, trainers and third party suppliers.
• Knowledge and experience of developing and maintaining financial payment systems to internal providers or customers.
• Ability to work with others and co-ordinate activities; good teamwork; willingness to understand and consider others’ views; ability to present positive messages and enthusiasm for change.
• Willingness to coach and mentor performance analysts to improve SQL expertise across the team and organisation.

Organisational Context

At Sandwell Children's Trust we strive for excellence to improve the lives of children. We value collaboration, partnership working and keeping the child at the heart of everything we do. We offer a culture of learning, development and opportunities to grow your career within a supportive team.

Benefits & Rewards

• Generous annual leave up to 31 days, plus 5 additional days for long service recognition.
• Your birthday off paid in addition to annual leave entitlement and 8 Bank Holidays, plus a concessionary day at Christmas.
• Generous Local Government Pension Scheme with employer contributions of 21.6%.
• Service awards at 2, 5, 10 and every 5 years thereafter.
• Flexible working patterns with clear career progression.
• Competitive expenses for mileage (55p per mile) and subsistence; access to a comprehensive employee benefits scheme.
• Relocation package up to £6,500.
• Access to Learning & Development portal with virtual training and events.
• Salary sacrifice schemes for cars, bikes and technology; discounts and wellbeing initiatives; eye care vouchers.