1 to 25 of 35 Star Schema Jobs in England

solutions that enable data-driven decision making. Key responsibilities include: Designing and developing Power BI dashboards and reports Building robust semantic models using Star Schema principles Developing advanced DAX measures and Power Query transformations Optimising report performance, datasets and refresh processes Integrating data from SQL Server, Azure, Databricks … practices Skills & Experience Strong commercial experience with Power BI Desktop & Service Advanced DAX, Power Query (M) and SQL skills Strong data modelling expertise using Star Schema Experience delivering performant enterprise reporting solutions A solid understanding of ETL and data warehousing concepts Excellent stakeholder engagement and communication skills Experience ...

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

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

tight deadlines with attention to detail Experience/skills regarded as ideal but not essential Excellent understanding of Entity-Relationship/Multidimensional Data Modelling (Star schema, Snowflake schema), Data Warehouse Life Cycle and SQL Server. Experience in creating master and child packages, package configurations, logging and using ...

Lambda AWS Step Functions Amazon Redshift Amazon Athena Amazon RDS/Aurora AWS IAM AWS KMS Amazon CloudWatch AWS Secrets Manager Data Modelling Skills Star Schema Snowflake Schema Dimensional Modeling Data Vault Data Warehouse Design Data Lake Architecture Data Formats Experience working with: Parquet Avro JSON ...

Lambda AWS Step Functions Amazon Redshift Amazon Athena Amazon RDS/Aurora AWS IAM AWS KMS Amazon CloudWatch AWS Secrets Manager Data Modelling Skills Star Schema Snowflake Schema Dimensional Modeling Data Vault Data Warehouse Design Data Lake Architecture Data Formats Experience working with: Parquet Avro JSON ...

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

development Proven experience building batch and streaming data pipelines Experience implementing Medallion Architecture and Lakehouse patterns Strong understanding of data modelling techniques (dimensional, star schema, data vault) Experience with CI/CD, Infrastructure as Code and DevOps practices, Git-based source control and deployment pipelines Strong understanding ...

reporting) using Azure services Work hands-on with tools including ADF, Synapse, ADLS and Microsoft Fabric Develop and optimise dimensional data models (Kimball/star schema) for analytics and reporting Provide technical guidance and support to BI Developers during delivery (non-managerial) Contribute to Power BI/semantic ...

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

high-performance solutions aligned with your target data architecture. Master Data Modeling Techniques: Apply expertise in various data modeling approaches, including 3NF, Data Vault, Star Schema, and One Big Table (OBT). Clearly articulate the benefits and trade-offs of each method and optimize their implementation within columnar ...

process mapping exercises. Work with experienced engineers and consultants to understand data modelling approaches. Learn and apply data warehousing principles, including dimensional modelling and star schemas. Develop practical experience using Microsoft Fabric, Power BI, SQL and Azure-based data and analytics solutions. Help validate solutions against business requirements. What ...

stakeholder engagement. Key Responsibilities Design, develop and maintain scalable data pipelines using Snowflake and DBT. Build high-quality data models, including dimensional and star schema models. Engineer solutions supporting complex investment and portfolio data. Work with market data platforms and external data feeds. Develop solutions for time-series … Strong commercial experience as a Data Engineer. Expert knowledge of Snowflake . Strong experience with DBT . Data modelling experience, including dimensional modelling and star schemas. Experience working with time-series data. Experience integrating and managing market data feeds or financial datasets. Strong SQL and analytical problem-solving skills. ...

supporting production data environments. Deep understanding of designing, building, and maintaining robust data pipelines, ETL/ELT processes, and data warehousing concepts (e.g., star schemas). Strong knowledge of data quality principles, validation, governance, and data integrity controls. Excellent communication skills—able to break down complex technical topics ...

process mapping exercises. Work with experienced engineers and consultants to understand data modelling approaches. Learn and apply data warehousing principles, including dimensional modelling and star schemas. Develop practical experience using Microsoft Fabric, Power BI, SQL and Azure-based data and analytics solutions. Help validate solutions against business requirements. What ...

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

Isio’s DBA strategy. Working with relevant stakeholders. Own and maintain the database architecture for Isio's data warehouses and connected operational systems, including schema design, indexing strategy and query optimisation. Operational and technical responsibility for the data systems. Define and enforce database backup schedules, test restore procedures … maintain database health. Monitor database performance, capacity, and availability; proactively address bottlenecks and plan for data growth. Manage database change control processes, including schema version control and change-freeze enforcement across systems. Work closely with data and solution architects providing technical expertise and design leadership for the delivery ...

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

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

team spirit Nice-to-Have Data Governance & Quality Hands-on experience with: Data Quality Data Governance practices Familiarity with modelling approaches such as: Star Schema OBT Knowledge of modern architectures: Medallion Lambda Kappa Experience building or contributing to cloud-based data platforms AWS preferred Familiarity with: S3 Glue ...

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

Strong interpersonal skills; ability to translate complex data architecture into clear language for Business Analysts and non-technical stakeholders. Duties Data Modelling Standard: defining Star Schema patterns, Snowflake object hierarchies, and modelling conventions that serve as the Group-wide standard for all data products. Cross-Cloud Orchestration : Design ...