23 of 23 Dimensional Modelling Jobs in the UK excluding London

scale. You will have strong experience in data architecture, ETL development, and modern data warehousing practices, including the application of Kimball methodology and dimensional modelling, alongside a proven track record of building reliable, high-performance data solutions in a business-focused environment. This is a newly created role … transformation logic in a data warehousing environment. Experience designing and maintaining ETL pipelines and data integration processes. Strong experience of Kimball data modelling techniques (e.g. star schema, dimensional modelling). Experience working within a Microsoft data stack (e.g. SQL Server, Azure Data Factory, Azure Synapse, Microsoft Fabric ...

intelligence capability. This is an excellent opportunity for a highly skilled Power BI professional who enjoys working across the full BI lifecycle, from data modelling and dashboard development through to governance, optimisation, and stakeholder engagement. You'll work closely with Data Engineering teams and business leaders to deliver trusted … Responsibilities: Own and develop the organisation's Power BI reporting estate, including dashboards, reports, and semantic models Design and maintain scalable data models using dimensional modelling and star schema best practices Develop advanced DAX calculations and Power Query transformations Optimise report and dataset performance, ensuring reliability and scalability ...

Hands-on experience with Cloud Storage, Dataflow, Dataproc, Pub/Sub, Cloud Composer, BigQuery Transfer Service, Cloud Functions, and Cloud Run, Strong SQL, data modelling, dimensional modelling, and data warehousing expertise, Experience in migrating on-premise or Legacy data platforms to GCP, Knowledge of ETL/ ...

development including query development and optimisation, stored procedures, and performance tuning Expert knowledge of end-to-end enterprise BI using Power BI including semantic modelling, DAX, Power Query, data visualisation best practice, report development, and performance optimisation Advanced data modelling including dimensional modelling, star schema design ...

expertise Proven experience designing and implementing data engineering solutions using Microsoft Fabric and Azure . Strong background in ETL/ELT , data warehousing concepts, dimensional modelling and modern data architecture patterns. Hands-on skills across T-SQL , Python , PySpark , and developing robust data processing solutions. Experience optimising performance ...

English communication skills and a proven ability to thrive in a fast-paced, highly collaborative environment. Desirable (Bonus) Skills: Languages: PySQL, C#, R. Reporting & Modelling: Power BI (or similar), SQL Server SSAS Tabular (DAX), Dimensional Modelling, Data Warehousing. Ecosystem & Management: Azure DevOps, SQL MI/DB, Active ...

quality, governance and best practice across the wider business. Ensuring Your Success To succeed in this role, you'll bring strong experience in data modelling, reporting, and analytics, with expert knowledge of SQL, Databricks, Azure Data Factory and Power BI, including DAX and semantic modelling. You'll have … solid understanding of Azure Data Lake architecture, ETL processes, dimensional modelling and modern reporting principles, with the ability to translate complex business requirements into practical, scalable data solutions. Experience with Cognos would be beneficial but isn't essential. You'll be a confident communicator who enjoys collaborating with ...

integrations using Azure Data Factory and Databricks and related services. Develop and maintain datasets and data models that support analytics and reporting, following established modelling standards Contribute to data lineage, metadata management and cataloguing practices, including exposure to Purview Work closely with the Lead Data Engineer, Analysts and Architects … production or near-production environment Practical experience building and maintaining ETL/ELT pipelines in a cloud environment Working knowledge of data modelling concepts including star schema and dimensional modelling Please see full job description attached. What you can expect from us We believe doing your best ...

such as Airflow to schedule, monitor and manage data pipelines Experience working with at least one major cloud data platform, preferably Azure Strong data modelling skills, including relational and dimensional modelling Knowledge of relational database technologies and best practices Proficiency in Python for data engineering, automation ...

physical data models that support efficient reporting, analytics, and self-service BI capabilities* Establish architectural patterns and frameworks (e.g. medallion architecture, data vault, dimensional modelling) for consistent implementation across data solutions* Evaluate and recommend architectural approaches for data storage, processing, and consumption, including lakehouse, data warehousing, and data … technical assessments to validate new technologies before adoption* Monitor industry best practices and ensure Arriva's architecture remains competitive and future-proof## Data Modelling & Standards* Define and document standard business entities, metrics, and KPIs to ensure consistency across reporting* Review and approve complex data models designed by BI Engineers ...

medallion architecture and Delta Lake Desirable Experience with Azure Synapse Analytics Experience with Azure Data Factory Experience in financial services or regulated environments Dimensional modelling/star schema knowledge Databricks Certification What you'll get in return - Competitive Salary - Great Career Progression - Hybrid Working Policy - 2 days ...

year Technical Skills. Expert in Data Bricks, ADF & SQL (SQL queries, SQL Server Integration Services (SSIS) (Stored Procedures Development). Expert in Data Modelling & Data Schema creation including measures, calculations, KPI's & CDE's Working knowledge of Microsoft Power BI Report Builder, PowerBI Working knowledge of tools to help …/SharePoint/One Drive Understanding of database management systems and ETL (Extract, transform, load) framework Understanding of MS Azure data lake design (e.g. dimensional modelling) and data mining Business Skills Proven abilities to take initiative and be innovative Analytical mind with a problem-solving aptitude Ability ...

Platforms: Hands-on experience with Databricks and Azure Data Lake . ETL: Proven ability to build efficient pipelines (ADF, SSIS, APIs). Desirable: PySpark, Dimensional Modelling, DAX/SSAS, or an interest in AI/ML applications. Interested in learning more? Send me a DM or comment below ...

level security. Develop and maintain dataflows and shared datasets to support enterprise reporting. Translate business requirements into intuitive and impactful visualisations. Data Modelling & Architecture Apply dimensional modelling and star-schema design principles. Collaborate with data engineers to design scalable reporting solutions. Ensure reporting solutions align with wider ...

Collaborate with operational teams to identify and surface key data for dashboards. Develop and implement data validation checks and quality control measures. Assist in modelling and structuring data in the new system for optimal visualisation. Provide technical expertise to enhance data reliability, traceability, and overall quality. Essential Skills … Experience : Strong experience with Snowflake and Data Warehousing. Proficiency in SQL and Azure Data Factory. Familiarity with data flows, dimensional modelling, and Power BI. BA background highly advantageous. Knowledge of KQL and DAX is desirable. Desirable Attributes : Experience in a regulated industry or with investment/financial data. ...

Jet2.com and Jet2holidays . Working within our Data Engineering & Analytics function, you'll transform business requirements and complex data sources into robust logical models, dimensional models, data flows and design artefacts that enable high-quality analytics and insight. As our Data Architect , you'll have access to a wide … unforgettable package holidays and flights. We couldn't do it without our wonderful people. What you'll be doing: Designing and developing logical and dimensional data models that support reporting, analytics and data products. Translating business requirements and conceptual designs into practical, delivery-ready data structures and design artefacts. ...

solution designs meet business requirements whilst aligning with architecture standards, governance frameworks and strategic objectives. The successful candidate will combine strong data architecture and modelling expertise with a broad understanding of Microsoft Azure data technologies and modern data platforms, enabling them to guide delivery teams and make informed design … ability to influence both technical and non-technical stakeholders. Proven experience designing conceptual, logical and physical data models. Strong knowledge of relational and dimensional modelling techniques. Experience undertaking data profiling and source system analysis. Experience designing enterprise data architectures and integration patterns. Ability to produce and review architecture ...

skills. Experience managing requests through ticketing or service management systems. Ability to take ownership and deliver complete reporting solutions end-to-end. Knowledge of dimensional modelling and Kimball methodology. Exposure to cloud technologies (AWS advantageous). Apply Now If you're a BI Developer with strong SQL Server ...

procedures, views and functions. Hands-on experience testing SSIS packages, ETL processes and data transformations. Good understanding of data warehouse architectures and methodologies, including dimensional modelling concepts. Experience validating data quality, integrity, consistency and reconciliation across multiple data sources. Experience validating Power BI dashboards, reports, KPIs and semantic ...

Analytics Stack Expertise: Expert‐level SQL and deep mastery of dbt (data build tool) or similar orchestrators, coupled with a thorough understanding of Kimball dimensional modelling principles and star schema layouts. AI Native Mindset: A progressive understanding of how automated AI agents consume data structures, and practical familiarity ...

ingest and transform data from multiple sources. Apache Airflow for workflow orchestration, scheduling and automation. Azure SQL and cloud-based data platforms. Data modelling, warehousing and optimisation activities. Data quality, governance and validation processes. Power BI reporting and business intelligence requirements. Technical and non-technical stakeholders across the business. … integration. Python scripting for automation, transformation and data engineering tasks. Experience with Apache Airflow or similar orchestration tools. Understanding of data warehousing and data modelling principles, including dimensional modelling. Experience working with cloud-based data platforms. Familiarity with Git and version control practices. Strong communication skills ...

Jet2.com Limited is seeking a Data Architect to shape how analytical data assets are designed, governed and delivered across Jet2.com and Jet2holidays. In the Data Engineering & Analytics function, you’ll translate business requirements and diverse ...

Knowledge of Docker and containerisation Understanding of encryption techniques (Server Side and client-side) Familiarity with Amazon Textract and Comprehend Strong understanding of data modelling concepts, including dimensional models and slowly changing dimensions Additional Skills: Ability to translate customer requirements into functional technical solutions Familiarity with engineering best ...