1 to 25 of 42 Permanent Dimensional Modelling Jobs in England

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 ❯

Hands-on expertise in Azure ecosystem, including components like Azure Data Factory, Azure Data Lake Storage, Azure, SQL, Azure DataBricks, HD Insights, ML Service etc. Expertise in relational and dimensional modelling, including big data technologies. Experience in Azure Infrastructure and Azure Dev Ops will be a strong plus. In terms of business responsibilities - Client Engagement & Business Growth with … Hands-on expertise in Azure ecosystem, including components like Azure Data Factory, Azure Data Lake Storage, Azure, SQL, Azure DataBricks, HD Insights, ML Service etc. Expertise in relational and dimensional modelling, including big data technologies. Experience in Azure Infrastructure and Azure Dev Ops will be a strong plus. Nice to have: Client Engagement & Business Growth with a heavy 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 ❯

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 ❯

have both hands on and business facing experience. Preferably in the insurance sector. Key responsibilities: Design Data Lake and Data Warehouse solutions. Design Data Models using Data Vault and Dimensional modelling methods Implement automated, reusable and efficient batch data pipelines and streaming data pipelines Work closely with Governance and Quality teams to ensure metadata, catalogue, lineage and known More ❯

have both hands on and business facing experience. Preferably in the insurance sector. Key responsibilities: Design Data Lake and Data Warehouse solutions. Design Data Models using Data Vault and Dimensional modelling methods Implement automated, reusable and efficient batch data pipelines and streaming data pipelines Work closely with Governance and Quality teams to ensure metadata, catalogue, lineage and known More ❯

and data analysis, ideally including both raw and aggregated data with the ability to review transformation logic Solid understanding of the full Software Development Lifecycle (SDLC) Appreciation of data modelling techniques (e.g. dimensional modelling, data vault) Strong knowledge of BCBS239 regulations and their practical applications. Experience in analysing business processes and delivering regulatory solutions. Proficiency in creating 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 ❯

data solutions and making strategic tech decisions without losing sight of day-to-day pragmatism. Familiarity with CI/CD, DevOps, data governance and responsible AI practices. Strong data modelling skills - e.g. dimensional modelling Experience leveraging AI tooling to accelerate and automate tasks Experience with Data Mesh practices is a plus Confidence in setting direction, managing ambiguity 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 ❯

Snowflake, Power BI, Python, and SQL. Your work will enable self-service analytics and support data governance across the business. Key Responsibilities: Develop robust ETL/ELT pipelines and dimensional models for BI tools Define and implement data quality, ownership, and security standards Empower business teams with intuitive, self-serve data models Own data products end-to-end, from … design to continuous improvement Promote innovation and best practices in data engineering About You: Strong experience with SQL, Python, and BI tools (e.g., Power BI) Solid understanding of dimensional modelling and data architecture Experience working in governed, decentralised data environments Excellent communication and stakeholder engagement skills Analytical mindset with a focus on delivering business value If you are 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 ❯

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 ❯

with the potential for extension. This role offers a hybrid working arrangement, requiring 1-2 days per week onsite at Heathrow, Hounslow, with on-site parking available. Responsibilities: Data Modelling: Design and optimize star schema data models tailored to our client's business needs for streamlined analytics and reporting. Collaboration: Work closely with data architects, BI developers, and business … with business goals. Data Quality & Governance: Establish data quality checks and governance practices to ensure accuracy and integrity within data models. Skills/Must have: Proven experience in data modelling using Kimball methodology, with a focus on dimensional modelling and star schemas. Strong proficiency in SQL and experience with data modelling tools like ER Studio, Power 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 ❯

experience. Strong background in System Integration, Application Development, or Data-Warehouse projects across enterprise technologies. Experience with Object-oriented languages (e.g., Python, PySpark) and frameworks. Expertise in relational and dimensional modeling, including big data technologies. Proficiency in Microsoft Azure components like Azure Data Factory, Data Lake, SQL, DataBricks, HD Insights, ML Service. Good knowledge of Python and Spark. Experience 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 ❯

or equivalent. MS SQL stack (SSIS, SSAS, SSRS) to high level of proficiency - Essential C# Programming/JavaScript programming - Desirable Knowledge and Skills Software analysis and design good practice Dimensional modelling, Entity Relationship modelling, Normalised modelling. Data warehouse design concepts, (Inmon, Kimball) The position is based in Central and you will be required to be in the More ❯

or equivalent. MS SQL stack (SSIS, SSAS, SSRS) to high level of proficiency - Essential C# Programming/JavaScript programming - Desirable Knowledge and Skills Software analysis and design good practice Dimensional modelling, Entity Relationship modelling, Normalised modelling. Data warehouse design concepts, (Inmon, Kimball) The position is based in Central and you will be required to be in the More ❯