Senior Analyst Developer

Salary range: £52,194 – £55,323 (pro rata) p.a. incl. London weighting
Contract: Fixed Term / Secondment with line management approval (6 Months)
Hours of work: 36 hours per week
Location: Civic Centre and other locations from time to time

Transform Complex Data into Insight and Drive Performance Across Adult Social Care.

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 Post

We are seeking an experienced, curious and proactive Senior Data Analyst/Developer who is excited to shape and lead a role that goes far beyond traditional data analysis. This is a unique opportunity to influence how Adult Social Care (ASC) captures, manages and uses data across the service.

You will work closely with a wide range of stakeholders to maintain essential reporting while exploring end‑to‑end data flows, identifying weaknesses and opportunities, and designing both short‑ and long‑term data solutions that make information more reliable, accessible and meaningful.

Your insights will directly support the planning, implementation and performance oversight of Adult Social Care services and integrated health and care initiatives. High‑quality, well‑developed data and reporting will play a key role in enabling better strategic decisions, service improvement and improved outcomes for residents.

Around half of your time will focus on core analytical and reporting work: producing high‑quality analysis, building engaging Power BI dashboards, developing paginated reports, and ensuring the accuracy and timeliness of statutory and corporate reporting.

The remaining time will be spent collaborating with colleagues across the Council and partner organisations to fix data issues at the root, redesign data flows and drive improvements in data quality, automation and system reliability.

A major part of the role involves leading the development and maintenance of the Adult Social Care data warehouse. You will write complex SQL queries, build and manage SSIS packages, identify and resolve data quality issues, and suggest improvements to ensure the system is efficient, robust and future‑proof. You will also use Power Automate to streamline data pipelines and automate routine processes.

The role requires a proactive mindset — someone who investigates issues rather than waits for them to escalate, who traces problems back to source systems such as Mosaic, and who is constantly looking for better, smarter, more efficient ways to deliver insight.

The Person

We’re looking for someone who:

• Brings an inquisitive mind and isn’t afraid to ask “why?”, “how?” or “what if?”
• Is proactive in identifying problems and suggesting innovative data‑driven solutions
• Has strong SQL coding skills, with experience in SSMS, building SSIS packages and managing data pipelines
• Can lead improvements to the Adult Social Care data warehouse and manage it end‑to‑end with full SQL access
• Has experience with Power BI, including modelling, DAX and designing impactful dashboards
• Can develop paginated reports where necessary
• Is comfortable using tools like Power Automate to streamline processes
• Understands Adult Social Care systems such as Mosaic, or other social care/NHS platforms
• Has strong experience with Excel, Power BI, SQL and Visual Studio
• Has practical experience designing, delivering and overseeing quantitative research
• Builds strong working relationships and networks to understand multiple perspectives
• Enjoys learning new things and developing robust, practical solutions
• Can manage their own workload effectively and work independently
• Thinks creatively, beyond standard approaches, to improve how data is captured, transformed and used

Why join us?

We know people achieve their best when they feed valued. At Brent, you’ll benefit from:

• Up to 33 days annual leave (depending on length of service) plus bank holidays
• Excellent pension with generous employer contributions (LGPS)
• Hybrid and flexible working options available for most roles
• Supportive family-friendly policies for parent, guardians, and carers
• Health and wellbeing support, including access to eye test support and a 24/7 Employee Assistance Programme
• Financial support such as education sessions, childcare deposit loans, and season ticket loans
• Travel perks including affordable parking nearby, a Cycle to Work scheme, and great onsite facilities
• Learning and development opportunities to help you grow your career
• Access to My Brent Rewards with exclusive discounts on shopping, travel, leisure, and entertainment

Closing Date: 4 March (23:59)

Additional Information

If 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.

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 here.

Brent has a positive approach to flexible working.

As a disability confident employer Brent welcomes applications from people with all disabilities, including hidden 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.