1 to 25 of 28 Star Schema Jobs in the UK

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 ❯

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 in More ❯

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 in 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 ❯

with the rest of the days from home. Key Skills * Hands-on experience working with Teradata and other Datawarehouses. * Deep expertise in Teradata architecture, star schema, snowflake schema, SQL optimization, and Data Modelling. * Experience in implementation of Teradata utilities (BTEQ, Fast Load, Multiload, TPT etc.) for efficient More ❯

with the rest of the days from home. Key Skills * Hands-on experience working with Teradata and other Datawarehouses. * Deep expertise in Teradata architecture, star schema, snowflake schema, SQL optimization, and Data Modelling. * Experience in implementation of Teradata utilities (BTEQ, Fast Load, Multiload, TPT etc.) for efficient 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 ❯

complex datasets using traditional or map reduce batch mechanism. Strong data modeling skills with solid knowledge of various industry standards such as dimensional modeling, star schemas, etc. Extremely proficient in writing performant SQL working with large data volumes. Experience designing and operating very large Data Warehouses. Experience with scripting 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 ❯

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 ❯

and other sources. Apply data cleansing rules to ensure high data quality standards. Model data into a single source of truth using Kimball methodology (star schema, snowflake, etc.). Develop high-quality code following DevOps and software engineering best practices, including testing and CI/CD. Monitor and More ❯

concisely PREFERRED QUALIFICATIONS Experience in data warehousing, BI tools, techniques, and technology Data engineering skills; programming knowledge (JAVA/PYTHON/SCALA) Knowledge of Star Schemas, Dimensional Models, Data Marts, Big Data, and Advanced Analytics Strong analytical skills with attention to detail and big-picture understanding Excellent communication skills More ❯

Strong Python skills • Experience with version control for data models (e.g., dbt testing frameworks, data documentation) • Demonstrated experience with data modelling concepts (dimensional modelling, star schemas) • Experience writing efficient and optimised SQL for large-scale data transformations • Understanding of data warehouse design principles and best practices • Proactive approach to 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 analyze 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, analyze, validate, normalize, and cleanse data. Understand and More ❯