Data Warehouse Consultant

ResponsibilitiesIdentify data requirements and data sources and engage with data owners and stakeholders to ensure data access and ingest.Design, develop, implement, and manage business intelligence reporting and Extract, Transform, Load (ETL) processes and environments.Design of data models and warehousing to best meet the requirements of DAFM Business Divisions and to maximise capabilities of available tools.Liaise with the business owners to monitor and report on project progression.Write and provide documentation including functional & technical specification and user guides or any supporting documentation required by the business owner.Provide training including presentations and facilitate/organise workshops as required.Maintenance and support of analytical products throughout their life cycle.Key SkillsExperience with real-time analytics and business intelligence platforms including the following software and database systems; Microsoft Power BI, Oracle, Cloudera & Hadoop.Using

scripting languages to develop new insights from the available data. Including the following programming languages; SQL/ PL-SQL.Experience in designing, developing, documenting, managing, and implementing business intelligence technical solutions covering Data modelling and Data architecture design (both logical and physical).Experience in Data Warehouse design methodologies e.g. star and snowflake schemas, or equivalent.Implementation, ETL, data integration and data migration design and implementation and Data warehouse performance optimisation.Experience in data management best practices including demonstrated experience with data profiling, sourcing, and cleansing routines utilising typical data quality functions including standardisation, transformation, rationalisation, linking and matching.Experience in providing data that is accurate, congruent, and reliable, and ensure the information is easily available to users for direct consumption or integration with other systems.Experience supporting mission-critical enterprise BI Systems.Experience in delivering end to end BI systems.Experience of working within a Public Service Body to develop insights for data driven policy development.