SQL Data Modeller (Data Analytics)

TL;DR

SQL Data Modeller (SQL/Amazon Redshift): Designing and building high-performing semantic models to underpin Power BI and Microsoft Fabric reporting with an accent on logical data layer creation and scalability. Focus on transforming complex datasets into clean, performant semantic models and optimizing reporting dataset performance.

Location: Hybrid (Leeds, 2x per week)

Salary: £500 - £550 per day

Company

hirify.global is a recruitment and staffing firm specializing in technical talent placement.

What you will do

• Design, build, and optimize semantic models that support Power BI and Microsoft Fabric reporting.
• Develop robust SQL-based data models to transform complex datasets into clear, business-friendly structures.
• Improve the performance, scalability, and usability of reporting datasets.
• Collaborate with data engineers to ensure effective model implementation on Amazon Redshift.
• Create a trusted, accessible reporting foundation to shape how the organization consumes data.

Requirements

• Strong SQL development experience with the ability to write complex queries and optimize performance.
• Proven experience designing and building semantic models and analytical data layers.
• Deep understanding of data modeling concepts for reporting and analytics.
• Ability to turn complex business requirements into logical data solutions.
• Experience supporting Power BI reporting through well-designed underlying models.
• Location: Must be able to work hybrid in Leeds (2x per week)

Nice to have

• Exposure to Microsoft Fabric, Amazon Redshift, or AWS.

Culture & Benefits

• Contract role Outside IR35.
• Initial 3-month duration with a strong chance of extension.
• Equal opportunities employer welcoming applications from all qualified persons.