1 to 25 of 171 Dimensional Modelling Jobs

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

scalability. Validate ETL processes, including during source system software upgrades, to ensure continuity and data integrity. Design and maintain the reporting layer, including dimensional modelling, to support efficient and reusable analytics. Apply expert T-SQL and SQL Server skills for query optimisation and advanced data manipulation. Support … processes that embed data quality monitoring within routine reporting and governance structures. Contribute to the implementation of advanced analytics methods such as predictive analytics, modelling including AI, Python, and R, to help drive innovation. The postholder will be line managed by the Principal BI Developer and will work closely ...

behind every report and every operational data feed at ECP, continue the migration of our data warehouse and data lake to a modern dimensional model, finish the rollout of a principle-of-least-privilege security model across a multi-server SQL estate, and continue the migration of our reporting … will include: Setting and personally delivering target architecture for the ECP data estate the data warehouse, data hub, data lake, raw/ODS layers, dimensional model, audit and schema-change tracking, and the load schedules that tie them together. Hands-on T-SQL, stored procedure, ETL framework and PowerShell ...

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

requirement for a Data Solution Architect to design, lead and deliver scalable, enterprise-grade data platforms. This role requires deep expertise in data architecture, dimensional data modelling (Kimball) and modern cloud-based data ecosystems (ideally Databricks) . Core Technical Expertise Strong experience in data solution architecture within enterprise … environments Proven hands-on expertise in data warehousing concepts and implementation Deep knowledge of Kimball dimensional modelling methodology. Platforms & Tools Experience with Databricks (preferred) or similar platforms: Snowflake, BigQuery, Redshift, Synapse, or equivalent Strong proficiency with: SQL (advanced level) Spark/PySpark Data pipeline orchestration tools (e.g., Airflow ...

Translate business requirements into structured and scalable data models in collaboration with Data Analysts and stakeholders. Provide guidance to Data Engineers on data structures, modelling patterns, and data granularity requirements. Promote consistency, reusability, and standardisation of data models across multiple business domains. Support data governance initiatives, including metadata management … data quality practices. Collaborate with architecture and engineering teams to optimise data design for cloud-based platforms. Contribute to the development and maintenance of modelling standards, frameworks, and best practices. Support the delivery of data products that enable analytical, operational, and regulatory reporting requirements. Essential Skills, Knowledge and Experience ...

advanced analytics or ML use cases where relevant. About You We are looking for a rigorous data engineer with strong experience in integration, modelling and delivering reliable, well-documented data solutions. You should be confident moving data from operational systems into governed analytical environments, with strong attention to quality … Fabric skills and proven experience building robust automated data pipelines. Experience with lake, lakehouse, warehouse or similar analytical platforms. Strong grasp of data modelling, quality, documentation, lineage and governance. Understanding of secure data access, GDPR and privacy-preserving methods. Ability to create trusted data assets for reporting, analytics ...

move and expose data safely and reliably. Agile ways of working with Jira/Confluence; clear stakeholder communication and concise technical documentation. Data warehousing & modelling (e.g., Redshift; dimensional modelling). Basic Power BI familiarity to partner with BI developers and validate end-to-end data flows. ...

hybrid role.Key Responsibilities: Design, build, and maintain data solutions using Microsoft Fabric. Develop and optimise data pipelines, Lakehouses, and Data Warehouses. Create and maintain dimensional data models and semantic models. Support Power BI reporting and analytics requirements. Ensure data quality, performance, security, and governance. Collaborate with business stakeholders … deliver scalable data solutions. Required Skills: Minimum 2 years' experience working with Microsoft Fabric. Strong experience in data modelling (Star Schema, dimensional modelling). Strong SQL skills and experience with data warehousing concepts. Experience with Power BI and semantic models. Knowledge of ETL/ELT processes ...

Scala for data processing and automation. Experience with BI and visualisation tools such as Power BI, Tableau, or Looker. Understanding of data warehousing concepts, dimensional modelling, and modern data architecture. Experience integrating APIs and third-party SaaS platforms. Must have excellent stakeholder management and communication skills, with ...

Experience with high-scale cloud data platforms and with at least one major cloud provider (AWS, Azure, or GCP) Expert knowledge of data integration, dimensional modeling and data warehousing techniques. Experience implementing CI/CD pipelines for data Proficiency in Java, SQL Experience with Snowflake Preferred Qualifications: Experience with ...

Experience with high-scale cloud data platforms and with at least one major cloud provider (AWS, Azure, or GCP) Expert knowledge of data integration, dimensional modeling and data warehousing techniques. Experience implementing CI/CD pipelines for data Proficiency in Java, SQL Experience with Snowflake Preferred Qualifications: Experience with ...

Experience with high-scale cloud data platforms and with at least one major cloud provider (AWS, Azure, or GCP) Expert knowledge of data integration, dimensional modeling and data warehousing techniques. Experience implementing CI/CD pipelines for data Proficiency in Java, SQL Experience with Snowflake Preferred Qualifications: Experience with ...

services across at least one major cloud provider (GCS, S3, Azure Blob Storage, Cloud Spanner, Redshift, or equivalent). Understanding of data modeling principles (dimensional modeling, data vault, or similar) and schema design for analytical workloads. Familiarity with data governance concepts - cataloging, lineage, access controls, retention - and their application ...

services across at least one major cloud provider (GCS, S3, Azure Blob Storage, Cloud Spanner, Redshift, or equivalent). Understanding of data modeling principles (dimensional modeling, data vault, or similar) and schema design for analytical workloads. Familiarity with data governance concepts - cataloging, lineage, access controls, retention - and their application ...

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

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

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

Terraform, CI/CD pipelines, and Infrastructure as Code. Git/GitLab and modern software development practices. API integration and data services. Data warehousing, dimensional modelling, and dbt. Power BI familiarity. Experience working within government or highly regulated environments. What's In It For You? Opportunity to work ...

tooling Dataflow or modern ingestion frameworks Experience designing and building scalable data ingestion and pipeline automation solutions Strong understanding of semantic layer development and dimensional modeling concepts Advanced SQL and Python development skills Experience with ELT/ETL pipeline design, orchestration, and optimization Familiarity with CI/CD pipelines ...

with data quality observability tools such as Soda or similar. Proficient in version control and CI/CD workflows using GitHub. Advanced understanding of dimensional modeling and data warehousing concepts. Comfortable leading efforts in agile environments and strong ownership and collaboration. Pay Rate: $65.00-$70.00/Hour. If hired ...

relationships. • The Contractor shall handle semi-structured data (JSON and XML); and transform into structured datasets with consistent schemas. • The Contractor shall design dimensional models, data warehouses, and data marts following industry methodologies. • The Contractor shall create conceptual, logical, and physical data models optimized for query performance and storage ...

assets to deliver high-performing, low-latency analytics at scale. Provide technical guidance through code reviews and mentorship, raising standards across data modelling and visualisation. Your Skills and Experience Strong commercial experience in BI engineering, analytics engineering, or data engineering within a modern data stack. Advanced SQL capability, including … complex transformations, window functions, and performance optimisation. Proven experience working with cloud data warehouses such as Databricks, Snowflake, or BigQuery. Deep understanding of dimensional modelling techniques and tools such as dbt. Hands-on expertise with enterprise BI platforms, such as Power BI, Looker or Omni. Ability to communicate ...

including MS SQL Server 4 years of experience in DB Development (OLTP) using MS SQL 2 years of experience in building Data Marts using dimensional models 2 years of experience in building Dashboards and KPI visualization on Power BI and/or Tableau Strong reporting and data warehouse development ...

teams to deliver high-quality, trusted data products that support analytics, reporting, and emerging AI initiatives. Key Responsibilities Define and own enterprise-wide data modelling standards, including Data Vault, semantic layers, Star Schema patterns, Snowflake object hierarchies, and governance frameworks. Design scalable integration architectures for legacy platforms, including AS400 … implementing solutions within Snowflake. Demonstrated success delivering enterprise-scale data transformation programmes and modernising legacy data environments. Deep expertise in Data Vault 2.0, Kimball dimensional modelling, and Inmon methodologies, with the ability to select the right approach for varying business requirements. Advanced knowledge of dbt and Git-based ...