1 to 25 of 26 Star Schema Jobs in England

skills, and design sensibility. Key Responsibilities Design and develop Power BI dashboards from concept through to deployment and maintenance. Build robust data models using star schema and dimensional modeling techniques. Write DAX measures and calculations to deliver business metrics and KPIs. Create Power Query transformations to extract, clean … Query proficiency including M language, data transformations, and query optimization. SQL skills for data extraction, transformation, and understanding database structures. Data modeling experience including star schema, dimensional modeling, and normalization. Understanding of UX and design principles for user-friendly dashboards. Stakeholder management skills with ability to gather requirements ...

tools such as Talend, Informatica, Matillion, Pentaho, MuleSoft, Boomi, or scripting languages (Python, PySpark, SQL). Understanding of data warehousing and data modelling techniques (Star Schema, Snowflake Schema). Familiarity with security frameworks (GDPR, HIPAA, ISO 27001, NIST, SOX, PII) and AWS security features (IAM, KMS, RBAC ...

Data architecture (Data Lakes, Data Warehouses) and distributed processing concepts (e.g., MapReduce). ETL/ELT Basic knowledge of ETL principles and data modeling (star schema, snowflake schema). Version Control Practical experience with Git (branching, merging, pull requests). Preferred Qualifications (A Plus) Experience with ...

Data architecture (Data Lakes, Data Warehouses) and distributed processing concepts (e.g., MapReduce). ETL/ELT Basic knowledge of ETL principles and data modeling (star schema, snowflake schema). Version Control Practical experience with Git (branching, merging, pull requests). Preferred Qualifications (A Plus) Experience with ...

Boomi, Informatica, Talend, SSIS, or custom scripting languages (Python, PySpark, SQL) for data extraction and transformation. Prior experience with Data warehousing and Data modelling (Star Schema or Snowflake Schema). Skilled in security frameworks such as GDPR, HIPAA, ISO 27001, NIST, SOX, and PII, with expertise ...

query development, performance tuning, indexing, and data transformation across on-premise databases and AWS cloud environments. Solid understanding of data warehousing and modelling techniques (Star Schema, Snowflake Schema). Familiarity with security frameworks such as GDPR, HIPAA, ISO 27001, NIST, SOX, and PII, as well ...

Hands-on expertise with Azure Data Factory, Azure Databricks, Azure Storage and Azure DevOps Advanced Python and SQL skills Experience designing data models (including star schema) for Power BI or similar reporting tools Experience within insurance, MGA or financial services environments is highly desirable Excellent communication skills with ...

multiple sources (APIs, databases, files, streaming) Develop scalable data transformations using PySpark and Spark SQL Implement data models optimized for analytics and reporting (e.g. star schemas) Monitor, troubleshoot, and optimize performance and cost of data workloads Apply data quality, validation, and governance best practices Collaborate with analysts ...

optimization. Python proficiency for data manipulation and automation. Power BI or Tableau experience including dashboard development. Data modeling experience including dimensional modeling and star schema. ETL and data transformation experience. Stakeholder management skills. Problem-solving mindset with ability to work independently. Strong attention to detail and commitment to data ...

scale. Key Responsibilities Data platform ownership: Lead the design, operation, and evolution of our SQL Server data warehouse. Establish best practice standards for schema design and performance tuning in SQL Server/SSMS. ETL/ELT & integration: Define and manage pipelines (e.g., SSIS & Power Query) that consolidate sources including … Power Query, RLS, performance). Advanced Excel: advanced formulas, Pivot tables, Power Pivot. ETL/ELT tooling (SSIS/Power Query) and dimensional modelling (Star Schema). Practical AI/ML exposure (e.g., Python notebooks, Azure ML, or equivalent) and the ability to operationalise models responsibly within reporting ...

Basic query optimisation* Exposure to CTEs and window functions* Hands-on experience with Power BI, including:* Building reports and dashboards* Basic data modelling (relationships, star schema awareness)* Creating DAX measures and calculations* Some experience or exposure to Azure Data Factory or similar ETL tools* Understanding of data warehousing ...

Strong SQL skills and experience with query optimisation. - Knowledge of Microsoft Fabric (Lakehouse, Dataflows, ADF).- An understanding of data modelling concepts (e.g. dimensional, star schema, denormalisation)- Knowledge of performance tuning techniques for ETL and SQL processes- Familiarity with data governance principles and GDPRDue to the type ...

Experience with at least one programming language such as Python, R, or similar Understanding of data warehousing and reporting architectures (ETL/ELT, star schemas, fact & dimension tables) Experience working with databases and data systems (cloud or on-premise) Interest in automating data and reporting workflows Finance & Business Understanding ...

design and data standards What you’ll need Strong Azure & Databricks engineering experience Advanced Power BI + SQL (SSIS a bonus) Solid data modelling (star schema, medallion, ETL patterns) Confident working with messy/complex data sources Performance tuning & optimisation skills Contract details 6-month Contract with ...

Power BI (report building, dashboards, DAX, data modelling) Proficiency in SQL for querying, validating, and analysing data Solid understanding of data modelling concepts (e.g. star schema, facts and dimensions) Experience working with data warehouses and/or data lakes Ability to create and maintain data dictionaries and metrics ...

visually engaging reports. Advanced proficiency with Power BI, including data modelling and DAX. Solid understanding of relational databases and data warehouse concepts (dimensions, facts, star schemas) and associated technologies (e.g., Databricks). Experience with Python (including Pandas/PySpark). Familiarity with software development and source control, in particular ...

visually engaging reports. Advanced proficiency with Power BI, including data modelling and DAX. Solid understanding of relational databases and data warehouse concepts (dimensions, facts, star schemas) and associated technologies (e.g., Databricks). Experience with Python (including Pandas/PySpark). Familiarity with software development and source control, in particular ...

visually engaging reports. Advanced proficiency with Power BI, including data modelling and DAX. Solid understanding of relational databases and data warehouse concepts (dimensions, facts, star schemas) and associated technologies (e.g., Databricks). Experience with Python (including Pandas/PySpark). Familiarity with software development and source control, in particular ...

Preparation Strong SQL and data transformation skills Power BI (DAX & Power Query) experience Familiarity with dbt or ELT tools (desirable) Knowledge of data modelling (star schema, slowly changing dimensions) Awareness of data governance and compliance (GDPR/GMP) Manufacturing or regulated industry experience is an advantage Ability ...

Preparation Strong SQL and data transformation skills Power BI (DAX & Power Query) experience Familiarity with dbt or ELT tools (desirable) Knowledge of data modelling (star schema, slowly changing dimensions) Awareness of data governance and compliance (GDPR/GMP) Manufacturing or regulated industry experience is an advantage Ability ...

experience across Azure Data Services (ADF, ADLS, Synapse, Databricks) Excellent SQL skills, with experience in performance tuning and optimisation Solid understanding of data modelling (star schema, medallion, ETL frameworks) Ability to work with complex, inconsistent or legacy data sources Experience building scalable, production-ready pipelines in a cloud ...

practices. A degree in a related field, such as Computer Science, Mathematics, or Statistics. Nice to have: Technical skills: Snowflake Scheme Design, Kimball Methodology, Star Schemas Programmes: Snowflake Job Offer A generous base salary and great flexibility with your working schedule, we offer training, development and progression opportunities. ...

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

data focused role such as Analytics, Business Intelligence, or Data Analysis. Proven ability to write complex, efficient queries and design analytical data models (e.g., star schemas). Strong understanding of how the business currently uses spreadsheets, with the ability to bridge manual analysis and scalable BI solutions. Hands ...

have Databricks experience Strong experience with relational and big data engines Knowledge of good data pipeline implementation and design (Concepts such as Kimball/Star Schema) Strong understanding Data warehousing concepts and modelling Proper documentation Good understanding of Agile ways of working Data Engineer, Azure, Databricks, ADF Reasonable ...