How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Job Title: SQL Data Modeller
Contract: Outside IR35
Duration: 3 months with strong chance of extension
Location: Leeds, 2x per week
Our client is looking for an experienced SQL 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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location