1 to 25 of 26 Star Schema Jobs in England

pipeline development on Azure and SQL Server. Hands-on orchestration experience with SSIS, SQL Agent, and Azure Data Factory. Solid data modelling, ideally star schema design. Experience implementing data quality checks and testing (DBT or similar). Comfortable with Git and GitHub in a CI/CD workflow. … pipelines for structured and unstructured data. Help develop and maintain a modern data architecture, including optimising on-prem data warehouses. Design performant data models (star schema) and apply data transformations. Implement data observability, testing, and validation checks (such as DBT tests) to protect data integrity. Set up dynamic ...

high-quality, trusted data products across the business. Key Responsibilities Define and own enterprise-wide data architecture standards, including Data Vault, semantic layer frameworks, star schema modelling patterns, and Snowflake design conventions. Design scalable integration patterns for legacy and modern data sources, ensuring strong governance, reconciliation, auditability … field. At least 4 years of hands-on Snowflake architecture and design experience. Proven expertise in Data Vault 2.0 and dimensional modelling methodologies, including Star Schema design. Strong knowledge of dbt and source control practices using GitHub. Experience integrating enterprise data platforms with AWS services and broader cloud ...

high-volume transactional sources. Build reliable, high-performance data solutions for reporting and analytics. Design scalable data models using dimensional modelling techniques including star schema and Data Vault methodologies. Evaluate and modernise existing data architecture, identifying opportunities to improve performance, scalability and governance. Ensure robust data governance, security ...

using Power BI including semantic modelling, DAX, Power Query, data visualisation best practice, report development, and performance optimisation Advanced data modelling including dimensional modelling, star schema design, database layers, and data mart development Knowledge of BI solution delivery methodologies including requirements and discovery, Agile delivery, testing, deployment ...

scale. Key Responsibilities: Data platform ownership: Lead the design, operation, and evolution of our SQL Server data warehouse. Establish best practice standards for schema design and performance tuning in SQL Server/SSMS. ETL/ELT & integration: Define and manage pipelines (e.g., SSIS & Power Query) that consolidate sources including … experience delivering Power BI models and dashboards (DAX, Power Query, RLS, performance). ETL/ELT tooling (SSIS/Power Query) and dimensional modelling (Star Schema). Practical AI/ML exposure (e.g., Python notebooks, Azure ML, or equivalent) and the ability to operationalise models responsibly within reporting ...

APIs and native connectors Own data quality, monitoring, and governance across the platform Design and implement dimensional data models (fact/dimension tables, star schema) Build and maintain Power BI semantic models with DAX, KPIs, and row-level security Deliver dashboards and reporting across commercial, marketing, and operational ...

Python skills Solid understanding of Lakehouse architecture and data management principles Hands-on experience with Azure (Data Factory, Databricks, Synapse, Storage, DevOps) Experience designing Star Schema data models for Power BI 5+ years' experience building data platforms in a commercial setting Nice to have: Real-time pipeline experience ...

Python skills Solid understanding of Lakehouse architecture and data management principles Hands-on experience with Azure (Data Factory, Databricks, Synapse, Storage, DevOps) Experience designing Star Schema data models for Power BI 5+ years' experience building data platforms in a commercial setting Nice to have: Real-time pipeline experience ...

Python skills Solid understanding of Lakehouse architecture and data management principles Hands-on experience with Azure (Data Factory, Databricks, Synapse, Storage, DevOps) Experience designing Star Schema data models for Power BI 5+ years' experience building data platforms in a commercial setting Nice to have: Real-time pipeline experience ...

documentation for all data warehouse and data engineering related processes. Able to document using approaches such as Entity Relationship diagrams, Data Flow Diagrams or Star Schema Diagrams. Develop detailed technical designs, SOPs, and post-incident reports to support continuous improvement. Keep documentation up to date to minimise recurrence ...

near-production environment Practical experience building and maintaining ETL/ELT pipelines in a cloud environment Working knowledge of data modelling concepts including star schema and dimensional modelling Please see full job description attached. What you can expect from us We believe doing your best work starts with ...

business analysis, data analysis and data cataloguing to identify and document data requirements. Proficient use of enterprise data platforms, semantic models and dimensional modelling (star schemas, fact/dimension tables). Proficient in data architecture principles, ETL processes and data pipeline concepts. Experience with data cataloguing tools ...

decision-making. Key Responsibilities End-to-End BI Architecture: Own the architecture of the Power BI application estate, designing robust semantic/data models (star schema, DAX) and defining standards for datasets, dataflows, workspaces, and report design. Platform & Integration Strategy: Architect Power BI integration with Azure/ ...

automation specialist or similar role. Strong proficiency in Power BI Desktop, Power BI Service, and Power Query. Solid understanding of data modelling concepts, including star schema, relationships, and normalisation. Experience with DAX (Data Analysis Expressions) for creating complex measures and calculations Familiarity with Power BI best practices, security ...

improve a lakehouse architecture, supporting ingestion, transformation, and consumption layers. Create robust, well-structured data models using best practice approaches such as Kimball and star schema. Work closely with business stakeholders to translate requirements into clear, usable data assets. Support and enhance the Power BI reporting layer, including semantic ...

Azure Data Platform technologies and modern Lakehouse architectures Databricks, Unity Catalog and Delta Lake PySpark, Databricks, SQL Medallion Architecture implementation Data modelling approaches including Star Schema and Data Vault Data governance, security and access management Why This Opportunity Greenfield data transformation programme Full ownership of enterprise data architecture ...

experience with business intelligence tools, data modeling, 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 ...

Skills Working knowledge of SAS (especially in ETL context) Experience in migrating SAS workloads to Informatica ETLs Familiarity with data modelling (dimensional modelling/star schema) Exposure to scheduling tools (e.g., Control-M, Autosys) Understanding of data governance and data quality frameworks ...

Snowflake Innovation: Drive CDC-based incremental processing using Snowflake Streams, Tasks, Snowpipe, Dynamic Tables, and Stored Procedures. Data Modeling: Design robust fact, dimension, and star schema models while focusing on query performance and cost optimization. Collaboration: Partner with Agile cross-functional teams and clearly translate complex data concepts ...

Strong interpersonal skills; ability to translate complex data architecture into clear language for Business Analysts and non-technical stakeholders. Duties Data Modelling Standard: defining Star Schema patterns, Snowflake object hierarchies, and modelling conventions that serve as the Group-wide standard for all data products. Cross-Cloud Orchestration : Design ...

Skills Working knowledge of SAS (especially in ETL context) Experience in migrating SAS workloads to Informatica ETLs Familiarity with data modelling (dimensional modelling/star schema) Exposure to scheduling tools (e.g., Control-M, Autosys) Understanding of data governance and data quality frameworks Must have skills Informatica PowerCentre (preferably ...

Power BI (critical – minimal ramp-up) Strong data modelling/DAX/SQL/data transformation Experience with large datasets/semantic models/star schema Exposure to Azure/data platforms (nice to have but helpful) Strong Excel Other must haves Commercial/business-facing analytics: Sales ...

coding assistant experience in a professional setting Financial services background preferred; BCBS 239 awareness advantageous Desirable Skills Data Vault 2.1 alongside Kimball/Star-schema modelling Data mesh, data product ownership and federated governance Knowledge graph platforms (Neo4j, Neptune) or knowledge of OWL, RDF and exposure ...

level SQL and deep mastery of dbt (data build tool) or similar orchestrators, coupled with a thorough understanding of Kimball dimensional modelling principles and star schema layouts. AI Native Mindset: A progressive understanding of how automated AI agents consume data structures, and practical familiarity with utilising generative ...

requirements in banking. Proficient in BigQuery, Vertex AI, Dataflow, and Pub/Sub. Strong understanding of relational, NoSQL, and analytical data modeling (e.g., Star Schema, Data Vault, etc.). Ability to independently drive the discovery phase, moving from a vague business problem to a structured ...