Data Modeller
Summary: The Data Modeller role involves designing, developing, and maintaining data models and datamarts to support analytical and reporting needs within a multidisciplinary Agile team. The position requires translating business requirements into efficient data structures optimized for tools like Power BI. The contract is for 6 months and is classified as inside IR35. The role is hybrid, requiring presence in Glasgow two days a week.
Key Responsibilities:
- Designing and developing dimensional data models and datamarts for reporting and analytics.
- Translating business requirements into logical and physical data models.
- Applying best-practice dimensional modelling techniques.
- Collaborating with Data Engineers for clean and reliable data pipelines.
- Defining and maintaining data definitions, metadata, and data dictionaries.
- Optimizing data models for Power BI consumption.
- Supporting the design of semantic layers and alignment with reporting models.
- Working with Business Analysts and Power BI Developers to meet analytical requirements.
- Implementing data governance standards and documentation.
- Identifying opportunities for data quality improvement.
- Supporting testing and validation activities for data accuracy.
- Contributing to continuous improvement in data modelling standards.
- Understanding the impact of data modelling on report performance.
- Working with SQL and data transformation processes.
- Engaging with modern data platforms like data warehouses and lakes.
- Applying data governance and quality principles.
- Collaborating in Agile delivery teams.
- Exhibiting analytical thinking and attention to detail.
Key Skills:
- Experience in data modelling, data warehousing, or analytics engineering (3-7+ years).
- Proficiency in designing and developing dimensional data models.
- Ability to translate business requirements into data models.
- Knowledge of dimensional modelling techniques.
- Collaboration skills with Data Engineers and cross-functional teams.
- Experience with SQL and data transformation processes.
- Understanding of data governance and metadata management.
- Familiarity with Agile methodologies.
- Strong analytical thinking and attention to detail.
- Effective communication of data concepts.
Salary (Rate): £509 per day
City: Glasgow
Country: UK
Working Arrangements: hybrid
IR35 Status: inside IR35
Seniority Level: undetermined
Industry: IT
Data Modeller - 6 Month Contract - Hybrid (Glasgow 2 days pw) - Inside IR35
You 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, you will ensure that data structures are robust, governed, and aligned with organisational data standards and architecture principles.
Essential Skills & Knowledge:
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.
Similar Jobs
Apologies, there are currently no similar jobs available.