25 of 25 Permanent Star Schema Jobs

Azure, or GCP. We are specifically looking for candidates with strong ETL experience, including: Informatica PowerCenter SQL Server Data Warehousing (DWH) Concepts Data Modeling (Star Schema, Snowflake Schema) Fact & Dimension Tables, SCD (Slowly Changing Dimensions) ETL Development (Source-to-Target Mapping, Incremental Loads) Cloud Platforms (AWS/… Experience in building and maintaining fact and dimension models Hands-on experience with data modeling and performance optimization Informatica PowerCenter, SQL Server, Data Warehousing Star Schema, Snowflake Schema Cloud Platforms: AWS/Azure/GCP (any one preferred) Cloud ETL Tools: Informatica IICS/Azure Data Factory ...

evolving reporting landscape. What You’ll Do Design and develop scalable data transformations in Azure Databricks using Python and Spark Build and maintain star-schema models aligned to business KPI definitions Collaborate with Data Engineering to improve data quality and reliability Support and enhance Tableau dashboards and certified … roles Strong SQL skills (complex queries, optimisation, data validation) Hands-on experience with Python and Spark, ideally in Azure Databricks Experience designing and maintaining star-schema models Experience supporting reporting in Tableau or Power BI Solid understanding of data warehousing, governance, and KPI standardisation Strong stakeholder communication ...

Developer. The Role Joining a newly formed team, you will take ownership of transforming ingested data from the staging layer into governed, high performance star schema models within the reporting layer using Azure Databricks and Azure SQL. Other key responsibilities include: Data Modelling - Design and maintain star schema models, ensuring fact and dimension structures are aligned to business definitions and scalable for future growth. Reporting Development and Delivery - Contribute directly to the development and enhancement of Tableau dashboards and certified data sources. Data Governance - Play a critical role in centralising KPI logic and improving consistency ...

within a small analytics squad. Build, maintain and optimise Power BI solutions, covering data modelling, DAX and semantic layers. Design robust data models using star schema principles and well managed relationships. Own performance tuning across Power BI models and reports to ensure scalability and usability. Partner closely with … analytical development. Advanced Power BI capability, including end to end build experience from data model to final dashboard. Strong data modelling skills, including star schema design and relationship management. Deep experience with DAX, including measures and calculated columns. Proven experience in performance tuning and optimisation of Power ...

Hands-on experience with SQL, PL/SQL, and ETL processes(SSIS) to transform and visualize complex data sets. Advanced knowledge of data modeling (Star Schema, Snowflake Schema), data visualization, and data transformation techniques. Strong knowledge of SQL Server, Power Query, Power Pivot, and T-SQL. Experience ...

processing. Work with AWS services such as DMS, Glue, Lambda, Step Functions, S3, Redshift, Athena, RDS, EC2, and CloudWatch. Design and implement data models (Star Schema, Snowflake Schema) to support downstream BI and analytics dashboards. Perform data validation, reconciliation, and quality checks across migration and ingestion pipelines. ...

solutions Requirements Strong experience with SQL and Azure Data Factory Experience with Databricks and/or Microsoft Fabric Good understanding of data modelling (e.g. star schema, dimensional modelling) Experience integrating data from multiple systems Exposure to Power BI, particularly data models or datasets Experience working in Azure cloud ...

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. A strong understanding of Power BI engineering discipline: PBIP/ ...

handling, encryption, RBAC, ACLs). - Worked with CI/CD, version control (Git), code review processes, and automated testing for data. - Designed data models (star schema, transformed delta tables, data marts) for analytics and BI. - Ensured data quality through validation, profiling, reconciliation, and automated tests. - Improved or restructured ...

Synapse/OneLake) Experience building and managing data pipelines and workflow orchestration tools (e.g. Airflow, Data Factory) A solid understanding of data modelling (e.g. star schemas, SCD) and governance principles Experience implementing data quality testing and validation Familiarity with CI/CD and version control (e.g. Git, GitHub Actions ...

optimise scalable data pipelines to ingest, transform and load data from multiple source systems into a centralised data platform Build and maintain performant star-schema data models aligned to business definitions Develop and enhance dashboards and certified data sources for business stakeholders Support governance initiatives including data definitions ...

backlog prioritization. Required Qualifications: Strong technical acumen in data product and BI solution delivery. Deep understanding of data modeling techniques and architectural patterns (Star Schema, normalized/denormalized models, etc.). Experience working with BI and data wrangling tools (Tableau, Power BI, etc.). Proficiency in SQL, Python ...

maintain data pipelines using Fabric Data Factory Develop and manage Fabric Warehouses, aligned to medallion architecture (Gold layer) Design and implement data models (Star Schema) Configure and manage Admin Portal and tenant settings Manage: Data gateways Connections and credentials Workspace roles and permissions OneLake security Essential Skills & Experience ...

reporting and analytics. • Partner with stakeholders to understand requirements, validate assumptions and shape how data should be modelled. • Apply strong data modelling practices, including star schemas and Kimball methodologies. • Support the management of the lakehouse, including incremental loads, snapshotting and data quality. • Contribute to the relationship with Databricks ...

developing Power BI reports and semantic models Advanced Power BI and DAX expertise Strong SQL skills for querying, validation, and analysis Strong understanding of star schema and BI data modelling best practices Experience working with financial or KPI-driven reporting environments Ability to troubleshoot reporting, data model ...

working in a cloud data environment, ideally Azure. Solid SQL capability and confidence building reliable transformation logic. Experience with data modelling concepts such as star schema, Kimball-style modelling, and semantic layers. Power BI experience across data modelling, DAX, and report development. Exposure to Databricks and lakehouse concepts ...

products that support analytics, reporting, and emerging AI initiatives. Key Responsibilities Define and own enterprise-wide data modelling standards, including Data Vault, semantic layers, Star Schema patterns, Snowflake object hierarchies, and governance frameworks. Design scalable integration architectures for legacy platforms, including AS400, iSeries, and SQL-based systems, ensuring ...

improve a lakehouse architecture, supporting ingestion, transformation, and consumption layers. Create robust, well-structured data models using best practice approaches such as Kimball and star schema. Work closely with business stakeholders to translate requirements into clear, usable data assets. Support and enhance the Power BI reporting layer, including semantic ...

Power BI Strong working knowledge of Git/version control, CI/CD pipelines, and Python for automation Solid understanding of star schemas and Kimball methodologies Experience supporting advanced Power BI models (DAX and Power Query) Exposure to ML/AI concepts (e.g. scikit-learn, TensorFlow) or an interest ...

managed service period What We're Looking For Expert SQL and data modelling; you build and maintain modular, analytics-ready data models (dimensional, star schema) that serve BI tools, AI agents, and automated reports. BigQuery preferred; Snowflake, Redshift, or Postgres transferable Cloud and pipeline fluency; comfortable navigating … BigQuery, IAM, GCS, CLI) and managing end-to-end ELT pipelines using tools like Fivetran, Airbyte, or dbt; you handle connector config, sync scheduling, schema management, and failure handling without hand-holding Python and AI tooling; you write scripts to automate provisioning and data quality checks ...

bridge" for data analysts, assisting them with DBT documentation, testing, and minor model adjustments. SOP Execution: Troubleshoot common issues (API timeouts, schema drifts) using our existing playbooks and document new fixes. Cloud Maintenance: Manage permissions and basic resource monitoring within AWS and Google Projects. What do we expect from … must; Python for general scripting and Airflow logic. Intermediate understanding of data modeling concepts, of how tables relate (Joins, Primary Keys, and basic Star Schema concepts). Ability to read logs in Databricks/Airflow and trace data flow through the stack. Ability to explain technical table structures ...

team member Data Modeling and Design: Design and maintain logical and physical data models (dimensional, relational) across our Databricks lakehouse environment. Apply Kimball star schema and normalized modeling best practices. Translate business requirements into clear, well-documented data structures that serve analytics, reporting, and AI consumption. Cross-System ...

Strong interpersonal skills; ability to translate complex data architecture into clear language for Business Analysts and non-technical stakeholders. Duties Data Modelling Standard: defining Star Schema patterns, Snowflake object hierarchies, and modelling conventions that serve as the Group-wide standard for all data products. Cross-Cloud Orchestration : Design ...

within Agile/Scrum/Kanban environments Proven experience writing user stories, acceptance criteria and defining Definition of Done Strong understanding of: Data warehousing Star schemas ELT pipelines Reporting & analytics processes Big data migration projects Good SQL and data analysis skills Experience working with both relational and non-relational ...

with clear ingestion, transformation, and consumption layers Creating robust data models to support analytics and reporting, following best-practice approaches such as Kimball and star schemas Supporting and enhancing the Power BI semantic layer and reporting outputs Working closely with stakeholders to translate business requirements into scalable data solutions … reporting layer Exposure to Databricks, particularly for data transformation and connecting multiple data sources Familiarity with concepts such as medallion architecture, star schemas, and analytics engineering best practice Confidence working with non-technical stakeholders and translating requirements into data models What They Offer Salary up to £60,000 plus ...