Senior Analyst Developer in Wembley

Salary range: £52,194 – £55,323 p.a. incl. London weighting

Contract: Permanent

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 elevate, 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

• 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 SQL server database, building SSIS packages and managing data pipelines
• Can lead improvements to the Adult Social Care data warehouse and manage it end to end
• 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

We know people achieve their best when they feel 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 parents, 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: 29 March 2026 (23:59)

Applications from those applying within the last 6 months will not be considered.

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. Brent Council values the diversity of its community and aims to have a workforce that reflects this and therefore encourages 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.

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.