1 to 25 of 93 Star Schema Jobs in England

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 ❯

and non-technical audiences, tailoring communication style based on the audience. Data Modeling and Warehousing: •Design and implement data models optimized for analytical workloads, using dimensional modeling techniques (e.g., star schema, snowflake schema). •Participate in the design, implementation, and maintenance of data warehouses ensuring data integrity, performance, and scalability. BASIC QUALIFICATIONS •Educational Background: Bachelor's or … Analysis Skills: Working knowledge of R or Python for analytics, data manipulation, and algorithm development. •Data Warehousing Knowledge: In-depth knowledge of data warehousing principles, dimensional modeling techniques (e.g., star schema, snowflake schema), and data quality management. •Communication and Collaboration Abilities: Excellent verbal and written communication skills, with the ability to effectively communicate technical concepts; experience gathering 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 ❯

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 ❯

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 ❯

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 ❯

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 ❯

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 ❯

Data Pipeline Orchestration : Experience with workflow orchestration tools such as Apache Airflow or Prefect to manage and schedule data pipelines. Data Modelling : Strong understanding of data modelling concepts (e.g., star schema, snowflake schema) and best practices for designing efficient and scalable data architectures. Data Quality and Governance : Knowledge of data quality principles and experience implementing data governance More ❯

culture of continuous improvement and innovation Build data integrations from multiple sources, including CRM, digital, and social platforms Design, implement and optimize data models with a medallion architecture using Star Schema and Snowflake techniques to enhance query performance and support analytical workloads Ensure data quality, consistency, and reliability across all marketing datasets Collaborate with analysts and data scientists 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 ❯

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 ❯

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 ❯

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 ❯

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 ❯

in Microsoft Azure (e.g. Data Factory, Synapse, Azure SQL, Data Lake) Strong proficiency in Power BI , including DAX, data modelling, and deployment Experience designing and implementing data warehouses and star schema models Background in building scalable data pipelines and APIs Excellent communication skills and ability to work with both technical and non-technical stakeholders Previous experience in local More ❯

If you're looking to contribute, grow, and work on diverse data challenges, join us! Your Contribution Design and develop efficient and scalable data models and data marts (e.g.star schema, snowflake schema) using best practices for data warehousing and business intelligence that are optimized for self-service analytics tools Collaborate with business stakeholders (e.g. finance, marketing, operations) to 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 ❯

knowledge of Azure Synapse Analytics, Azure SQL Database, Azure Data Factory, Azure Data Lake, and related Azure data services. Expertise in designing and optimizing relational and dimensional data models (star schema, snowflake schema). Experience with ETL tools and data integration techniques. Proficient in SQL and other data querying languages. Understanding of data governance practices, data security More ❯