1 to 25 of 32 Star Schema Jobs in England

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

develop the organisation's Power BI reporting estate, including dashboards, reports, and semantic models Design and maintain scalable data models using dimensional modelling and star schema best practices Develop advanced DAX calculations and Power Query transformations Optimise report and dataset performance, ensuring reliability and scalability Partner with Data … solutions in production environments Advanced Power BI expertise, including semantic modelling, DAX, Power Query, and performance optimisation Excellent data modelling skills with experience of star schema and dimensional modelling techniques Strong SQL skills, including complex query writing, data validation, and performance tuning Experience working with enterprise data warehouses ...

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

high-quality, trusted data products across the business. Key Responsibilities Define and own enterprise-wide data architecture standards, including Data Vault, semantic layer frameworks, star schema modelling patterns, and Snowflake design conventions. Design scalable integration patterns for legacy and modern data sources, ensuring strong governance, reconciliation, auditability … field. At least 4 years of hands-on Snowflake architecture and design experience. Proven expertise in Data Vault 2.0 and dimensional modelling methodologies, including Star Schema design. Strong knowledge of dbt and source control practices using GitHub. Experience integrating enterprise data platforms with AWS services and broader cloud ...

such as Talend, Informatica, Matillion, Pentaho, MuleSoft, Boomi, or scripting languages (Python, PySpark, SQL). Solid understanding of data warehousing and data modelling techniques (Star Schema, Snowflake Schema). Familiarity with security frameworks (GDPR, HIPAA, ISO 27001, NIST, SOX, PII) and AWS security features (IAM, KMS, RBAC ...

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

using Power BI including semantic modelling, DAX, Power Query, data visualisation best practice, report development, and performance optimisation Advanced data modelling including dimensional modelling, star schema design, database layers, and data mart development Knowledge of BI solution delivery methodologies including requirements and discovery, Agile delivery, testing, deployment ...

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

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

Python skills Solid understanding of Lakehouse architecture and data management principles Hands-on experience with Azure (Data Factory, Databricks, Synapse, Storage, DevOps) Experience designing Star Schema data models for Power BI 5+ years' experience building data platforms in a commercial setting Nice to have: Real-time pipeline experience ...

Python skills Solid understanding of Lakehouse architecture and data management principles Hands-on experience with Azure (Data Factory, Databricks, Synapse, Storage, DevOps) Experience designing Star Schema data models for Power BI 5+ years' experience building data platforms in a commercial setting Nice to have: Real-time pipeline experience ...

Python skills Solid understanding of Lakehouse architecture and data management principles Hands-on experience with Azure (Data Factory, Databricks, Synapse, Storage, DevOps) Experience designing Star Schema data models for Power BI 5+ years' experience building data platforms in a commercial setting Nice to have: Real-time pipeline experience ...

documentation for all data warehouse and data engineering related processes. Able to document using approaches such as Entity Relationship diagrams, Data Flow Diagrams or Star Schema Diagrams. Develop detailed technical designs, SOPs, and post-incident reports to support continuous improvement. Keep documentation up to date to minimise recurrence ...

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

reporting and analytics. • Partner with stakeholders to understand requirements, validate assumptions and shape how data should be modelled. • Apply strong data modelling practices, including star schemas and Kimball methodologies. • Support the management of the lakehouse, including incremental loads, snapshotting and data quality. • Contribute to the relationship with Databricks ...

documentation, and managing a project structure Ability to translate business logic and organisational rules into data model design Experience building curated or semantic layers — star schemas or similar Excellent communication skills — able to work closely with non-technical stakeholders to understand and codify their data needs Outstanding attention ...

decision-making. Key Responsibilities End-to-End BI Architecture: Own the architecture of the Power BI application estate, designing robust semantic/data models (star schema, DAX) and defining standards for datasets, dataflows, workspaces, and report design. Platform & Integration Strategy: Architect Power BI integration with Azure/ ...

decision-making. Key Responsibilities End-to-End BI Architecture: Own the architecture of the Power BI application estate, designing robust semantic/data models (star schema, DAX) and defining standards for datasets, dataflows, workspaces, and report design. Platform & Integration Strategy: Architect Power BI integration with Azure/ ...

automation specialist or similar role. Strong proficiency in Power BI Desktop, Power BI Service, and Power Query. Solid understanding of data modelling concepts, including star schema, relationships, and normalisation. Experience with DAX (Data Analysis Expressions) for creating complex measures and calculations Familiarity with Power BI best practices, security ...

improve a lakehouse architecture, supporting ingestion, transformation, and consumption layers. Create robust, well-structured data models using best practice approaches such as Kimball and star schema. Work closely with business stakeholders to translate requirements into clear, usable data assets. Support and enhance the Power BI reporting layer, including semantic ...

managed service period What We're Looking For Expert SQL and data modelling; you build and maintain modular, analytics-ready data models (dimensional, star schema) that serve BI tools, AI agents, and automated reports. BigQuery preferred; Snowflake, Redshift, or Postgres transferable Cloud and pipeline fluency; comfortable navigating … BigQuery, IAM, GCS, CLI) and managing end-to-end ELT pipelines using tools like Fivetran, Airbyte, or dbt; you handle connector config, sync scheduling, schema management, and failure handling without hand-holding Python and AI tooling; you write scripts to automate provisioning and data quality checks ...

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

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

experience with business intelligence tools, data modeling, data staging, and data extraction processes, including data warehouse and cloud infrastructure. Experience with multi-dimensional design, star schemas, facts and dimensions. Experience and demonstrated competencies in ETL development techniques. Experience in data warehouse performance optimization. Experience on projects across a variety ...

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