1 to 25 of 51 Star Schema Jobs in England

operations. Focusing primarily on Finance and Retail data streams, you will own the end-to-end Power BI lifecycle, from refining data models using Star Schema principles to deploying performant, production-ready dashboards. Key Responsibilities End-to-End Analytics: Design, build, and maintain scalable Power BI dashboards … Finance and Retail data. Advanced hands-on expertise in DAX, Power Query (M), and SQL (T-SQL). Strong data modelling expertise using Star Schema principles. Experience querying Databricks structures and integrating modern cloud data architectures. Excellent stakeholder management skills with the ability to bridge the gap between ...

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

develop the organisation's Power BI reporting estate, including dashboards, reports, and semantic modelsDesign and maintain scalable data models using dimensional modelling and star schema best practicesDevelop advanced DAX calculations and Power Query transformationsOptimise report and dataset performance, ensuring reliability and scalabilityPartner with Data Engineering teams to support … Power BI solutions in production environmentsAdvanced Power BI expertise, including semantic modelling, DAX, Power Query, and performance optimisationExcellent data modelling skills with experience of star schema and dimensional modelling techniquesStrong SQL skills, including complex query writing, data validation, and performance tuningExperience working with enterprise data warehouses and modern ...

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

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

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

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

with Azure Databricks and PySpark Azure Data Factory Advanced SQL, including query optimisation and complex transformations ETL/ELT pipeline development Dimensional modelling (Kimball, Star Schemas) Experience building modern Azure data platforms Cloud data migration experience Strong understanding of data quality, governance and production support Experience working with Azure ...

Python (or equivalent language) skills for data manipulation and automation.Hands-on experience with cloud platforms (AWS, Azure, GCP).Knowledge of data modelling methodologies (star schemas, Data Vault, Kimball, Inmon).Familiarity with data lake architectures and distributed processing frameworks (e.g., Spark, Hadoop).Experience with version control tools (GitHub, Bitbucket ...

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

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

query optimisation and working with the Azure data stack(Data Factory, Synapse/Fabric, SQL-based semantic layers). Advanced Power BI: data modelling (star schemas), advanced DAX, Power Query/M,performance tuning, RLS and deployment via pipelines. Astrong understanding of Power BI engineering discipline: PBIP/TMDLsource ...

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

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

platform, with Power BI preferred; Tableau or Qlik acceptable depending on environment. Strong SQL skills and solid understanding of data modelling concepts, including star schemas, measures/metrics design and performance optimisation. Demonstrated ability to standardise KPIs and reporting approaches across multiple geographies, teams or business units. Strong communication ...

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

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

enabled analytics.What You'll BringSemantic and dimensional data modelling - design comprehensive models from different source systems using state of the art modelling techniques, Kimbal, star schema and modern modelling tooling and automation of modelling.Data visualisation — ability to design clear, accurate, executive-ready outputs using tools such as Power ...

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

important as communication and stakeholder engagement.Key ResponsibilitiesDesign, 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 datasets … quality, governance and performance optimisation.Skills & ExperienceEssentialStrong 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.Financial Services experience, ideally ...

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