19 of 19 Remote/Hybrid Star Schema Jobs

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

/ELT processes to ingest, transform, and load data from various sources (APIs, databases, flat files, streaming sources). Implement data modeling techniques (star schema, snowflake schema, medallion architecture). Ensure data quality, governance, and security standards are met. Monitor, troubleshoot, and optimize data workflows for performance ...

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

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

users on BI tools. Essential skills: Proven experience developing Power BI solutions (reports, dashboards, dataflows). Strong DAX and data modelling skills (star schema, relationships, measures). Solid working knowledge of SQL. Ability to turn business requirements into scalable BI solutions. Strong analytical and problem solving skills. ...

Power BI (report building, dashboards, DAX, data modelling) Proficiency in SQL for querying, validating, and analysing data Solid understanding of data modelling concepts (e.g. star schema, facts and dimensions) Experience working with data warehouses and/or data lakes Ability to create and maintain data dictionaries and metrics ...

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

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

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 Strong hands-on experience as a Power BI Analyst/Developer Advanced Power BI (Desktop & Service) and DAX skills Solid data modelling experience (star schema, dimensions, measures) Strong SQL and experience working with relational data Proven experience delivering dashboards in real-world service environments Comfortable working with ...

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

have Databricks experience Strong experience with relational and big data engines Knowledge of good data pipeline implementation and design (Concepts such as Kimball/Star Schema) Strong understanding Data warehousing concepts and modelling Proper documentation Good understanding of Agile ways of working Data Engineer, Azure, Databricks, ADF Reasonable ...

self-serve confidently while protecting core business logic. Key Responsibilities Enterprise Semantic Modelling Design, build and maintain enterprise Power BI semantic models using star schema and dimensional modelling best practice. Develop advanced DAX measures, calculation groups and reusable logic Ensure datasets reflect authoritative, agreed business definitions Implement time ...