2 of 2 Remote/Hybrid Dimensional Modelling Jobs in Scotland

partner to clients, shaping their data strategy, advising senior stakeholders and articulating architecture decisions with clarity and confidence. Create and enforce architectural guidelines, including modelling standards, reference architectures, blueprints and reusable components to ensure consistent delivery quality. Stay current with emerging data platform technologies, architectural patterns and cloud-native … architectures in large-scale, enterprise or transformation programmes. Proven expertise designingcloud-native data platforms, including MS Fabric, Databricks and AWS Strong background in data modelling methodologies (Kimball, 3NF, Data Vault, dimensional modelling). Experience with modern data transformation approaches — familiarity with analytics engineering principles is beneficial. Deep ...

with other members of the IT and development teams. What We’re Looking For Essential Hands-on experience with Power BI Desktop, including data modelling, Power Query and report development. Good working knowledge of DAX, including an understanding of measures, filter context and relationships. Good SQL development skills, including … joins, aggregations, and window functions. Good understanding of dimensional modelling, including facts, dimensions and star-schema design. Experience working with relational databases and data warehouse environments. Strong attention to detail and a disciplined approach to validating the accuracy and consistency of data. Ability to investigate discrepancies between reports ...