25 of 25 Permanent Star Schema Jobs in London

technical feasibility, evaluate trade-offs, and translate product requirements into maintainable, scalable technical solutions. Build and maintain production-ready Python services, SQL transformation layers, star-schema data models, and API integrations across relational databases and cloud storage (Azure Data Lake).Optimise pipeline performance, system reliability, compute efficiency … sharing, while systematically refactoring technical debt and maintaining operational runbooks. Experience that contributes to success: Substantial experience designing, building, and operating production data platforms, star-schema data models, and complex ELT/ETL pipelines. Advanced proficiency in Python and SQL, including clean object-oriented design, Pandas, query optimization ...

PySpark, Spark SQL, T-SQL and KQL, optimizing Delta tablesAdd data quality checks, validation rules, logging and alerting to data pipelinesBuild enterprise semantic models (star schema) using Direct Lake, Import or DirectQuery as specified in the architectureWrite efficient DAX measures, calculation groups and Power Query (M) transformationsBuild reports ...

Design, implement and maintain scalable ETL/ELT pipelines, ensuring data quality, integrity and reconciliation throughout the migration. Develop and optimise data warehouse structures, star schemas and dimensional models to support business and regulatory reporting. Apply best practices for Snowflake performance tuning, query optimisation and cost efficiency. Implement automated … design, query optimisation, performance tuning and troubleshooting. Significant experience designing and delivering enterprise-scale ETL/ELT solutions. Strong understanding of data warehousing principles, star schema design, dimensional modelling and data architecture. Experience with data governance, data quality and reconciliation within enterprise environments. Familiarity with Git-based source ...

/ELT solutions. Knowledge of Lakehouse and Data Warehouse architectures. Experience with Data Pipelines, Dataflows Gen2, and Notebooks. Understanding of data modelling techniques, including star schemas and dimensional modelling. Experience with Power BI semantic models and reporting. Knowledge of data governance, security, and performance optimisation. Experience using ...

/ELT solutions. Knowledge of Lakehouse and Data Warehouse architectures. Experience with Data Pipelines, Dataflows Gen2, and Notebooks. Understanding of data modelling techniques, including star schemas and dimensional modelling. Experience with Power BI semantic models and reporting. Knowledge of data governance, security, and performance optimisation. Experience using ...

/ELT solutions. Knowledge of Lakehouse and Data Warehouse architectures. Experience with Data Pipelines, Dataflows Gen2, and Notebooks. Understanding of data modelling techniques, including star schemas and dimensional modelling. Experience with Power BI semantic models and reporting. Knowledge of data governance, security, and performance optimisation. Experience using ...

experience building and optimising semantic or data models at scale, including window functions and complex business logic. Solid understanding of data modelling principles — star schema, dimensional modelling, DAX.Experience with Power BI and the Microsoft Power Platform, including building on top of central/curated data models. Familiarity with ...

plus years in a solution architect roleOne-plus year of Microsoft Fabric experienceTwo-plus years of Power BI experience: enterprise semantic model design, star schema modeling, DAX concepts, performance and capacity management and tenant administrationEnough hands-on ability to validate prototypes, review pipelines, notebooks, semantic models ...

within the insurance industry, ideally with exposure to Delegated Authority and/or Large Single Risk/Specialty business Familiarity with dimensional modelling concepts (star schemas, slowly changing dimensions) as applied within a modern lakehouse environment Thought Leaders: You are seen as an expert in your field and will ...

optimisation Stakeholder engagement and requirements gathering Communicating technical concepts to non-technical audiences Designing scalable reporting solutions using best-practice methodologies such as Kimball, Star Schema, or Medallion Architecture Azure DevOps or CI/CD processes Azure Databricks Databricks Genie or AI-assisted analytics tools Microsoft Fabric Agile ...

Snowflake)Proven experience with dbt (modelling, testing, documentation)Experience building dashboards in Looker (LookML is a strong plus)Solid understanding of data modelling concepts (star schema, dimensional modelling)Experience working with large-scale datasetsStrong communication skills with the ability to work with non-technical stakeholdersNICE TO HAVEHands ...

Proven ETL development and data pipeline experience. Solid understanding of data warehousing principles and best practices. Experience with dimensional modelling, including concepts such as star schema, semantic models, tabular models and Kimball methodologies. Exposure to DAX development. Experience working across complex data environments and multiple stakeholders. Strong problem ...

building and designing products that use both real-time and batch data at scale, and an understanding of the underlying data architecture (e.g. lakehouse, star schema).Ability to write and validate SQL queries, and to trace data flows end-to-end to ensure data quality. Awareness ...

high-performance solutions aligned with your target data architecture. Master Data Modeling Techniques – Apply expertise in various data modeling approaches, including 3NF, Data Vault, Star Schema, and One Big Table (OBT). Clearly articulate the benefits and trade-offs of each method and optimize their implementation within columnar ...

building and maintaining ETL processes and data pipelines Solid understanding of data warehousing concepts and dimensional modelling Experience working with semantic models, tabular models, star schemas, Kimball methodologies, or similar data modelling approaches Exposure to SSAS, DAX, and BI solution development Experience working across different data architectures and technology ...

will have strong commercial experience with: SQL Server and SQL development. ETL development and data pipeline engineering. Data warehousing principles and dimensional modelling. Star schema, Kimball methodologies, semantic models, and tabular models. DAX. Working within fast-paced delivery environments. Communicating effectively with both technical and non-technical stakeholders. ...

across Microsoft Fabric and Azure, aligned with global business goals. Design the Data-to-AI Interface: Establish how enterprise data is structurally modelled (using star schemas, semantic layers, dimensional modelling, and knowledge ontologies) to ensure autonomous AI agents can search, retrieve, and reason over data reliably without hallucinating. Pioneer ...

visualisation and back-end modelling Excellent SQL skills for querying, transforming, and structuring data Strong understanding of data modelling principles, including concepts such as star schema, Kimball methodology, and semantic modelling Experience developing and maintaining DAX measures and calculations Confidence engaging with stakeholders and translating business requirements into ...

strategy, sets standards for data modelling, transformations, and governance. Leads the design and implementation of new features,, such as the creation of a new star schema and other best practices to optimise data usability. Sets best practices and standards on how we use SQL & dbt/Python/ ...

infrastructure using Trino/Presto and open table formats like Apache Iceberg or Delta Lake. Advanced Data Modeling: Deep expertise in Medallion Architecture patterns, Star Schemas, and processing semi-structured financial data logs (JSON/Avro).Robust ETL/ELT Orchestration: Expert proficiency in data transformation engines (such ...

marts and business specific data products. Ability to model complex business relationships, hierarchies, and many-to-many relationships. Proficiency in dimensional modelling techniques including star schemas, snowflake schemas, facts, dimensions, and slowly changing dimensions (SCDs).Experience producing ERDs, logical data models, business data models, and data dictionaries. Strong knowledge ...

marts and business specific data products. Ability to model complex business relationships, hierarchies, and many-to-many relationships. Proficiency in dimensional modelling techniques including star schemas, snowflake schemas, facts, dimensions, and slowly changing dimensions (SCDs).Experience producing ERDs, logical data models, business data models, and data dictionaries. Strong knowledge ...

Server. Must have familiarity using either SQL 2012 or SQL 2014Experience in integrating data from external sources via API calls or FTP downloadsUnderstanding of Star Schema and Database design using accepted best practice and Kimball methodologies. Strong Knowledge of T-SQL – must have a good understanding of stored ...

data feeds, assessing data quality, structure, and suitability for analytics and AI use casesDesign and document analytics‐focused data models, including dimensional models and star schemasProduce source‐to‐target mappings, business rules, and transformation logic to support data engineering and analytics deliveryWork closely with data engineers, architects ...

UKType: ContractSalary: GBP Negotiable per yearPosted: 2026-10-30What you'll bringDAX: time intelligence, context transition, iterators; able to debug filter contextData modelling: star schema, cardinality and filter direction, many-to-many and role-playing dimensionsPower Query/M: query folding, parameters, incremental refreshSQL: strong ...