22 of 22 Remote/Hybrid Star Schema Jobs

join a UKRI data initiative, enhancing, expanding and improving an existing enterprise data warehouse. The role requires strong hands-on experience with Kimball and star schema modelling, together with the SQL/data skills to take new source data and integrate it into an existing warehouse model. This ...

join a UKRI data initiative, enhancing, expanding and improving an existing enterprise data warehouse. You'll need strong hands-on experience with Kimball and star schema modelling , together with the SQL/data skills to take new source data and integrate it into an existing warehouse model. … requirements Strong experience with Kimball and star schema data modelling Experience enhancing and expanding existing enterprise data warehouses Proven ability to take source data and integrate it into an existing warehouse model Strong SQL and data skills Good understanding of enterprise data warehouse environments Strong stakeholder engagement ...

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

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

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

transform data from SQL Server databases, REST APIs, SaaS applications and file‐based exports. Develop and optimise SQL transformations, stored procedures and Kimball‐style star‐schema data models. Build and support Power BI semantic models and the datasets behind dashboards used by teams across the business. Implement data ...

transform data from SQL Server databases, REST APIs, SaaS applications and file‐based exports. Develop and optimise SQL transformations, stored procedures and Kimball‐style star‐schema data models. Build and support Power BI semantic models and the datasets behind dashboards used by teams across the business. Implement data ...

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

Redshift. Experience working with data ingestion techniques, including change data capture (CDC), REST API integrations and incremental loading. Understanding of data modelling approaches, including star schemas, medallion architecture and slowly changing dimensions. Experience with Git, version control and CI/CD pipelines. An understanding of Infrastructure as Code principles ...

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

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

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

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

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

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