1 to 25 of 37 Star Schema Jobs in London

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 ❯

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 ❯

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 ❯

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 ❯

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 ❯

Proficiency in ETL/ELT processes and best practices - Experience with data visualization tools (Quicksight) Required Skills: - Strong analytical and problem-solving abilities - Excellent understanding of dimensional modeling and star schema design (Facts, dimensions, scd type 2) - Experience with agile development methodologies - Strong communication skills and ability to work with cross-functional teams - Background in data governance and More ❯

Proficiency in ETL/ELT processes and best practices - Experience with data visualization tools (Quicksight) Required Skills: - Strong analytical and problem-solving abilities - Excellent understanding of dimensional modeling and star schema design (Facts, dimensions, scd type 2) - Experience with agile development methodologies - Strong communication skills and ability to work with cross-functional teams - Background in data governance and More ❯

ETL/ELT processes and best practices. Experience with data visualization tools such as Quicksight. Required Skills: Strong analytical and problem-solving abilities. Excellent understanding of dimensional modeling and star schema design (facts, dimensions, SCD type 2). Experience with agile development methodologies. Strong communication skills and ability to collaborate with cross-functional teams. Background in data governance More ❯

Proficiency in ETL/ELT processes and best practices - Experience with data visualization tools (Quicksight) Required Skills: - Strong analytical and problem-solving abilities - Excellent understanding of dimensional modeling and star schema design (Facts, dimensions, scd type 2) - Experience with agile development methodologies - Strong communication skills and ability to work with cross-functional teams - Background in data governance and More ❯

Proficiency in ETL/ELT processes and best practices - Experience with data visualization tools (Quicksight) Required Skills: - Strong analytical and problem-solving abilities - Excellent understanding of dimensional modeling and star schema design (Facts, dimensions, scd type 2) - Experience with agile development methodologies - Strong communication skills and ability to work with cross-functional teams - Background in data governance and More ❯

Proficiency in ETL/ELT processes and best practices - Experience with data visualization tools (Quicksight) Required Skills: - Strong analytical and problem-solving abilities - Excellent understanding of dimensional modeling and star schema design (Facts, dimensions, scd type 2) - Experience with agile development methodologies - Strong communication skills and ability to work with cross-functional teams - Background in data governance and More ❯

Proficiency in ETL/ELT processes and best practices - Experience with data visualization tools (Quicksight) Required Skills: - Strong analytical and problem-solving abilities - Excellent understanding of dimensional modeling and star schema design (Facts, dimensions, scd type 2) - Experience with agile development methodologies - Strong communication skills and ability to work with cross-functional teams - Background in data governance and More ❯

Proficiency in ETL/ELT processes and best practices - Experience with data visualization tools (Quicksight) Required Skills: - Strong analytical and problem-solving abilities - Excellent understanding of dimensional modeling and star schema design (Facts, dimensions, scd type 2) - Experience with agile development methodologies - Strong communication skills and ability to work with cross-functional teams - Background in data governance and More ❯

Proficiency in ETL/ELT processes and best practices - Experience with data visualization tools (Quicksight) Required Skills: - Strong analytical and problem-solving abilities - Excellent understanding of dimensional modeling and star schema design (Facts, dimensions, scd type 2) - Experience with agile development methodologies - Strong communication skills and ability to work with cross-functional teams - Background in data governance and More ❯

integrity, and security controls. Define data ownership and stewardship roles across data sets. Conduct regular data audits and drive continuous improvement initiatives. Establish data model management in line with star schema principles. Organizing data into fact and dimension tables. Work with key business stakeholders to define new data sets for incorporation into the data platform. Work with the … updated data sets to ensure they align to the required data model, data governance and data quality requirements Ensure that data from various sources is accurately integrated into the star schema. This includes designing ETL (Extract, Transform, Load) processes to move data into the fact and dimension tables. Ensuring that the data model is optimized for performance, working with … the Development team to ensure any performance issues are resolved. Document the schema design, data sources, ETL processes, and any changes made to the schema. Provide training to team members on how to use and maintain the star schema. Work closely with stakeholders, including data analysts, data scientists, developers and IT teams, to understand their data needs and More ❯

The Person Confident in SQL and Python for data analysis and transformation. Experience with Azure Synapse Analytics and Microsoft Fabric is highly desirable. Understanding of data modeling concepts (e.g., star schema, snowflake, normalized and denormalized structures). Experience working in Change Control or Agile methodologies. Financial services or other regulated entity experience is desirable. The Opportunity Shawbrook is 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 ❯

in a collaborative, trusting environment that values diversity of thought and creative solutions. What Do We Need From You? Experience developing Azure Data solutions Knowledge of data modelling principles (star schema, snowflake, data vault) Experience implementing end-to-end ETL/ELT solutions Maintaining and optimising an Enterprise Data Warehouse Data analysis skills Testing and software release management 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 ❯

sector is alive with career potential. What Do We Need From You? Experience in the development of Azure Data solutions Knowledge of data modelling principles, including common patterns, e.g. star schema, snowflake or data vault Experience in implementation end-to-end ETL/ELT solutions Experience in m aintaining and optimising an Enterprise Data Warehouse Knowledge of data More ❯

lost revenue , 4 billion pounds of textile waste , and 10% of global carbon emissions each year. Rather than adjusting sizing after the fact, we prevent bad fit from the star t. Using machine learning and generative AI, we simulate and predict how garments will perform on real bodies, eliminating poor fit before a single item is made. It’s … when to use snapshots vs incremental , can use seeds for controlled lookup data, and enjoy keeping models modular and maintainable. Modelling Expertise : Comfortable working across normalized and analytics-ready star schemas Deep understanding of SCD types, particularly Type 2, using dbt snapshots Experience working with multi-tenant datasets and aligning models across clients/domains Strong discipline around testing 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 ❯