18 of 18 Star Schema Jobs in the South East

processes to integrate data from multiple sources. Develop and maintain Power BI dashboards and reports that provide actionable business insights. Implement data models (star schema, snowflake schema) optimized for analytics and reporting. Ensure data quality, consistency, and governance across the data warehouse. Optimize query performance and data ...

Development Design and develop enterprise data warehouse solutions using Azure SQL Database/Azure SQL Managed Instance/Azure Synapse Analytics. Build and maintain star and snowflake schemas for analytical workloads. Develop ETL/ELT pipelines for ingesting and transforming data from multiple source systems. Implement data partitioning, indexing … Analysis Expressions). Experience with Power BI semantic models or Azure Analysis Services/SQL Server Analysis Services (SSAS). Strong data modeling skills (star schema, dimensional modeling). Azure & Data Engineering Experience with: Azure Synapse Analytics Azure Data Factory or similar ETL tools Azure Storage/Data ...

scale processing Support the development and optimisation of Power BI datasets, reports and dashboards Build and maintain scalable semantic data models including dimensional and star schema structures Ensure strong data quality, governance and testing standards across all BI and data engineering solutions Skills and Experience Hands-on expertise ...

scale processing Support the development and optimisation of Power BI datasets, reports and dashboards Build and maintain scalable semantic data models including dimensional and star schema structures Ensure strong data quality, governance and testing standards across all BI and data engineering solutions Skills and Experience Hands-on expertise ...

scale processing Support the development and optimisation of Power BI datasets, reports and dashboards Build and maintain scalable semantic data models including dimensional and star schema structures Ensure strong data quality, governance and testing standards across all BI and data engineering solutions Skills and Experience Hands-on expertise ...

including indexing, optimisation and partitioningBackground in financial or investment data environmentsAdvanced SQL and Python skillsExperience migrating data from platforms like DatabricksConfident with dimensional modelling, star schemas, SCDs etc.Experience within regulated financial servicesDesirableExperience in pensions, asset management or institutional investingUnderstanding of performance measurement and attributionExposure to Airflow or dbtCloud platform ...

experience with Power BI Strong DAX knowledge Strong SQL skills for data exploration and transformation Experience with Power Query (M) Strong data modelling skills (star schema, dimensional modelling, relationships, etc.) Experience designing structured reporting datasets Ability to translate business questions into structured data models Experience defining KPIs ...

implemented Bronze/Silver/Gold medallion architecture Made architectural decisions and produced Architecture Decision Records (ADRs) Data Engineering & Modelling Dimensional modelling (Kimball) , star schemas SCD Type 2 MDM concepts (entity resolution, golden records) Batch & incremental ETL/ELT pipelines File-based ingestion (CSV/XLS) with error handling ...

developing Power BI reports, data models and DAX measures Modernising existing Excel-based reporting into scalable BI solutions Implementing best practice dimensional modelling (star schema) Creating and managing trusted datasets and reusable metrics Supporting the organisation’s transition toward Microsoft Fabric Working with stakeholders to translate reporting requirements ...

Silver/Gold), data pipelines, and OneLake storage. Querying & Modelling: Exposure to SQL or Spark SQL for querying data models, alongside a familiarity with Star Schema principles. Platform Concepts: An understanding of ETL/ELT concepts with the ability to troubleshoot (rather than design) complex architectures. Soft Skills ...

primary escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation ...

experience in data engineering, including 5+ years of people management and technical leadership experience. Deep understanding of Ralph Kimball dimensional modelling best practices, including star schema design and data cube modelling to support scalable analytics and reporting. Experience building and optimising cloud-based data platforms and scalable data ...

Code/SOLID principles). AWS: EMR, Glue, S3, Athena, IAM, Lambda. Data Modeling: SCD Type 2, Fact/Dimension tables, Data Vault/Star Schema. Legacy: Proficiency in reading/debugging SAS (Base, Macros, DI Studio). DevOps: Git-based workflows, Jenkins/GitLab CI, Terraform. Randstad Technologies ...

have Databricks experience Strong experience with relational and big data engines Knowledge of good data pipeline implementation and design (Concepts such as Kimball/Star Schema) Strong understanding Data warehousing concepts and modelling Proper documentation Good understanding of Agile ways of working Data Engineer, Azure, Databricks, ADF Reasonable ...

have Databricks experience Strong experience with relational and big data engines Knowledge of good data pipeline implementation and design (Concepts such as Kimball/Star Schema) Strong understanding Data warehousing concepts and modelling Proper documentation Good understanding of Agile ways of working Data Engineer, Azure, Databricks, ADF Reasonable ...

Role * Design and build Power BI dashboards with a strong focus on visual design and user experience * Develop well-structured data models using star schema principles * Write efficient DAX measures and calculated columns * Build and maintain Power Query transformations for data preparation * Define and maintain design systems, templates ...

Excellent data analysis and profiling skills, with the ability to interpret and draw insights from complex datasets. Experienced in implementing analytical modelling techniques, including star schemas and wide-table designs. Background working in Telecommunications, particularly within commercial or marketing analytics teams. Exceptional communication abilities and strong stakeholder management skills. ...

Power BI Developer will: * Build high quality Power BI dashboards and reports for client projects and internal initiatives. * Develop structured data models, including star schemas, to ensure scalable and efficient reporting. * Use DAX, calculated measures and Power Query to transform and optimise data. * Support improvements to BI standards, design ...