20 of 20 Remote/Hybrid Star Schema Jobs

assess 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 … knowledge-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 ...

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

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

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

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

financial reporting solutions, including dashboard design and data visualisationStrong technical knowledge of ERP-derived financial data, data extraction and transformation, reconciliation, data quality and Star Schema dimensional modelling.Experience with Microsoft Fabric, Direct Lake, SQL, DAX and M Coding. Proven ability to develop team capability, strengthen technical reporting skills ...

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

Isio’s DBA strategy. Working with relevant stakeholders. Own and maintain the database architecture for Isio's data warehouses and connected operational systems, including schema design, indexing strategy and query optimisation. Operational and technical responsibility for the data systems. Define and enforce database backup schedules, test restore procedures … maintain database health. Monitor database performance, capacity, and availability; proactively address bottlenecks and plan for data growth. Manage database change control processes, including schema version control and change-freeze enforcement across systems. Work closely with data and solution architects providing technical expertise and design leadership for the delivery ...

following skills, knowledge and experienceStrong SQL skills and experience building analytical data models in a production environmentData modelling approaches such as dimensional modelling, star schemas, metric layers or similarWorking with dbt or similar transformation and orchestration toolsBuilding semantic models or reusable business logic for BI, analytics or self-service ...

Alteryx, PowerQuery (M) or Fabric tools (e.g. Dataflows, Lakehouse, pipelines) to create reliable datasets for reporting.Experience developing and managing robust semantic models (dimensional/star schema) to underpin scalable and reusable reporting solutions including DAX optimisation and model design best practice.Experience working with end-users and stakeholders ...

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

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

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

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

scalable dimensional model built to serve multiple global clients.This role is not just about moving data; it is about the sophisticated translation of complex schema designs into production-ready SQL. You will be the bridge between abstract data architecture and the high-performance scripts that power our business intelligence.Key … will be responsible for ensuring the architecture is scalable enough to onboard several major global clients without compromising performance.Expert SQL Development: Translate complex schema designs into high-quality, performant SQL scripts. You will own the logic that transforms raw, disparate data into structured clean tables.Global Scalability: Design and optimise ...

integrations, APIs and data flows **Experience governing vendor and SI designs within a Design Authority **Strong stakeholder management and influencing skills **Lakehouse (Medallion) or Star Schema data warehouse design, and agentic AI automation (desirable) The Rate: The Rate: £500 - £525 per day, hybrid role 2 days onsite, inside ...