Junior Data Analyst

About the roleROLE PURPOSEDevelops BI reports, working across multiple datasets within local government rather than a single service. Works closely with stakeholders to gather requirements and develop high-quality reports and dashboards. Possesses Power BI skills, with an understanding of SQL, although further training will be required to develop deeper SQL proficiency. Experience in report building and report automation is critical to this role. Resident & Community ContributionDevelops reports that support service improvements for residents. Ensures transparency and accessibility of insights across council teams. People ManagementLine manages one direct report, ensuring support and professional development.

Provides guidance on Power BI best practices to junior team members. Manages Stakeholders relationships effectively Operational Service DeliveryWorks with stakeholders to gather reporting requirements and deliver effective Power BI solutions. Develops and maintains Power BI reports and dashboards. Ensures automated reporting processes are in place to reduce manual workload. Supports data integration efforts to enable seamless reporting. Applies SQL knowledge to data modelling and transformation, with further training as needed. Service Planning & DevelopmentWorks with senior team members to enhance Power BI capabilities. Contributes to the improvement of report automation and efficiency.

Assists in the migration of legacy reporting systems to Power BI. Financial & Resource ManagementEnsures reporting solutions are optimized for efficiency. Contributes to cost-effective data storage and processing practices. Service ImprovementImplements best practices for report development and automation. Continuously enhances Power BI dashboards for improved usability and performance. Supports efforts to standardize reporting across multiple datasets in local government. ContactsEngages with stakeholders across different services to understand reporting needs. Works closely with data teams to ensure effective data integration. Collaborates with IT and senior developers to enhance Power BI infrastructure. Additional ResponsibilitiesUndertakes additional tasks aligned with role objectives as required.

Key Performance IndicatorsDelivery of high-quality, automated Power BI reports. Increased efficiency through reduced manual reporting. Effective engagement with stakeholders to ensure reporting meets business needs. Demonstrated improvements in Power BI and SQL capabilities. B. Person SpecificationQUALIFICATIONSESSENTIALExperience in Power BI development. Knowledge of SQL with a willingness to further develop skills. Proven ability to work across multiple datasets in local government. ESSENTIALSTATUTORY or ROLE-SPECIFIC REQUIREMENTSPower BI development skills, including reporting and automation. Basic understanding of SQL, with a focus on continuous learning. Ability to manage stakeholder relationships effectively. EXPERIENCEESSENTIALExperience in developing Power BI reports and dashboards.

Working across multiple datasets within local government. Report automation and optimization experience. ESSENTIALKNOWLEDGE & SKILLSPower BI development and visualization skills. Basic to intermediate SQL skills, with a focus on growth. Ability to translate stakeholder needs into actionable reports. Strong analytical and problem-solving skills. COMPETENCIESResidents and Community FocusEnsures reporting supports improvements in council services. Develops solutions that enhance transparency and accessibility. Accountability and DeliveryProvides high-quality, automated Power BI reports. Manages workload effectively to meet stakeholder expectations. Inspirational LeadershipShares knowledge and promotes best practices. Drives Change and ImprovementIdentifies opportunities to improve reporting efficiency. Implements solutions that streamline data and reporting processes.

About YouAbout usWe value our employees and are committed to ensuring that they enjoy a fulfilling and rewarding career with us. We understand that a happy and motivated workforce is essential for the success of our organisation. That is why we offer a wide range of employee benefits to enhance your work-life balance, financial wellbeing, health, and professional development. Here’s a comprehensive overview of the fantastic benefits we provide: Flexible Working Hours – We recognise the importance of flexibility in managing your work and personal life. 36 Hour Week – Enjoy a standard 36-hour workweek for all full time staff.

Generous Holiday Entitlement – increasing with length of service (for non-casual roles). Hillingdon Sports & Leisure – Stay active and healthy with discounts at council owned leisure centres and swimming pools across the borough. Salary Sacrifice Schemes – option to join schemes for cycle purchase, electric vehicle leasing and additional voluntary pension contributions (subject to scheme rules). Cycle to Work – Eco-friendly commuting with our cycle purchase scheme. We also provide bicycle parking, lockers, and showers at the Civic Centre. Local Government Pension Scheme – access to Local Government Pension Scheme and membership to the Credit Union.

Vivup Benefits – Access a variety of offers and discounts through our Vivup Benefits. Mental Health Support and Counselling Services – Our mental health first aiders are trained to identify, understand, and help employees experiencing mental health issues. Access free 24-hour confidential advice and counselling as well as a legal advice service for you and your immediate family. Travel Support – Make your daily commute easier with our season ticket loans and free car parking. Equity, Diversity and Inclusion StatementAt the London Borough of Hillingdon, we are committed to creating a diverse, inclusive, and equitable workplace.

This commitment means that all employees, job applicants and others who work for us will be treated fairly. The aim is for our workforce to be representative of all sections of society and Hillingdon residents so we welcome applicants from a wide variety of backgrounds. We strive to ensure that our recruitment process is free from discrimination and bias, and we are dedicated to providing reasonable adjustments to applicants with disabilities. Join us in building a workplace where everyone feels respected, able to give their best and be themselves at work, whilst contributing meaningfully to our organisation's success.

Recruitment InformationHillingdon Council operates a guaranteed interview scheme for candidates with disabilities that meet the essential criteria for the role and wish to be considered under this scheme. We believe in the option to choose, so candidates declaring a disability have the choice to opt in for consideration under this scheme, on a ‘per application’ basis. We are committed to safeguarding and promoting the welfare of children, young people and vulnerable groups and expect all staff and volunteers to share this commitment.

Some posts are subject to The Rehabilitation of Offenders Act 1974 (Exceptions) Order 1975 (Amendment) (England and Wales) Order 2019 and it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service. In addition to verifying Right to Work in the UK and a new starter health questionnaire, the post is subject to?the following pre-employment screening: Basic DBS Check3 years of Referencing Please note: ?Priority will be given to those at risk of redundancy within Hillingdon Council.

Current employees who are part of the redeployment pool must meet the essential criteria for shortlisting to be prioritised. It may be necessary due to a high volume of applications to close this role early. We therefore recommend you apply as soon as possible to avoid disappointment.