1 to 25 of 36 Dimensional Modelling Jobs in England

scalability. Validate ETL processes, including during source system software upgrades, to ensure continuity and data integrity. Design and maintain the reporting layer, including dimensional modelling, to support efficient and reusable analytics. Apply expert T-SQL and SQL Server skills for query optimisation and advanced data manipulation. Support … processes that embed data quality monitoring within routine reporting and governance structures. Contribute to the implementation of advanced analytics methods such as predictive analytics, modelling including AI, Python, and R, to help drive innovation. The postholder will be line managed by the Principal BI Developer and will work closely ...

capture data requirements.Support the design and oversight of the data infrastructure and technical environments.Ensure architecture compliance, documentation standards, and technical integrity.Skills & ExperienceExpertise in dimensional modelling and strong understanding of Third Normal Form data models.Demonstrated experience across conceptual, logical, and physical data architectures.Familiarity with data integration, ETL, and data … months agoGreater London, England, United Kingdom 1 week agoIlford, England, United Kingdom 1 month agoIsleworth, England, United Kingdom 6 days agoData Architect - Data Modelling - Dimensional - Relational - Data VaultLondon, England, United Kingdom 3 days agoBig Data Architect (Open source contributor)City Of London, England, United Kingdom £90,000.00 ...

Data Warehouse Engineer, or similar. Strong hands-on knowledge of Microsoft Fabric and related services. End-to-end DWH development knowledge, from ingestion to modelling and consumption. Strong background in data modelling, including star schema, dimensional modelling and semantic modelling. Ability to orchestrate, monitoring and optimise ...

regulatory reporting processes. This role requires a strong understanding of insurance data structures, market-specific standards, and advanced data architecture principles. Key Responsibilities Data Modelling & Architecture Design and maintain conceptual, logical, and physical data models for insurance systems. Ensure alignment with Lloyd's market standards, including Core Data Record … rules. Ensure compliance with Lloyd's market regulations, GDPR, and Solvency II requirements. Required Skills & Experience Technical Expertise 10+ years of experience in data modelling within the Lloyd's of London or London Market insurance sector. Proficiency in ER modelling, relational and dimensional modelling, and data ...

quality technical documentation About You You will have extensive experience designing and delivering modern data platforms, with: Strong expertise in data warehouses, data lakes, dimensional modelling, and both batch and streaming data processing A solid understanding of data strategy and management, including data governance, data quality, security ...

Role – Data Modelling Lead Technology – Snowflake, SQL Server, PostgreSQL, Data Warehousing, Data Lake, Medallion, Data Vault, Data Fabric, Semantic modelling Location – London, UK Job Description We are seeking an experienced Data Modeler who can analyze and understand the existing customer data and analytics models on SQL Server … concepts—including Specialized Insurance, London Market, and Regulatory Data—is essential for success in this role. Your role In the role of a Data Modelling Lead, you will be responsible for leading the design and transformation of enterprise data models to support scalable, high-performance analytics and reporting solutions. ...

Server, SSIS, SSAS, SSRS) Hands-on experience building and maintaining data pipelines and integrations (ETL/ELT) Solid understanding of data warehousing concepts, dimensional modelling, and data normalisation Experience with data manipulation languages such as T-SQL and DAX Experience working in an Agile environment (ideally Kanban) Strong ...

strategies. Experience integrating data via APIs and services. Clear communication skills and experience working in Agile delivery teams. Nice to Have: Data warehousing and dimensional modelling (e.g. dbt). Basic Power BI knowledge. Relevant Microsoft or Azure certifications. Reasonable Adjustments: Respect and equality are core values to us. ...

Server, SSIS, SSAS, SSRS) Hands-on experience building and maintaining data pipelines and integrations (ETL/ELT) Solid understanding of data warehousing concepts, dimensional modelling, and data normalisation Experience with data manipulation languages such as T-SQL and DAX Experience working in an Agile environment (ideally Kanban) Strong ...

Google Cloud Platform (GCP) Experience with orchestration tools (e.g., Apache Airflow) Experience with version control (e.g., Git) Solid understanding of data warehousing concepts and dimensional modeling To apply for this role please submit your CV or contact Dillon Blackburn on or at . Tenth Revolution Group ...

quality, and availability across core data assets. Data Platforms, Governance & Maturity Develop and maintain enterprise data models, including master data management (MDM) and core dimensional models. Establish and embed data governance frameworks covering data quality, security, access, and regulatory compliance. Support the introduction of data standards, cataloguing, and best ...

using Snowflake Optimise workflows and integrations using Openflow Develop and maintain ETL and ELT pipelines from Salesforce, relational databases, files, and NoSQL sources Implement dimensional modelling to support data warehousing and BI reporting Build and optimise data pipelines across Azure and AWS Ensure data quality, governance, and security ...

into meaningful insights and recommendations What you'll bring Experience of building a data warehouse using an ETL/ELT tool Star schema/dimensional modelling. Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience of developing using ...

operational reporting. Key Responsibilities: Build, maintain and optimise scalable, secure and well-governed data pipelines. Develop and maintain data models (Data Vault and Dimensional). Ensure data quality, lineage, governance and security standards are embedded in all pipelines. Troubleshoot and resolve data pipeline issues, performing root cause analysis … distributed environments (DBT, Snowflake, SQL Server Stack; experience with Kafka, MySQL, Azure or AWS is a plus). Strong expertise in Data Vault and Dimensional modelling is essential. Experience embedding data governance, quality, monitoring and alerting into pipelines. Knowledge of Agile delivery and CI/CD principles. Excellent ...

such as SQL Server, SSIS, SSRS and SSAS, ensuring that legacy systems and modern cloud components work together effectively. You will define data models, dimensional structures and integration patterns that support operational reporting, dashboards and analytical workloads. You will work closely with business teams to understand data requirements, translate … well systems integrate and how effectively the organisation makes decisions. What you'll need to succeed You bring strong experience in data architecture, data modelling and BI engineering within a medium or large organisation. You have hands-on expertise with SQL Server technologies including SSIS, SSRS and SSAS ...

tools such as SSIS and Azure Data Factory, and cleansing and manipulating datasets via SQL. , You will also be adept at designing and implementing dimensional models including star schemas, and implementing Slowly Changing Dimensions (SCD Type 1 or 2) to support accurate historical reporting and analytics. You should have ...

business goals Design logical and physical data models optimised for reporting, analytics, and self-service BI Establish and govern architectural patterns (e.g. medallion architecture, dimensional modelling, data vault) Design cloud-based data platform architectures (AWS preferred), including data storage, processing, and consumption layers Technology Leadership Evaluate and recommend … cloud-native services Lead proofs-of-concept and technical assessments for new technologies Ensure the data architecture remains modern, performant, and future-proof Data Modelling & Governance Define standard business entities, metrics, and KPIs for consistent reporting Review and approve complex data models created by BI Engineers Design and embed ...

business goals Design logical and physical data models optimised for reporting, analytics, and self-service BI Establish and govern architectural patterns (e.g. medallion architecture, dimensional modelling, data vault) Design cloud-based data platform architectures (AWS preferred), including data storage, processing, and consumption layers Technology Leadership Evaluate and recommend … cloud-native services Lead proofs-of-concept and technical assessments for new technologies Ensure the data architecture remains modern, performant, and future-proof Data Modelling & Governance Define standard business entities, metrics, and KPIs for consistent reporting Review and approve complex data models created by BI Engineers Design and embed ...

. Technical Expertise: Strong expertise in Microsoft Data Platform technologies, including: SQL Server SSIS SSAS SSRS Solid understanding of data warehousing concepts, data normalisation, dimensional modelling, and associated best practices. Hands-on experience with data pipelines and integrations (ETL/ELT). Proficiency in data manipulation languages such ...

. Technical Expertise: Strong expertise in Microsoft Data Platform technologies, including: SQL Server SSIS SSAS SSRS Solid understanding of data warehousing concepts, data normalisation, dimensional modelling, and associated best practices. Hands-on experience with data pipelines and integrations (ETL/ELT). Proficiency in data manipulation languages such ...

technical concepts clearly to non-technical audiences Act as a positive, approachable technical lead and support other team members Maintain robust data dictionaries and dimensional data models Apply strong analytical thinking and stay up to date with existing and emerging technologies Demonstrate expertise in SQL, data warehousing, dimensional modelling, Databricks, Data Lakes, and knowledge of CDL Kingfisher, Classic data, OGI, and main PAS data sources Skills, Experience & Knowledge: Development experience in SQL programming and systems integration Strong knowledge of SQL, data modelling, data warehousing concepts, and Kimball methodology Experience within Insurance or Broking (preferred) Proven ...

closely with data engineers, analysts, and architects to deliver high-quality, scalable data pipelines and models. Strong expertise in Snowflake, ETL/ELT, data modelling, and data warehousing is essential. Responsibilities Snowflake Development: Build and optimise Snowflake objects (databases, schemas, tables, views, tasks, streams, resource monitors). ETL/… Pipelines: Develop and maintain robust data pipelines using tools like dbt, Airflow, Azure Data Factory, or similar. Data Modelling: Implement dimensional models (star/snowflake schemas), handle SCDs, and design efficient structures for analytics. Performance Tuning: Optimise queries, manage clustering, caching, and warehouse sizing for cost and speed. ...

experience with complex data transformations Experience with cloud platform - Azure Familiarity with ETL/ELT tools Strong understanding of data warehousing concepts and dimensional modelling Responsibilities Design, develop, and maintain data pipelines and data models in Snowflake Implement ELT/ETL processes using Snowflake and associated tools Optimise ...

Blocks Source system classification and data contracts Ingestion and landing architecture Standardisation validation and data quality layers Master and reference data integration Analytical and dimensional modelling approaches Semantic layer and BI consumption patterns Metadata lineage observability and monitoring Architecture Leadership Act as architectural authority and design reviewer Produce ...

experience Strong experience with the Microsoft BI stack (SSIS, SSAS, SSRS, Power BI) and SQL/relational databases. Knowledge of ETL processes, data warehousing, dimensional modelling (Kimball), and analytics/OLAP cube development. High analytical capability with strong numerical, logical, and problem-solving skills. Effective communication and stakeholder ...