Summary of the work
Specialist role – Designer
GreenPlum Specialist for HMPO’s BI transformation project, working within an agile delivery team to iteratively build and implement a BI service in collaboration with the project team to deliver Alpha. Alpha is limited in scope but will lay foundation of key architecture building blocks for the future BI platform.
Latest start date Monday 29 May 2017
Expected contract length 3-6 months with the possibility of 2 years to delivery of an end to end BI service.
Work is for Her Majesty’s Passport Office
About the work
Who the specialist will work with:
There is a small team allocated to this work formed of 1 Product Manager, 1 BA and a Lead Architect.
What the specialist will work on:
Design the GreenPlum schema for the BI views, and data analysis Implement GreenPlum infrastructure for HMPO in cloud Implement the data ingestion and annoymisation of data in GreenPlum Implement the database access controls working closely with IA and Security Architect. Do the Data analysis and implement resource isolation between different tenants of that data platform, using workload management feature of GreenPlum at scale Document the schema design choices; write efficient queries and troubleshooting performance issues Work with BI developers implement data solutions between the visualisation and back-ends Document the high/low level technical details as per the project’s technical governance.
Skills and experience
Essential skills and experience:
Have demonstrable experience Experience in Greenplum (Analysis, Design, Development and Deployment)
Have completed 2 end to end implementation in Greenplum
Have demonstrable experience of using Azure SQL databases and data warehouse services
Have demonstrable experience of using Data connectors to private cloud data stores
Have demonstrable experience of successfully delivering digital solutions that collect and manage personal and/or sensitive information with appropriate controls and protection.
Have demonstrable experience of successfully working with other suppliers/3rd parties/other partners in the delivery of public sector digital services;
Have demonsrtable experience of Data analysis and multi-dimensional data modelling, resource isolation between different tenants of that data platform, using workload management feature of GreenPlum at scale
Experience in guiding development team to make good schema design choices and write efficient queries
Experienced in troubleshooting performance issues
Work with BI developers finding data solutions between the visualisation and back-ends
Handle ad-hoc schema changes with no downtime
Nice-to-have skills and experience:
Experience of using Miscrsoft Azure, and Power BI to develop interactive reports and dashboards for visual insights.
Have demonstrable experience of successfully and collaboratively working, coaching and sharing knowledge with Public Sector client teams, particularly those with limited agile development experience.
Have demonstrable experience of successfully design and implementation for cloud based BI / data analytics solutions utilising Microsoft PowerBI
Have demonstrable experience of Data Analysis, Data Cleansing, Database Administration, Analytics
Have demonstrable experience of Regulatory Reporting, Data Visualisation