9 of 9 Remote/Hybrid Star Schema Jobs in England

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

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

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

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