1 to 25 of 30 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 ...

Layer assets and analytics-ready datasets for enterprise consumption Building and maintaining data pipelines and transformation frameworks using dbt Designing dimensional data models and Star Schema structures Contributing to a rapidly evolving Data & AI capability What We're Looking For Essential Experience Excellent commercial experience with Snowflake Experience … delivering data solutions within Wealth Management, Asset Management, Investment Management or Financial Services environments Excellent understanding of Star Schema/dimensional modelling Strong experience with dbt Strong SQL and data engineering capability Strong data quality, lineage and governance experience Exposure to market data platforms and financial data ingestion ...

Snowflake Building and maintaining data pipelines and transformation frameworks using dbt Working with complex market, investment and risk datasets Designing dimensional data models and Star Schema structures Supporting portfolio suitability and regulatory reporting initiatives Implementing data quality, validation and governance controls Working closely with investment, risk and business … Leveraging modern engineering practices and AI-assisted development tools What We're Looking For Essential Experience Strong commercial experience with Snowflake Excellent understanding of Star Schema/dimensional modelling Experience with dbt Strong SQL and data engineering capability Experience working with time-series market data Exposure to market ...

dashboard design and DAX. PL-300 certification (or equivalent Microsoft Power BI certification). Strong understanding of semantic models, tabular models and dimensional modelling (star schema). Solid SQL skills for data exploration, validation and analysis. Experience delivering reporting solutions for operational, commercial and executive audiences. Strong communication … dashboard design and DAX. PL-300 certification (or equivalent Microsoft Power BI certification). Strong understanding of semantic models, tabular models and dimensional modelling (star schema). Solid SQL skills for data exploration, validation and analysis. Experience delivering reporting solutions for operational, commercial and executive audiences. Strong communication ...

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

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

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

/ELT processes Understanding and experience with DDL/DML Query optimisation and performance tuning Proficiency in SQL and DAX (Python would be desirable) Star schema data modelling Power BI Experience with or knowledge of: Azure Data Warehouse Snowflake MS Power Platform – Power Apps/Power Automate GitHub ...

Server, CosmosDB, Azure Data Factory, Purview, Synapse, Event Hub, Azure Databricks/Fabric) Extensive data modelling experience: both normalised relational models and de-normalised Star Schema/dimensional models Excellent relational database design skills with expertise in diagnosing and optimising performance across SQL Server, PostgreSQL, and cloud databases ...

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

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

accurate reconciliation between systems. Enterprise Data Warehouse Own the design and continual evolution of the company's enterprise data warehouse. Responsibilities include: Dimensional modelling Star schema design Fact and dimension modelling Slowly changing dimensions Master data management Metadata management Semantic layer design Data lineage Business definitions Data quality … warehouses Strong commercial awareness Excellent understanding of financial reporting principles Experience partnering with Finance teams Strong SQL expertise Excellent dimensional modelling skills Experience designing star schemas Experience building enterprise reporting platforms Strong understanding of data governance Excellent stakeholder management skills Ability to communicate complex technical concepts to non-technical ...

Fabric. Experience delivering finance reporting and analytical solutions. Experience building Power BI reports and dashboards directly from Microsoft Fabric. Strong data modelling skills including star schema, fact tables, dimensions and semantic modelling. Strong Power BI skills including DAX and Power Query. Strong SQL skills and experience working with ...

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

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

delivering finance reporting and analytical solutions. Experience building Power BI reports and dashboards directly from Microsoft Fabric. Strong data modelling skills, including semantic models, star schema design, fact tables and dimensions. Strong Power BI experience, including DAX and Power Query. Strong SQL skills and experience working with multiple ...

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

experience with Databricks, Unity Catalog, and Delta Lake Advanced SQL and PySpark development skills Experience implementing Medallion Architecture principles Strong data modelling expertise, including Star Schema and Data Vault methodologies Solid understanding of data governance, security, compliance, and access controls Why Join? Join a genuine greenfield data transformation ...

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

experience with Databricks, Unity Catalog and Delta Lake Strong SQL and PySpark skills Experience implementing Medallion Architecture principles Knowledge of data modelling methodologies including Star Schema and Data Vault Strong understanding of data governance, security and access management frameworks What's on Offer Salary ...

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

experience where appropriate, with a clear understanding of when SQL is the preferred solution. Experience designing robust data models using methodologies such as Kimball, Star Schema or Data Vault. Strong understanding of CI/CD, Infrastructure as Code and modern software engineering practices within data platforms. Experience building ...

multiple platforms. Support the adoption of AI-enabled capabilities within the data ecosystem. Required Technical Skills Snowflake (expert level) Cortex AI (Snowflake Cortex AI) Star Schema Data Modelling Market Data integration and management Time-Series Data engineering and modelling Dbt (Data Build Tool) Claude Code Data warehousing ...