At a Glance
- Tasks: Design and develop high-quality data models for analytics and reporting.
- Company: Public sector organisation in Glasgow with a focus on innovation.
- Benefits: Competitive rate of £526/day, hybrid working, and potential contract extension.
- Other info: Join a dynamic Agile team and enhance your career in data.
- Why this job: Make a real impact by optimising data for powerful insights in Power BI.
- Qualifications: 3-7+ years in data modelling and strong analytical skills required.
The predicted salary is between 40000 - 50000 £ per year.
Venesky-Brown’s client, a public sector organisation in Glasgow, is currently looking to recruit Data Modeller for initial 9 month contracts with potential to extend on a rate of £526/day (Inside IR35). These roles will be hybrid working with a minimum of 2 days per week in their Glasgow office.
Responsibilities:
- 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.
Essential Skills:
- 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.
If you would like to hear more about this opportunity please get in touch.
Data Modeller employer: Venesky Brown
Venesky-Brown is an exceptional employer, offering a dynamic work environment in the heart of Glasgow, where collaboration and innovation thrive. With a strong commitment to employee growth, we provide opportunities for professional development within a supportive Agile team, ensuring that your contributions as a Data Modeller are valued and impactful. Enjoy the flexibility of hybrid working while being part of a public sector organisation dedicated to enhancing data governance and quality.
