1 to 25 of 56 Star Schema Jobs in the UK excluding London

through robust, scalable, and innovative data solutions. In this position, you'll be responsible for designing, building, and optimizing data warehouses using best practices in dimensional modelling, Kimball methodologies, star schema design, and Data Vault principles, ensuring adherence to sound data architecture practices. Based in Avonmouth on a hybrid working basis – 2 days in office per week Compensation … premises SQL Server data warehouses, focusing on stored procedures, indexing, partitioning, and load performance. A proven track record in designing and building data warehouses using Kimball methodologies, dimensional modeling, star schema design, and Data Vault techniques is essential. You should be well-versed in applying data architecture principles to create robust, scalable solutions Azure Cloud Proficiency: Deep understanding More ❯

data from various sources including APIs, Excel, CSV, JSON, and databases. Manage data lakes, warehouses, and lakehouses within Azure cloud environments. Apply data modelling techniques such as Kimball methodologies, star schemas, and data warehouse design principles. Build and support ETL workflows using tools like Azure Data Factory, Synapse, Delta Live Tables, dbt, SSIS, etc. Automate infrastructure deployment with Terraform … engineering experience. Has strong skills in Python, SQL, and PySpark. Experienced working with data lakes, warehouses, lakehouses, and cloud platforms, preferably Azure. Knowledgeable in data modelling, including Kimball and star schemas. Familiar with ETL tools such as Azure Data Factory, Synapse, Delta Live Tables, dbt, SSIS. Experienced with Infrastructure as Code (Terraform, ARM, Bicep). Skilled in Power BI More ❯

security, and best practices for the warehouse. Develop and maintain documentation on data models, processes, and business rules. SKILLS AND QUALIFICATIONS Data Warehousing: Strong knowledge of the Kimball methodology (star schema, fact & dimension tables). Experience in designing and implementing data models for analytical reporting. ETL/ELT & Data Integration: Hands-on experience with ETL tools (e.g., Azure More ❯

etc. · In-depth knowledge of Snowflake architecture, features, and best practices. · Experience with CI/CD pipelines using Git and Git Actions. · Knowledge of various data modeling techniques, including Star Schema, Dimensional models, and Data Vault. · Hands-on experience with: · Developing data pipelines (Snowflake), writing complex SQL queries. · Building ETL/ELT/data pipelines. · Kubernetes and Linux More ❯

documentation on data models, processes, and business rules. **Please note that the responsibilities listed above are not exhaustive. SKILLS AND QUALIFICATIONS Data Warehousing: Strong knowledge of the Kimball methodology (star schema, fact & dimension tables). Experience in designing and implementing data models for analytical reporting. ETL/ELT & Data Integration: Hands-on experience with ETL tools (e.g., Azure More ❯

documentation on data models, processes, and business rules. **Please note that the responsibilities listed above are not exhaustive. SKILLS AND QUALIFICATIONS Data Warehousing: Strong knowledge of the Kimball methodology (star schema, fact & dimension tables). Experience in designing and implementing data models for analytical reporting. ETL/ELT & Data Integration: Hands-on experience with ETL tools (e.g., Azure More ❯

the data-driven solutions within our products and across the organisation. You should have in-depth knowledge of SQL databases (Microsoft or Postgres), and be familiar with dimensional modelling, star schema design and ETL processes. You will have the opportunity to be part of our strategic plan to incorporate machine learning and artificial intelligence into our product suite … or similar) in an Agile environment ◦ Experience of SQL database systems and data warehousing, focusing on stored procedures, indexing, partitioning and load performance ◦ Experience of ETL, dimensional modelling and star schema solutions ◦ Technical expertise with data models, data mining, and segmentation techniques ◦ Have a strong understanding of data security and multi-tenancy ◦ Excellent communication skills with both technical 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 ❯

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 ❯

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 ❯

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 ❯

with tools such as MuleSoft, Boomi, Informatica, Talend, SSIS, or custom scripting languages (Python, PySpark, SQL) for data extraction and transformation. Prior experience with Data warehousing and Data modelling (Star Schema or Snowflake Schema). Skilled in security frameworks such as GDPR, HIPAA, ISO 27001, NIST, SOX, and PII, with expertise in IAM, KMS, and RBAC implementation. More ❯

languages (Spark, MPP, Python, Delta, Parquet). Experience with Azure DevOps & CICD processes, software development lifecycle including infrastructure as code (Terraform). Understand data warehousing concepts, including dimensional modelling, star schema, data aggregation, and best practices for designing efficient and scalable data models. Excellent documentation and diagramming skills. Technical Cloud Certification preferred e.g., Azure, Amazon Web Services, or More ❯

for recurring tasks in line with documentation standards. Essential Skills & Experience Proficient in working with UK mortgage data, including portfolio onboarding, new lending, and securitisations. Experience with Kimball-based star schema data warehouses. Strong capabilities in reporting and data visualisation using: Microsoft SQL Server T-SQL Power BI SSRS Microsoft Excel Azure DevOps Performance tuning techniques Solid understanding More ❯

design and rollout. Hands on experience with business intelligence tools, data modelling, data staging, and data extraction processes, including data warehouse and cloud infrastructure. Experience with multi-dimensional design, star schemas, facts and dimensions. Experience and demonstrated competencies in ETL development techniques. Experience in data warehouse performance optimization. Experience on projects across a variety of industry sectors an advantage. More ❯

design and rollout. Hands on experience with business intelligence tools, data modelling, data staging, and data extraction processes, including data warehouse and cloud infrastructure. Experience with multi-dimensional design, star schemas, facts and dimensions. Experience and demonstrated competencies in ETL development techniques. Experience in data warehouse performance optimization. Experience on projects across a variety of industry sectors an advantage. 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 ❯

Azure Databricks, Azure Synapse Analytics, and other Azure data services. Familiarity with Azure Blob Storage, Azure Data Lake, and data lake architectures. Experience working with data modelling, normalization, and star schema design for data warehouses. Proficient in scripting languages such as Python, Shell, or PowerShell for automation tasks. Knowledge of CI/CD practices and tools for data More ❯

Azure Databricks, Azure Synapse Analytics, and other Azure data services. Familiarity with Azure Blob Storage, Azure Data Lake, and data lake architectures. Experience working with data modelling, normalization, and star schema design for data warehouses. Proficient in scripting languages such as Python, Shell, or PowerShell for automation tasks. Knowledge of CI/CD practices and tools for data More ❯

Azure Databricks, Azure Synapse Analytics, and other Azure data services. Familiarity with Azure Blob Storage, Azure Data Lake, and data lake architectures. Experience working with data modelling, normalization, and star schema design for data warehouses. Proficient in scripting languages such as Python, Shell, or PowerShell for automation tasks. Knowledge of CI/CD practices and tools for data More ❯

design and rollout. Hands on experience with business intelligence tools, data modelling, data staging, and data extraction processes, including data warehouse and cloud infrastructure. Experience with multi-dimensional design, star schemas, facts and dimensions. Experience and demonstrated competencies in ETL development techniques. Experience in data warehouse performance optimization. Experience on projects across a variety of industry sectors an advantage More ❯

ability to communicate issues and solutions to a variety of stakeholders including the facilitation of client workshops. An understanding of key data modelling concepts (e.g., fact and dimension tables, star schemas and snowflake schemas, denormalised tables, and views). Experience with data handling, e.g. data querying, data manipulation or data wrangling to transform raw data into the desired format More ❯

ability to communicate issues and solutions to a variety of stakeholders including the facilitation of client workshops. An understanding of key data modelling concepts (e.g., fact and dimension tables, star schemas and snowflake schemas, denormalised tables, and views). Experience with data handling, e.g. data querying, data manipulation or data wrangling to transform raw data into the desired format 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 ❯