Data Modeller

I.T. & Communications
Glasgow
July 7, 2026
Permanent
Urgent

Job Description

ASA Recruitment’s client, a Public Sector organisation in Glasgow are currently looking to recruit a Data Modeller for an initial 9 month contract (with potential extensions) on a rate up to c.£530/day inside of IR35 (based on experience).

The Role

The Data Modeller will be responsible for designing, developing, and maintaining high-quality data models and datamarts that support analytical and reporting needs. They will translate business requirements into scalable, performant, and well-structured data models that enable efficient consumption in Power BI and other reporting tools.

Working as part of a multidisciplinary Agile delivery team, the Data Modeller will ensure that data structures are robust, governed, and aligned with organisational data standards and architecture principles.

Demonstrable Experience of:

  • Designing and developing dimensional data models and datamarts to support reporting and analytics use cases
  • Translating business requirements and user stories into logical and physical data models aligned to reporting needs
  • Applying best-practice dimensional modelling techniques to optimise usability and performance
  • Collaborating with Data Engineers to ensure data pipelines and transformations deliver clean, reliable, and appropriately structured data
  • Defining and maintaining data definitions, metadata, and data dictionaries to support consistent understanding and reuse
  • Ensuring data models are optimised for Power BI consumption, including considerations for performance, aggregation, and usability
  • Supporting the design of semantic layers and ensuring alignment between data models and reporting models
  • Working closely with Business Analysts and Power BI Developers to ensure data structures meet analytical requirements
  • Implementing and upholding data governance standards, including naming conventions, lineage, and documentation
  • Identifying opportunities to improve data quality, consistency, and reusability across datamarts
  • Supporting testing and validation activities, ensuring data accuracy and integrity
  • Contributing to continuous improvement in data modelling standards, patterns, and tools
  • Solid understanding of how data modelling impacts report performance and usability
  • Working with SQL and data transformation processes
  • Working with modern data platforms (data warehouses, data lakes)
  • Data governance, metadata management, and data quality principles
  • Working in Agile delivery teams, collaborating with cross-functional roles
  • Analytical thinking, attention to detail, and ability to communicate data concepts clearly
  • 3-7+ years’ experience in data modelling, data warehousing, or analytics engineering roles is expected

Location

Related Jobs