1 to 25 of 46 Star Schema Jobs in London

maintain high-quality Power BI dashboards and reports. Translate business requirements into scalable reporting and data modelling solutions. Develop robust semantic models using star schema principles. Build complex DAX measures, KPIs and Power Query transformations. Optimise report performance, datasets and refresh processes. Integrate Power BI with SQL Server … with Microsoft Power BI (Desktop & Service). Advanced DAX, Power Query (M) and SQL (T-SQL preferred). Strong understanding of dimensional modelling and star schema design. Experience developing high-performance enterprise reporting solutions. Strong understanding of ETL processes and data warehousing concepts. Experience integrating multiple enterprise data ...

Layer assets and analytics-ready datasets for enterprise consumption Building and maintaining data pipelines and transformation frameworks using dbt Designing dimensional data models and Star Schema structures Contributing to a rapidly evolving Data & AI capability What We're Looking For Essential Experience Excellent commercial experience with Snowflake Experience … delivering data solutions within Wealth Management, Asset Management, Investment Management or Financial Services environments Excellent understanding of Star Schema/dimensional modelling Strong experience with dbt Strong SQL and data engineering capability Strong data quality, lineage and governance experience Exposure to market data platforms and financial data ingestion ...

Snowflake Building and maintaining data pipelines and transformation frameworks using dbt Working with complex market, investment and risk datasets Designing dimensional data models and Star Schema structures Supporting portfolio suitability and regulatory reporting initiatives Implementing data quality, validation and governance controls Working closely with investment, risk and business … Leveraging modern engineering practices and AI-assisted development tools What We're Looking For Essential Experience Strong commercial experience with Snowflake Excellent understanding of Star Schema/dimensional modelling Experience with dbt Strong SQL and data engineering capability Experience working with time-series market data Exposure to market ...

Lambda AWS Step Functions Amazon Redshift Amazon Athena Amazon RDS/Aurora AWS IAM AWS KMS Amazon CloudWatch AWS Secrets Manager Data Modelling Skills Star Schema Snowflake Schema Dimensional Modeling Data Vault Data Warehouse Design Data Lake Architecture Data Formats Experience working with: Parquet Avro JSON ...

related field;3+ years of experience in Data Engineering;Knowledge of developing dimensional data models 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 cloud ...

working with the Azure data stack (Data Factory, Synapse/Fabric, SQL-based semantic layers). Advanced Power BI engineering skills: data modelling (star schemas), advanced DAX, Power Query/M, performance tuning and RLS, alongside sound engineering discipline, PBIP/TMDL source format, Git-based version control, pull ...

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 ...

Python (or equivalent language) skills for data manipulation and automation.Hands-on experience with cloud platforms (AWS, Azure, GCP).Knowledge of data modelling methodologies (star schemas, Data Vault, Kimball, Inmon).Familiarity with data lake architectures and distributed processing frameworks (e.g., Spark, Hadoop).Experience with version control tools (GitHub, Bitbucket ...

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 ...

stakeholder engagement. Key Responsibilities Design, develop and maintain scalable data pipelines using Snowflake and DBT. Build high-quality data models, including dimensional and star schema models. Engineer solutions supporting complex investment and portfolio data. Work with market data platforms and external data feeds. Develop solutions for time-series … Strong commercial experience as a Data Engineer. Expert knowledge of Snowflake . Strong experience with DBT . Data modelling experience, including dimensional modelling and star schemas. Experience working with time-series data. Experience integrating and managing market data feeds or financial datasets. Strong SQL and analytical problem-solving skills. ...

with several years of hands-on experienceExperience building scalable semantic layers in a BI tool (Looker preferred)Solid understanding of data modelling principles (e.g., star schema, dimensional modelling)Experience with ETL/ELT tools (e.g., dbt, Fivetran or similar)Knowledge of data governance and metric standardisation practicesExperience delivering ...

similar modern cloud‐based analytics and data platforms. Strong experience designing and governing analytical data models using recognised patterns such as Medallion Architecture, star schema, and snowflake schema. Experience leading technical teams, mentoring engineers, and establishing engineering standards and delivery practices. Experience developing and implementing data quality, monitoring ...

Server, CosmosDB, Azure Data Factory, Purview, Synapse, Event Hub, Azure Databricks/Fabric) Extensive data modelling experience: both normalised relational models and de-normalised Star Schema/dimensional models Excellent relational database design skills with expertise in diagnosing and optimising performance across SQL Server, PostgreSQL, and cloud databases ...

accurate reconciliation between systems. Enterprise Data Warehouse Own the design and continual evolution of the company's enterprise data warehouse. Responsibilities include: Dimensional modelling Star schema design Fact and dimension modelling Slowly changing dimensions Master data management Metadata management Semantic layer design Data lineage Business definitions Data quality … warehouses Strong commercial awareness Excellent understanding of financial reporting principles Experience partnering with Finance teams Strong SQL expertise Excellent dimensional modelling skills Experience designing star schemas Experience building enterprise reporting platforms Strong understanding of data governance Excellent stakeholder management skills Ability to communicate complex technical concepts to non-technical ...

Fabric. Experience delivering finance reporting and analytical solutions. Experience building Power BI reports and dashboards directly from Microsoft Fabric. Strong data modelling skills including star schema, fact tables, dimensions and semantic modelling. Strong Power BI skills including DAX and Power Query. Strong SQL skills and experience working with ...

important as communication and stakeholder engagement.Key ResponsibilitiesDesign, develop and maintain scalable data pipelines using Snowflake and DBT.Build high-quality data models, including dimensional and star schema models.Engineer solutions supporting complex investment and portfolio data.Work with market data platforms and external data feeds.Develop solutions for time-series datasets … quality, governance and performance optimisation.Skills & ExperienceEssentialStrong commercial experience as a Data Engineer.Expert knowledge of Snowflake.Strong experience with DBT.Data modelling experience, including dimensional modelling and star schemas.Experience working with time-series data.Experience integrating and managing market data feeds or financial datasets.Strong SQL and analytical problem-solving skills.Financial Services experience, ideally ...

communication and stakeholder engagement. Key ResponsibilitiesDesign, develop and maintain scalable data pipelines using Snowflake and DBT.Build high-quality data models, including dimensional and star schema models. Engineer solutions supporting complex investment and portfolio data. Work with market data platforms and external data feeds. Develop solutions for time-series … performance optimisation. Skills & ExperienceEssentialStrong commercial experience as a Data Engineer. Expert knowledge of Snowflake. Strong experience with DBT.Data modelling experience, including dimensional modelling and star schemas. Experience working with time-series data. Experience integrating and managing market data feeds or financial datasets. Strong SQL and analytical problem-solving skills. ...

Project Billing and Costing, Human Capital Management – and understands their underlying data structures and interdependencies. You should be familiar with the EBS schema, concurrent processing, and EBS configuration from a data perspective.Data Modelling: Strong data modelling skills, both relational (3NF) and dimensional (star schema) design. Able ...

delivering finance reporting and analytical solutions. Experience building Power BI reports and dashboards directly from Microsoft Fabric. Strong data modelling skills, including semantic models, star schema design, fact tables and dimensions. Strong Power BI experience, including DAX and Power Query. Strong SQL skills and experience working with multiple ...

least one of AWS, GCP or AWS. Strong SQL skills for data extraction, transformation and analysis. Experience working with dimensional modelling concepts (e.g. Star Schema, Kimball principles). Understanding of Data Warehousing, Lakehouse and Medallion architectures. TOTAL REWARDS: Total Rewards associated with this position include a comprehensive benefits ...

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 ...

Cloud). Experience with data ingestion tools like Fivetran or custom Python pipelines is a bonus.You bring hands-on data modelling expertise, Dimensional Modelling, Star Schemas, Data Vault, or OBT, and know how to translate complex real-world domains into clean, scalable analytics blueprints.You are comfortable working with cloud ...

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 ...

also relevant).• Comfortable with Git (branching, pull requests, code reviews) and basic CI/CD concepts.• Familiarity with data modelling concepts (tables, views, star schema basics).Highly Desirable:• Experience with Google Cloud Platform services - BigQuery, Cloud Functions, Cloud Storage, or Cloud Run.• Experience with dbt macros, Jinja ...

modelling 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/Pyspark ...