14 of 14 Permanent Star Schema Jobs in London

within a small analytics squad. Build, maintain and optimise Power BI solutions, covering data modelling, DAX and semantic layers. Design robust data models using star schema principles and well managed relationships. Own performance tuning across Power BI models and reports to ensure scalability and usability. Partner closely with … analytical development. Advanced Power BI capability, including end to end build experience from data model to final dashboard. Strong data modelling skills, including star schema design and relationship management. Deep experience with DAX, including measures and calculated columns. Proven experience in performance tuning and optimisation of Power ...

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. A strong understanding of Power BI engineering discipline: PBIP/ ...

Strong hands-on coding capability in Pytho n for data engineering, service development, and pipeline automation .Data Transformation & Modeling : Proficient in SQL, data modeling (Star Schema, Data Vault, normalisation), and data transformation frameworks like db t .Regulated Environment Experience : Prior experience working within UK financial services, banking ...

reporting and analytics. • Partner with stakeholders to understand requirements, validate assumptions and shape how data should be modelled. • Apply strong data modelling practices, including star schemas and Kimball methodologies. • Support the management of the lakehouse, including incremental loads, snapshotting and data quality. • Contribute to the relationship with Databricks ...

skills, including views, stored procedures, CTEs, and window functions Solid understanding of data modelling concepts such as fact and dimension tables, and star schemas Desirable Experience Experience with Azure Synapse or similar cloud data platforms Knowledge of Power Query (M language) Understanding of Power BI performance optimisation techniques Familiarity ...

working in a cloud data environment, ideally Azure. Solid SQL capability and confidence building reliable transformation logic. Experience with data modelling concepts such as star schema, Kimball-style modelling, and semantic layers. Power BI experience across data modelling, DAX, and report development. Exposure to Databricks and lakehouse concepts ...

products that support analytics, reporting, and emerging AI initiatives. Key Responsibilities Define and own enterprise-wide data modelling standards, including Data Vault, semantic layers, Star Schema patterns, Snowflake object hierarchies, and governance frameworks. Design scalable integration architectures for legacy platforms, including AS400, iSeries, and SQL-based systems, ensuring ...

improve a lakehouse architecture, supporting ingestion, transformation, and consumption layers. Create robust, well-structured data models using best practice approaches such as Kimball and star schema. Work closely with business stakeholders to translate requirements into clear, usable data assets. Support and enhance the Power BI reporting layer, including semantic ...

essential). High proficiency in Excel is assumed, but a "Systems-First" mindset is required Data Modelling: Solid understanding of relational data modelling (Star Schema) and how to structure financial data for scale. Change Management: Proven experience in seeking and implementing ways to improve current practice through automation ...

Strong interpersonal skills; ability to translate complex data architecture into clear language for Business Analysts and non-technical stakeholders. Duties Data Modelling Standard: defining Star Schema patterns, Snowflake object hierarchies, and modelling conventions that serve as the Group-wide standard for all data products. Cross-Cloud Orchestration : Design ...

Modelling & Data Desig nDesign and govern complex relational data models — both normalised and denormalised — appropriate to the workload and performance requirements .Develop dimensional models (star schema, snowflake) to support reporting, analytics, and data warehousing needs .Define master data structures, reference data frameworks, and data lineage across interconnected systems ...

expertise in: .NET .NET Core Python Deep 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 environments. Strong knowledge ...

within Agile/Scrum/Kanban environments Proven experience writing user stories, acceptance criteria and defining Definition of Done Strong understanding of: Data warehousing Star schemas ELT pipelines Reporting & analytics processes Big data migration projects Good SQL and data analysis skills Experience working with both relational and non-relational ...

with clear ingestion, transformation, and consumption layers Creating robust data models to support analytics and reporting, following best-practice approaches such as Kimball and star schemas Supporting and enhancing the Power BI semantic layer and reporting outputs Working closely with stakeholders to translate business requirements into scalable data solutions … reporting layer Exposure to Databricks, particularly for data transformation and connecting multiple data sources Familiarity with concepts such as medallion architecture, star schemas, and analytics engineering best practice Confidence working with non-technical stakeholders and translating requirements into data models What They Offer Salary up to £60,000 plus ...