26 to 50 of 66 Remote/Hybrid Dimensional Modelling Jobs

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

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

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

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

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

Python Experience developing and optimizing batch and real-time data processing solutions Strong understanding of modern data architecture patterns, including Kimball, Data Vault, dimensional modelling, and data product design principles Experience implementing Infrastructure as Code using tools such as Terraform or CloudFormation Experience leading technical delivery teams ...

Python Experience developing and optimizing batch and real-time data processing solutions Strong understanding of modern data architecture patterns, including Kimball, Data Vault, dimensional modelling, and data product design principles Experience implementing Infrastructure as Code using tools such as Terraform or CloudFormation Experience leading technical delivery teams ...

Python Experience developing and optimizing batch and real-time data processing solutions Strong understanding of modern data architecture patterns, including Kimball, Data Vault, dimensional modelling, and data product design principles Experience implementing Infrastructure as Code using tools such as Terraform or CloudFormation Experience leading technical delivery teams ...

Delivery: Experience working in a consultancy, systems integrator, or client-facing setting with direct accountability to project delivery outcomes. Data Modeling: Solid depth in dimensional modeling, NoSQL schemas, and lakehouse/medallion architecture patterns. Data Governance & Operations: Practical experience implementing data catalogues, lineage, access controls, data quality checks ...

models, supporting data migration initiatives, and helping shape the target data architecture. Key Responsibilities Design conceptual, logical and physical data models. Define data standards, modelling practices and governance frameworks. Work closely with Data Engineers, Solution Architects and business stakeholders. Support migration from legacy systems to modern cloud-based data … data quality and governance requirements. Produce architecture and design documentation. Model and analyse data from Salesforce and associated enterprise systems. Essential Experience Strong Data Modelling experience (Conceptual, Logical & Physical). Enterprise Data Architecture expertise. Hands-on experience with Salesforce data models , objects and integrations. Data warehousing and dimensional ...

into practical reporting and analytical solutions. Supporting the development of self‐service analytics. Mentoring BI Developers and providing guidance on Power BI, DAX, data modelling and development standards. Conducting code reviews and quality‐assurance activities. Communicating technical recommendations clearly to both technical and non‐technical stakeholders. What … complex enterprise environment. Expert knowledge of Power BI Desktop and Power BI Service. Advanced experience with DAX, Power Query and SQL. Strong knowledge of dimensional modelling, star‐schema design and semantic models. Experience with Power BI administration, workspace management, dataflows and deployment pipelines. Experience working with cloud ...

datasets, semantic models, dashboards and reports Build ETL/ELT processes using Azure Data Factory and SQL Server Develop data warehouse solutions and dimensional models Translate business requirements into effective technical solutions Analyse data from multiple sources to deliver meaningful insight Apply data quality, governance, testing and documentation standards … dashboards and semantic models Strong SQL and Microsoft data platform experience Experience with Azure Data Factory and SQL Server Knowledge of data warehouses and dimensional modelling Experience translating business requirements into technical solutions Understanding of data quality, governance and testing Strong communication skills with technical and non-technical ...

learning and AI to accelerate change across our industry. This role is an opportunity to apply and develop your expertise in analytics engineering, data modelling and visualisation to build, extend and maintain the analytics and reporting capabilities that are central to decision making across Canopius. You will contribute … reliable and aligned to approved sources. Document solutions clearly, including data sources, logic, refresh schedules, access requirements and support considerations. Follow team standards for modelling conventions, naming, testing, deployment and version control, contributing suggestions for improvement where appropriate. Support the rationalisation and redevelopment of legacy reporting solutions as part ...

data models. The successful candidate will have strong hands‐on Power BI development experience, advanced DAX capability, and a solid understanding of data modelling best practice, including star schema design. You will be comfortable working across Power BI Desktop, Service, and Premium, and ideally bring experience with Microsoft Fabric … filter context and time intelligence. Power Query/M Language – Experience building and maintaining data transformation processes and integrating data from multiple sources. Data Modelling (Star Schema Design) – Good understanding of dimensional modelling principles, including creating efficient and user‐friendly data models. Microsoft Fabric & Direct Lake Mode ...

monitor moderately complex data pipelines and data models in production independently Model finance data across data warehouse layers using Data Vault and Kimball dimensional modelling Write transformations in SQL and Python, orchestrate workflows (Airflow/Dagster), and manage IaC via Git and CI/CD pipelines Connect disparate … strong SQL skills with performance tuning Hands-on experience with Snowflake, AWS, S3 and with Dagster or Airflow Experience with ETL/ELT, Kimball modelling, Git (GitHub/GitLab), and CI/CD Strong data quality mindset and ability to work in Agile environments Excellent written and verbal English ...

writing complex queries and stored procedures Hands-on experience with Power BI, Tableau or a similar BI platform Experience building data models (star schema, dimensional modelling) - desirable Familiarity with ETL tools and processes Experience with Azure Data Factory, SSIS or similar - desirable Strong stakeholder management and communication skills ...

procedures. Preferred Qualifications Google Cloud Professional Data Engineer, Professional Cloud Developer, Associate Cloud Engineer, or another relevant Google Cloud certification. Experience with data modeling, dimensional modeling, ETL or ELT pipelines, data quality controls, metadata, lineage, and enterprise data governance. Experience modernizing legacy reporting applications and validating data, calculations, security ...

Strong expertise in GCP architecture (BigQuery, Dataflow, Pub/Sub, IAM, Composer). Proven experience designing complex, cross-team, enterprise-scale solutions. Advanced data modelling (3NF, Data Vault, dimensional modelling). Deep understanding of metadata, lineage, data governance, and reference data frameworks. Strong experience with finance data ...