12 of 12 Dimensional Modelling Jobs in Yorkshire

senior level while remaining hands-on with architecture and modelling. The Role You will act as the technical authority for data architecture and modelling across a modern Azure environment. Key responsibilities include: Designing and governing enterprise-wide data models across a Medallion Architecture framework Creating curated data models using … dimensional modelling and Kimball methodologies Defining modelling standards, governance frameworks, and data feed specifications Supporting the design of semantic layers that enable reporting, analytics, and future AI use cases Collaborating closely with Data Engineers and Analytics Engineers in an agile delivery environment Producing architecture documentation, diagrams ...

documenting data lineage, transformations and business definitions to support transparency and trust in data. Promote best practices for data governance, accuracy and consistency. Data Modelling & Architecture Support Support the design, development and maintenance of logical and physical data models across business domains. Assist with dimensional modelling activities … layers. Help define and document data flows, business entities and relationships across enterprise systems. Contribute to the ongoing development of architecture standards, principles and modelling best practices. Support metadata management, data catalogue and data discoverability initiatives. Requirements & Business Engagement Engage with business stakeholders to understand requirements, pain points ...

fantastic opportunity to join a major organisation undergoing a significant Azure Data Lakehouse transformation. You'll take ownership of enterprise-wide data modelling and architecture, helping the business evolve from traditional reporting towards advanced analytics and data-driven decision making. THE COMPANY: This well-established UK professional services organisation … include: Designing and governing enterprise-wide data models across Bronze, Silver and Gold layers within a Medallion Architecture. Creating scalable curated data models using dimensional modelling and Kimball methodologies. Defining semantic data layers, standards and governance practices that ensure consistency, quality and efficiency across the data platform. Managing ...

transformation. You'll play a key role in shaping the future of the company's data platform, becoming the go-to expert for data modelling and architecture whilst helping drive the move towards advanced analytics and data-driven decision making. THE COMPANY Our client is a well-established professional … platform, the business is now focused on building innovative data solutions and creating greater value from its data assets. THE ROLE Own the data modelling and architecture strategy across a modern Azure Data Lakehouse environment Design and govern enterprise-wide data models across Medallion Architecture layers Create scalable curated ...

Lakehouse Architecture, and Medallion Design Patterns. Strong hands-on knowledge of Databricks, Spark/PySpark, SQL, and data engineering best practices. Expertise in data modelling techniques including dimensional modelling, Data Vault, and canonical data models. Strong understanding of data integration, ETL/ELT frameworks, API integration ...

Working closely with the Business Intelligence Manager, you'll play a key role in delivering end-to-end BI solutions, covering data ingestion, transformation, modelling and visualisation. You'll work closely with stakeholders to understand business requirements, define KPIs and translate these into effective technical solutions. The role will … enabled analytics such as Copilot and natural-language insight. If you're an experienced BI Developer with strong Power BI, SQL and data modelling skills and want to have a genuine impact on how an organisation uses data, this could be an excellent opportunity. Key Responsibilities Design, build ...

term strategy, making this a highly visible role with significant business impact. THE ROLE You will be responsible for shaping the data architecture and modelling strategy across a modern Azure Data Lakehouse environment.Key responsibilities include: Designing and governing enterprise data models across Medallion Architecture layers. Building scalable dimensional models using Kimball methodologies and star schemas. Defining modelling standards, governance frameworks, and best practices. Designing and maintaining curated semantic layers for reporting and analytics. Collaborating with Data Engineers, Analytics teams, and senior stakeholders across the business. Producing architecture artefacts, data models, documentation, and design standards. Acting ...

engineering experience across batch, streaming and CDC ingestion patterns. Advanced SQL skills and strong Python development experience. Experience using dbt for data transformation and modelling would be highly beneficial. Experience building and optimising ETL/ELT pipelines. Good understanding of data warehousing, dimensional modelling and analytical data ...

optimised analytical datasets. Own data model delivery for the domain area, ensuring documentation and data definitions are accurate and accessible. Colleague Champion data literacy, modelling best practices, and standard transformation guidelines across the organisation. Mentor trainee data practitioners on SQL standards, data testing, version control, and business domain context. … about you What we’re looking for: Skills, Qualifications and Experience As a Data & Analytics Specialist - Analytics Engineer you will have experience of: Data Modelling: Proven experience building and maintaining data models using recognised patterns (e.g., Kimball, Inmon, dimensional modelling). Semantic Layer Architecture: Hands-on experience ...

.data architecture and creating data models and documentation.data monitoring, testing, and implementing quality improvements.SQL and technical database experience using relational databases and/or dimensional modellingusing CI/CD techniques and processes DevOps/Git repository code promotion and change management experience.Proven proficiency in relevant technology, Microsoft Azure certification ...

processes, including version control, labelling and configuration management.Essential:* Strong Informatica PowerCenter experience.* Strong SQL and database knowledge, particularly Oracle and data warehouse structures (e.g. dimensional models, SCD types).* Experience building and managing ETL processes, including data extraction, transformation, cleansing and loading activities.* Scripting skills (Unix/Bash ...

Deep knowledge of the Azure data stack (Azure SQL Server, CosmosDB, Azure Data Factory, Purview, Synapse, Event Hub, Azure Databricks/Fabric) Extensive data modelling experience: both normalised relational models and de-normalised Star Schema/dimensional models Excellent relational database design skills with expertise in diagnosing ...