Analytics Engineer / Data Modeller

Fruition Group; Leeds; On-site; GBP 83,025 - 119,925; Full time

Job summary

Fruition Group is seeking an Analytics Engineer / Data Modeller in Leeds for a 3-month contract with potential extension. The role focuses on designing and building high-performing semantic models to underpin Power BI and Microsoft Fabric reporting.

Applicants should possess deep SQL and data modelling expertise to transform complex data into clean, scalable analytical layers, supporting accurate analytics across a complex organisation.

Qualifications

• Strong SQL development experience with complex queries and performance tuning.
• Experience designing and building semantic models and analytics layers.
• Solid understanding of data modelling for reporting and analytics.
• Experience turning business requirements into logical data solutions.
• Experience supporting Power BI reporting with underlying models.
• Exposure to Redshift / AWS Data stack is a plus.

Responsibilities

• Design, build and optimise semantic models for Power BI and Microsoft Fabric reporting.
• Develop robust SQL-based data models transforming complex datasets into clear structures.
• Improve performance, scalability and usability of reporting datasets.
• Apply data modelling principles to create reliable analytical layers.
• Collaborate with data engineers to align models with Redshift data structures.
• Help shape how the organisation consumes data by building a trusted reporting foundation.

Skills

SQL development

Semantic models

Data modelling

Power BI reporting

Data analysis

AWS / Redshift

Problem solving

Job description

Duration: 3 months with strong chance of extension

Our client is looking for an experienced Analytics Engineer / Data Modeller to join their data team and design/build high-performing semantic models that will underpin Power BI and Microsoft Fabric reporting. Working with data held in Amazon Redshift, you'll create a logical, business-friendly data layer that enables accurate, scalable analytics across a complex organisation.

This is not a dashboard development role. They're looking for someone with deep SQL and data modelling expertise who can turn complex data into clean, performant semantic models.

Responsibilities

• Design, build and optimise semantic models that support Power BI and Microsoft Fabric reporting.
• Develop robust SQL-based data models that transform complex datasets into clear, business-friendly structures.
• Improve the performance, scalability and usability of reporting datasets.
• Apply strong data modelling principles to create reliable and consistent analytical layers.
• Work with data engineers to understand underlying data structures and ensure models are built effectively on top of Amazon Redshift.
• Help shape how the organisation consumes data by creating a trusted, accessible reporting foundation.

Skills & Experience

• Strong SQL development experience, with the ability to write complex queries and optimise performance.
• Proven experience designing and building semantic models and analytical data layers.
• Strong understanding of data modelling concepts, including structuring datasets for reporting and analytics.
• Experience working with complex datasets and turning business requirements into logical data solutions.
• Experience supporting Power BI reporting through well-designed underlying models.
• Exposure to Microsoft Fabric, Amazon Redshift or AWS would be beneficial.
• Strong problem-solving skills with the ability to understand complex business processes and simplify data for end users.

We are an equal opportunities employer and welcome applications from all suitably qualified persons regardless of race, sex, disability, religion or belief, sexual orientation, or age.