13 of 13 Remote/Hybrid Star Schema Jobs in the UK

models, dashboards and reports. Develop scalable dimensional data models (fact and dimension tables) to support analytical reporting. Design and optimise enterprise semantic models using star schema methodologies. Develop advanced DAX measures, calculations and KPIs to support business reporting requirements. Optimise Power BI datasets and semantic models to maximise … Strong experience designing dimensional data models for enterprise analytics. Excellent knowledge of Microsoft Fabric architecture. Advanced experience with DAX and enterprise semantic modelling using star schema design. Strong experience tuning and optimising Power BI semantic models. Advanced knowledge of Power Query , including transformation optimisation and diagnostics. Strong ...

pipeline development on Azure and SQL Server. Hands-on orchestration experience with SSIS, SQL Agent, and Azure Data Factory. Solid data modelling, ideally star schema design. Experience implementing data quality checks and testing (DBT or similar). Comfortable with Git and GitHub in a CI/CD workflow. … pipelines for structured and unstructured data. Help develop and maintain a modern data architecture, including optimising on-prem data warehouses. Design performant data models (star schema) and apply data transformations. Implement data observability, testing, and validation checks (such as DBT tests) to protect data integrity. Set up dynamic ...

high-volume transactional sources. Build reliable, high-performance data solutions for reporting and analytics. Design scalable data models using dimensional modelling techniques including star schema and Data Vault methodologies. Evaluate and modernise existing data architecture, identifying opportunities to improve performance, scalability and governance. Ensure robust data governance, security ...

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 … experience delivering Power BI models and dashboards (DAX, Power Query, RLS, performance). 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 ...

handling, encryption, RBAC, ACLs).- Worked with CI/CD, version control (Git), code review processes, and automated testing for data.- Designed data models (star schema, transformed delta tables, data marts) for analytics and BI.- Ensured data quality through validation, profiling, reconciliation, and automated tests.- Improved or restructured ...

logic in a data warehousing environment. Experience designing and maintaining ETL pipelines and data integration processes. Strong experience of Kimball data modelling techniques (e.g. star schema, dimensional modelling). Experience working within a Microsoft data stack (e.g. SQL Server, Azure Data Factory, Azure Synapse, Microsoft Fabric, or similar ...

near-production environment Practical experience building and maintaining ETL/ELT pipelines in a cloud environment Working knowledge of data modelling concepts including star schema and dimensional modelling Please see full job description attached. What you can expect from us We believe doing your best work starts with ...

dashboards and reports for internal and client ue Develop interactive visualizations to highlight trends and key workforce metrics Build and maintain data models (e.g. star schemas, fact and dimension tables) Create complex DAX measures and calculations for reporting and analytics Extract, transform, and load data using SQL and Power ...

best practices across client environments. Provide technical leadership and architectural guidance to engineering teams. Design and optimise data models including 3NF, Data Vault, Star Schema, and OBT approaches. Partner with stakeholders to develop data strategies aligned to business objectives. Collaborate with engineering and data science teams to deliver ...

Skills Working knowledge of SAS (especially in ETL context) Experience in migrating SAS workloads to Informatica ETLs Familiarity with data modelling (dimensional modelling/star schema) Exposure to scheduling tools (e.g., Control-M, Autosys) Understanding of data governance and data quality frameworks ...

transform Salesforce data into a unified data platform. Develop and optimise ETL/ELT processes for performance and scalability. Implement data modelling best practices (star schema, dimensional modelling). Collaborate with stakeholders to translate business requirements into technical solutions. Key Requirements Proven experience as a Data Engineer working ...

Python in a modern data environment Experience working with cloud-based data platforms such as a lakehouse architecture Understanding of data modelling principles, including star schemas and data transformation Ability to work independently in a fast-moving and evolving environment Comfortable collaborating across teams and reviewing or guiding others ...

layering etc Looker Semantic Layer - user view definitions, dimensions grouping, aggregation definitions, hidden join management MetaData and Documentation - Looker and BQ field description standards Schema Design standards - flattened views, deterministic types, order consistency, semantic description, enum constraints etc Partitioning and clustering standards Policy Tags Star Schema Design ...