1 to 25 of 26 Star Schema Jobs in the UK excluding London

maintain high-quality Power BI dashboards and reports. Translate business requirements into scalable reporting and data modelling solutions. Develop robust semantic models using star schema principles. Build complex DAX measures, KPIs and Power Query transformations. Optimise report performance, datasets and refresh processes. Integrate Power BI with SQL Server … with Microsoft Power BI (Desktop & Service). Advanced DAX, Power Query (M) and SQL (T-SQL preferred). Strong understanding of dimensional modelling and star schema design. Experience developing high-performance enterprise reporting solutions. Strong understanding of ETL processes and data warehousing concepts. Experience integrating multiple enterprise data ...

tight deadlines with attention to detail Experience/skills regarded as ideal but not essential Excellent understanding of Entity-Relationship/Multidimensional Data Modelling (Star schema, Snowflake schema), Data Warehouse Life Cycle and SQL Server. Experience in creating master and child packages, package configurations, logging and using ...

tight deadlines with attention to detail Experience/skills regarded as ideal but not essential Excellent understanding of Entity-Relationship/Multidimensional Data Modelling (Star schema, Snowflake schema), Data Warehouse Life Cycle and SQL Server. Experience in creating master and child packages, package configurations, logging and using ...

development Proven experience building batch and streaming data pipelines Experience implementing Medallion Architecture and Lakehouse patterns Strong understanding of data modelling techniques (dimensional, star schema, data vault) Experience with CI/CD, Infrastructure as Code and DevOps practices, Git-based source control and deployment pipelines Strong understanding ...

business analysis and process mapping (BPMN2.0 flowcharts) • Project Management training (PRINCE2, PMP, Agile, Scrum Master etc.) • Knowledge of data modelling (Unified Modelling Language, star schema) • Knowledge of best-practice Data Maturity and Data Quality frameworks (e.g. DAMA) • Strong expertise in Microsoft Azure, Fabric, Microsoft 365 platform • Fluency ...

working with the Azure data stack (Data Factory, Synapse/Fabric, SQL-based semantic layers). Advanced Power BI engineering skills: data modelling (star schemas), advanced DAX, Power Query/M, performance tuning and RLS, alongside sound engineering discipline, PBIP/TMDL source format, Git-based version control, pull ...

reporting) using Azure services Work hands-on with tools including ADF, Synapse, ADLS and Microsoft Fabric Develop and optimise dimensional data models (Kimball/star schema) for analytics and reporting Provide technical guidance and support to BI Developers during delivery (non-managerial) Contribute to Power BI/semantic ...

APIs and native connectors Own data quality, monitoring, and governance across the platform Design and implement dimensional data models (fact/dimension tables, star schema) Build and maintain Power BI semantic models with DAX, KPIs, and row-level security Deliver dashboards and reporting across commercial, marketing, and operational ...

/ELT processes Understanding and experience with DDL/DML Query optimisation and performance tuning Proficiency in SQL and DAX (Python would be desirable) Star schema data modelling Power BI Experience with or knowledge of: Azure Data Warehouse Snowflake MS Power Platform – Power Apps/Power Automate GitHub ...

stakeholder engagement. Key Responsibilities Design, develop and maintain scalable data pipelines using Snowflake and DBT. Build high-quality data models, including dimensional and star schema models. Engineer solutions supporting complex investment and portfolio data. Work with market data platforms and external data feeds. Develop solutions for time-series … Strong commercial experience as a Data Engineer. Expert knowledge of Snowflake . Strong experience with DBT . Data modelling experience, including dimensional modelling and star schemas. Experience working with time-series data. Experience integrating and managing market data feeds or financial datasets. Strong SQL and analytical problem-solving skills. ...

Fabric. Experience delivering finance reporting and analytical solutions. Experience building Power BI reports and dashboards directly from Microsoft Fabric. Strong data modelling skills including star schema, fact tables, dimensions and semantic modelling. Strong Power BI skills including DAX and Power Query. Strong SQL skills and experience working with ...

delivering finance reporting and analytical solutions. Experience building Power BI reports and dashboards directly from Microsoft Fabric. Strong data modelling skills, including semantic models, star schema design, fact tables and dimensions. Strong Power BI experience, including DAX and Power Query. Strong SQL skills and experience working with multiple ...

solutions in a commercial environment. • Strong expertise across Power BI, DAX, Power Query and semantic data modelling. • Experience designing scalable data models, including star-schema methodologies. • A strong appreciation for analytics best practice, governance and quality assurance. • The ability to work independently whilst managing multiple priorities and deadlines. ...

accurate reconciliation between systems. Enterprise Data Warehouse Own the design and continual evolution of the company's enterprise data warehouse. Responsibilities include: Dimensional modelling Star schema design Fact and dimension modelling Slowly changing dimensions Master data management Metadata management Semantic layer design Data lineage Business definitions Data quality … warehouses Strong commercial awareness Excellent understanding of financial reporting principles Experience partnering with Finance teams Strong SQL expertise Excellent dimensional modelling skills Experience designing star schemas Experience building enterprise reporting platforms Strong understanding of data governance Excellent stakeholder management skills Ability to communicate complex technical concepts to non-technical ...

Power BI Strong working knowledge of Git/version control, CI/CD pipelines, and Python for automation Solid understanding of star schemas and Kimball methodologies Experience supporting advanced Power BI models (DAX and Power Query) Exposure to ML/AI concepts (e.g. scikit-learn, TensorFlow) or an interest ...

experience with Databricks, Unity Catalog and Delta Lake Strong SQL and PySpark skills Experience implementing Medallion Architecture principles Knowledge of data modelling methodologies including Star Schema and Data Vault Strong understanding of data governance, security and access management frameworks What's on Offer Salary ...

Azure Data Platform technologies and modern Lakehouse architectures Databricks, Unity Catalog and Delta Lake PySpark, Databricks, SQL Medallion Architecture implementation Data modelling approaches including Star Schema and Data Vault Data governance, security and access management Why This Opportunity Greenfield data transformation programme Full ownership of enterprise data architecture ...

experience where appropriate, with a clear understanding of when SQL is the preferred solution. Experience designing robust data models using methodologies such as Kimball, Star Schema or Data Vault. Strong understanding of CI/CD, Infrastructure as Code and modern software engineering practices within data platforms. Experience building ...

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

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

Requirements Strong Power BI build skills: DAX, Power Query (M), data modelling (star schema) Experience reporting from Dynamics 365/Dataverse (tables, relationships, option sets, including custom tables) Delivered reporting for Customer Service/Contact Centre : cases, queues, SLAs, agent performance, call statistics. Data extraction/refresh patterns ...

architecture across the organisation. Your Skills & Experience You will have strong commercial experience in: Data Architecture and Data Modelling in enterprise environments. Dimensional modelling, star schemas, facts and dimensions, and Kimball methodologies. Designing semantic or curated data layers within modern cloud platforms. Medallion Architecture and Azure Data Lakehouse environments. ...

towards predictive and prescriptive analytics capabilities. YOUR SKILLS AND EXPERIENCE: You will bring strong capability in: Enterprise Data Architecture and Data Modelling. Dimensional modelling, star schemas, fact and dimension modelling, and Kimball methodologies. Designing logical, physical and analytical data models across complex environments. Azure Data Lakehouse and Medallion Architecture ...

towards predictive and prescriptive analytics capabilities. YOUR SKILLS AND EXPERIENCE: You will bring strong capability in: Enterprise Data Architecture and Data Modelling. Dimensional modelling, star schemas, fact and dimension modelling, and Kimball methodologies. Designing logical, physical and analytical data models across complex environments. Azure Data Lakehouse and Medallion Architecture ...

prescriptive analytics. Your Skills & Experience You will bring strong commercial experience in: Data Architecture and Data Modelling within large-scale enterprise environments. Dimensional modelling, star schemas, facts and dimensions, and Kimball methodologies. Designing and implementing Medallion Architecture frameworks. Building curated semantic layers within modern cloud data platforms. ...