18 of 18 Star Schema Jobs in London

source systems into the cloud data platform. Design and govern data transformation frameworks using DBT. Define and enforce data modelling standards including dimensional modelling, star schema, and enterprise data models. Lead architecture reviews and solution design discussions for new data initiatives. Optimize Snowflake performance, workload management, and cost … Python (preferred) for automation and data engineering tasks. Data Engineering Enterprise ETL/ELT pipeline architecture Data warehousing and enterprise data modelling Dimensional modelling (Star Schema, Snowflake Schema) Data pipeline scalability and reliability design. AI/Data Science Exposure Experience supporting AI/ML data pipelines ...

using Fabric and Azure Data Factory to ensure reliable data ingestion. Develop and support a medallion architecture and apply best-practice semantic modelling (e.g., star schema) to create analytics-ready data structures. Collaborate with analytics and business teams while implementing data governance, version control, and quality assurance processes … data warehousing environments, along with strong SQL skills for data transformation and modelling. Solid understanding of relational and dimensional data modelling techniques (e.g., star schema, slowly changing dimensions), with the ability to guide others. Hands-on experience with Microsoft Fabric or Azure Databricks, including exposure to Delta Lake ...

processes to integrate data from multiple sources. Develop and maintain Power BI dashboards and reports that provide actionable business insights. Implement data models (star schema, snowflake schema) optimized for analytics and reporting. Ensure data quality, consistency, and governance across the data warehouse. Optimize query performance and data ...

Development Design and develop enterprise data warehouse solutions using Azure SQL Database/Azure SQL Managed Instance/Azure Synapse Analytics. Build and maintain star and snowflake schemas for analytical workloads. Develop ETL/ELT pipelines for ingesting and transforming data from multiple source systems. Implement data partitioning, indexing … Analysis Expressions). Experience with Power BI semantic models or Azure Analysis Services/SQL Server Analysis Services (SSAS). Strong data modeling skills (star schema, dimensional modeling). Azure & Data Engineering Experience with: Azure Synapse Analytics Azure Data Factory or similar ETL tools Azure Storage/Data ...

/CD deployment processes using Azure DevOps Required Experience Power BI (data visualisation, semantic models, paginated reports) SQL databases & data architecture Multidimensional modelling (star schema, snowflake, denormalised models, SCD handling) DAX (complex measures and analytical logic) Azure Data Factory/Fabric pipelines (complex ETL processes across relational ...

scale processing Support the development and optimisation of Power BI datasets, reports and dashboards Build and maintain scalable semantic data models including dimensional and star schema structures Ensure strong data quality, governance and testing standards across all BI and data engineering solutions Skills and Experience Hands-on expertise ...

including indexing, optimisation and partitioningBackground in financial or investment data environmentsAdvanced SQL and Python skillsExperience migrating data from platforms like DatabricksConfident with dimensional modelling, star schemas, SCDs etc.Experience within regulated financial servicesDesirableExperience in pensions, asset management or institutional investingUnderstanding of performance measurement and attributionExposure to Airflow or dbtCloud platform ...

developing Power BI reports, data models and DAX measures Modernising existing Excel-based reporting into scalable BI solutions Implementing best practice dimensional modelling (star schema) Creating and managing trusted datasets and reusable metrics Supporting the organisation’s transition toward Microsoft Fabric Working with stakeholders to translate reporting requirements ...

primary escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation ...

implemented Bronze/Silver/Gold medallion architecture Made architectural decisions and produced Architecture Decision Records (ADRs) Data Engineering & Modelling Dimensional modelling (Kimball) , star schemas SCD Type 2 MDM concepts (entity resolution, golden records) Batch & incremental ETL/ELT pipelines File-based ingestion (CSV/XLS) with error handling ...

experience in data engineering, including 5+ years of people management and technical leadership experience. Deep understanding of Ralph Kimball dimensional modelling best practices, including star schema design and data cube modelling to support scalable analytics and reporting. Experience building and optimising cloud-based data platforms and scalable data ...

Code/SOLID principles). AWS: EMR, Glue, S3, Athena, IAM, Lambda. Data Modeling: SCD Type 2, Fact/Dimension tables, Data Vault/Star Schema. Legacy: Proficiency in reading/debugging SAS (Base, Macros, DI Studio). DevOps: Git-based workflows, Jenkins/GitLab CI, Terraform. Randstad Technologies ...

Code/SOLID principles). AWS: EMR, Glue, S3, Athena, IAM, Lambda. Data Modeling: SCD Type 2, Fact/Dimension tables, Data Vault/Star Schema. Legacy: Proficiency in reading/debugging SAS (Base, Macros, DI Studio). DevOps: Git-based workflows, Jenkins/GitLab CI, Terraform. Randstad Technologies ...

Role * Design and build Power BI dashboards with a strong focus on visual design and user experience * Develop well-structured data models using star schema principles * Write efficient DAX measures and calculated columns * Build and maintain Power Query transformations for data preparation * Define and maintain design systems, templates ...

have Databricks experience Strong experience with relational and big data engines Knowledge of good data pipeline implementation and design (Concepts such as Kimball/Star Schema) Strong understanding Data warehousing concepts and modelling Proper documentation Good understanding of Agile ways of working Data Engineer, Azure, Databricks, ADF Reasonable ...

Power BI Developer will: * Build high quality Power BI dashboards and reports for client projects and internal initiatives. * Develop structured data models, including star schemas, to ensure scalable and efficient reporting. * Use DAX, calculated measures and Power Query to transform and optimise data. * Support improvements to BI standards, design ...

used by BI tools and analytics platforms. Build datasets that support consistent business metrics, reporting and analysis. Implement modelling approaches such as star schemas, denormalised analytical tables and reusable metric layers. Data Analysis & Profiling Profile complex datasets to understand data structure, quality and business meaning. Investigate and interpret source …/GCP). Strong data analysis and data profiling capability with the ability to interpret complex datasets. Experience implementing analytical modelling approaches such as star schemas or wide tables. Desirable Skills Experience working with semantic layers or metrics layers (e.g. Looker/LookML). Experience designing consistent business metrics ...

used by BI tools and analytics platforms. * Build datasets that support consistent business metrics, reporting and analysis. * Implement modelling approaches such as star schemas, denormalised analytical tables and reusable metric layers. Data Analysis & Profiling * Profile complex datasets to understand data structure, quality and business meaning. * Investigate and interpret source …/GCP). * Strong data analysis and data profiling capability with the ability to interpret complex datasets. * Experience implementing analytical modelling approaches such as star schemas or wide tables. Desirable Skills * Experience working with semantic layers or metrics layers (e.g. Looker/LookML). * Experience designing consistent business metrics ...