1 to 25 of 34 Star Schema Jobs

design and delivery at scale (high level and detailed) and various architectural strategies Solid information architecture skills/experience: Data ingestions, and Data Warehouse and Date Lake modelling experience (Star Schema, Snowflake Schema, Data Vault etc.) Past hands-on development experience in at least one enterprise analytics database like Oracle/Terradata/SQL Server/Snowflake … design and delivery at scale (high level and detailed) and various architectural strategies Solid information architecture skills/experience: Data ingestions, and Data Warehouse and Date Lake modelling experience (Star Schema, Snowflake Schema, Data Vault etc.) Past hands-on development experience in at least one enterprise analytics database like Oracle/Terradata/SQL Server/Snowflake More ❯

design and delivery at scale (high level and detailed) and various architectural strategies Solid information architecture skills/experience: Data ingestions, and Data Warehouse and Date Lake modelling experience (Star Schema, Snowflake Schema, Data Vault etc.) Past hands-on development experience in at least one enterprise analytics database like Oracle/Terradata/SQL Server/Snowflake … design and delivery at scale (high level and detailed) and various architectural strategies Solid information architecture skills/experience: Data ingestions, and Data Warehouse and Date Lake modelling experience (Star Schema, Snowflake Schema, Data Vault etc.) Past hands-on development experience in at least one enterprise analytics database like Oracle/Terradata/SQL Server/Snowflake More ❯

a senior, you'll be responsible for mentoring MI Analysts, improving how operational reporting is delivered, and playing a key role in translating existing SQL-based reports into modern star-schema structures. You'll work across retail operations, smart metering, customer support, and market interaction, delivering insights that directly impact B2B customer performance and experience. What you'll … day leadership Owning the delivery of key operational reporting across smart meters, contact centres, faults, goodwill, and more Leading the transition of reporting from legacy SQL statements to new star schema models Building and optimising Power BI dashboards for improved speed, usability, and future self-serve functionality Collaborating with the business to deliver insights in line with agile … BI, including DAX, data modelling, and report optimisation Experience coaching or mentoring junior analysts in a structured environment Bonus if you've been involved in data warehouse redesigns or schema transitions Why this role? This is a genuinely exciting time to join. The MI function has moved away from central transformation and now sits closely aligned to the business More ❯

solutions on cloud-based data platforms such as Azure, Snowflake, Google Cloud, and related accelerators. Experience with developing and deploying containerised microservices architectures. Understanding of data modelling techniques, including star schema, snowflake schema, and third normal form (3NF). Proven track record with DevOps methodologies in data engineering, including CI/CD and Infrastructure as Code. Knowledge More ❯

pipelines handling diverse data sources. You'll work closely with our clients to design the correct data models to support their analytic requirements following best practices such as Kimball star schemas and snowflake schemas, ensuring performance and ease of use for the client. You'll manage the delivery of ETL/ELT processes using tools like Matillion, Informatica, or … GCP. Technical Skills Extensive experience with ETL/ELT tools (e.g. Matillion, Informatica, Talend) and cloud data platforms (e.g., Snowflake, Databricks, BigQuery). Expertise in data modelling techniques (e.g., star schema, snowflake schema) and optimising models for analytics and reporting. Familiarity with version control, CI/CD pipelines, and containerisation tools (e.g., Git, Jenkins, Docker, Kubernetes). More ❯

training to empower end users. PRINCIPAL MISSIONS Design and implement data pipelines using Azure Data Factory or Microsoft Fabric. Develop and maintain SQL-based transformations and data models (e.g., star schema, snowflakes) in SQL Server, Fabric Datawarehouse/Lakehouse. Build and optimize Power BI dashboards and reports to support business decision-making. Collaborate with stakeholders to gather requirements More ❯

of enterprise data management and governance principles. Proven experience delivering Business Intelligence (BI) solutions and dashboards to enable data-driven decisions. Experience designing relational and dimensional data models (e.g. star schema, snowflake, etc.). Proficient in ETL and data warehousing, including handling slowly changing dimensions. Excellent communication and interpersonal skills, with the ability to liaise confidently between technical More ❯

PE & PFE. · Experience working with large scale, multi-terabyte data warehouses including performance tuning, query optimization and execution plan analysis · Advanced knowledge of data warehousing principles, dimensional modelling and star schema design · Hands-on experience with SQL Server and Snowflake, including their architecture, features and best practices · Familiarity with data integration tools (SSIS, ADF) and techniques (ELT, ETL More ❯

/ETL pipelines that ingest data from network devices (IPDR, SNMP, OSS/BSS), CRM, finance, and IoT platforms into our BI warehousing environment. • Model data using Kimball/star schemas and data vault principles to support BI and self service analytics. • Implement data quality, lineage, and observability tooling (e.g., dbt tests, Great Expectations, Azure Purview). • Optimise storage More ❯

Responsibilities: Design and develop Power BI reports, dashboards and datasets that drive actionable insights using DAX and SQL to support analytical needs. Transform business requirements into technical specifications, applying STAR schema and Kimball dimensional modelling to optimise data structures for performance and usability. Collaborate with stakeholders to decentralise data access and empower decision-makers. Optimise performance of data More ❯

Criteria You'll need all of these. Experience of building a data warehouse using an ETL/ELT tool, preferably Oracle ODI Significant database experience in Snowflake or Oracle Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience of More ❯

Criteria You'll need all of these. Experience of building a data warehouse using an ETL/ELT tool, preferably Oracle ODI Significant database experience in Snowflake or Oracle Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience of More ❯

Criteria You'll need all of these. Experience of building a data warehouse using an ETL/ELT tool, preferably Oracle ODI Significant database experience in Snowflake or Oracle Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience of More ❯

Criteria You'll need all of these. Experience of building a data warehouse using an ETL/ELT tool, preferably Oracle ODI Significant database experience in Snowflake or Oracle Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience of More ❯

code (IaC) principles using Terraform to automate provisioning and configuration. Manage and optimize cloud resources to ensure cost-efficiency and performance. Design and implement efficient data models following a star schema approach to support analytical and operational workloads. Collaborate with data analysts to develop advanced analytics solutions. Conduct data quality analysis to drive better data management on outputs More ❯

of the data across the organisation. We need a few basics from you: Data pipeline creation Strong ETL development experience with Azure Data Factory Datawarehouse and data storage concepts - star schema/snowflake/Kimball Azure Databricks and AI Power BI reporting skills would be advantageous Strong stakeholder management experience After a few weeks of induction and meeting More ❯

Detail: Keep continuity across reports created by the team while maintaining accuracy and consistency, ensuring insights are reliable and actionable. Who we're looking for Knowledge Designing Kimball/star schema data models. Agile Methodology. Solar and BESS knowledge (Desirable) Qualifications Bachelor's degree in computer science, mathematics, statistics or engineering discipline. Microsoft Power BI Certification. Experience High More ❯

development experience in a client-facing or consultancy setting Strong command of DAX (CALCULATE, SUMX, VAR, FILTER, REMOVEFILTERS, time intelligence) Proficiency in SQL and solid understanding of tabular/star schema models Experience working with cloud platforms, ETL tools, and performance tuning Confident leading sessions with both technical and non-technical stakeholders Why Apply his is a key More ❯

development experience in a client-facing or consultancy setting Strong command of DAX (CALCULATE, SUMX, VAR, FILTER, REMOVEFILTERS, time intelligence) Proficiency in SQL and solid understanding of tabular/star schema models Experience working with cloud platforms, ETL tools, and performance tuning Confident leading sessions with both technical and non-technical stakeholders Why Apply his is a key More ❯

application SQL Server database performance and SQL tuning Experience in handling large databases Knowledge of column store indexes Very good SSRS skills Data warehouse experience, design of data marts, star schemas and type 2 slowly changing dimensions Data analysis skills Desirable Skills and Knowledge: Experience with tSQLt unit testing Understands the Agile software development lifecycle and working knowledge of More ❯

solutions that power advanced analytics and business intelligence. What You'll Do: Architect and build scalable data pipelines using Microsoft Fabric, PySpark, and T-SQL Lead the development of Star Schema Lakehouse tables to support BI and self-service analytics Collaborate with stakeholders to translate business needs into data models and solutions Mentor engineers and act as a More ❯

solutions that power advanced analytics and business intelligence. What You'll Do: Architect and build scalable data pipelines using Microsoft Fabric, PySpark, and T-SQL Lead the development of Star Schema Lakehouse tables to support BI and self-service analytics Collaborate with stakeholders to translate business needs into data models and solutions Mentor engineers and act as a More ❯

solutions that power advanced analytics and business intelligence. What You'll Do: Architect and build scalable data pipelines using Microsoft Fabric, PySpark, and T-SQL Lead the development of Star Schema Lakehouse tables to support BI and self-service analytics Collaborate with stakeholders to translate business needs into data models and solutions Mentor engineers and act as a More ❯

solutions that power advanced analytics and business intelligence. What You'll Do: Architect and build scalable data pipelines using Microsoft Fabric, PySpark, and T-SQL Lead the development of Star Schema Lakehouse tables to support BI and self-service analytics Collaborate with stakeholders to translate business needs into data models and solutions Mentor engineers and act as a More ❯

extension. This role offers a hybrid working arrangement, requiring 1-2 days per week onsite at Heathrow, Hounslow, with on-site parking available. Responsibilities: Data Modelling: Design and optimize star schema data models tailored to our client's business needs for streamlined analytics and reporting. Collaboration: Work closely with data architects, BI developers, and business analysts to translate … governance practices to ensure accuracy and integrity within data models. Skills/Must have: Proven experience in data modelling using Kimball methodology, with a focus on dimensional modelling and star schemas. Strong proficiency in SQL and experience with data modelling tools like ER Studio, Power Designer, or similar. Ability to translate complex business needs into structured, efficient data models. More ❯