51 to 75 of 83 Dimensional Modelling Jobs in the UK

SQL environments Work with business and technical teams to gather and document data requirements Design, implement, update, and support data pipelines in Azure Data Factory (ADF) Maintain data warehouse dimensional model and develop data marts Develop standards and processes to optimize cost and service delivery Provide ongoing support, debug issues, and perform root cause analysis Enforce data management governance More ❯

SQL environments Work with business and technical teams to gather and document data requirements Design, implement, update, and support data pipelines in Azure Data Factory (ADF) Maintain data warehouse dimensional model and develop data marts Develop standards and processes to optimize cost and service delivery Provide ongoing support, debug issues, and perform root cause analysis Enforce data management governance More ❯

field. 10+ years of experience in data architecture and modeling. Proven experience in data modeling, data architecture, and data product design. Proficiency in data modeling standards and techniques (e.g., dimensional model, 3NF, Vault 2.0). Experience with analytical and real-time/streaming data solutions. Hands-on experience with data modeling tools (e.g., Erwin, Lucidchart, SAP PowerDesigner). Knowledge More ❯

looking for: Strong commercial experience in BI/Data Warehousing Proven expertise with Power BI and SQL (DAX, T-SQL) Experience with cloud platforms (ideally Azure) Solid understanding of dimensional modelling and ETL processes Excellent communication and stakeholder management skills 💼 Why this role? Outside IR35 – keep more of your day rate Hybrid flexibility with a vibrant central London More ❯

looking for: Strong commercial experience in BI/Data Warehousing Proven expertise with Power BI and SQL (DAX, T-SQL) Experience with cloud platforms (ideally Azure) Solid understanding of dimensional modelling and ETL processes Excellent communication and stakeholder management skills 💼 Why this role? Outside IR35 – keep more of your day rate Hybrid flexibility with a vibrant central London More ❯

well documented and thoroughly tested Collaborating with analytics and data scientists to understand their needs and build models that drive insights and decision making Champion best practices for data modelling, transformation, and governance, in your immediate time and across the business Consult on our evolving data platform, advising on the tooling, infrastructure and practices needed to enable best-in … SQL skills, with experience writing efficient and well structured queries Hands on experience with DBT, building and maintaining modular, scalable data models that follow best practices Strong understanding of dimensional modelling Familiarity with AWS data services (S3, Athena, Glue) Experience with Airflow for scheduling and orchestrating workflows Experience working with data lakes or modern data warehouses (Snowflake, Redshift 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 ❯

systems to support changing and evolving business intelligence use cases. Plan, design, implement, update and support data pipelines in ADF. Support the development and maintenance of the data warehouse dimensional model and development of data marts. Ensure the adoption of best practices, develop standards and new processes to optimise cost and service delivery. Provide technical knowledge and expertise on … pipelines. Previous experience in working with data cubes and migrating SSRS reports to PowerBI and tabular model is highly advantageous. Experience with business and technical requirements analysis, business process modelling/mapping and methodology development, and data mapping. General knowledge of database solutions, application services, data architecture and architecture patterns. Experience of working in a legal or professional services More ❯

Data Factory, Data Lake and SQL. Role & Responsibilities Building end to end data pipelines in Azure (Data Factory and SQL) Building workflows in SQL, Spark and DBT Data and dimensional modelling Skills & Qualifications Azure Data factory, Synapse and SSIS Python/Park/PySpark Ideally Snowflake and DBT More ❯

transformation logic, and uploading data in target tables. You would be responsible for designing, testing, and troubleshooting the company's data storage system before it goes live. Knowledge of dimensional modeling and data warehouse concepts, such as star schemas, snowflakes, dimensions, facts Define scope, execution plans, and coordinate test activities Ensure all sign-offs on deliverables (overall test strategy More ❯

transformation logic, and uploading data in target tables. You would be responsible for designing, testing, and troubleshooting the company's data storage system before it goes live. Knowledge of dimensional modeling and data warehouse concepts, such as star schemas, snowflakes, dimensions, facts Define scope, execution plans, and coordinate test activities Ensure all sign-offs on deliverables (overall test strategy More ❯

org level contributions. Rotate around the business to build relationships and act as a multiplier. What we look for in you Understand, assess and effectively apply modern data architectures (dimensional model, data mesh, data lake). Experience in applying and using data observability methods effectively. Experience in modern software development practices (agile, CI/CD, DevOps, infrastructure as code More ❯

of Business Objects and/or QlikView. Understanding of insurance products/concepts. Knowledge of agile methodologies and Rally application. Experience with Entity Relationship Diagrams, Data flow diagrams, and Dimensional modelling. Knowledge of Exploratory data analysis techniques. Experience with Quality Center. Understanding of basic principles and terminology to solve simple problems. Intermediate analytic, diagnostic, interpersonal, and communication skills. Ability 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 ❯

as a Data Architect with knowledge of end-to-end Data Architecture Demonstrable experience in defining and building BI/Data Warehouse Logical and Physical models, including normalised and dimensional models, as well as Data Lake architectures. Knowledge of Conceptual, Logical, and Physical Data Models Confident with mapping data from source to target. Ability to define and build Data … Migration architectures Expertise in a minimum of one data modelling tool (Erwin and/or IBM Rational System Architect) Understanding of Oracle and SQL Server. Experience in at least one of Azure, AWS, or Google architectures. Availability to start in January 2025 Nice to have: Confident in ETL and Business Intelligence tools. Proficiency in Azure Databricks. More ❯

You'll have broad career progression opportunities across Group, which includes several high profile household name What you'll bring: Strong Python & TDD skills Expertise in modern data architecture (dimensional modelling, data mesh, data lake) & best practices (agile, CI/CD, IaC, observability). Experience with Cloud and big data technologies (e.g. Spark/Databricks/Delta Lake More ❯

The position requires at least 2 years of experience using QlikView version 11 or higher, with proven expertise in the following areas: Good knowledge of SQL, relational databases, and Dimensional Modeling Experience working with large data sets and complex data models involving more than 10 tables Integrating data from multiple sources into QlikView Data Models, including social media content … and API extensions Use of complex QlikView functions and developing optimal scripts for solutions Optimizing Dimensional data models for performance Primary Responsibilities: Creating and providing reporting and dashboard applications using QlikView and NPrinting to facilitate better decision-making Collaborating with stakeholders to gather requirements, and translating these into system and functional specifications Creating prototypes and conducting proof of concepts More ❯

involves building strong relationships across the business to support existing systems and contribute to future upgrades and system improvements. Key Responsibilities: Design, develop, and test data warehouse (Star schema dimensional model), reporting, and dashboard solutions (SSRS/Power BI). Create, maintain, and enhance data integrations (IntApp Integrate/SSIS). Analyse database data to identify and fix integrity More ❯

involves building strong relationships across the business to support existing systems and contribute to future upgrades and system improvements. Key Responsibilities: Design, develop, and test data warehouse (Star schema dimensional model), reporting, and dashboard solutions (SSRS/Power BI). Create, maintain, and enhance data integrations (IntApp Integrate/SSIS). Analyse database data to identify and fix integrity More ❯

The position requires at least 2 years of experience using QlikView version 11 or higher with proven experience in the following areas: Good knowledge of SQL, relational databases, and Dimensional Modeling Working with large data sets & experience with complex data models involving more than 10 tables Integrating data from multiple data sources into a QlikView Data Model, Social Media … content, API extensions, etc. Use of complex QlikView functions and developing optimal scripts for a given solution Optimization of Dimensional data model for performance. Primary Responsibilities Will Include: Using technologies such as QlikView and NPrinting to create and provide the business areas with new reporting and dashboard applications to enable better decision making Working with stakeholders, business users, and More ❯

Job Description AWS Stack, data being landed in S3, Lambda triggers, Data Quality, data written back out to AWS S3(Parquet Formats), Snowflake for dimensional model. Design and build the data pipelines, work with someone around understanding data transformation, this is supported by BA's, building out the data pipelines, moving into layers in the data architecture (Medallion architecture More ❯

on SQL experience for basic analysis and investigations. Experience with product management tools such as backlog management, road mapping, and prototyping. Passion for data; knowledge of data warehousing and dimensional modeling is a plus. Required Characteristics Ownership and accountability for tasks, with problem-solving skills. Collaborative mindset to work with stakeholders and development teams. Effective communication with technical and More ❯

A strong understanding of business needs and data maximisation solutions Experience with digital or data initiatives as a Product Owner, managing full lifecycle Familiarity with data architecture, engineering, analytics, modelling, visualisation, and governance Hands-on SQL experience for analysis and investigations Experience with product owner tools: backlog management, road mapping, prototyping Passion for data, with knowledge of warehousing and … dimensional modelling as a plus Required Characteristics Ownership and problem-solving skills Team-oriented, stakeholder and developer collaboration Effective communication with technical and non-technical audiences Quick understanding of client contexts and business expertise If you don't fit all these exactly but are interested, we encourage you to get in touch - we hire people, not just job More ❯

observability, and engineering best practice A role designed for someone who enjoys building, influencing, and mentoring What you’ll do Design and evolve modern data architecture (data mesh, lakes, dimensional modelling) Build robust, event-driven pipelines with Python, SQL, and cloud-native tooling Improve the delivery and reliability of data products and observability tooling Lead by example: mentor More ❯

observability, and engineering best practice A role designed for someone who enjoys building, influencing, and mentoring What you’ll do Design and evolve modern data architecture (data mesh, lakes, dimensional modelling) Build robust, event-driven pipelines with Python, SQL, and cloud-native tooling Improve the delivery and reliability of data products and observability tooling Lead by example: mentor More ❯