1 to 25 of 34 Star Schema Jobs in London

e.g., PostgreSQL, MySQL) and experience with modern data warehousing solutions (e.g., Snowflake, BigQuery, Redshift, Synapse).**Data Modeling:** Knowledge of data modeling principles (e.g., star schema, snowflake schema, normalization).**Programming:** Proficiency in Python and/or Scala for data processing and pipeline development**.****Agentic workflows ...

Strong proficiency in SQL and Python Strong experience with AWS (Batch, Lambda, Glue, ECR, RDS, Redshift, S3) Experience in data warehousing, database design (e.g., star schema, snowflake schema), and data modelling. Excellent problem‐solving skills and the ability to work independently and as part of a team ...

PySpark, Spark SQL, T-SQL and KQL, optimizing Delta tablesAdd data quality checks, validation rules, logging and alerting to data pipelinesBuild enterprise semantic models (star schema) using Direct Lake, Import or DirectQuery as specified in the architectureWrite efficient DAX measures, calculation groups and Power Query (M) transformationsBuild reports ...

integration: bulk loading, contin-uous ingestion, connectors Significant knowledge and experience in data transformation & modelling: ELT patterns, dbt + Snowflake integration, stored procedures, star schema, building curate layer, incremen-tal models, slowly changing dimensions Significant experience and knowledge of per-formance & cost optimization: clustering, mi-cro-partitions, credit … consumption, resource monitoring, warehouse sizing, query profile, account usage views, schema information Significant knowledge and experience of se-curity, governance & compliance: access con-trols, data protection, compliance Significant knowledge and experience of ad-vance enterprise capabilities: data sharing, Snowpark, native apps, unistore and iceberg tables Significant experience of automated ...

skills for transformations, data modelling, and debugging data issues Experience building and supporting ingestion pipelines end to end Understanding of data modelling for analytics (star schema, facts/dimensions) and how schema changes affect downstream users Exposure to layered data architectures (e.g. bronze/silver/gold ...

practices, such as SOLID principals, structuring code, testing, IOC, etc. Strong repositories, CI/CD skills. Strong knowledge of Kimball data modelling, such as star schema, snowflake, etc. Strong SQL skills. Strong data analysis skills. Excellent written and verbal communication skills A demonstrable track record of getting stuff ...

query optimisation and working with the Azure data stack (Data Factory, Synapse/Fabric, SQL‐based semantic layers). Advanced Power BI: data modelling (star schemas), advanced DAX, Power Query/M, performance tuning, RLS, and deployment via pipelines. Understanding of Power BI engineering discipline: PBIP/TMDL source ...

/ELT solutions. Knowledge of Lakehouse and Data Warehouse architectures. Experience with Data Pipelines, Dataflows Gen2, and Notebooks. Understanding of data modelling techniques, including star schemas and dimensional modelling. Experience with Power BI semantic models and reporting. Knowledge of data governance, security, and performance optimisation. Experience using ...

varied unstructured content into structured meta-data; Knowledge of developing dimensional data models from unstructured content and awareness of the advantages and limitations of Star Schema and Snowflake schema designs; Solid ETL development, reporting knowledge based off intricate understanding of business process and measures; Knowledge of Snowflake ...

experience building and optimising semantic or data models at scale, including window functions and complex business logic. Solid understanding of data modelling principles - star schema, dimensional modelling, DAX. Experience with Power BI and the Microsoft Power Platform, including building on top of central/curated data models. Familiarity ...

varied unstructured content into structured meta-data. Knowledge of developing dimensional data models from unstructured content and awareness of the advantages and limitations of Star Schema and Snowflake schema designs. Solid ETL development, reporting knowledge based off intricate understanding of business process and measures. Knowledge of Snowflake ...

query optimisation and working with the Azure data stack(Data Factory, Synapse/Fabric, SQL-based semantic layers). Advanced Power BI: data modelling (star schemas), advanced DAX, Power Query/M,performance tuning, RLS and deployment via pipelines. Astrong understanding of Power BI engineering discipline: PBIP/TMDLsource ...

high-performance solutions aligned with your target data architecture. Master Data Modeling Techniques – Apply expertise in various data modeling approaches, including 3NF, Data Vault, Star Schema, and One Big Table (OBT). Clearly articulate the benefits and trade-offs of each method and optimize their implementation within columnar ...

environment. Expert knowledge of Power BI Desktop and Power BI Service. Advanced experience with DAX, Power Query and SQL. Strong knowledge of dimensional modelling, star‐schema design and semantic models. Experience with Power BI administration, workspace management, dataflows and deployment pipelines. Experience working with cloud and on‐premise ...

ensure clean, reliable and timely data flows into a central reporting layer with low ongoing maintenance. Build a scalable data model, such as a star schema, to support fast, flexible reporting rather than one-off extracts. Establish data governance practices, including naming conventions, refresh schedules, version control ...

automation. Hands‐on experience with cloud platforms (AWS, Azure, GCP). Familiarity with Databricks Workflows and other orchestration tools. Knowledge of data modelling methodologies (star schemas, Data Vault, Kimball, Inmon). Familiarity with medallion architectures, data lakehouse principles and distributed data processing. Experience with version control tools (GitHub, Bitbucket ...

optimisation Stakeholder engagement and requirements gathering Communicating technical concepts to non-technical audiences Designing scalable reporting solutions using best-practice methodologies such as Kimball, Star Schema, or Medallion Architecture Azure DevOps or CI/CD processes Azure Databricks Databricks Genie or AI-assisted analytics tools Microsoft Fabric Agile ...

architecture for Power BI-based BI and management information applications, translating reporting needs into scalable technical solutions. Design governed semantic and data models using star-schema principles, DAX and Power Query, and define standards for datasets, dataflows, workspaces and report design. Architect integrations between Power BI and Azure ...

building and designing products that use both real-time and batch data at scale, and an understanding of the underlying data architecture (e.g. lakehouse, star schema). Ability to write and validate SQL queries, and to trace data flows end-to-end to ensure data quality. Awareness ...

building a data warehouse using an ETL/ELT tool, preferably Oracle ODI or dbt Significant database experience in Snowflake and/or Oracle Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions ...

system observability, and experience with source control tools like GitHub. Hands on experience with dbt or similar transformation tools. Strong data modelling principles, including star schema, and best practices for building scalable data assets that can be used in BI and other user facing tools. Experience working with ...

strategy, sets standards for data modelling, transformations, and governance. Leads the design and implementation of new features, such as the creation of a new star schema and other best practices to optimise data usability. Sets best practices and standards on how we use SQL & dbt/Python/ ...

skills, including views, stored procedures and query optimisation. A good understanding of Kimball data modelling concepts including grain, surrogate keys, conformed dimensions, and star schemas. Experience turning raw or operational data into trusted, business‐ready datasets. The ability to investigate complex data issues and work through them logically. Confidence ...

team spirit Nice-to-Have Data Governance & Quality Hands-on experience with: Data Quality Data Governance practices Familiarity with modelling approaches such as: Star Schema OBT Knowledge of modern architectures: Medallion Lambda Kappa Experience building or contributing to cloud-based data platforms AWS preferred Familiarity with: S3 Glue ...

marts and business specific data products. Ability to model complex business relationships, hierarchies, and many-to-many relationships. Proficiency in dimensional modelling techniques including star schemas, snowflake schemas, facts, dimensions, and slowly changing dimensions (SCDs). Experience producing ERDs, logical data models, business data models, and data dictionaries. Strong ...