7 of 7 Permanent Dimensional Modelling Jobs in West Yorkshire

About the Platform: This greenfield initiative is focused on building a next-gen data ecosystem with a tech stack including: Snowflake for cloud data warehousing dbt for transformation and modelling Azure for cloud infrastructure and orchestration Fivetran for automated data ingestion Power BI and other modern BI tools for reporting and visualisation 🧠 What You’ll Do: Design and implement … BI developers to deliver insightful, high-performance dashboards Work with Data Engineers to optimise data ingestion and orchestration pipelines using Azure Data Factory and Fivetran Apply best practices in dimensional modelling, layered architecture, and data quality ✅ What We’re Looking For: Strong experience in data modelling and SQL Hands-on experience with dbt and cloud data platforms … like Snowflake or Azure Synapse Analytics Solid understanding of modern data stack principles , including layered modelling and data warehouse design Excellent communication skills and the ability to work with stakeholders across technical and non-technical teams Nice to have: Experience with Power BI or similar BI tools Familiarity with CI/CD practices in data environments Exposure to data More ❯

with data extracts, data analysis and data validation as required The role requires: In-depth working knowledge and experience working with relational databases Background in data warehouse design (e.g. dimensional modelling) and data analysis Advanced MS SQL Server skillset (T-SQL, stored procedures, functions, dynamic SQL) Proven experience of developing complex reports using SSRS or closely equivalent tools More ❯

Data Factory, Data Lake and SQL. Role & Responsibilities Building end to end data pipelines in Azure (Data Factory and SQL) Building workflows in SQL, Spark and DBT Data and dimensional modelling Skills & Qualifications Azure Data factory, Synapse and SSIS Python/Park/PySpark Ideally Snowflake and DBT More ❯

end-to-end technical BI delivery goals in focus Providing assistance to the technical team; offering technical solutions and answers to difficult and complicated business issues ETL scripting, data modelling, and report/dashboard delivery within BI tool Developing technical processes and strategy for business demands managed efficiently and effectively, giving both ad-hoc and strategic considerations to the … solutions Developing BI tool architecture including data presentation, data modelling, data blending, metadata, and semantic layer development and governance Supporting significant data and BI tool migration projects Ensuring BI reporting is governed to the highest degree in line with developed Business Glossary and Business Semantic Layer Supporting, promoting & managing Data Warehouse roadmap delivery through detailed requirements provision and building … KPIs, and dashboards Ability to review existing code and set up best coding practices and standards across all BI development Enhancing query and report performance Strong knowledge of relational & dimensional modelling with Kimball design Preparing technical artefacts such as Data Mapping, Data Lineage, Metadata, Logical and Physical Data Models for complex data structures Good understanding of end-to More ❯

technical BI delivery goals in focus Provide assistance to the technical team; be able to provide technical solutions and answers to difficult and complicated business issues. ETL scripting, data modelling and report/dashboard delivery within BI tool Develop technical processes and strategy for business demands managed efficiently and effectively, giving both ad-hoc and strategic considerations to the … solutions. Develop BI tool architecture including data presentation, data modelling, data blending, metadata and semantic layer development and governance Support significant data and BI tool migration projects Ensure BI reporting is governed to the highest degree in line with developed Business Glossary and Business Semantic Layer Support, promote & manage Data Warehouse roadmap delivery through detailed requirements provision and building … and dashboards Ability to review the existing code and set up best coding practices and standards across all BI development Enhancing query and report performance Strong knowledge of relational & dimensional modelling with Kimball design Preparing technical artefacts such as (but not limited to) Data Mapping, Data Lineage, Metadata, Logical and Physical Data Models for complex data structures Good More ❯

and direction based on findings Experience of building logical data models will be desired Knowledge of BI tools, such as Qlik, SSRS, Business Objects will be desired Knowledge of Dimensional Modelling - Kimball methodology will be desired Ability to rapidly understand business processes in detail Business/Numerical Honours degree or QBE or equivalent Effective communicator with good organisational More ❯

and direction based on findings Experience of building logical data models will be desired Knowledge of BI tools, such as Qlik, SSRS, Business Objects will be desired Knowledge of Dimensional Modelling - Kimball methodology will be desired Ability to rapidly understand business processes in detail Business/Numerical Honours degree or QBE or equivalent Effective communicator with good organisational More ❯