Senior HR Analyst

Data Freelance Hub; Glasgow; Hybrid; GBP 80,000 - GBP 100,000; Full time

Job summary

A leading consultancy firm in Scotland is seeking a Senior HR Analyst to oversee HR data quality and enhance processes using SQL and Power BI. Responsibilities include leading data projects, ensuring compliance with data governance, and optimizing workflows through AI-driven automation. The ideal candidate will have a background in HR systems, experience in data migration, and strong analytical skills. This full-time role offers a hybrid working model and a range of employee benefits.

Benefits

Competitive pension scheme

Enhanced maternity/paternity pay

Life assurance

HolidayPlus scheme

Cycle2work Scheme

Qualifications

• Strong experience with HR systems and data reconciliation.
• Power BI expert with data modelling and DAX skills.
• Solid understanding of HR data and compliance protocols.

Responsibilities

• Lead projects for HR data quality uplift using SQL and Oracle.
• Own data mapping and transformation logic for migrations.
• Build executive-ready Power BI dashboards and models.

Skills

Advanced SQL

HR systems experience (Oracle Fusion Cloud HCM)

Power BI expertise

Attention to detail

Analytical skills

Excellent communication skills

Education

Degree in Data, Analytics, HR, IT or related field

Professional qualifications (CIPD, Data Analytics, Microsoft)

Tools

Power BI

SQL

Oracle

Job description

Senior HR Analyst (12 month FTC) – Glasgow

Personal Contract (dependent on skills and qualifications), Full Time, Hybrid working.

Competitive pension scheme – Enhanced maternity/paternity pay – Life assurance – HolidayPlus – Cycle2work Scheme & more.

Responsibilities

• Lead projects to support end‑to‑end HR data quality uplift: profiling, validation, deduplication, and cleansing using SQL, Oracle, and other tools.
• Own data mapping, transformation logic and reconciliation ahead of Oracle Fusion migration.
• Conduct mock loads, cut‑over rehearsals, error reporting and remediation cycles.
• Establish and enforce data validation and business rules to ensure accuracy and auditability.
• Design, develop and enhance Microsoft Power Apps to eliminate manual processes, orchestrate data refreshes and streamline HR workflows.
• Collaborate on integration flows across Core HR, Payroll, Talent, Learning and Finance.
• Lead system data troubleshooting projects, change control and regression testing cycles.
• Collaborate with stakeholders to define requirements and integration points between core HCM platforms, Data Lake, payroll and reporting environments.
• Build advanced executive‑ready Power BI dashboards, data models and self‑service data sets, and schedule reporting to deliver business insights.
• Translate complex workforce data into clear narratives for stakeholders.
• Create automated monitoring dashboards for data quality KPIs and governance compliance.
• Optimise semantic models, dataset performance and apply data security best practice.
• Identify opportunities to embed AI‑driven automation in HR operations and lifecycle.
• Guide stakeholders on where AI can enhance decision making and self‑service.
• Ensure responsible, compliant use of AI aligned with governance standards.
• Work in partnership with the data governance team to embed data dictionaries, standards, and quality KPIs.
• Ensure GDPR/DPIA compliance, support audit readiness and remediate data integrity issues.
• Facilitate workshops, demos and training across HR, BSC, Finance and Data Governance.

What You Will Need (Qualifications)

• Advanced SQL for complex querying, optimisation and data reconciliation.
• Strong experience with HR systems (Oracle Fusion Cloud HCM or similar).
• Power BI expert, including data modelling, DAX, Power Query and performance tuning.
• Solid understanding of HR data (organisation structures, roles, assignments, payroll).
• Experience with HR data cleansing and large‑scale system migrations.
• Knowledge of integrations (APIs, ETL, data transformations).
• Understanding of AI and automation, with the ability to identify suitable use cases.
• Strong analytical skills and attention to detail.
• Excellent communication skills, able to explain technical topics to non‑technical audiences.
• Experience working in governance and compliance‑focused environments.
• Degree (or equivalent experience) in Data, Analytics, HR, IT or a related field.
• Professional qualifications (e.g. CIPD, Data Analytics, Microsoft) are desirable.

Benefits

• Competitive pension scheme.
• Enhanced maternity/paternity pay.
• Life assurance.
• HolidayPlus scheme.
• Cycle2work Scheme.

Diversity and Inclusion

We value diverse backgrounds, experiences and perspectives. If you require accommodations or support during the application process, let us know – we're committed to an inclusive and accessible experience for everyone.