2 of 2 Dimensional Modelling Jobs in Hampshire

business requirements and high-level designs. Ensure alignment of low-level designs with application architecture, high-level designs, and AA Standards, Frameworks, and Policies. Analyse data sets to identify modelling logic and key attributes required for low-level design, and create and maintain appropriate documentation. Develop and update Physical Data Models (PDMS) and participate in design reviews. Lead handover … What do I need? Experienced with data warehouse and business intelligence, including delivering low-level ETL design and physical data models. Proficient in Data Warehousing Design Methodologies (e.g., Kimball dimensional models) and Data Modelling tools (e.g., ER Studio). Strong Data Analysis skills and hands-on experience with SQL/Python for data interrogation. Working knowledge of Cloud More ❯

The position requires at least 2 years of experience using QlikView version 11 or higher, with proven expertise in the following areas: Good knowledge of SQL, relational databases, and Dimensional Modeling Experience working with large data sets and complex data models involving more than 10 tables Integrating data from multiple sources into QlikView Data Models, including social media content … and API extensions Use of complex QlikView functions and developing optimal scripts for solutions Optimizing Dimensional data models for performance Primary Responsibilities: Creating and providing reporting and dashboard applications using QlikView and NPrinting to facilitate better decision-making Collaborating with stakeholders to gather requirements, and translating these into system and functional specifications Creating prototypes and conducting proof of concepts More ❯