GreenPlum Specialist

Tender description

Who Speclialist Work With There is a small team allocated to this work formed of 1 Product Manager, 1 BA and a Lead Architect. What Specialists 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. Where the Work Takes Place Westminster, London Early Market Engagement Home Office have already evaluated various BI tools and chosen Microsoft Power BI as a strategic BI Visualisation Tool. Greenplum is chosen as underlying BI data platform Working Arrangements We expect the specialist to work collaboratively with existing in house project teams that are transforming the way HMPO processes business intelligence. Work is based in London and will involve the supplier being on site 4 days per week to work collaboratively with HMPO teams; travel and expenses remains the responsibility of the supplier. Service design and development must align with the HM Passport Office strategic technical architecture and technologies. Work Location Westminster, London Security Clearance SC clearance is required. HMPO will support the clearance process. Additional T&Cs Breakpoints to assess progress and quality will be set at the end of alpha phase. Skills & 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 Haves 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 No. of Specialists to Evaluate 3 Cultural Fit Criteria Be transparent and collaborative when making decisions Take responsibility for their work Can work with clients with low technical expertise Able to work within HMPO design, delivery and governance framework Assessment Method Evaluation Weighting Technical competence 55% Cultural fit 20% Price 25% Questions from Suppliers Budget range market rate