5 of 5 Dimensional Modelling Jobs in Manchester

from SSRS into Snowflake Assess and rationalise existing reports (remove duplication, improve logic, simplify where possible) Redesign reporting structures to align with modern data modelling principles Define and Implement Best Practice Establish scalable standards for: Data modelling (e.g. dimensional modelling, layered architecture) Transformation workflows (ELT patterns … experience working with Snowflake (or similar cloud data warehouse) Experience migrating from legacy BI/reporting tools (e.g. SSRS, Cognos, Business Objects) Strong data modelling experience (dimensional modelling, star schemas, etc.) Experience building transformation layers in ELT environments Track record of delivering in hands-on roles ...

development including query development and optimisation, stored procedures, and performance tuning Expert knowledge of end-to-end enterprise BI 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 ...

frameworks using Spark and Python or SQL-based pipelines. Optimise query performance across large datasets, improving efficiency and cost control. Define and manage data modelling standards, including dimensional modelling approaches. Develop CI and CD pipelines to enable reliable deployment and testing of data products. Create and maintain … legacy data systems into scalable architectures. Proven ability to design and build data pipelines using Spark and Python or SQL. Strong understanding of data modelling, including star and snowflake schemas. Experience working with BI tools and semantic layers such as Looker or similar platforms. Familiarity with version control ...

existing ELT pipelines Skills and Experience: Essential to have 3+ years experience in: SQL Python DBT Cloud techs such as Snowflake, BigQuery or Databricks Dimensional Modelling such as Kimball Desirable to have experience with: CI/CD pipelines Kafka; real-time streaming Snowflake as a data warehouse Interview ...

processes that support scalable analytics and reporting Your Skills and Experience Strong commercial experience as a Data Engineer with solid foundations in SQL and dimensional modelling Experience working with Snowflake or similar cloud data warehouses such as BigQuery Good Python capability, including orchestration tools such as Airflow Proven ...