Analyst Developer

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 PostWe 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

• 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

• Up to 33 days annual leave (depending on length of service) plus bank holidays
• Excellent pension with generous employer contributions
• 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