14 of 14 Star Schema Jobs in London

week, with the remaining days from home. Key Skills Hands-on experience working with Teradata and other data warehouses. Deep expertise in Teradata architecture, star schema, snowflake schema, SQL optimization, and Data Modelling. Experience in implementing Teradata utilities (BTEQ, Fast Load, Multiload, TPT, etc.) for efficient data More ❯

with the rest of the days from home. Key Skills * Hands-on experience working with Teradata and other Datawarehouses. * Deep expertise in Teradata architecture, star schema, snowflake schema, SQL optimization, and Data Modelling. * Experience in implementation of Teradata utilities (BTEQ, Fast Load, Multiload, TPT etc.) for efficient More ❯

with the rest of the days from home. Key Skills * Hands-on experience working with Teradata and other Datawarehouses. * Deep expertise in Teradata architecture, star schema, snowflake schema, SQL optimization, and Data Modelling. * Experience in implementation of Teradata utilities (BTEQ, Fast Load, Multiload, TPT etc.) for efficient More ❯

support the onboarding of new datasets. Azure SQL: Integrating database access with Microsoft Entra ID for improved identity and access management. Designing and implementing STAR schema models to support analytical workloads. Defining consistent naming conventions across all database objects. Migrating data processing logic from Power BI into Azure More ❯

complex datasets using traditional or map reduce batch mechanism. Strong data modeling skills with solid knowledge of various industry standards such as dimensional modeling, star schemas, etc. Extremely proficient in writing performant SQL working with large data volumes. Experience designing and operating very large Data Warehouses. Experience with scripting More ❯

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 More ❯

and other sources. Apply data cleansing rules to ensure high data quality standards. Model data into a single source of truth using Kimball methodology (star schema, snowflake, etc.). Develop high-quality code following DevOps and software engineering best practices, including testing and CI/CD. Monitor and More ❯

concisely PREFERRED QUALIFICATIONS Experience in data warehousing, BI tools, techniques, and technology Data engineering skills; programming knowledge (JAVA/PYTHON/SCALA) Knowledge of Star Schemas, Dimensional Models, Data Marts, Big Data, and Advanced Analytics Strong analytical skills with attention to detail and big-picture understanding Excellent communication skills More ❯

Strong Python skills • Experience with version control for data models (e.g., dbt testing frameworks, data documentation) • Demonstrated experience with data modelling concepts (dimensional modelling, star schemas) • Experience writing efficient and optimised SQL for large-scale data transformations • Understanding of data warehouse design principles and best practices • Proactive approach to More ❯

and analyze large scale structured data and validate by profiling in a data environment. Understand data structures and data model (dimensional & relational) concepts like Star schema or Fact & Dimension tables, to design and develop ETL patterns/mechanisms to ingest, analyze, validate, normalize, and cleanse data. Understand and More ❯

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 7+ More ❯

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 7+ More ❯

service principals. Enabling parallel processing in pipelines. Creating reusable templates for onboarding new datasets. Azure SQL: Securing database access via Microsoft Entra ID. Building STAR schema-based data models. Establishing naming conventions and best practices. Shifting data processing from Power BI to Azure SQL. Organising data with schemas More ❯

role will focus on designing and developing both relational and dimensional data models to support robust, scalable data solutions. You’ll work extensively with STAR schemas, role-playing dimensions, and handle late-arriving data scenarios as part of building high-quality data models. In addition to modelling, the role … and dimensional data models, applying best practices in normalisation and working with complex structures like parent-child tables. You’ll leverage your understanding of STAR schemas and role-playing dimensions to support reporting and analytics needs. ETL and Metadata Management: Lead the design and optimisation of ETL processes and … understand client data needs and deliver actionable insights within a consulting framework Required Experience: Proven experience in designing relational and dimensional data models, including STAR schemas and role-playing dimensions. Strong understanding of data modelling concepts such as normalisation types, parent-child table structures, and handling of late-arriving More ❯