Job Description

:This position is only open to current employees of Brent Council or Temporary Agency Workers currently working in Brent Council.Salary range: xc2xa350,574 - xc2xa353,607 p.a. inc. London weighting
Contract: Permanent
Hours of work: 36 hours per week
Location: Civic centre and other locations from time to timeCan you deliver high-quality data analysis for our Adult Social Care team?Brent is a tremendously vibrant London borough where the iconic arch of Wembley Stadium dominates the skyline. Spanning both inner and outer London, it is a borough of huge contrasts in terms of its economic, environmental, ethnic and social make up. Brent's diversity is evident to all who visit our borough and our long history of ethnic and cultural diversity has created a place that is truly unique and valued by those who live and work here.The council is pursuing a far-reaching transformation agenda that better meets the needs of our community so it is an exciting time to join us.The PostWe are looking for a skilled and proactive Senior Analyst and Developer to join our Adult Social Care (ASC) team. In this pivotal role, you will lead on delivering high-quality data analysis, performance reporting, and statutory returns that directly inform decision-making, service improvement, and strategic planning across the department.You will use your expertise in SQL, Power BI, and Power Apps to design innovative data solutions, improve reporting processes, and provide insightful analysis that supports better outcomes for our residents. You'll also play a key role in ensuring data quality and compliance, working closely with internal teams to resolve issues and build a culture of data-informed service delivery.You will:

• Lead the completion and submission of statutory returns, ensuring accuracy and timeliness
• Design, build and maintain engaging performance dashboards using Power BI and Business Objects
• Use advanced SQL to manage, query and analyse data from complex systems
• Develop low-code tools and digital solutions using Power Apps to streamline processes and reporting
• Monitor data quality, investigate anomalies, and work with services to resolve issues effectively
• Support performance improvement projects, deep-dive reviews, and benchmarking exercises
• Promote self-service access to data by supporting managers in understanding and using performance information
• Collaborate with colleagues and partners to ensure that business intelligence supports both operational and strategic objectives

The PersonWe are looking for someone with:

• Expert-level SQL skills and a strong understanding of relational databases
• Proven experience in Power BI and Power Apps, with the ability to build user-friendly tools and dashboards
• Experience in submitting and managing statutory performance returns, ideally within Adult Social Care or a related service
• Excellent analytical and problem-solving skills, with a keen eye for detail
• The ability to explain complex data to non-technical audiences clearly and effectively
• A collaborative and proactive approach to improving services through data

In addition to your salary, you will also get to enjoy the following benefits:

• 27 days annual leave plus 8 bank holidays, increasing to 31 days plus 8 bank holidays after 5 years continuous service
• Very generous employer pension contribution
• Flexible working hours and the opportunity to work from home 2 days per week (laptop provided)
• A wide range of family friendly policies such as parental leave
• Access to affordable parking nearby
• Access to our Zipcar scheme
• Access to our Employee Assistance programme for free confidential counselling
• Season ticket loan for public transport
• Cycle to work scheme and good onsite facilities
• Access to My Brent Rewards for big brand discounts, local offers and money off for travel, cinema and shopping vouchers.

Closing date: 26 May 2025 (23:59)Additional InformationIf you are interested in applying for this job, please start by clicking the "Apply Now" button below. You must provide a supporting statement as part of your application that clearly shows how you meet the criteria on the Person Specification. We will accept a CV in support of your application, however, you should still provide a supporting statement.This position is only open to current employees of Brent Council or Temporary Agency Workers currently working in Brent Council. External candidates are not permitted to apply for internal only roles. Forwarding 'internal only' roles to external candidates may lead to disciplinary action being taken.Brent Council values the diversity of its community and aims to have a workforce that reflects this and therefore encourage applications from all sections of the community. We positively encourage all applicants to self-identify their characteristics in the diversity survey section in the application.We are committed to safer recruitment and safeguarding and promoting the welfare of children and young people and expect all staff and volunteers to share this commitment. Applicants should be aware that posts working with children, young people and vulnerable adults are subject to an Enhanced DBS check as well as other employment clearances.The information we collect from you will be shared with Cifas who will use it to prevent fraud, other unlawful or dishonest conduct, malpractice, and other seriously improper conduct. Further details of how your information will be used by us and Cifas and your data protection rights, can be found .Brent has a positive approach to flexible working.As a disability confident employer Brent welcomes applications from people with all disabilities, including xe2x80x9cnon-visiblexe2x80x9d disabilities and mental health conditions. We will interview any disabled applicant who meets the essential criteria. If you require reasonable adjustments to be made to any part of the recruitment process due to your disability, please contact us on