Back to jobs
Hays

Hays

Data Analyst

City of Edinburgh Remote OK 2-5 yrs exp Staffing and Recruiting 31,551 employees£250 – £300
Power BIData CleansingData ModellingPower QueryDAX

Requirements

Candidates need strong commercial experience in Power BI, DAX, and Power Query, with a proven ability to handle complex data transformation. Experience in risk-scoring analytics and stakeholder management is essential.

Job Description

Your New Company


A leading public sector organisation is seeking an experienced Power BI Data Analyst to support a key data and compliance initiative. Driven by the introduction of new legislation, this project will help the organisation proactively identify, manage and mitigate risks across its existing estate.


This is an opportunity to deliver meaningful outcomes that support regulatory compliance, improve services and enable data-driven decision-making within a large and complex environment.



Your New Role


As a Power BI Data Analyst, you will join an initial 3-month contract to review, cleanse and consolidate data currently held across multiple Excel spreadsheets.


Key responsibilities will include:

  • Assessing and improving the quality, consistency and accuracy of existing datasets.
  • Consolidating multiple Excel-based data sources into a structured analytical model.
  • Designing and developing Power BI dashboards and reporting solutions for operational and senior stakeholders.
  • Creating a comprehensive reporting and case management solution.
  • Producing reporting covering inspections, risk assessments, customer communications, remedial works and more
  • Analysing historical data to identify trends and patterns.
  • Developing predictive analytics and risk-based models
  • Delivering actionable insights that support proactive intervention and compliance activities.



What You'll Need to Succeed


To be successful in this role, you will have:

  • Strong commercial experience developing solutions in Power BI.
  • Advanced data cleansing, transformation and data modelling expertise.
  • Excellent knowledge of Power Query, DAX and advanced Excel.
  • Experience consolidating fragmented datasets into a trusted analytical model.
  • Experience developing predictive, trend-based or risk-scoring analytics.
  • Strong stakeholder engagement and requirements gathering skills.
  • The ability to work independently and deliver outcomes in a fast-paced project environment.


Desirable experience includes:

  • SQL and database analysis experience.
  • Geospatial analysis, heat mapping or hotspot visualisation expertise.
  • Knowledge of data governance and data quality best practice.
  • Experience supporting regulatory or compliance-driven programmes




What you need to do now


If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.
If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion about your career.

Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at hays.co.uk

Skills

Power BIData CleansingData ModellingPower QueryDAXAdvanced ExcelPredictive AnalyticsStakeholder EngagementSQLDatabase AnalysisGeospatial AnalysisHeat MappingData GovernanceData Quality

About Hays

At Hays, we believe that the right job can transform a person's life - and the right person can transform a business. From career‑defining opportunities to complex workforce strategies, we connect ambition with opportunity - helping people and organisations reimagine what’s possible. Every year we place over 200,000 professionals into new roles. Whether it’s a permanent role or a temporary contract, our specialist consultants provide tailored advice and market intelligence to accelerate careers, from emerging talent to executive leadership. For organisations, our expert teams build recruitment and workforce solutions shaped by real-time market insights, local expertise and the scale of a world leading specialist in white collar hiring. With operations in 30 countries, over 200 offices and 9,500 colleagues worldwide, we fill around 1,000 roles every working day. The future of work isn’t something we’re waiting for.  We’re creating it every day.