Analytics Engineer / Data Modeller

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.