17 of 17 Star Schema Jobs

scalable, future-proof data architectures and provide technical leadership across transformation programmes: Architecture & Design: Design enterprise data architectures for Snowflake and Azure cloud ecosystems Create dimensional data models (star schema, snowflake schema, Data Vault) supporting analytics and BI Define data strategy and governance frameworks – lineage, cataloging, security, compliance Lead solution design for data warehouse, data lake … technical challenges Conduct architecture reviews and design authority for data solutions Mentor engineers on best practices in data modeling, performance optimization, and cloud architecture ESSENTIAL SKILLS: Data Modeling expertise - Star schema, dimensional modeling, Data Vault, logical/physical design Snowflake Cloud Data Platform - Architecture design, performance tuning, cost optimization, governance Azure Data Factory - Pipeline architecture, orchestration patterns, best More ❯

duties as directed. Provide a list of the day to day tasks to be performed by the Selected Candidate: Perform Data profiling on the source systems Design and review star schema dimensional model to support data warehouse and data marts Perform Source to Target Mapping between source system database and data warehouse target database Develop analytics and reports … Services (SSIS) or other similar ETL tool 2. 36 months experience in analytics and operational reporting using Tableau and SQL Server Reporting Services (SSRS 3. 36 months experience in Star Schema/Dimensional Modeling to support data warehouse environments as well as OLTP environments. 4. 48 months experience developing and tuning complex SQL and PL/SQL against More ❯

have an advanced education. Requirements: 84 Months experience with developing and maintaining logical and physical dimensional data models, building data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc. 84 Months experience in a data modeling tool (e.g., ErWin, ER/Studio). 84 Months experience in relational data management disciplines and More ❯

data pipelines using Fabric Pipelines, Azure Data Factory, Notebooks and SSIS. Develop Power BI dashboards and paginated reports tailored to business needs. Model complex datasets into actionable insights using star schemas, snowflakes, and denormalised models. Optimise SQL queries and build semantic models within Fabric. Collaborate with cross-functional teams to translate business requirements into technical solutions. Support CI/ More ❯

Requirements Essential: Strong experience with SSRS, SSIS, SSAS, and Power BI Advanced SQL Server capabilities: T-SQL, stored procedures, and performance tuning Experience designing and building data warehouses and star schemas Strong ETL experience using SQL Server SSIS Proficiency with Power BI, including DAX and Power Query Experience with Visual Studio and Microsoft BI development tools Familiarity with source More ❯

proficiency in SQL - writing and optimizing complex queries, joins, window functions, performance tuning. Experience with dbt (or equivalent) - building models, tests, documentation, version control. Understanding of data warehousing concepts (star schemas, snowflake, slowly changing dimensions, partitioning, clustering). Experience working in a modern data stack (e.g. BigQuery, Snowflake, Redshift, Databricks, etc.) Comfortable working downstream (with BI/analytics users More ❯

Essential Skills and Experience Strong, proven experience in Power BI development within an Asset Management environment Strong, proven experience in advanced data modelling , DAX , and data transformation Expertise with star schemas , dimensional modelling semantic models , and dataflows Solid understanding of data security, access controls, and distribution practices Experience with data sources such as Snowflake , SQL , Databricks , and BW Knowledge More ❯

Essential Skills and Experience Strong, proven experience in Power BI development within an Asset Management environment Strong, proven experience in advanced data modelling , DAX , and data transformation Expertise with star schemas , dimensional modelling semantic models , and dataflows Solid understanding of data security, access controls, and distribution practices Experience with data sources such as Snowflake , SQL , Databricks , and BW Knowledge More ❯

in a fast-moving environment. Ability to build good, professional relationships, both internally and externally as a representative of Reed In Partnership. Technical skills: Snowflake Scheme Design, Kimball Methodology, Star Schemas Programmes: Snowflake More ❯

design, implementation, and testing of Microsoft BI technologies. Responsibilities Design, develop, implement, and maintain business intelligence using Microsoft BI technologies. Understand and implement data modeling using best practices and star schema design. Analyze complex data from multiple sources including SQL Server databases and Analysis Services Tabular models. Collaborate with business analysts and subject matter experts to gather requirements More ❯

Collaborate with stakeholders to understand requirements and deliver practical solutions. Ensure data quality and consistency across reporting pipelines. What We’re Looking For Power BI Expertise: Advanced data modelling (STAR schema, relationships, filter direction). Strong DAX skills for measures and calculations. Experience optimizing performance for large datasets. Excel Mastery: Advanced formulas (SUMIFS, COUNTIFS, text functions). Dashboard More ❯

Ensure documentation, data dictionaries, lineage, and governance standards are embedded across the team. Essential Skills Strong expertise with SQL , particularly Databricks SQL . Demonstrable experience designing data models (e.g., star schema) and scalable architecture. Knowledge of Azure Modern Data Warehouse tools: Synapse, Databricks, Delta Lake, Unity Catalog. Experience with pipeline orchestration (e.g., Synapse pipelines). Proven background in More ❯

will: Digest data requirements, gather and analyse large scale structured data and validate by profiling in a data environment Understand data structures and data model (dimensional & relational) concepts like Star schema or Fact & Dimension tables, to design and develop ETL patterns/mechanisms to ingest, analyse, validate, normalize and cleanse data Understand and produce ‘Source to Target mapping More ❯

analytics projects Manage multi-vendor and internal teams Ensure alignment with strategic objectives Essential Skills Leadership in multi-vendor environments BI/Warehousing & Agile Scrum expertise Data warehouse architecture (Star Schema, Kimball, Inmon) Project management (PRINCE2, PMP) & ITIL principles Strong stakeholder engagement & risk management Desirable Knowledge of emerging tech & MPP platforms Advanced data warehouse design experience Other Ability More ❯

analytics projects Manage multi-vendor and internal teams Ensure alignment with strategic objectives Essential Skills Leadership in multi-vendor environments BI/Warehousing & Agile Scrum expertise Data warehouse architecture (Star Schema, Kimball, Inmon) Project management (PRINCE2, PMP) & ITIL principles Strong stakeholder engagement & risk management Desirable Knowledge of emerging tech & MPP platforms Advanced data warehouse design experience Other Ability More ❯

Implement ingestion patterns for files, APIs, SaaS platforms (e.g. subscription billing), SQL sources, SharePoint and SFTP using ADF + metadata-driven frameworks . Apply Lakeflow expectations for data quality, schema validation and operational reliability. Curated Data Layers & Modelling Build clean, conformed Silver/Gold models aligned to enterprise business domains (customers, subscriptions, deliveries, finance, credit, logistics, operations). Deliver … star schemas, harmonisation logic, SCDs and business marts to power high-performance Power BI datasets . Apply governance, lineage and fine-grained permissions via Unity Catalog . Orchestration & Observability Design and optimise orchestration using Lakeflow Workflows and Azure Data Factory . Implement monitoring, alerting, SLAs/SLIs, runbooks and cost-optimisation across the platform. DevOps & Platform Engineering Build CI More ❯

Implement ingestion patterns for files, APIs, SaaS platforms (e.g. subscription billing), SQL sources, SharePoint and SFTP using ADF + metadata-driven frameworks . Apply Lakeflow expectations for data quality, schema validation and operational reliability. Curated Data Layers & Modelling Build clean, conformed Silver/Gold models aligned to enterprise business domains (customers, subscriptions, deliveries, finance, credit, logistics, operations). Deliver … star schemas, harmonisation logic, SCDs and business marts to power high-performance Power BI datasets . Apply governance, lineage and fine-grained permissions via Unity Catalog . Orchestration & Observability Design and optimise orchestration using Lakeflow Workflows and Azure Data Factory . Implement monitoring, alerting, SLAs/SLIs, runbooks and cost-optimisation across the platform. DevOps & Platform Engineering Build CI More ❯