RQ1788240 – BI & Insight Analyst

Job Details

Work Pattern: 37.5 hours per week, Hybrid – 2 days per week in Coventry office

PAYE Pay Rate: £17.47 per hour

Main Purpose of the Role

To support Coventry City Council’s data transformation project, helping migrate data from the existing data warehouse into a new Data Lake environment. The role will focus heavily on data quality, validation, analysis and reporting, with a significant focus on HR data.

The postholder will use Power BI and SQL to develop accurate reports and dashboards and provide meaningful insights to support decision-making across the Council.

Typical Day Overview

  • Extract, cleanse and validate data from different sources.
  • Support the migration of data into the new Data Lake.
  • Analyse large and complex datasets to identify trends and issues.
  • Develop and maintain Power BI dashboards and reports.
  • Use SQL to query and manipulate data.
  • Check data quality, accuracy and integrity.
  • Produce performance and management information.
  • Work with HR teams and other stakeholders to understand reporting requirements.
  • Translate complex data into clear and useful insights.
  • Investigate and resolve data/reporting issues.
  • Support improvements to data quality and BI processes.

Key Skills & Responsibilities

  • Strong Power BI dashboard and report development.
  • Good SQL skills and experience querying large datasets.
  • Data extraction, cleansing, validation and analysis.
  • Experience working with large and complex datasets.
  • Data migration and transformation experience.
  • Knowledge of Data Warehouses, Data Lakes or ETL processes.
  • Ability to identify and resolve data-quality issues.
  • Strong analytical and problem-solving skills.
  • Excellent attention to detail.
  • Ability to gather and understand business/reporting requirements.
  • Confident communication with both technical and non-technical stakeholders.
  • Ability to turn complex data into clear business insights.
  • Experience producing management and performance information.

Essential Requirements / Qualifications

  • Previous experience as a Data Analyst, BI Analyst, Insight Analyst, Reporting Analyst or similar.
  • Strong practical experience with Power BI.
  • Strong SQL skills.
  • Experience with data quality, validation and analysis.
  • Experience working with large or complex datasets.
  • Strong analytical and problem-solving ability.
  • Excellent attention to detail.
  • Strong stakeholder engagement and communication skills.