SQL & Power BI Developer
Role details
Job location
Tech stack
Job description
At Sandwell Children's Trust we strive for excellence to improve the lives of children. Our 'Sandwell Deal', brings together our new improved offering that make Sandwell Children's Trust a great place to work; it also sets out our expectations of you as a member of staff., Sandwell Children's Trust is seeking a skilled and proactive SQL and Power BI Developer to enhance and expand our performance framework, ensuring it effectively reflects the requirements of the Families First Partnership programme.
As a Power Bi SQL and SAP Developer you will:
- Lead responsibility for the development, implementation and maintenance of Power Bi and SQL development of 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 integrity of data across all Social Care Systems and Performance Reporting.
- Planning, testing and implementing technical upgrades to Social Care Systems and Power Bi.
- Develop and maintain highly complex automated data using Microsoft SQL Server and a range of other professional development and data management tools, with a particular focus 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 team management where necessary. Develop and maintain CONTROCC Financial Systems reports.
- Develop Power BI reporting for Families First.
Requirements
-
Educated to degree standard in IT/statistics or minimum 2 years experience within SQL or Power BI reporting. At least two years experience of:-
-
working within in 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;
-
working with LCS, EHM or 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.
-
Ability to work with others and co-ordinate activities.
-
Ability to work as part of a team.
-
Accepting responsibility readily.
-
Willingness to understand and take others views on board.
-
Ability to sell new ideas and instil confidence and enthusiasm in end users.
-
Excellent communicator with 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.
Benefits & conditions
What we can offer you:-
- Generous annual leave of 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.
- You will receive a generous local government career average pension scheme with employer contributions of 21.6%.
- We recognise individual loyalty with service awards from 2, 5, 10 and every 5 years onwards.
- Flexible working patterns that suit you and all of our roles have well-defined career progression.
- We provide competitive expenses for both mileage (55p per mile) and subsistence, plus access to a comprehensive employee benefits scheme.
With the work that we have done so far and with the ambitions we have for the future, it's a really exciting time to join Sandwell Children's Trust and to become part of our 'Sandwell Family'., * Flexible working patterns that suit you and all of our roles have well-defined career progression.
- Access to our Learning & Development portal offering virtual training programmes, learning & development info bursts, learning events and much more.
- The latest technology enabling more effective and streamlined working.
- Detailed and effective appraisals to strengthen your practice.
- Access to a range of family friendly policies.
Benefits & Rewards
- Up to £6,500 re-location package
- Generous annual leave entitlement, plus 5 additional days for long service recognition.
- The opportunity to purchase up to 10 days additional holiday through our salary sacrifice scheme.
- Your birthday off paid in addition to annual leave entitlement and 8 bank holidays, plus a concessionary day at Christmas.
- Membership of the Local Government Pension Scheme, this is a nationwide career average scheme with employer contributions of 21.6%.
- We recognise individual loyalty with service awards from 2, 5, 10 and every 5 years onwards.
- Reimbursement of Social Work England registration
- 24/7 access to free and confidential employee counselling service
- Access to a range of discounts on products and services
- Salary sacrifice schemes for cars, bikes and technology.
- Refer a friend scheme
- Wellbeing initiatives and forums
- Discounted gym membership
- Eye care vouchers