Data Analyst

UBDS Group; City of Westminster; On-site; GBP 40,000 - 55,000; Full time

Job summary

A leading technology solutions firm is seeking a Data Analyst to design and optimise data models and reporting solutions. The ideal candidate will have advanced skills in Power BI and SQL, with experience in data integration and governance. Benefits include private medical cover, 25 days holiday plus additional days, and a discretionary bonus. Join a team committed to innovation and impactful solutions.

Benefits

Training and personal development options

Private medical cover

Discretionary bonus

25 days holiday plus additional days

Electric Vehicle leasing

Contributed Pension Scheme

Death in service cover

Qualifications

• Proven experience as a Data Analyst or BI Developer in a data-driven environment.
• Strong understanding of data quality principles and visualisation best practices.
• Experience with consultancy or regulated industries is desirable.

Responsibilities

• Design, develop, and maintain advanced Power BI reports and dashboards.
• Implement DirectQuery and Import mode solutions for scalable reporting.
• Build dimensional models for trend analysis and regulatory requirements.

Skills

Power BI

SQL

Dimensional modelling

Data governance

DAX

M

Education

Microsoft Certified: Data Analyst Associate

Microsoft Certified: Azure Data Engineer Associate

Job description

Role Overview

The UBDS group is seeking a highly skilled Data Analyst to join our growing Data & Analytics team. This role will play a pivotal part in designing, building, and optimising data models and reporting solutions that provide actionable insights to our clients. The successful candidate will be proficient in advanced Power BI development, SQL, and dimensional modelling, with proven experience in integrating datasets across platforms such as Dataverse and Databricks.

Key Responsibilities

• Design, develop, and maintain advanced Power BI reports and dashboards, ensuring efficient data modelling using DAX and M.
• Implement and optimise DirectQuery and Import mode solutions for scalable and high-performing reporting.
• Build robust dimensional models that support time-travel and snapshot reporting for historical trend analysis and regulatory requirements.
• Develop and optimise SQL queries to support reporting, analysis, and data integration tasks.
• Integrate and transform datasets from Dataverse and Databricks into consumable Power BI solutions.
• Collaborate with business stakeholders to translate requirements into effective data solutions that drive decision-making.
• Ensure data quality, consistency, and governance across all reporting solutions.
• Provide technical expertise and guidance to colleagues and clients on data visualisation best practices and analytics capabilities.
• Expert-level proficiency with Power BI, including DAX, M, advanced modelling techniques, DirectQuery, and Import.
• Strong SQL skills, with the ability to write complex queries for analysis and integration.
• Experience in dimensional modelling, including star and snowflake schema design.
• Demonstrated capability in time-travel and snapshot reporting methodologies.
• Practical experience with integrating data from Dataverse and Databricks into reporting workflows.

Experience & Knowledge

• Proven experience as a Data Analyst, BI Developer, or similar role in a data-driven environment.
• Strong understanding of data governance, data quality principles, and best practices for visualisation.
• Experience working within consultancy, financial services, or other regulated industries (desirable).

Certifications

• Microsoft Certified: Data Analyst Associate (Power BI).
• Microsoft Certified: Azure Data Engineer Associate.

Personal Attributes

• Analytical mindset with excellent problem-solving skills.
• Strong communication skills with the ability to engage both technical and non-technical stakeholders.
• Detail-oriented, with the ability to deliver high-quality solutions within agreed timelines.
• A collaborative team player who thrives in a fast-paced, client-facing environment.

About UBDS Group

At UBDS Group our mission is to support entrepreneurs who are setting new standards with technology solutions across cloud services, cybersecurity, data and AI, ensuring that every investment advances our commitment to innovation, making a difference, and creating impactful solutions for organisations and society.

Equal Opportunities

We are an equal opportunities employer and do not discriminate on the grounds of gender, sexual orientation, marital or civil partner status, pregnancy or maternity, gender reassignment, race, colour, nationality, ethnic or national origin, religion or belief, disability or age.

Benefits

• Training - All team members are offered a number of options in terms of personal development, whether it is technical led, business acumen or methodologies. We want you to grow with us and to help us achieve more.
• Private medical cover for you and your spouse/partner, offered via Vitality.
• Discretionary bonus based on a blend of personal and company performance.
• Holiday - 25 days holiday, plus 1 day for Birthday and 1 day for work anniversary in addition to UK bank holidays.
• Electric Vehicle leasing with salary sacrifice.
• Contributed Pension Scheme.
• Death in service cover.