24 of 24 Star Schema Jobs in the UK excluding London

ETL, SQL programming/SSIS skills. Skills in data mapping and modelling. 3-5 years' experience in SQL language. Knowledge of Kimball methodology/Star Schema modelling in Data Warehousing. Experience of SSIS and SSMS. Good understanding and experience of building ETL processes including extracting data via APIs. … ETL, SQL programming/SSIS skills. Skills in data mapping and modelling. 3-5 years' experience in SQL language. Knowledge of Kimball methodology/Star Schema modelling in Data Warehousing. Experience of SSIS and SSMS. Good understanding and experience of building ETL processes including extracting data via APIs. More ❯

members at Gray. What we expect (essential functions) Develop and maintain reports, dashboards, and visualizations using Power BI. Design and implement data models using star schema principles to optimize report performance and usability. Write advanced SQL queries to clean, transform, and validate data for reporting. Apply DAX to … Data Analysis Expressions) for creating calculated measures and columns in Power BI reports. Advanced understanding of SQL for querying and transforming data. Familiarity with star schema design and its application in reporting. Strong communication and analytical skills, with the ability to manage multiple priorities effectively. Experience with GIT More ❯

ll play a key role in delivering this vision as part of an agile team focused on: Developing scalable Azure Data Factory pipelines Implementing STAR schema-based data models in Azure SQL Enhancing security, manageability, and cost-efficiency of data operations Building reusable, templated data ingestion processes Applying … authentication Parallelism and performance tuning for ADF pipelines Templating for reusable, scalable ingestion patterns Azure SQL: Integration with Microsoft Entra ID (formerly Azure AD) STAR schema implementation for analytic models Standardising naming conventions and schema organisation Migrating data processing logic from Power BI to the SQL layer More ❯

the warehouse. Develop and maintain documentation on data models, processes, and business rules. SKILLS AND QUALIFICATIONS Data Warehousing: Strong knowledge of the Kimball methodology (star schema, fact & dimension tables). Experience in designing and implementing data models for analytical reporting. ETL/ELT & Data Integration: Hands-on experience More ❯

and other Azure data services. Familiarity with Azure Blob Storage, Azure Data Lake, and data lake architectures. Experience working with data modelling, normalization, and star schema design for data warehouses. Proficient in scripting languages such as Python, Shell, or PowerShell for automation tasks. Knowledge of CI/CD More ❯

and other Azure data services. Familiarity with Azure Blob Storage, Azure Data Lake, and data lake architectures. Experience working with data modelling, normalization, and star schema design for data warehouses. Proficient in scripting languages such as Python, Shell, or PowerShell for automation tasks. Knowledge of CI/CD More ❯

databases and data warehouses. Hands on experience of delivering fully reconciled Facts and Dimensions and accurate end user reports. Knowledge of Data Warehouse design; Star schema and dimensional modelling. Strong analytical skills and a technical aptitude. Ability to challenge and provide input in system architecture and design decisions. More ❯

databases and data warehouses. Hands on experience of delivering fully reconciled Facts and Dimensions and accurate end user reports. Knowledge of Data Warehouse design; Star schema and dimensional modelling Strong analytical skills and a technical aptitude Ability to challenge and provide input in system architecture and design decisions. More ❯

databases and data warehouses. Hands on experience of delivering fully reconciled Facts and Dimensions and accurate end user reports. Knowledge of Data Warehouse design; Star schema and dimensional modelling Strong analytical skills and a technical aptitude Ability to challenge and provide input in system architecture and design decisions. More ❯

of these. Experience of building a data warehouse using an ETL/ELT tool, preferably Oracle ODI Significant database experience in Snowflake or Oracle Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions More ❯

of these. Experience of building a data warehouse using an ETL/ELT tool, preferably Oracle ODI Significant database experience in Snowflake or Oracle Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions More ❯

support the onboarding of new datasets. Azure SQL: Integrating database access with Microsoft Entra ID for improved identity and access management. Designing and implementing STAR schema models to support analytical workloads. Defining consistent naming conventions across all database objects. Migrating data processing logic from Power BI into Azure More ❯

pipeline to support the ingestion of new datasets through the platform Azure SQL Integrating Database Access with Microsoft Entra ID for enhanced security. Implementing STAR schemas on Data Models. Establishing naming conventions for database objects. Transitioning data processing from Power BI to Azure SQL. Segregating data serve level data More ❯

with accurate end-user reports Proficiency with reporting tools such as Oracle OAS and Microsoft Power BI Deep understanding of Data Warehouse design, including Star schema and dimensional modelling Strong analytical skills and technical aptitude, with the ability to influence system architecture decisions Experience leading testing disciplines within More ❯

with accurate end-user reports Proficiency with reporting tools such as Oracle OAS and Microsoft Power BI Deep understanding of Data Warehouse design, including Star schema and dimensional modelling Strong analytical skills and technical aptitude, with the ability to influence system architecture decisions Experience leading testing disciplines within More ❯

design and build of data platforms using Databricks following best practices and a consistent approach and methodology You'll create robust data models (e.g. star schemas, data vault) to enable scalable analytics and reporting You'll deliver efficient ETL/ELT processes tailored to our clients' requirements. Team Leadership More ❯

Familiar with Microsoft Office Suite (Excel, PowerPoint). Ambitious, inquisitive, team player with 'can-do' attitude. Excellent attention to detail. Desired Skills Experience with star schema and multi-dimensional data modelling Proficiency in SQL, Python, or other languages in data analysis Experience with DBT and/or Snowflake More ❯

and analyse large scale structured data and validate by profiling in a data environment Understand data structures and data model (dimensional & relational) concepts like Star schema or Fact & Dimension tables, to design and develop ETL patterns/mechanisms to ingest, analyse, validate, normalize and cleanse data Liaise with More ❯

and analyse large scale structured data and validate by profiling in a data environment. Understand data structures and data model (dimensional & relational) concepts like Star schema or Fact & Dimension tables, to design and develop ETL patterns/mechanisms to ingest, analyse, validate, normalize and cleanse data. Liaise with More ❯

and analyse large scale structured data and validate by profiling in a data environment. Understand data structures and data model (dimensional & relational) concepts like Star schema or Fact & Dimension tables, to design and develop ETL patterns/mechanisms to ingest, analyse, validate, normalize and cleanse data. Understand and More ❯

streamlining manual processes into automated flows. Familiarity with pharmaceutical compliance risks or compliance considerations for stakeholder engagements is a plus. Fluency in SQL, PowerQuery, star-schemas, DAX, or similar coding languages and approaches is preferred but not required. Are you ready to 'go beyond' to create value and make More ❯

User Stories and Acceptance Criteria specification Managing agile product backlogs in scrum Process and requirements modelling Data Modelling of financial data and CUBE/Star Schema Data Analysis Reconciliation Defect triage and classification of bug prioritisation and severity Financial modelling and statutory reporting platforms Knowledge and Experience 7+ More ❯

delivering fully reconciled Facts and Dimensions and accurate end user reports. Hands on and technical understanding of complex Data Warehousing, including Data Warehouse design; Star schema and dimensional modelling Proficient with using OAS (or similar reporting tools) and validating subject areas and reports. Experience of working with and More ❯

delivering fully reconciled Facts and Dimensions and accurate end user reports. Hands on and technical understanding of complex Data Warehousing, including Data Warehouse design; Star schema and dimensional modelling Proficient with using OAS (or similar reporting tools) and validating subject areas and reports. Experience of working with and More ❯