BI & Insight Analyst
Role Overview
Two-month contract with a local authority.
Support business intelligence, reporting, and data transformation, including migration from an existing Data Warehouse to a new Data Lake.
Work with Digital Services, HR Services, and other stakeholders to deliver reporting and insights for evidence-based decisions.
Key Skills for This Role
Full Job Posting
Job purpose
Two-month contract with a local authority.
Support business intelligence, reporting, and data transformation, including migration from an existing Data Warehouse to a new Data Lake.
Work with Digital Services, HR Services, and other stakeholders to deliver reporting and insights for evidence-based decisions.
Key responsibilities
- Support migration from existing Data Warehouse environments into a new Data Lake platform.
- Extract, validate, cleanse, and analyze data from multiple sources; ensure quality, consistency, and integrity.
- Develop and enhance Power BI dashboards, reports, visualizations, and data models.
- Produce performance reports, management information, analytical insights, briefings, and summaries.
- Gather reporting requirements, translate business needs into BI solutions, and analyze complex datasets for trends, risks, and opportunities.
- Contribute to data quality, governance, reporting, ETL, and data integration improvements.
- Support migration testing, validation, and reconciliation; maintain documentation for reports, datasets, processes, and procedures.
- Collaborate with HR, Digital Services, and operational teams and provide technical guidance on reporting and BI solutions.
Essential requirements
- Previous experience in a BI Analyst, Data Analyst, Insight Analyst, Reporting Analyst, or similar role.
- Strong Power BI dashboard development and reporting experience and strong SQL skills.
- Experience analyzing, validating, and cleansing data, including large and complex datasets.
- Strong understanding of data quality management and experience producing management information and performance reports.
- Excellent analytical and problem-solving ability; able to communicate findings to technical and non-technical audiences.
- Experience gathering reporting and BI requirements, with strong stakeholder engagement and communication skills.
- Excellent attention to detail, commitment to data accuracy, and ability to manage competing priorities and deadlines.
Desirable experience
- Microsoft Fabric, Data Lake environments, and Data Warehouse platforms.
- ETL, data integration, and data migration projects.
- HR data and workforce reporting, local government or public sector, and BI best practice or data governance.
Work arrangement
- Coventry; hybrid working.
Hours and payment
- 37 hours per week.
- Payment frequency: bi-weekly.
Other hiring information
- Basic DBS required.
- Two-stage interview process: online assessment and Teams interview.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Civic Recruitment Limited
Systems, Insight & Intelligence Analyst (Street Scene)
Barnet, GBR
A local authority is seeking a Systems, Insight & Intelligence Analyst to provide data analysis, performance reporting and insight for Street Scene and wider Environment services. The work includes developing Power BI da
Regional Development Manager – Fostering
Cardiff, GBR
A local authority is seeking a Regional Development Manager to lead fostering service development and improvement across Cardiff and the Vale of Glamorgan. Candidates need substantial fostering or children's social care
Procurement & Contracts Lawyer
Harlow, GBR
The employer is seeking a qualified lawyer to advise a local authority on procurement, contracts and commercial legal matters. The role requires a current practising certificate, significant relevant legal experience, in
HR Recruitment Coordinator
Nottingham, GBR
A local authority needs an HR Recruitment Coordinator for a three-month contract supporting recruitment administration for its Children & Education Services Target Operating Model. Candidates should have recruitment coor
NEC Project Manager
Hackney, GBR
The employer is seeking an experienced project manager to lead NEC system implementations and enhancements across multiple workstreams. You will oversee delivery from initiation through go-live, including governance, int
Senior Programme Manager
Reigate, GBR
The employer is seeking an experienced Senior Programme Manager to lead a strategic review and develop a business case guiding future service delivery. Candidates should bring complex programme leadership, business case
Technical Support Officer
Harlow, GBR
Harlow Council is seeking an experienced Technical Support Officer to support its Housing Property Services asset management team. The role covers survey coordination, records and reporting, system support, and stakehold
Business Change Accountant
Greenwich, GBR
The employer is seeking an accountant to support financial management and business change across local authority services. The role covers budgeting, financial reporting, controls, forecasting, advice and improvement ini
Systems, Insight & Intelligence Analyst (Street Scene)
Barnet, GBR
Regional Development Manager – Fostering
Cardiff, GBR
Procurement & Contracts Lawyer
Harlow, GBR
HR Recruitment Coordinator
Nottingham, GBR
NEC Project Manager
Hackney, GBR
Senior Programme Manager
Reigate, GBR
Technical Support Officer
Harlow, GBR
Business Change Accountant
Greenwich, GBR