8 of 8 Star Schema Jobs in London

data pipelines using Fabric Pipelines, Azure Data Factory, Notebooks and SSIS. Develop Power BI dashboards and paginated reports tailored to business needs. Model complex datasets into actionable insights using star schemas, snowflakes, and denormalised models. Optimise SQL queries and build semantic models within Fabric. Collaborate with cross-functional teams to translate business requirements into technical solutions. Support CI/ More ❯

proficiency in SQL - writing and optimizing complex queries, joins, window functions, performance tuning. Experience with dbt (or equivalent) - building models, tests, documentation, version control. Understanding of data warehousing concepts (star schemas, snowflake, slowly changing dimensions, partitioning, clustering). Experience working in a modern data stack (e.g. BigQuery, Snowflake, Redshift, Databricks, etc.) Comfortable working downstream (with BI/analytics users More ❯

Essential Skills and Experience Strong, proven experience in Power BI development within an Asset Management environment Strong, proven experience in advanced data modelling , DAX , and data transformation Expertise with star schemas , dimensional modelling semantic models , and dataflows Solid understanding of data security, access controls, and distribution practices Experience with data sources such as Snowflake , SQL , Databricks , and BW Knowledge More ❯

Essential Skills and Experience Strong, proven experience in Power BI development within an Asset Management environment Strong, proven experience in advanced data modelling , DAX , and data transformation Expertise with star schemas , dimensional modelling semantic models , and dataflows Solid understanding of data security, access controls, and distribution practices Experience with data sources such as Snowflake , SQL , Databricks , and BW Knowledge More ❯

design, implementation, and testing of Microsoft BI technologies. Responsibilities Design, develop, implement, and maintain business intelligence using Microsoft BI technologies. Understand and implement data modeling using best practices and star schema design. Analyze complex data from multiple sources including SQL Server databases and Analysis Services Tabular models. Collaborate with business analysts and subject matter experts to gather requirements More ❯

Collaborate with stakeholders to understand requirements and deliver practical solutions. Ensure data quality and consistency across reporting pipelines. What We’re Looking For Power BI Expertise: Advanced data modelling (STAR schema, relationships, filter direction). Strong DAX skills for measures and calculations. Experience optimizing performance for large datasets. Excel Mastery: Advanced formulas (SUMIFS, COUNTIFS, text functions). Dashboard More ❯

analytics projects Manage multi-vendor and internal teams Ensure alignment with strategic objectives Essential Skills Leadership in multi-vendor environments BI/Warehousing & Agile Scrum expertise Data warehouse architecture (Star Schema, Kimball, Inmon) Project management (PRINCE2, PMP) & ITIL principles Strong stakeholder engagement & risk management Desirable Knowledge of emerging tech & MPP platforms Advanced data warehouse design experience Other Ability More ❯

analytics projects Manage multi-vendor and internal teams Ensure alignment with strategic objectives Essential Skills Leadership in multi-vendor environments BI/Warehousing & Agile Scrum expertise Data warehouse architecture (Star Schema, Kimball, Inmon) Project management (PRINCE2, PMP) & ITIL principles Strong stakeholder engagement & risk management Desirable Knowledge of emerging tech & MPP platforms Advanced data warehouse design experience Other Ability More ❯