Data Analyst in City

CPS Group (UK) Limited; City; Hybrid; GBP 45,000 - 55,000; Full time

Job summary

CPS Group (UK) Ltd is seeking a Data Analyst in Cardiff, with hybrid working (1 day per week in the office) and a salary up to £50,000 plus annual bonus. The role blends data analysis, data modelling, reporting and elements of data engineering to grow the organisation’s analytics capability.

You will design and optimise analytical data models, develop data pipelines, and deliver Power BI dashboards for stakeholders.

Qualifications

• Commercial experience in a Data Analyst/Analytics Engineer role.
• Strong SQL skills and experience with modern analytic data environments.
• Experience designing and maintaining analytical data models (fact/dimension tables).
• Hands-on experience with data pipelines, transformations and queries.
• Experience delivering Power BI dashboards to non-technical users.
• Understanding of data quality, documentation and governance.

Responsibilities

• Design, build and maintain analytical data models (fact and dimension tables).
• Develop and optimise data pipelines, transformations and SQL queries for reliable datasets.
• Support data quality, integrity, traceability and documentation across environments.
• Develop and maintain Power BI dashboards and reports for actionable insights.
• Translate business requirements into analytical metrics, measures and visuals.
• Support data integration from multiple systems into analytical environments.

Skills

SQL

Data Modeling

Power BI

Analytics Engineering

Stakeholder communication

Tools

Power BI

Job description

Data Analyst

Location: Cardiff (1 Day p/week in the office) Salary: Up to 50,000 + Annual Bonus

CPS Group are supporting a growing Technology Healthcare organisation who are looking for a Data Analyst to join their team in Cardiff.

This is an excellent opportunity for a Data Analyst with commercial experience of Data Engineering responsibilities to step into a genuinely hybrid role, combining data analysis, data modelling, reporting and elements of data engineering.

The role offers amazing career development and progression opportunities, with the chance to work closely with technical data teams and senior business stakeholders while helping to develop the organisation's wider data and analytics capability.

The Role

As a Data Analyst, you'll sit at the intersection of business requirements and technical data delivery, working closely with data and business teams to develop trusted data products and reporting solutions.

You'll be responsible for:

• Designing, building and maintaining analytical data models, including fact and dimension tables.
• Developing and optimising data pipelines, transformations and SQL queries to produce reliable analytical datasets.
• Supporting data quality, integrity, traceability and documentation across analytical environments.
• Developing and maintaining Power BI dashboards and reports that provide clear, actionable business insight.
• Translating business requirements and questions into analytical metrics, measures and visualisations.
• Supporting the integration of data from multiple operational systems into analytical environments.

Required Experience

• Commercial experience in a Data Analyst, Analytics Engineer or similar role, ideally working across both analytics and data engineering.
• Strong SQL skills and experience working with modern analytical data environments.
• Experience designing and maintaining analytical data models, including fact and dimension tables.
• Hands-on experience with data pipelines, transformations and queries.
• Strong experience with Power BI and delivering reporting solutions to non-technical users.
• Good understanding of data modelling, data quality and documentation.
• Experience translating business requirements into analytical metrics, dashboards and visualisations.
• Experience working closely with business stakeholders and communicating complex data concepts clearly. Experience building lightweight analytical applications
• Experience with reverse-ETL or operational analytics.
• Experience or interest in regulatory reporting data.

If you're a Data Analyst with some commercial Data Engineering experience and are looking for your next step, this could be an excellent opportunity to develop your career.

By applying to this advert you are giving CPS Group (UK) Ltd authority to hold and process your data for this specific role and any other roles we may deem suitable to you over time. We will not pass your data to any third party without your verbal or written permission to do so. All incoming and outgoing calls are recorded for training and compliance purposes. CPS Group (UK) Ltd is acting as an Employment Agency in relation to this vacancy. Our new privacy policy can be found here (url removed)