3 of 3 Star Schema Jobs in Edinburgh

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 ❯

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 ❯