10 of 10 Contract Dimensional Modelling Jobs in the UK

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

Strong understanding of ETL processes and data validation techniques. - Experience with Azure Data Factory, including understanding pipelines, datasets, and data flows. - Knowledge of data modelling and dimensional modelling concepts. - Solid SQL skills, including writing and analysing complex queries. - Experience using Azure DevOps for test and defect management. ...

retesting, and reporting. Perform back-end data testing, analysing large datasets to identify data quality issues, inconsistencies, and root causes. Validate data models and dimensional models, ensuring data structures, relationships, and business rules are correctly implemented. Use SQL to interrogate databases, read schemas and tables, reconcile data, and verify … skills with the ability to write queries, interrogate databases, read schemas and tables, and perform data reconciliation and validation. Solid understanding of data modelling and dimensional modelling, including testing data relationships, facts, dimensions, and business rules. ISTQB Data Testing certification (or equivalent) and recent, demonstrable experience working ...

Collaborate with engineers, analysts and stakeholders to deliver practical solutions. Essential Skills Strong SQL and Snowflake experience. Data engineering and ETL/ELT development. Dimensional modelling (Kimball methodology). dbt development and engineering best practices. Azure Data Factory, Azure Functions and CI/CD. Python development for automation ...

Collaborate with engineers, analysts and stakeholders to deliver practical solutions. Essential Skills Strong SQL and Snowflake experience. Data engineering and ETL/ELT development. Dimensional modelling (Kimball methodology). dbt development and engineering best practices. Azure Data Factory, Azure Functions and CI/CD. Python development for automation ...

What you'll be doing Design, develop and 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 … Extensive commercial experience 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 ...

. Extensive SQL development and performance tuning expertise. Experience building and supporting ETL/ELT frameworks. Strong understanding of data warehousing concepts and dimensional modelling. AWS experience, including services such as S3, Glue, EMR, or PySpark . Knowledge of data governance, quality controls, and testing practices. Experience working within ...

engineering standards, design patterns, and development best practices. Database & Data Engineering Strong experience with SQL Server, PostgreSQL, and enterprise database platforms. Expertise in: Data modelling (OLTP, OLAP, dimensional models) Query optimization and performance tuning Database scalability and resilience Data governance and quality management Experience delivering large-scale ...

solution designs meet business requirements whilst aligning with architecture standards, governance frameworks and strategic objectives. The successful candidate will combine strong data architecture and modelling expertise with a broad understanding of Microsoft Azure data technologies and modern data platforms, enabling them to guide delivery teams and make informed design … ability to influence both technical and non-technical stakeholders. Proven experience designing conceptual, logical and physical data models. Strong knowledge of relational and dimensional modelling techniques. Experience undertaking data profiling and source system analysis. Experience designing enterprise data architectures and integration patterns. Ability to produce and review architecture ...

rule definition, thresholding, automated alerting, and root-cause remediation). Craft complex SQL transformations, optimize query performance, handle advanced window functions, and design conformed dimensional models for curated platform layers. Map end-to-end data flows from ingestion to serving, defining upstream/downstream contracts and data ownership boundaries. ...