1 to 25 of 47 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 ...

Strong proficiency in SQL and Python Strong experience with AWS (Batch, Lambda, Glue, ECR, RDS, Redshift, S3) Experience in data warehousing, database design (e.g., star schema, snowflake schema), and data modelling. Excellent problem‐solving skills and the ability to work independently and as part of a team ...

Data Science, or a related field; 3+ Years of experience in Data Engineering; Knowledge of dimensional data modeling and the advantages and limitations of Star Schema and Snowflake schema designs; Solid ETL development and reporting knowledge based on an intricate understanding of business processes and measures; Knowledge ...

skills for transformations, data modelling, and debugging data issues Experience building and supporting ingestion pipelines end to end Understanding of data modelling for analytics (star schema, facts/dimensions) and how schema changes affect downstream users Exposure to layered data architectures (e.g. bronze/silver/gold ...

practices, such as SOLID principals, structuring code, testing, IOC, etc. Strong repositories, CI/CD skills. Strong knowledge of Kimball data modelling, such as star schema, snowflake, etc. Strong SQL skills. Strong data analysis skills. Excellent written and verbal communication skills A demonstrable track record of getting stuff ...

query optimisation and working with the Azure data stack (Data Factory, Synapse/Fabric, SQL‐based semantic layers). Advanced Power BI: data modelling (star schemas), advanced DAX, Power Query/M, performance tuning, RLS, and deployment via pipelines. Understanding of Power BI engineering discipline: PBIP/TMDL source ...

varied unstructured content into structured meta-data; Knowledge of developing dimensional data models from unstructured content and awareness of the advantages and limitations of Star Schema and Snowflake schema designs; Solid ETL development, reporting knowledge based off intricate understanding of business process and measures; Knowledge of Snowflake ...

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

automation. Hands-on experience with cloud platforms (AWS, Azure, GCP). Familiarity with Databricks Workflows and other orchestration tools. Knowledge of data modelling methodologies (star schemas, Data Vault, Kimball, Inmon). Familiarity with medallion architectures, data lakehouse principles and distributed data processing. Experience with version control tools (GitHub, Bitbucket ...

varied unstructured content into structured meta-data. Knowledge of developing dimensional data models from unstructured content and awareness of the advantages and limitations of Star Schema and Snowflake schema designs. Solid ETL development, reporting knowledge based off intricate understanding of business process and measures. Knowledge of Snowflake ...

Python (or equivalent language) skills for data manipulation and automation. Hands-on experience with cloud platforms (AWS, Azure, GCP).Knowledge of data modelling methodologies (star schemas, Data Vault, Kimball, Inmon).Familiarity with data lake architectures and distributed processing frameworks (e.g., Spark, Hadoop).Experience with version control tools (GitHub, Bitbucket ...

automation. Hands‐on experience with cloud platforms (AWS, Azure, GCP). Familiarity with Databricks Workflows and other orchestration tools. Knowledge of data modelling methodologies (star schemas, Data Vault, Kimball, Inmon). Familiarity with medallion architectures, data lakehouse principles and distributed data processing. Experience with version control tools (GitHub, Bitbucket ...

automation. Hands-on experience with cloud platforms (AWS, Azure, GCP). Familiarity with Databricks Workflows and other orchestration tools. Knowledge of data modelling methodologies (star schemas, Data Vault, Kimball, Inmon). Familiarity with medallion architectures, data lakehouse principles and distributed data processing. Experience with version control tools (GitHub, Bitbucket ...

equivalent language) skills for data manipulation and automation. Hands-on experience with cloud platforms (AWS, Azure, GCP). Knowledge of data modelling methodologies (star schemas, Data Vault, Kimball, Inmon). Familiarity with data lake architectures and distributed processing frameworks (e.g., Spark, Hadoop). Experience with version control tools (GitHub ...

data pipelines and data models Work across Lakehouse and medallion architectures, including Bronze, Silver and Gold layers Develop dimensional models including facts, dimensions and star schemas Own platform reliability, monitoring, performance and incident management Establish standards around data quality, governance, lineage and security Implement and improve CI/… with strong experience across: Python/PySpark SQL Modern cloud data platforms Data pipelines and ETL/ELT Lakehouse/medallion architecture Dimensional and star-schema modelling Production data platform ownership Data quality and governance CI/CD and modern engineering practices Experience with Microsoft Fabric would ...

ensure clean, reliable and timely data flows into a central reporting layer with low ongoing maintenance. Build a scalable data model, such as a star schema, to support fast, flexible reporting rather than one-off extracts. Establish data governance practices, including naming conventions, refresh schedules, version control ...

measures. Strong experience using Power Query and data transformation techniques. Experience working with SQL and relational databases. Understanding of data modelling principles, including star schemas, dimensions, fact tables and relationships. Experience producing reporting solutions for a range of business audiences. Strong understanding of dashboard design and data visualisation best ...

query optimisation and working with the Azure data stack(Data Factory, Synapse/Fabric, SQL-based semantic layers). Advanced Power BI: data modelling (star schemas), advanced DAX, Power Query/M,performance tuning, RLS and deployment via pipelines. Astrong understanding of Power BI engineering discipline: PBIP/TMDLsource ...

architecture for Power BI-based BI and management information applications, translating reporting needs into scalable technical solutions. Design governed semantic and data models using star-schema principles, DAX and Power Query, and define standards for datasets, dataflows, workspaces and report design. Architect integrations between Power BI and Azure ...

environment. Expert knowledge of Power BI Desktop and Power BI Service. Advanced experience with DAX, Power Query and SQL. Strong knowledge of dimensional modelling, star‐schema design and semantic models. Experience with Power BI administration, workspace management, dataflows and deployment pipelines. Experience working with cloud and on‐premise ...

Server, CosmosDB, Azure Data Factory, Purview, Synapse, Event Hub, Azure Databricks/Fabric) Extensive data modelling experience: both normalised relational models and de-normalised Star Schema/dimensional models Excellent relational database design skills with expertise in diagnosing and optimising performance across SQL Server, PostgreSQL, and cloud databases ...

data pipeline reliability, proactively monitoring, troubleshooting, and resolving complex data and performance issues with minimal disruption. Architect and evolve analytics‐ready data models (e.g., star schemas, data marts), balancing performance, flexibility, and usability. Collaborate with senior stakeholders (Analytics, Salesforce, Architecture) to define requirements and translate them into scalable technical ...

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

data-driven decision-making Experience building data products that transition manual and heavily Excel-based analysis to automated or semi-automated solutions Knowledge of star schema modelling, including dimensional data modelling, dimensions, facts, measures, and hierarchies Experience developing analytics with Microsoft Power BI or other data visualisation tools ...

building a data warehouse using an ETL/ELT tool, preferably Oracle ODI or dbt Significant database experience in Snowflake and/or Oracle Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions ...