5 of 5 Star Schema Jobs in London

proficiency in SQL - writing and optimizing complex queries, joins, window functions, performance tuning. Experience with dbt (or equivalent) - building models, tests, documentation, version control. Understanding of data warehousing concepts (star schemas, snowflake, slowly changing dimensions, partitioning, clustering). Experience working in a modern data stack (e.g. BigQuery, Snowflake, Redshift, Databricks, etc.) Comfortable working downstream (with BI/analytics users More ❯

Collaborate with stakeholders to understand requirements and deliver practical solutions. Ensure data quality and consistency across reporting pipelines. What We’re Looking For Power BI Expertise: Advanced data modelling (STAR schema, relationships, filter direction). Strong DAX skills for measures and calculations. Experience optimizing performance for large datasets. Excel Mastery: Advanced formulas (SUMIFS, COUNTIFS, text functions). Dashboard More ❯

Connect data sources: HubSpot (CRM/marketing), ad platforms (Meta, Google, TikTok), Stripe (payments), and analytics tools Monitor pipeline health, troubleshoot data consistency issues, and ensure data freshness Handle schema changes and API updates Data Modeling and Transformation Design dimensional data models (fact and dimension tables, star schemas) Build standardized business metrics for marketing, sales, and finance Combine … and optimized performance Advanced SQL proficiency - Complex joins, CTEs, window functions, query optimization ETL/pipeline experience - Configured tools like Fivetran, Airbyte, or Stitch Data modeling expertise - Dimensional modeling, star schemas, fact/dimension tables BI tool experience - Built executive dashboards in Sigma, Tableau, Power BI, Looker, or similar Business acumen - Understanding of marketing metrics (CAC, LTV, ROAS), SaaS More ❯

analytics projects Manage multi-vendor and internal teams Ensure alignment with strategic objectives Essential Skills Leadership in multi-vendor environments BI/Warehousing & Agile Scrum expertise Data warehouse architecture (Star Schema, Kimball, Inmon) Project management (PRINCE2, PMP) & ITIL principles Strong stakeholder engagement & risk management Desirable Knowledge of emerging tech & MPP platforms Advanced data warehouse design experience Other Ability More ❯

analytics projects Manage multi-vendor and internal teams Ensure alignment with strategic objectives Essential Skills Leadership in multi-vendor environments BI/Warehousing & Agile Scrum expertise Data warehouse architecture (Star Schema, Kimball, Inmon) Project management (PRINCE2, PMP) & ITIL principles Strong stakeholder engagement & risk management Desirable Knowledge of emerging tech & MPP platforms Advanced data warehouse design experience Other Ability More ❯