21 of 21 Remote/Hybrid Dimensional Modelling Jobs in England

from SSRS into Snowflake \nAssess and rationalise existing reports (remove duplication, improve logic, simplify where possible)Redesign reporting structures to align with modern data modelling principles\n Define and Implement Best Practice \n \n Establish scalable standards for:\n \n Data modelling (e.g. dimensional modelling, layered … experience working with Snowflake (or similar cloud data warehouse)Experience migrating from legacy BI/reporting tools (e.g. SSRS, Cognos, Business Objects)Strong data modelling experience (dimensional modelling, star schemas, etc.)Experience building transformation layers in ELT environmentsTrack record of delivering in hands-on roles (not purely ...

operational systems, ERP platforms and high-volume transactional sources. Build reliable, high-performance data solutions for reporting and analytics. Design scalable data models using dimensional modelling techniques including star schema and Data Vault methodologies. Evaluate and modernise existing data architecture, identifying opportunities to improve performance, scalability and governance. … platforms using Azure, AWS, GCP or similar. Strong Python experience. Solid understanding of ETL/ELT processes and modern data warehousing principles. Experience with dimensional modelling, data governance and data architecture. Experience with Power BI and DAX. Experience integrating ERP and other operational business systems. Excellent stakeholder management ...

dashboards Contribute to long-term AI and data innovation initiatives YOUR SKILLS AND EXPERIENCE: 6+ years' experience in data engineering Strong expertise in data modelling (dimensional modelling and semantic layer design) Hands-on experience with Microsoft Fabric and/or Azure data services Proven ...

batch processing Desirable Skills Working knowledge of SAS (especially in ETL context) Experience in migrating SAS workloads to Informatica ETLs Familiarity with data modelling (dimensional modelling/star schema) Exposure to scheduling tools (e.g., Control-M, Autosys) Understanding of data governance and data quality frameworks ...

including query development and optimisation, stored procedures, and performance tuning \n 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 \n Advanced data modelling including dimensional modelling, star schema ...

consultant, in addition to developing innovative solutions for our clients, you will keep abreast of the latest developments in the data, analytics and data modelling products and offerings from other vendors, and demonstrate a wider knowledge of data platforms, non-Oracle and hybrid data ecosystems. You will provide guidance … Platform, and Oracle Fusion Cloud’s embedded reporting technologies (OTBI and BI Publisher) Programming languages such as SQL and Python Logical and physical data modelling, including dimensional modelling and Data Vault 2.0 Deploying data models and accelerated data integration pipelines into target data warehouse and hybrid data ...

requirement for a Data Solution Architect to design, lead and deliver scalable, enterprise-grade data platforms. This role requires deep expertise in data architecture, dimensional data modelling (Kimball) and modern cloud-based data ecosystems (ideally Databricks) . Core Technical Expertise Strong experience in data solution architecture within enterprise … environments Proven hands-on expertise in data warehousing concepts and implementation Deep knowledge of Kimball dimensional modelling methodology. Platforms & Tools Experience with Databricks (preferred) or similar platforms: Snowflake, BigQuery, Redshift, Synapse, or equivalent Strong proficiency with: SQL (advanced level) Spark/PySpark Data pipeline orchestration tools (e.g., Airflow ...

batch and near-real-time data processing. Experience with data formats such as Parquet, Avro, ORC, JSON, and CSV. Good understanding of data modelling, data warehousing, and dimensional modelling concepts. Experience with data validation, reconciliation, data quality, audit, and logging frameworks. Experience with Git-based version control ...

Lead Data Business Analyst (Data Warehouse & Data Modelling) Our London based client is currently looking for a Lead Data Business Analyst to act as the bridge between business stakeholders and technical data teams to define, document, and validate requirements for their enterprise data warehouse. The Data Business Analyst will … requirements, including source‐to‐target mappings and logical, conceptual, and physical data models. Collaborate with data architects and data engineers to design and enhance dimensional data models, including fact and dimension tables using star and snowflake schemas. Produce and maintain data warehouse documentation, including entity relationship diagrams (ERDs), data ...

. Proven expertise in data integration and analytics platforms, including Azure Data Factory, Microsoft Fabric (Lakehouse/Warehouse), and strong understanding of data warehousing, dimensional modelling, and lakehouse concepts. Experience with Microsoft Azure cloud platform, including Azure Data Lake Storage/ADLS Gen2, Microsoft Fabric (OneLake, Workspaces, Capacity ...

implementing solutions on AWS data and analytics platforms. Proven expertise in data integration and analytics platforms on AWS, with strong understanding of data warehousing, dimensional modelling, and lakehouse/data lake concepts. Experience with AWS cloud platform, including Amazon S3, AWS Lake Formation, AWS Glue, Amazon Redshift, Amazon ...

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 ...

+ benefits This is a rare opportunity to join an organisation undertaking a major data and digital transformation, with a clear path from data modelling into data architecture. You will step into a role designed for long-term growth, working closely with senior architects and influencing how data … support key business initiatives Contribute to the design and evolution of data architecture standards and best practices Work across multiple projects, ensuring consistency in modelling approaches and data structures Collaborate with data engineers, analysts, and governance teams to deliver high-quality data solutions Support the transition towards modern, cloud ...

writing. Significant experience delivering Power BI models and dashboards (DAX, Power Query, RLS, performance). ETL/ELT tooling (SSIS/Power Query) and dimensional modelling (Star Schema). Practical AI/ML exposure (e.g., Python notebooks, Azure ML, or equivalent) and the ability to operationalise models responsibly ...

collaborative engineering team. Key responsibilities include: Designing and developing scalable data pipelines for ingestion and transformation Writing high quality SQL for complex data modelling and analytics use cases Implementing dimensional models using Kimball methodologies Working with cloud data warehouse technologies such as Snowflake or BigQuery Supporting analytics … writing complex SQL, including CTEs and window functions Experience working with modern cloud data warehouses such as Snowflake, BigQuery or similar Solid understanding of dimensional modelling and data warehousing concepts Exposure to data transformation tools such as DBT is beneficial Basic knowledge of Python, ideally in the context ...

engineering solutions. The Fabric Ecosystem: Demonstrable, hands-on expertise with Microsoft Fabric , SQL , and Python/PySpark Notebooks . Core Competencies: Proven skill in dimensional modeling, data governance, and data extraction from online platforms via SaaS and APIs. Analytical Mindset: Excellent ability to analyze, manipulate, and interpret complex business ...

within a fast-paced environment. Desirable Skills Previous experience within the insurance, financial services or other regulated industries. Understanding of data warehousing concepts and dimensional modelling. Exposure to Python or R for data analysis. Knowledge of data governance and data quality best practices. Experience working within Agile environments. Package ...

data models across policy lifecycle, underwriting, pricing, claims, reinsurance, and delegated authority domains. Develop and govern Canonical Data Models, Data Vault (RDV & BDV), and Dimensional models, selecting the right approach based on integration, auditability, and analytics needs. Model data for modern cloud platforms aligned with Medallion Architecture (Silver, Gold … Semantic layers). Translate complex London Market business rules into reusable, well‐defined data assets. Lead data modelling workshops and collaborate with underwriting, claims, finance, actuarial, and operations teams. Engage senior stakeholders to validate assumptions, standards, and design decisions. Embed data quality, reconciliation, lineage, and audit considerations into models. ...

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. ...

Define and implement robust application architectures aligned to business, security and operational requirements. Design modern data platforms including relational databases, NoSQL/document stores, dimensional models, data lakes and streaming architectures. Translate business requirements into end-to-end technical solutions spanning applications, data and infrastructure. Provide expertise across cloud … development expertise in: .NET .NET Core ReactJS Some Python Understanding Understanding of modern data architectures and technologies, including: Relational databases NoSQL/document databases Dimensional modelling and star schemas Data lakes Event-driven and streaming data platforms Experience designing and deploying solutions across both cloud and on-premises ...

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 ...