1 to 25 of 47 Star Schema Jobs

technical feasibility, evaluate trade-offs, and translate product requirements into maintainable, scalable technical solutions. Build and maintain production-ready Python services, SQL transformation layers, star-schema data models, and API integrations across relational databases and cloud storage (Azure Data Lake).Optimise pipeline performance, system reliability, compute efficiency … sharing, while systematically refactoring technical debt and maintaining operational runbooks. Experience that contributes to success: Substantial experience designing, building, and operating production data platforms, star-schema data models, and complex ELT/ETL pipelines. Advanced proficiency in Python and SQL, including clean object-oriented design, Pandas, query optimization ...

insights into enterprise grade, productionised reporting. What You'll DoOwn the Gold Layer: Build and optimize high-performance Power BI semantic models and star-schema architectures within a Unified, AI-powered analytics platformProductionize Reports: Review, refine, and promote reports from domain workspaces (Finance, Financial Crime, Marketing) into central … level security (RLS).What You BringSignificant hands on experience productionising Power BI reports and managing live estates. Deep expertise in DAX, dimensional modelling (star schema), and layered data architectures. Demonstrable excellence with SQLExposure to Microsoft Fabric, Azure Synapse, or Azure Data FactoryHigh technical rigor and diplomatic communicationYou catch ...

Apache Kafka for real-time event streaming and data pipeline orchestration at scale. Hands-on experience with Apache Iceberg table formats, including partitioning strategies, schema evolution, and snapshot management. Experience with Starburst/Trino (or other modern query engine like StarRocks, Dremio) as a distributed SQL query engine … RESTful APIs and back-end services that serve data to web applications. Deep knowledge of PostgreSQL (16+) including advanced query optimization, indexing strategies, and schema design for both application and analytical workloads. Experience with Iceberg catalog management (e.g., Lakekeeper) and object storage (e.g., AWS S3, MinIO) for physical data ...

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

development Proven experience building batch and streaming data pipelines Experience implementing Medallion Architecture and Lakehouse patterns Strong understanding of data modelling techniques (dimensional, star schema, data vault) Experience with CI/CD, Infrastructure as Code and DevOps practices, Git-based source control and deployment pipelines Strong understanding ...

Server, Azure SQL Database and T-SQL. Experience with ETL/ELT and data integration tools, ideally Informatica. Strong understanding of dimensional modelling, including Star Schema. Experience optimising BI models, queries and reporting performance. Understanding of Power BI Service administration and governance. Experience working in an agile environment, ideally ...

Design, implement and maintain scalable ETL/ELT pipelines, ensuring data quality, integrity and reconciliation throughout the migration. Develop and optimise data warehouse structures, star schemas and dimensional models to support business and regulatory reporting. Apply best practices for Snowflake performance tuning, query optimisation and cost efficiency. Implement automated … design, query optimisation, performance tuning and troubleshooting. Significant experience designing and delivering enterprise-scale ETL/ELT solutions. Strong understanding of data warehousing principles, star schema design, dimensional modelling and data architecture. Experience with data governance, data quality and reconciliation within enterprise environments. Familiarity with Git-based source ...

dashboards, reports, and semantic models. Proficiency in DAX for measures, calculated columns, time intelligence, and analytical functions. Solid understanding of dimensional modeling and Star Schema design. Experience connecting Power BI to Azure Databricks, Data Lakehouse, or similar cloud platforms. Strong MS SQL skills for data analysis and validation. ...

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

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

https://www.mclh.co.uk/careers/employee-benefits/) What you will be doing Design, develop and maintain Power BI semantic models, including star schemas, relationships, calculated measures and DAX. Develop clear, intuitive and well-organised Power BI reports and dashboards, as well as maintaining and improving existing … measures, filter context and relationships. Good SQL development skills, including joins, aggregations, and window functions. Good understanding of dimensional modelling, including facts, dimensions and star-schema design. Experience working with relational databases and data warehouse environments. Strong attention to detail and a disciplined approach to validating the accuracy ...

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

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

Python and statistical modelling techniques. Experience working with Snowflake or similar cloud-based data warehouse technologies. Understanding of data modelling principles, including dimensional and star schema modelling. Experience with Power BI and data visualisation best practices. Familiarity with CI/CD processes, version control, testing, and software development ...

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

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

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 datasetsStrong communication skills with the ability to work with non-technical stakeholdersNICE TO HAVEHands ...

legacy reporting processes into scalable automated pipelines, including migration from SAS-based processes to Anaconda and Python-based solutions. Design optimized data marts and star schemas for Power BI consumption. Develop and tune SQL queries to deliver accurate, high-performing risk-reporting outputs. Partner with data-reporting teams ...

with Microsoft Fabric, Azure Databricks and Azure Data Factory. Solid knowledge of Delta Lake, Medallion Architecture, PySpark and SQL. Expertise in dimensional modelling and star schema design. Advanced Power BI development, including DAX and semantic modelling. Experience with Azure security, governance, DevOps and CI/CD practices. Proven ...

Proven ETL development and data pipeline experience. Solid understanding of data warehousing principles and best practices. Experience with dimensional modelling, including concepts such as star schema, semantic models, tabular models and Kimball methodologies. Exposure to DAX development. Experience working across complex data environments and multiple stakeholders. Strong problem ...

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

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

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

data warehouse projects Experience working with Power BI, Tableau, Qlik, Cognos, or similar BI platforms Strong understanding of data modelling concepts , including facts, dimensions, star schemas, semantic models, and reporting architectures Experience working with Kimball-style dimensional modelling methodologies Experience designing, supporting, or validating semantic data models for reporting ...