24 of 24 Permanent Star Schema Jobs in England

evolving reporting landscape. What You’ll Do Design and develop scalable data transformations in Azure Databricks using Python and Spark Build and maintain star-schema models aligned to business KPI definitions Collaborate with Data Engineering to improve data quality and reliability Support and enhance Tableau dashboards and certified … roles Strong SQL skills (complex queries, optimisation, data validation) Hands-on experience with Python and Spark, ideally in Azure Databricks Experience designing and maintaining star-schema models Experience supporting reporting in Tableau or Power BI Solid understanding of data warehousing, governance, and KPI standardisation Strong stakeholder communication ...

+ 3rd party applications covering, Retail and Wholesale Sales, Stock, Customer, Supply Chain and Finance) into the data lake environment. • Apply good practice in star-schema modelling, incremental refresh, and DAX/M query optimisation. • Work with software developers, analysts and self-serve users to shape reporting requirements … understanding of Microsoft Fabric, particularly: o Lakehouses/Warehouses o Dataflows Gen2 o Pipelines & notebooks o OneLake data architecture • Good knowledge of data modelling (star-schema, fact/dimension design, calculations, DAX, M). • Strong SQL skills and ability to work with structured/unstructured data. • Comfortable working ...

skills, and design sensibility. Key Responsibilities Design and develop Power BI dashboards from concept through to deployment and maintenance. Build robust data models using star schema and dimensional modeling techniques. Write DAX measures and calculations to deliver business metrics and KPIs. Create Power Query transformations to extract, clean … Query proficiency including M language, data transformations, and query optimization. SQL skills for data extraction, transformation, and understanding database structures. Data modeling experience including star schema, dimensional modeling, and normalization. Understanding of UX and design principles for user-friendly dashboards. Stakeholder management skills with ability to gather requirements ...

Boomi, Informatica, Talend, SSIS, or custom scripting languages (Python, PySpark, SQL) for data extraction and transformation. Prior experience with Data warehousing and Data modelling (Star Schema or Snowflake Schema). Skilled in security frameworks such as GDPR, HIPAA, ISO 27001, NIST, SOX, and PII, with expertise ...

optimization. Python proficiency for data manipulation and automation. Power BI or Tableau experience including dashboard development. Data modeling experience including dimensional modeling and star schema. ETL and data transformation experience. Stakeholder management skills. Problem-solving mindset with ability to work independently. Strong attention to detail and commitment to data ...

Microsoft Fabric and related services. End-to-end DWH development knowledge, from ingestion to modelling and consumption. Strong background in data modelling, including star schema, dimensional modelling and semantic modelling. Ability to orchestrate, monitoring and optimise data pipelines. Proficiency in SQL and strong understanding of database principles. Ability ...

manipulate datasets using SQL/T-SQL.Experience producing clear technical documentation, data flows, and specifications.Ability to design and implement dimensional data models (e.g., star schema) including Slowly Changing Dimensions (SCD Type 1/2) for accurate historical reporting.Desirable:Experience in the Social Housing sector.Exposure to BI tools such ...

scale. Key Responsibilities Data platform ownership: Lead the design, operation, and evolution of our SQL Server data warehouse. Establish best practice standards for schema design and performance tuning in SQL Server/SSMS. ETL/ELT & integration: Define and manage pipelines (e.g., SSIS & Power Query) that consolidate sources including … Power Query, RLS, performance). Advanced Excel: advanced formulas, Pivot tables, Power Pivot. ETL/ELT tooling (SSIS/Power Query) and dimensional modelling (Star Schema). Practical AI/ML exposure (e.g., Python notebooks, Azure ML, or equivalent) and the ability to operationalise models responsibly within reporting ...

work Transform data into meaningful insights and recommendations What you'll bring Experience of building a data warehouse using an ETL/ELT tool Star schema/dimensional modelling. Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements ...

analytics roles. Experience working within a Medallion Architecture, ideally with direct responsibility for Gold layer curation. Expertise in Power BI, including: Intermediate DAX Star schema modelling and semantic model design Report UX/UI best practices Performance optimisation Hands-on experience with Microsoft Fabric features such as Lakehouse ...

SSIS and Azure Data Factory, and cleansing and manipulating datasets via SQL. , You will also be adept at designing and implementing dimensional models including star schemas, and implementing Slowly Changing Dimensions (SCD Type 1 or 2) to support accurate historical reporting and analytics. You should have excellent problem-solving ...

Silver/Gold), data pipelines, and OneLake storage. Querying & Modelling: Exposure to SQL or Spark SQL for querying data models, alongside a familiarity with Star Schema principles. Platform Concepts: An understanding of ETL/ELT concepts with the ability to troubleshoot (rather than design) complex architectures. Soft Skills ...

Lakehouse architecture and best practices. Experience with Unity Catalog. Expertise in Azure DevOps and CI/CD pipelines. Knowledge of data modelling (dimensional/star schemas). Experience working in Agile environments. Desirable Skills Exposure to multiple data technology stacks. Experience in large-scale enterprise environments. Knowledge of security ...

developing Power BI solutions — semantic models, reports, and dashboards — that serve real business needs across multiple areas of the organisation Writing complex DAX, building star schema data models, and optimising solutions for performance and usability Managing your own projects end-to-end, from requirements and scoping through … before writing a single measure Strong DAX skills, including time intelligence and advanced calculations that go beyond the basics Solid understanding of data modelling — star schemas, dimensional design, and how to build models that perform at scale Experience with Power Query (M) and SQL for data transformation and preparation ...

Power BI Strong working knowledge of Microsoft Fabric architecture Experience managing Premium and/or Fabric capacities Advanced DAX and enterprise semantic modelling (star schema) Performance tuning and optimisation of semantic models Advanced Power Query diagnostics and optimisation SQL optimisation for analytics workloads Working knowledge of Python ...

tenant level. Strong working knowledge of Microsoft Fabric architecture. Experience managing Premium or Fabric capacities. Advanced knowledge of DAX calculations and enterprise semantic modelling (star schemas). Expertise in performance tuning and optimisation of semantic models. Advanced knowledge of Power Query transformations and diagnostics. Experienced in optimising ...

tenant level. Strong working knowledge of Microsoft Fabric architecture. Experience managing Premium or Fabric capacities. Advanced knowledge of DAX calculations and enterprise semantic modelling (star schemas). Expertise in performance tuning and optimisation of semantic models. Advanced knowledge of Power Query transformations and diagnostics. Experienced in optimising ...

production. Key Experience Required Strong hands-on experience with Microsoft Fabric Experience building end-to-end Lakehouse solutions Good data modelling skills (e.g. star schema) Experience using PySpark or Spark SQL Building data pipelines from APIs, ERP or SaaS systems Working with Fabric pipelines, notebooks and Dataflows Understanding ...

experience with Power BI, covering the full end-to-end lifecycle, including modelling, DAX, Power Query, workspace management, and security. Data modelling principles and star schema design Advanced DAX and optimisation techniques Power Query (M) Microsoft Fabric (Lakehouse/Warehouse, semantic models, pipelines) Git/DevOps workflows ...

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 Advanced formulas (SUMIFS, COUNTIFS ...

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 Advanced formulas (SUMIFS, COUNTIFS ...

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 Advanced formulas (SUMIFS, COUNTIFS ...

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

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 Advanced formulas (SUMIFS, COUNTIFS ...