Data Modeller

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 ensure 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 uphold 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.

ASA Recruitment is one of Scotland’s largest independent multi-sector recruitment agencies. We specialise in providing effective tailored solutions for permanent, contract and temporary employment requirements for our Clients and Candidates. We are members of the REC and are ISO certified.

YOU SEEK WE FIND