BI & Insight Analyst: Data Lake & Dashboards

Zohorecruit; Coventry; Hybrid; GBP 36,000 - 51,000; Part time

Job summary

Civic Recruitment Limited in Coventry is recruiting a BI & Insight Analyst on a 2‑month contract to support data migration to a Data Lake and deliver BI reporting.

You will extract, cleanse and analyse data, develop Power BI dashboards, and collaborate with HR, Digital Services and other stakeholders to provide actionable insights and robust management information.

Experience with Data Warehouse/Data Lake, ETL and governance is desirable; basic DBS may be required.

Qualifications

• Previous experience in a BI Analyst, Data Analyst, Insight Analyst, Reporting Analyst or similar role.
• Strong Power BI dashboard development and reporting experience.
• Experience analysing, validating and cleansing data.
• Experience working with large and complex datasets.
• Strong understanding of data quality management principles.
• Experience producing management information and performance reporting.
• Excellent analytical and problem-solving skills.
• Ability to interpret data and communicate findings to both technical and non-technical stakeholders.
• Experience gathering reporting and business intelligence requirements.
• Strong stakeholder engagement and communication skills.
• Excellent attention to detail and commitment to data accuracy.
• Ability to manage competing priorities and work to deadlines.
• Experience with Microsoft Fabric.
• Experience working within Data Lake environments.
• Experience working with Data Warehouse platforms.
• Knowledge of ETL processes and data integration methodologies.
• Experience supporting data migration projects.
• Experience working with HR data and workforce reporting.
• Local Government or wider Public Sector experience.
• Knowledge of business intelligence best practice and data governance principles.

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.

Skills

Power BI

Data analysis

ETL

Data cleansing

Data migration

Stakeholder engagement

Data governance

SQL

Tools

Microsoft Fabric

Data Lake platforms

Data Warehouse platforms

Job description

Civic Recruitment Limited in Coventry is recruiting a BI & Insight Analyst on a 2‑month contract to support data migration to a Data Lake and deliver BI reporting.

You will extract, cleanse and analyse data, develop Power BI dashboards, and collaborate with HR, Digital Services and other stakeholders to provide actionable insights and robust management information.

Experience with Data Warehouse/Data Lake, ETL and governance is desirable; basic DBS may be required.