BI & Insight Analyst – AR

Carrington Blake Recruitment; Coventry; Hybrid; GBP 36,000 - 54,000; Full time

Job summary

Coventry City Council is seeking an experienced BI & Insight Analyst / Data Analyst to support a data transformation project within Digital & HR Services. The role involves migrating data from the existing data warehouse to a new Data Lake, with HR data a significant focus, and close collaboration with HR teams and stakeholders across the Council.

You will develop and maintain Power BI dashboards and reports, use SQL to extract and manipulate data, and produce performance information while

Qualifications

• Experience as Data Analyst, BI Analyst, Insight Analyst, Reporting Analyst or similar.
• Strong Power BI dashboard and reporting experience.
• Good SQL skills.
• Experience working with large and complex datasets.
• Strong data validation, cleansing and analytical skills.
• Excellent attention to detail.
• Strong communication and stakeholder engagement skills.
• Ability to turn complex data into clear and meaningful insights.

Responsibilities

• Extract, cleanse, validate and analyse data from multiple sources.
• Support the migration of data into a new Data Lake environment.
• Develop and maintain Power BI dashboards and reports.
• Use SQL to extract and manipulate data.
• Produce performance and management information.
• Analyse large and complex datasets to identify trends and insights.
• Gather reporting requirements from stakeholders and develop appropriate solutions.
• Improve data quality, reporting processes and business intelligence outputs.
• Present complex data and findings clearly to technical and non-technical stakeholders.
• Quality-assure reports and analysis to ensure accuracy.

Skills

Power BI

SQL

Data analysis

Stakeholder communication

Data cleansing

Job description

BI & Insight Analyst / Data Analyst

Location: Coventry – Hybrid (2 days per week in the office)
Rate: £160 per day (£21.34 per hour)
Contract: Initial 2-month contract, with potential extension
Hours: 37.5 hours per week
IR35: Inside IR35
Start: ASAP
DBS: Basic DBS required

The Role

Coventry City Council is looking for an experienced BI & Insight Analyst / Data Analyst to support a key data transformation project within Digital & HR Services.

You will help migrate data from the Council’s existing data warehouse into a new Data Lake environment, ensuring data is accurate, reliable and fit for reporting. A significant part of the work will involve HR data, working closely with HR teams and stakeholders across the Council.

Key Responsibilities

• Extract, cleanse, validate and analyse data from multiple sources.
• Support the migration of data into a new Data Lake environment.
• Develop and maintain Power BI dashboards and reports.
• Use SQL to extract and manipulate data.
• Produce performance and management information.
• Analyse large and complex datasets to identify trends and insights.
• Gather reporting requirements from stakeholders and develop appropriate solutions.
• Improve data quality, reporting processes and business intelligence outputs.
• Present complex data and findings clearly to technical and non-technical stakeholders.
• Quality-assure reports and analysis to ensure accuracy.

Essential Experience

• Previous experience as a Data Analyst, BI Analyst, Insight Analyst, Reporting Analyst or similar.
• Strong Power BI dashboard and reporting experience.
• Good SQL skills.
• Experience working with large and complex datasets.
• Strong data validation, cleansing and analytical skills.
• Excellent attention to detail.
• Strong communication and stakeholder engagement skills.
• Ability to turn complex data into clear and meaningful insights.

Desirable

• Experience with Microsoft Fabric.
• Experience working with Data Lakes or Data Warehouses.
• Experience of data migration or ETL processes.
• Previous experience working with HR data.
• Local Authority or wider Public Sector experience.
• Knowledge of council performance and reporting frameworks.

Additional Information

The role is hybrid, with 2 days per week required in Coventry, and equipment will be provided. The recruitment process will involve a two-stage interview, including an online assessment and Teams interview.