16 of 16 Contract Dimensional Modelling Jobs

semantic models, including star schemas, relationships, measures, and row-level security. Create and maintain dataflows and shared datasets to support enterprise reporting. Data Modelling & Architecture Apply dimensional modelling principles to support analytical workloads. Work with data engineers to design and document technical solutions. Ensure interoperability with … practices to support BI capability development. Documentation Produce and maintain business requirement documents, technical design documents, implementation notes, and user guides. Understanding of data modelling techniques for relational and dimensional databases (e.g. dimensional modelling theory) Knowledge or experience of ORACLE or Microsoft SQL Server databases including ...

batch processing Desirable Skills Working knowledge of SAS (especially in ETL context) Experience in migrating SAS workloads to Informatica ETLs Familiarity with data modelling (dimensional modelling/star schema) Exposure to scheduling tools (e.g., Control-M, Autosys) Understanding of data governance and data quality frameworks ...

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

Data Engineers, Business Analysts, and Power BI Developers to ensure data is structured, governed, and optimised for business use. Key Responsibilities Design and develop dimensional data models and datamarts Translate business requirements into logical and physical data models Optimise data structures for Power BI reporting and analytics Collaborate with … maintain metadata, data dictionaries, and documentation Support data governance, quality, and consistency initiatives Ensure data integrity through testing and validation activities Contribute to data modelling standards and best practices Essential Skills & Experience Strong experience in Data Modelling and Data Warehousing Expertise in dimensional modelling techniques Experience ...

notebooks Serverless SQL Synapse Pipelines Azure Data Factory Azure DevOps, including Repos, YAML Pipelines, CI/CD and Release Management SQL Data Warehousing and dimensional modelling Building and deploying enterprise-scale data engineering solutions Working directly with business stakeholders to gather requirements and own technical delivery Highly desirable ...

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

that data structures are robust, governed, and aligned with organisational data standards and architecture principles. Essential Skills & Knowledge: Demonstrable experience of: * Designing and developing dimensional data models and datamarts to support reporting and analytics use cases* Translating business requirements and user stories into logical and physical data models aligned … reporting needs* Applying best-practice dimensional modelling techniques to optimise usability and performance* Collaborating with Data Engineers to ensure data pipelines and transformations deliver clean, reliable, and appropriately structured data* Defining and maintaining data definitions, metadata, and data dictionaries to support consistent understanding and reuse* Ensuring data models ...

Agentic AI. Strong experience Must have prior experience with end-to-end implementation of Cloud data technologies (i.e.Fabric, Snowflake). Expertise in data modelling, ELT and implementing complex stored Procedures. Expertise in various Snowflake technologies like Snowpark, SnowPipe, SnowPipe Stream, Dynamic Tables, Document AI, Cortex Analytics, Unistore etc. Expertise … systems, Salesforce, GIS, PI Historian to Snowflake. Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modelling and third normal form) Experience with data security and data access controls and design Deep understanding of SoX, GDPR and Regulatory/ ...

tools such as Apache Airflow or similar. Experience implementing CI/CD pipelines using Git, Azure DevOps, GitHub Actions, or Jenkins. Good understanding of dimensional modelling, data warehousing, and modern data architecture. Experience with data quality, lineage, metadata management, and governance. Familiarity with Agile delivery methodologies. ...

Fabric Integrate and transform Salesforce data into a unified data platform. Develop and optimise ETL/ELT processes for performance and scalability. Implement data modelling best practices (star schema, dimensional modelling). Collaborate with stakeholders to translate business requirements into technical solutions. Key Requirements Proven experience ...

Fabric Integrate and transform Salesforce data into a unified data platform. Develop and optimise ETL/ELT processes for performance and scalability. Implement data modelling best practices (star schema, dimensional modelling). Collaborate with stakeholders to translate business requirements into technical solutions. Key Requirements Proven experience ...

Fabric Integrate and transform Salesforce data into a unified data platform. Develop and optimise ETL/ELT processes for performance and scalability. Implement data modelling best practices (star schema, dimensional modelling). Collaborate with stakeholders to translate business requirements into technical solutions. Key Requirements Proven experience ...

Engineering Proven experience creating trusted analytics outputs from curated datasets Strong understanding of KPI definition, metrics and business logic Experience working with semantic or dimensional models Exposure to governed, production-focused data environments Technical Skills: Advanced SQL KPI/metric design and governance Data modelling (dimensional/ ...

Collaborate with operational teams to identify and surface key data for dashboards. Develop and implement data validation checks and quality control measures. Assist in modelling and structuring data in the new system for optimal visualisation. Provide technical expertise to enhance data reliability, traceability, and overall quality. Essential Skills … Experience : Strong experience with Snowflake and Data Warehousing. Proficiency in SQL and Azure Data Factory. Familiarity with data flows, dimensional modelling, and Power BI. BA background highly advantageous. Knowledge of KQL and DAX is desirable. Desirable Attributes : Experience in a regulated industry or with investment/financial data. ...

visual clarity * Translating user stories and acceptance criteria into effective reporting and analytical solutions * Designing and developing semantic models aligned to best-practice dimensional modelling approaches (e.g., star schema principles) * Collaborating with Business Analysts and Data Engineers to ensure requirements are clear and underlying data structures support reporting … testing and validation activities, including resolving defects and ensuring outputs meet acceptance criteria * Contributing to user adoption through demonstrations, guidance, and support materials * Using dimensional models and understanding how model design impacts performance and usability * Managing Power BI Service environments, including security and deployment processes * Data governance, accessibility standards ...

skills, including working with structured and semi-structured data Experience validating and querying data using tools such as Athena and notebooks Understanding of data modelling concepts, including dimensional models and slowly changing dimensions Ability to generate realistic test data for various scenarios Additional Knowledge Understanding of distributed data ...