1 to 25 of 33 Permanent 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: Experience ...

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

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

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

plus years in a solution architect roleOne-plus year of Microsoft Fabric experienceTwo-plus years of Power BI experience: enterprise semantic model design, star schema modeling, DAX concepts, performance and capacity management and tenant administrationEnough hands-on ability to validate prototypes, review pipelines, notebooks, semantic models ...

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

within the insurance industry, ideally with exposure to Delegated Authority and/or Large Single Risk/Specialty business Familiarity with dimensional modelling concepts (star schemas, slowly changing dimensions) as applied within a modern lakehouse environment Thought Leaders: You are seen as an expert in your field and will ...

Warehouse) Azure Data Services (Synapse, Data Factory, Data Lake) SQL (advanced) and Python/Spark for data transformation Strong understanding of data modelling (e.g. star schema) Experience building scalable data pipelines for large datasets Experience in financial services data environments (desirable) #J-18808-Ljbffr ...

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

Snowflake ) Proven experience with dbt (modelling, testing, documentation) Experience building dashboards in Looker ( LookML is a strong plus) Solid understanding of data modelling concepts (star schema, dimensional modelling) Experience working with large-scale datasets Strong communication skills with the ability to work with non-technical stakeholders NICE ...

building and maintaining ETL processes and data pipelines Solid understanding of data warehousing concepts and dimensional modelling Experience working with semantic models, tabular models, star schemas, Kimball methodologies, or similar data modelling approaches Exposure to SSAS, DAX, and BI solution development Experience working across different data architectures and technology ...

/Sub, and Cloud Scheduler* Experience with Infrastructure as Code (Terraform) for provisioning and managing cloud resources.* Solid understanding of data modelling techniques (star schema, dim/fact architecture, slowly changing dimensions).* Comfortable with Git (GitHub, branching strategies, pull requests) and CI/CD (Cloud Build ...

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

infrastructure using Trino/Presto and open table formats like Apache Iceberg or Delta Lake. Advanced Data Modeling: Deep expertise in Medallion Architecture patterns, Star Schemas, and processing semi-structured financial data logs (JSON/Avro). Robust ETL/ELT Orchestration: Expert proficiency in data transformation engines (such ...

resolve production data issuesMust Have SkillsStrong Handson experience with DBT Data Build ToolExpertise in Snowflake Data WarehouseAdvanced SQL development and performance tuningData modelling Star Schema Dimensional ModellingExperience with ELTETL conceptsGit version control and CICD practicesExperience working in Agile environmentsNice to Have SkillsPython or PySparkAzure Data Factory ADFAzure DevOps ...

Microsoft BI technologies. Responsibilities Design, develop, implement, and maintain business intelligence using Microsoft BI technologies. Understand and implement data modeling using best practices and star schema design. Analyze complex data from multiple sources including SQL Server databases and Analysis Services Tabular models. Collaborate with business analysts and subject ...

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