51 to 75 of 139 Dimensional Modelling Jobs

quality. Develop and maintain Gold Layer data marts in BigQuery using dbt Core, with a strong grasp of top-down/bottom-up data modelling methodologies (Kimball, OBT, or equivalent). Build and maintain Airflow-orchestrated ELT workflows across the retail media data platform, including attribution pipelines supporting campaign … with dbt Core (or dbt Cloud) and Airflow for orchestration and transformation at scale. Solid grounding in data warehouse and data lake architecture, including dimensional modelling and layered architectures (Gold/Silver/Bronze or equivalent). Production experience with GCP (BigQuery, Dataflow, GCS) and AWS (S3, Iceberg ...

Fabric (preferred) Advanced SQL development and performance tuning skills Experience with Python, PySpark, or Scala for data processing Knowledge of data warehousing concepts and dimensional modelling Experience with CI/CD pipelines using Azure DevOps or GitHub Understanding cloud architecture and distributed data processing Data Management Experience with ...

Vault integration, encryption, and network security. Experience implementing enterprise data quality frameworks, monitoring, observability, and operational dashboards. Strong understanding of data modeling techniques including dimensional modeling, Data Vault, medallion architecture, and enterprise data warehouse concepts. Strong knowledge of Azure Data Lake Storage Gen2, Azure Key Vault, Azure Monitor, Microsoft ...

/ELT practices. Experience working with modern cloud data platforms and orchestration technologies. Experience within the Microsoft data ecosystem would beadvantageous. Experience of data modelling for reporting and analytics, including dimensional modelling and designing datasets for downstream consumption. Experience with modern engineering practices including Git-based source ...

Data & Analysis standards Ensure compliance with company data governance, risk and security policies Support the BI Manager and BI Analysts with data engineering, architecture, modelling and best practices Help upskill the BI team and promote consistent data and BI practices across the organisation ESSENTIAL SKILLS AND EXPERIENCE Strong experience … data engineering, including ETL/ELT, data pipelines and modern cloud data platforms Strong understanding of data warehousing, dimensional modelling, Kimball principles and data architecture Advanced SQL/T-SQL skills, including query development, optimisation and troubleshooting Strong Python, PySpark or similar programming skills for data manipulation ...

architecture and delivery in a business with limited existing data capability Strong SQL and Python or PySpark skills, with practical experience of ELT pipelines, dimensional modelling, source control and CI/CD Experience putting data governance and self-service BI into practice, including ownership, quality standards, training … user adoption Microsoft Fabric experience, or transferable Azure Synapse or Databricks Lakehouse experience, including an understanding of medallion architecture Strong Power BI semantic modelling and DAX skills, sufficient to take responsibility for shared datasets and business measures Ability to work as the sole senior data specialist, gather requirements from ...

with Azure Databricks and Azure SQL/SQL Server to process and manage large datasets. Design and implement data models using Kimball, 3NF and dimensional modelling approaches. Develop metadata-driven pipelines to improve automation and efficiency. Work closely with technical teams and clients to understand data requirements ...

with Azure Databricks and Azure SQL/SQL Server to process and manage large datasets. Design and implement data models using Kimball, 3NF and dimensional modelling approaches. Develop metadata-driven pipelines to improve automation and efficiency. Work closely with technical teams and clients to understand data requirements ...

insights, and operational decision‐making. Knowledge of Microsoft Fabric architecture, including OneLake, Lakehouses, Warehouses, Pipelines, and Notebooks. Understanding of business intelligence best practices, including dimensional modelling, data warehousing, and data governance. Experience supporting mission‐critical systems with a strong focus on uptime, stability, and service excellence. Working knowledge ...

implementing solutions on AWS data and analytics platforms.* Proven expertise in data integration and analytics platforms on AWS, with strong understanding of data warehousing, dimensional modelling, and lakehouse/data lake concepts.* Experience with AWS cloud platform, including Amazon S3, AWS Lake Formation, AWS Glue, Amazon Redshift, Amazon ...

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

with other members of the IT and development teams. What We’re Looking For Essential Hands-on experience with Power BI Desktop, including data modelling, Power Query and report development. Good working knowledge of DAX, including an understanding of measures, filter context and relationships. Good SQL development skills, including … joins, aggregations, and window functions. Good understanding of dimensional modelling, including facts, dimensions and star-schema design. Experience working with relational databases and data warehouse environments. Strong attention to detail and a disciplined approach to validating the accuracy and consistency of data. Ability to investigate discrepancies between reports ...

data layers Lead schema design, model validation, scalable partitioning, and metadata-driven SQL frameworks Hands-on ownership of the most complex implementation work Data Modelling & Design Define and evolve data models powering SCV, segmentation, AI features, and analytics Work across dimensional, event-based, and ML-aligned data structures … line management experience — not just technical leadership Track record of building or improving engineering processes and team structures Expertise in SQL pipelines, Python orchestration, dimensional modelling, and star/snowflake schemas Experience with cloud data infrastructure, CI/CD automation, and metadata frameworks Comfortable working across product ...

including S3, Lambda, Glue, Athena, Kinesis, RDS, IAM and CloudWatch. Lakehouse architectures and open table formats such as Iceberg. Medallion-style data layering and dimensional modelling. Strong SQL and Python development skills. Infrastructure as code using Terraform. CI/CD, automated testing and modern engineering practices. SQL Server, SSIS ...

including S3, Lambda, Glue, Athena, Kinesis, RDS, IAM and CloudWatch. Lakehouse architectures and open table formats such as Iceberg. Medallion-style data layering and dimensional modelling. Strong SQL and Python development skills. Infrastructure as code using Terraform. CI/CD, automated testing and modern engineering practices. SQL Server, SSIS ...

business insights. Develop DAX measures, KPIs and calculations. Support self-service reporting capabilities across business departments. Optimise report performance and user experience. Data Integration & Modelling Integrate data from multiple sources including CRM, ERP, finance, operational, marketing, web and third-party platforms. Design and maintain logical and physical data models … Analytics Engineer or similar role. Strong experience with Microsoft Fabric (Desired). Experience developing and supporting Fabric Pipelines. Advanced Power BI skills including data modelling, DAX, Power Query and semantic models. Experience integrating and analysing data from multiple business systems and data sources. Strong SQL skills and experience working ...

better time to join Smiths. Design, build and deploy interactive Power BI dashboards and reports. Develop robust data models using star schema and dimensional modelling principles. Create and optimise DAX measures for performance and scalability. Deliver ETL processes across SAP, databases and other data sources. Gather and translate … Power BI assets in line with evolving business needs. Establish data quality checks and monitoring mechanisms. Use advanced Excel (Power Query, complex formulas, data modelling) to support reporting and automation. Qualifications Required Skills & Experience Significant experience in Data Analytics or BI development. Strong expertise in Power BI (Desktop & Service ...

+ benefits This is a rare opportunity to join an organisation undertaking a major data and digital transformation, with a clear path from data modelling into data architecture. You will step into a role designed for long‐term growth, working closely with senior architects and influencing how data … support key business initiatives Contribute to the design and evolution of data architecture standards and best practices Work across multiple projects, ensuring consistency in modelling approaches and data structures Collaborate with data engineers, analysts, and governance teams to deliver high‐quality data solutions Support the transition towards modern, cloud ...

+ benefits This is a rare opportunity to join an organisation undertaking a major data and digital transformation, with a clear path from data modelling into data architecture. You will step into a role designed for long‐term growth, working closely with senior architects and influencing how data … support key business initiatives Contribute to the design and evolution of data architecture standards and best practices Work across multiple projects, ensuring consistency in modelling approaches and data structures Collaborate with data engineers, analysts, and governance teams to deliver high‐quality data solutions Support the transition towards modern, cloud ...

models and build cloud data pipelines on Snowflake and AWS Requirements Previous experience in Data Engineering, Analytics Engineering or Data Platform Engineering Strong data modelling, including conceptual, logical, physical and dimensional modelling Proficiency in SQL Previous technical experience with Snowflake and AWS Experience building and maintaining production ...

quality. Collaborate with colleagues through knowledge sharing, peer review, coaching and practical technical guidance. Skills and Experience Strong proficiency in SQL, relational data concepts, dimensional modelling and ELT design patterns. Proficiency with Azure-native data services, particularly Azure Databricks and Azure Data Factory. Working knowledge of Python … branching strategies and automated build and release pipelines. Experience implementing testing, monitoring, operational controls and data quality checks. Working knowledge of Power BI, semantic modelling and DAX. Ability to gather and refine business requirements, working autonomously and collaboratively as appropriate, to produce proportionate technical designs. Experience estimating, planning ...

products, customers, suppliers, and stores, establishing authoritative sources and harmonization patterns across systems together with master data responsible. Establishing data quality measures and modelling standards embedded in architectural patterns: operational schemas in bronze, conformed and dimensional entities in silver, and consumption-ready models in gold. Reviewing key physical … ensuring consistent understanding across technical and business stakeholders. Mentoring teams on data architectural best practices while documenting anti-patterns to avoid common pitfalls in dimensional modelling and naming standards. Qualifications Proven experience designing enterprise-scale information architectures (multi-source, multi-domain at scale) that successfully went into production. ...

Working with business stakeholders and providing technical leadership through delivery What You'll Bring Extensive hands-on Snowflake experience, with strong dbt for transformation, modelling and deployment Python for data engineering, particularly loading and processing files Solid grounding in data warehousing, dimensional modelling, source control ...

level security (RLS). What You Bring Significant hands on experience productionising Power BI reports and managing live estates. Deep expertise in DAX, dimensional modelling (star schema), and layered data architectures. Demonstrable excellence with SQL Exposure to Microsoft Fabric, Azure Synapse, or Azure Data Factory High technical rigor ...

solutions. Extensive experience with Azure SQL, Azure Data Factory, Power BI and Azure DevOps Demonstrable experience delivering greenfield data platform implementations. Strong understanding of dimensional modelling and data warehouse design principles. Experience implementing scalable, secure and maintainable cloud architectures. Experience establishing CI/CD pipelines and DevOps practices ...