Data Modeler

Salary: £70,000 - 85,000 per year

• Strong SQL development experience, including writing complex queries and optimising 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.

• 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.

• AWS
• Redshift
• Fabric
• Support
• Power BI
• SQL
• Cloud

We are hiring an experienced SQL Data Modeller to join our data team on an outside IR35 contract for 3 months, with a strong chance of extension. We are based in Leeds and work on a hybrid basis, with 2 days per week in the office. This is not a dashboard development role; we are looking for someone with deep SQL and data modelling expertise to design and build high-performing semantic models that underpin Power BI and Microsoft Fabric reporting.

We work with data held in Amazon Redshift and are focused on creating a logical, business-friendly data layer that enables accurate, scalable analytics across a complex organisation. 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.