Senior Data Analyst

Morson Group; Glasgow; On-site; GBP 36,000 - 60,000; Full time

Job summary

Morson Group is recruiting a Power BI Specialist to build, optimise and embed trusted semantic models, dashboards and analytics that enable evidence-based decision making across the People function.

Working with the People Analytics Manager, you will deliver analytics projects, design data quality frameworks, and ensure data assets are documented, reusable and governed while collaborating with Performance & Governance and the wider People teams.

Qualifications

• Strong Power BI and Power Query experience.
• Excel-based reporting experience.
• Analytical mindset with a structured approach to problem-solving.
• Experience with large or varied datasets, including manual system extracts from multiple sources.
• Excellent communication and data storytelling skills.
• Human Resources experience (desirable)

Responsibilities

• Own and develop Power BI semantic models and dashboards.
• Build dataflows and data models for insights.
• Manage manual data extracts and governance via a central repository.
• Apply change management to prevent downstream breakage.
• Translate data into compelling narratives for stakeholders.
• Collaborate with P&O and wider business teams to co-create solutions.
• Deliver analytics projects from problem definition to insight narrative ensuring value.
• Maintain documentation and governance across outputs.
• Ensure data protection and governance compliance.

Skills

Power BI

Power Query

Data modelling

Data storytelling

Analytical thinking

Communication

Problem solving

HR data (desirable)

Tools

Excel

DAX

Job description

This role will focus on building, optimising and embedding trusted Power BI semantic models, dashboards and analytics solutions that enable consistent, evidence based decision making across the function. Working with the People Analytics Manager and team, the role will take accountability for specific analytics deliverables, including designing data quality frameworks with the team, semantic model optimisation and end to end project delivery. The role will partner closely with the Performance & Governance and wider People teams to ensure shared data assets are trusted, reusable and well documented. Additionally, the role will deliver agreed analytics projects which provide clear business value.

Responsibilities

• Take shared ownership of People Analytics Power BI semantic models as trusted, single source of truth assets, including measures, definitions, refresh processes and supporting documentation.
• Develop Modern BI Solutions: Build and enhance Power BI reports, dataflows and data models that provide actionable insights and support informed decision making.
• Data Integration Workarounds: In a complex environment with some system constraints, apply creative thinking to manage manual data extracts, versioning and governance via a centralised repository.
• Apply controlled change practices to ensure updates are implemented safely, are well communicated and do not break downstream reporting.
• Insightful Storytelling: Translate complex datasets into simple, compelling narratives that resonate with a variety of audiences, including non-technical stakeholders.
• Collaborative Delivery: Work with colleagues across P&O and the wider business to understand their needs and co-create solutions.
• Work on the delivery of prioritised People Analytics projects from the governed workstack supported by the People Analytics Manager. Including problem definition, requirements, data modelling, reporting outputs and insight narrative ensuring projects deliver value for the business.
• Maintain best practices: Create clear documentation and support reporting governance to ensure transparency, continuity and quality across all outputs.
• Data Protection & Governance: Ensure that all handling of personal and sensitive data aligns with internal data protection policies and legal obligations (e.g. GDPR) maintaining secure process and upholding good data governance practices.

Skills & Requirements

• Strong Power BI and Power Query experience (data transformation, data modelling, semantic model management, Power Query, DAX)
• Comfortable navigating and reworking complex Excel-based reporting.
• Analytical mindset with a structured approach to problem-solving
• Experience working with large or varied datasets, including manual system extracts from multiple sources.
• Excellent communication and data storytelling skills.
• Comfortable operating with high levels of initiative and adaptability.
• Ability to balance detail and pragmatism keeping solutions fit for purpose.
• Human Resources experience (desirable)