2 Month Contract With A Local Authority

Job Purpose

To support the delivery of business intelligence, reporting, and data transformation initiatives across the Council, playing a key role in the migration of data from the existing Data Warehouse environment into a new Data Lake platform. The postholder will be responsible for data extraction, cleansing, validation, analysis, and reporting, ensuring the integrity, quality, and accuracy of information throughout the migration process. Working closely with Digital Services, HR Services, and wider stakeholders, the role will develop meaningful business intelligence solutions that support evidence-based decision-making and organisational performance. The BI & Insight Analyst will combine strong technical expertise with excellent stakeholder engagement skills to deliver high-quality reporting, dashboards, and data insights across a range of service areas.

Key Responsibilities

• Support the migration of data from existing data warehouse environments into a new Data Lake platform.
• Extract, validate, cleanse, and analyse data from multiple sources.
• Ensure data quality, consistency, and integrity throughout the migration process.
• Develop, maintain, and enhance Power BI dashboards and reporting solutions.
• Produce performance reports, management information, and analytical insights.
• Create visualisations that enable stakeholders to understand complex datasets and trends.
• Work with stakeholders to gather and document reporting and business intelligence requirements.
• Translate business requirements into meaningful data models, reports, and dashboards.
• Analyse large and complex datasets to identify trends, risks, opportunities, and performance issues.
• Support the development of business intelligence and data-driven decision-making across the organisation.
• Contribute to improving data quality standards, governance, and reporting processes.
• Support ETL and data integration processes where required.
• Assist with testing, validation, and reconciliation activities associated with data migration projects.
• Work collaboratively with HR, Digital Services, and operational teams to ensure reporting requirements are met.
• Provide technical guidance and support relating to reporting and business intelligence solutions.
• Prepare reports, briefings, and analytical summaries for stakeholders and management.
• Support continuous improvement initiatives within data, reporting, and business intelligence functions.
• Maintain accurate documentation relating to reports, datasets, processes, and procedures.