22 of 22 Star Schema Jobs

Redshift. Implementing a Medallion architecture (bronze, silver, gold). Using DBT to model data, configure tables, and set up tests (including unit testing). Creating a data mart and star schema for financial and revenue reporting. Advising on orchestration best practices using Airflow. Optimising data pipelines for downstream BI tools (Power BI/Looker). This role won … a functioning data mart and reporting models, not dashboarding. YOUR SKILLS & EXPERIENCE The successful candidate will have: Strong SQL and DBT experience. Familiarity with Kimball methodology, dimensional modelling, and star schema design. Proven experience with Redshift or Snowflake. Strong background in cloud-based data environments (AWS preferred). Hands-on experience with Airflow for orchestration. (Nice-to-have More ❯

and lead analytics projects from onboarding through delivery in a collaborative, fast-growing environment. Analytical Data Engineer Job Overview Cleanse and transform data sets to create one-to-many star schema models from multiple sources. Define fact and dimension tables based on requirements, enabling users to drill down and explore data independently. Proactively search for and review data … outcomes. Develop and deliver advanced analytical dashboards using Sisense, Quicksight, and Power BI, tailored to user needs. Provide technical guidance on data structures from APIs to ensure alignment with star schema models. Support the Lead Solutions Architect on best practices for go-live within client Microsoft environments. Work directly with clients during onboarding, running workshops, gathering requirements, clarifying More ❯

and lead analytics projects from onboarding through delivery in a collaborative, fast-growing environment. Analytical Data Engineer Job Overview Cleanse and transform data sets to create one-to-many star schema models from multiple sources. Define fact and dimension tables based on requirements, enabling users to drill down and explore data independently. Proactively search for and review data … outcomes. Develop and deliver advanced analytical dashboards using Sisense, Quicksight, and Power BI, tailored to user needs. Provide technical guidance on data structures from APIs to ensure alignment with star schema models. Support the Lead Solutions Architect on best practices for go-live within client Microsoft environments. Work directly with clients during onboarding, running workshops, gathering requirements, clarifying More ❯

DB2/Oracle/SQL Experience with microservices and API design Superior problem-solving skills and debugging capabilities Knowledge of relational and multidimensional data design and development techniques including star schema, snowflake schema, cube design, ETL and others Background in data warehousing concepts, ETL development, data modeling, metadata management and data quality Bachelor's degree in Computer More ❯

and loading (ETL) processes, leveraging tools such as Talend, Informatica, Matillion, Pentaho, MuleSoft, Boomi, or scripting languages (Python, PySpark, SQL). Understanding of data warehousing and data modelling techniques (Star Schema, Snowflake Schema). Familiarity with security frameworks (GDPR, HIPAA, ISO 27001, NIST, SOX, PII) and AWS security features (IAM, KMS, RBAC). Strong analytical skills to More ❯

performing data analysis and performance tuning. Proven knowledge and skills in designing data models and tables such as fact, snapshot, and dimension (including but not limited to medallion architectures, star schemas and slowly changing dimension designs). Ability to test and document end-to-end processes. Proven problem-solving abilities. Demonstrated experience in learning and understanding business domains. Experience More ❯

fully reconciled Facts and Dimensions with accurate end-user reports Proficiency with reporting tools such as Oracle OAS and Microsoft Power BI Deep understanding of Data Warehouse design, including Star schema and dimensional modelling Strong analytical skills and technical aptitude, with the ability to influence system architecture decisions Experience leading testing disciplines within agile projects Self-starter with More ❯

metadata management Performance Tuning : Partitioning, caching, Spark job optimization Cloud Architecture : Infrastructure-as-code, monitoring, automation Finance Domain Knowledge : Experience with financial systems and reporting Data Modelling : Kimball methodology, star schemas Retail Experience : Preferred but not essential About the Team We're a collaborative data function made up of BI Developers and Data Engineers. We work end-to-end More ❯

the wider data culture. Key Responsibilities: Design and deliver robust data pipelines using Databricks, Azure Data Factory, and Azure SQL. Build and enhance enterprise data warehouse models (facts, dimensions, star schemas). Collaborate with BI and Analytics teams to translate requirements into engineering solutions. Drive adoption of modern DevOps practices (CI/CD, cost optimisation, automation). Advocate for … solutions. Essential Skills: 5 years' experience in Data Engineering. Strong expertise in Databricks, Azure Data Factory, Azure SQL, and Azure Synapse/DW. Solid understanding of dimensional modelling (Kimball, Star Schema) and EDW solutions. Experience working with structured and unstructured data. Familiarity with cloud and DevOps practices - ie Azure, CI/CD pipelines, scaling, cost optimisation. Strong problem More ❯

SQL, Python, PowerShell, and Regular Expressions Strong knowledge of data governance principles, frameworks, and best practices. Strong knowledge of data modeling specifically in Data Vault, Lake, and Relational/Star Schema. Proficiency in data management concepts, including data quality, data lineage, metadata management, and data security. Excellent written and verbal communication skills, with the ability to explain complex technical More ❯

Experience managing large and complex datasets, with a strong command of SQL for cloud-based environments (Fabric, Snowflake, BigQuery, Redshift, etc.). A solid understanding of data modelling techniques (star schema, data vault, dimensional modelling). Proficiency in Excel-based data workflows for various Agile Retail projects. Hands-on experience with data pipeline orchestration tools (Airflow, dbt, Prefect More ❯

Experience managing large and complex datasets, with a strong command of SQL for cloud-based environments (Fabric, Snowflake, BigQuery, Redshift, etc.). A solid understanding of data modelling techniques (star schema, data vault, dimensional modelling). Proficiency in Excel-based data workflows for various Agile Retail projects. Hands-on experience with data pipeline orchestration tools (Airflow, dbt, Prefect More ❯

making. A successful Lead Azure Data Engineer should have: Strong experience with Databricks, Azure Synapse, Delta Lake, and pipeline orchestration. Hands-on with ETL/ELT processes, data modeling (star schema), SQL, Python, and data governance tools (e.g., Purview, Unity Catalog). Experience implementing AI/ML solutions in Databricks or similar platforms. Knowledge of data observability, monitoring More ❯

relational databases (preferably postgres); working with Change Data Capture is a bonus. Data modelling knowledge, breaking down backend logic to understand and form a holistic data model (ie 3NF, star schema, Data Vault). Strong experience with Python, TypeScript or Java (a significant amount of work will be in Java - it is not expected for you to know … as code" practices. Good understanding of DevOps practices, Infrastructure as Code & Continuous Integration/Continuous Deployment. Desirable Experience extracting, loading and transforming large data sets (>100GBs). Experience with schema evolution tools such as flyway or liquibase. Experience with AWS (S3, IAM, RDS). Translate internal data user needs into building BI Dashboards to answer their key business questions. More ❯

ensure data accuracy, quality, and security. What you’ll bring: Proven BI or Data experience with strong Power BI, DAX, and Power Query skills. SQL and data modelling expertise (star schema design). Strong Excel skills and knowledge of relational databases. Excellent problem-solving and communication skills, with high attention to detail. Experience with SSRS/SSIS/ More ❯

and configure incremental loads with built-in unit testing. Support data pipeline orchestration with Airflow and work with AWS cloud tools. Help deliver a production-ready Data Mart with star schema design to power business reporting and dashboards (PowerBI experience a plus). Skills & Experience: Strong SQL expertise and hands-on experience with DBT. Familiarity with Kimball dimensional More ❯

to the business. What you’ll be doing Designing and delivering Power BI dashboards that are accurate, intuitive and widely adopted across the business. Building and maintaining semantic models (star schema, relationships, hierarchies) to create a single source of truth. Ability to read SQL Code Implementing Row-Level Security (RLS) and governance controls to ensure the right people More ❯

to the business. What you’ll be doing Designing and delivering Power BI dashboards that are accurate, intuitive and widely adopted across the business. Building and maintaining semantic models (star schema, relationships, hierarchies) to create a single source of truth. Ability to read SQL Code Implementing Row-Level Security (RLS) and governance controls to ensure the right people More ❯

to the business. What you’ll be doing Designing and delivering Power BI dashboards that are accurate, intuitive and widely adopted across the business. Building and maintaining semantic models (star schema, relationships, hierarchies) to create a single source of truth. Ability to read SQL Code Implementing Row-Level Security (RLS) and governance controls to ensure the right people More ❯

to the business. What you’ll be doing Designing and delivering Power BI dashboards that are accurate, intuitive and widely adopted across the business. Building and maintaining semantic models (star schema, relationships, hierarchies) to create a single source of truth. Ability to read SQL Code Implementing Row-Level Security (RLS) and governance controls to ensure the right people More ❯

translating business requirements and use cases into optimized models, data flows, and developing database solutions Experience with and knowledge of relational databases, entity relationships, data warehousing, facts, dimensions, and star schema concepts and terminology Strong proficiency with SQL Server, T-SQL, SSIS, stored procedures, ELT processes, scripts, and complex queries Working knowledge of Azure Databricks, Delta Lake, Synapse More ❯

when needed Excellent requirements, Epics, User Stories and Acceptance Criteria specification Managing agile product backlogs in scrum Process and requirements modelling Data Modelling of financial data and CUBE/Star Schema Data Analysis Reconciliation Defect triage and classification of bug prioritisation and severity Financial modelling and statutory reporting platforms Knowledge and Experience Experience of finance software implementations and More ❯