10 of 10 Contract 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 ...

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

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

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

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

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

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