1 to 25 of 28 Permanent Dimensional Modelling Jobs in the UK excluding London

Power BI reports, dashboards and datasets that drive actionable insights using DAX and SQL to support analytical needs. Transform business requirements into technical specifications, applying STAR schema and Kimball dimensional modelling to optimise data structures for performance and usability. Collaborate with stakeholders to decentralise data access and empower decision-makers. Optimise performance of data models and reports through … sources, data cubes and data models. Experience with a Data Warehouse development lifecycle and an understanding of development, test and/or production environments. Experience with concepts such as dimensional modelling and data transformation. To be educated to degree level, or possess equivalent professional qualifications and experience. Other organisations may call this role Power BI Developer, Business Intelligence More ❯

with Power BI is an essential requirement for this role SQL and Excel experience is essential to support the running of Internal and external reporting Knowledge and experience of dimensional modelling, creating new, interactive and engaging reports based on stakeholder requirements Knowledge and use in at least one analytical programming language (Python (preferred), R or Julia) this is … desirable Knowledge and experience of dimensional modelling with the ability to optimise workflows and analysis for map reduce processing Please contact John here at ISR to learn more about our exciting client based in Exeter, Devon and their ongoing growth plans More ❯

the mobile/telecoms industry would be a bonus! Key outputs for the role • Design, build, and maintain scalable and trustworthy data models in dbt, making use of Kimball Dimensional and One Big Table (OBT) methodologies. • Translate business requirements from stakeholders into robust, well-documented and tested dbt models. • Develop and own workflows within Google Cloud Platform environments, primarily … and implement robust, well-documented and performant dbt models that serve as a single source of truth for business reporting. • Implement and champion data quality testing, documentation standards, and modelling best practices within dbt projects. • Troubleshoot and resolve any issues or errors in the data pipelines. • Stay updated with the latest cloud technologies and industry best practices to continuously … be expecting to see: • Expert level proficiency in SQL. • Deep, practical experience of building and architecting data models with dbt. • A strong understanding of data warehousing concepts and data modelling techniques (e.g., Kimball, Dimensional Modelling, One Big Table). • Solid, hands-on experience within the Google Cloud Platform, especially with BigQuery. • Proven experience working directly with business More ❯

with Apache Spark (PySpark or Spark SQL) Experience with the Azure data stack Knowledge of workflow orchestration tools like Apache Airflow Experience with containerisation technologies like Docker Proficiency in dimensional modelling techniques Experience with CI/CD pipelines for data solutions Experience implementing and advocating for test-driven development methodologies in data pipeline workflows, including unit testing, integration More ❯

Define scalable data models and implement architectural patterns such as lakehouse and medallion Lead technical solution design during client engagements, from discovery to delivery Establish and enforce data governance, modelling, and lifecycle standards Support engineering and DevOps teams with guidance on best practices, CI/CD, and infrastructure-as-code Requirements 7+ years in data architecture or senior engineering … roles Strong hands-on experience with Azure Databricks and Azure Data Factory Proficient in SQL, Python , and Spark Expertise in data modelling and architectural patterns for analytics (e.g., lakehouse, medallion, dimensional modelling) Solid understanding of cloud security, private networking, GDPR, and PII compliance Excellent communication skills with a strong consulting mindset Desirable Experience with Microsoft Purview, Power More ❯

and migration strategies Maintain enterprise data models, metadata repositories, and data lineage documentation Optimise data products for performance, scalability, and reliability Skills & Experience: 10+ years in data architecture and modelling Expertise in dimensional modelling, 3NF, and Data Vault 2.0 Experience with real-time/streaming data solutions Proficiency in Python, SQL, and data modelling tools (e.g. … services (Lambda, SNS, S3, EKS, API Gateway) Familiarity with Snowflake, Spark, Airflow, DBT, and data governance frameworks Preferred: Certifications in cloud/data technologies Experience with API/interface modelling and CI/CD (e.g. GitHub Actions) Knowledge of Atlan and iceberg tables Reference: AMC/SCU/SDA/3007 Postcode: SW1 #secu More ❯

experience Comprehensive Data Engineering background - proven track record in enterprise data solutions Experience with ETL processes and data transformation, preferably using Databricks Strong foundation in Data Warehousing architectures and dimensional modeling Familiarity with batch processing from relational database sources Communication & Collaboration Skills of the Data Engineer Outstanding stakeholder engagement abilities across technical and business audiences Strong relationship-building skills More ❯

An understanding of databasetheory and design. Experience withSQL and NoSQL databases. Familiarity with big datatechnologies and ecosystems suchas MicrosoftSynapse/Fabric,Hadoop, Spark, Kafka, and others. Skills in data modelling and datawarehousing solutions. Experienceof dimensional modelling (Kimball). Proven Experience in designing and developing ETL/ELT processes. Knowledge of data pipeline toolssuch as Data Factory, Airflow More ❯

should have: Experience with Azure Data Factory, Azure Synapse, Azure SQL, or Azure Data Lake. Hands-on knowledge of the ETL process and working with large datasets. Understanding of dimensional modelling and data warehousing principles. Familiarity with CI/CD pipelines or monitoring tools for data processes. Solid skills in SQL and basic knowledge of Python scripting. Exposure More ❯

need all of these. Experience of building a data warehouse using an ETL/ELT tool, preferably Oracle ODI Significant database experience in Snowflake or Oracle Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience of developing using an Agile More ❯

need all of these. Experience of building a data warehouse using an ETL/ELT tool, preferably Oracle ODI Significant database experience in Snowflake or Oracle Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience of developing using an Agile More ❯

need all of these. Experience of building a data warehouse using an ETL/ELT tool, preferably Oracle ODI Significant database experience in Snowflake or Oracle Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience of developing using an Agile More ❯

need all of these. Experience of building a data warehouse using an ETL/ELT tool, preferably Oracle ODI Significant database experience in Snowflake or Oracle Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience of developing using an Agile More ❯

developing + maintaining SQL Server database solutions that power core business applications. Strong hands-on SQL Server database development skills including: complex stored procedures T-SQL, indexing, relational/dimensional modelling, data dashboards. Building/optimising data pipelines and integrations across cloud platforms. Any cloud platforms experience would be helpful including: such as Snowflake, Databricks, BigQuery, Azure SQL. More ❯

Here at Halton Housing, we are looking for an experienced Data Developer to work across our vibrant organisation. What You'll Do: Coding DAX Measures and Dimensional Models Developing & delivering visually compelling Power BI Dashboards & Reports to specification Developing and maintaining SSRS reports Developing & maintaining ETL pipeline solutions in Azure Data Factory and SSIS, utilising Azure Data Lake & Dev More ❯

PowerBI/Tableau developer, with a solid track record in delivering complex solutions. They will be proficient in desktop and cloud, with expert level experience in calculated metrics, data modelling, and optimising reports. You will Lead the design and development of visualisation dashboards that meet complex data requirements and present information in a clear and concise manner Drive data … design with business users Ability to perform data blending, data aggregation and complex calculated fields when required Possess hands on experience with SQL and knowledge of data warehousing and dimensional modelling will be advantageous Experience using large data platforms such as Snowflake, Databricks or similar Exposure to other visualisation platforms is helpful, but not essential Required Characteristics Cares More ❯

solutions that drive informed decision-making across the organisation. The ideal candidate will have solid expertise in Power BI, SQL Server, and SSIS, along with strong experience in data modelling, ETL workflows, and translating data into meaningful insights for stakeholders. Main responsibilities of the role: Power BI Development: Build and maintain interactive dashboards, develop robust data models and DAX … Enhancement: Oversee BI tool governance, assist with upgrades, and support continuous improvement of reporting systems and infrastructure. Essential attributes for success: Extensive practical experience with Power BI, including data modelling, Power Query, and DAX development. Strong command of Microsoft SQL Server, with expertise in T-SQL, stored procedures, and query performance optimisation. Proven ability to design and implement ETL … processes using SQL Server Integration Services (SSIS). Good understanding of data warehousing concepts, including dimensional modelling techniques. Familiar with BI performance tuning and applying best practices to ensure efficient data solutions. Keen to be part of the team that keeps everything ticking behind the scenes at Red Bull Racing? Join our Support Functions and you won't More ❯

Type: Permanent Key Responsibilities Build and maintain Snowflake-based data platforms. Collaborate with product owners and stakeholders to gather requirements and deliver scalable solutions. Ensure best practices in data modelling, governance, and architecture are applied across projects. Essential Skills Strong knowledge of cloud computing and Snowflake architecture. Proficient in SQL (ANSI-SQL). Solid experience with data models: Dimensional … Background in investment banking or financial services. Familiarity with Power BI and statistics. Ability to support multiple concurrent projects. Tech Stack: Snowflake, ANSI-SQL, Python, GitLab, Snowpark, Cloud Platforms, Dimensional Modelling This is a great opportunity to join a well-established consultancy and work on advanced cloud data solutions in the financial sector. Randstad Technologies Ltd is a More ❯

Type: Permanent Key Responsibilities Build and maintain Snowflake-based data platforms. Collaborate with product owners and stakeholders to gather requirements and deliver scalable solutions. Ensure best practices in data modelling, governance, and architecture are applied across projects. Essential Skills Strong knowledge of cloud computing and Snowflake architecture. Proficient in SQL (ANSI-SQL). Solid experience with data models: Dimensional … Background in investment banking or financial services. Familiarity with Power BI and statistics. Ability to support multiple concurrent projects. Tech Stack: Snowflake, ANSI-SQL, Python, GitLab, Snowpark, Cloud Platforms, Dimensional Modelling This is a great opportunity to join a well-established consultancy and work on advanced cloud data solutions in the financial sector. Randstad Technologies Ltd is a More ❯

work across teams do great things here at Starling, to continue changing banking for good. Responsibilities: Translate data requirements from across the organisation into robust and reusable data models, modelling both within the data warehouse and exposing via Looker, with a particular focus on Customer Data Draw insights and use appropriate analytical methods to analyse large datasets to identify … with SQL Experience with Python Strong experience with Looker or a Similar Business Intelligence (BI) Tool Good understanding and experience of DBT and applying data architecture principles such as dimensional modelling, to translate raw data into a structured format, or a willingness to learn Self-starter with the ability to think outside the box and evolve projects. Take More ❯

work across teams do great things here at Starling, to continue changing banking for good. Responsibilities: Translate data requirements from across the organisation into robust and reusable data models, modelling both within the data warehouse and exposing via Looker, with a particular focus on Customer Data Draw insights and use appropriate analytical methods to analyse large datasets to identify … with SQL Experience with Python Strong experience with Looker or a Similar Business Intelligence (BI) Tool Good understanding and experience of DBT and applying data architecture principles such as dimensional modelling, to translate raw data into a structured format, or a willingness to learn Self-starter with the ability to think outside the box and evolve projects. Take More ❯

phased implementation roadmaps Significant experience (and ideally certified) in Snowflake and acted as lead data architect on at least two Snowflake implementations. Expertise in data architecture concepts such as dimensional modelling, data vault, data mesh. Understanding data management and governance concepts such as data quality, metadata management, etc. Experience in designing data engineering solutions using open source and More ❯

focus on driving warehouse efficiencies and optimisation to reduce complexity and cost Strong experience with SQL Strong understanding and experience of DBT and applying data architecture principles such as dimensional modelling, to translate raw data into a structured format Strong experience with Looker or a Similar Business Intelligence (BI) Tool Self-starter with the ability to think outside More ❯

focus on driving warehouse efficiencies and optimisation to reduce complexity and cost Strong experience with SQL Strong understanding and experience of DBT and applying data architecture principles such as dimensional modelling, to translate raw data into a structured format Strong experience with Looker or a Similar Business Intelligence (BI) Tool Self-starter with the ability to think outside More ❯

on driving warehouse efficiencies and optimisation to reduce complexity and cost Requirements Strong experience with SQL Strong understanding and experience of DBT and applying data architecture principles such as dimensional modelling, to translate raw data into a structured format Strong experience with Looker or a Similar Business Intelligence (BI) Tool Self-starter with the ability to think outside More ❯