Business Objects Analyst/Developer for HMPPS Digital Studio - 2372

Tender description

Summary of the work Support and improve a Business Objects environment aimed at improving the reporting capabilities for Probation staff, following a recent upgrade to version 4.2. The service provides performance and operational reporting capability for both front line staff and managers in Probation Specialist role Business analyst Expected Contract Length SOW001 dated to 30/06/2017. Subsequent SOWs 3 month durations, up to 24 months Latest start date 01/05/2017 Who Speclialist Work With We're building a team of around seventy experts in Web Development, Design and User Research in Sheffield. This is a brilliant opportunity to be part of a growing team from its nascent stage and to play an active and continued role in the strategic development of the team and studio approaches. Existing team: Service Manager / Product Manager / Delivery Manager / User researcher / User interaction designer / Technical Architect / Developers / Content Designer / Web Ops What Specialists Work On This resource is required to support the reporting environment for the probation CMS within MOJ. The resource is expected to cover the ongoing development, maintenance/support requirements of the ETL process, Business Objects tools, as well as providing the technical expertise to improve the current configuration and staff knowledge within the Reporting Team who support the system. The work will also include developing and managing data extracts, monitoring system performance and supporting the Subject Matter Experts and end users by investigating broken or poor performing reports as well as assisting SME’s to develop ‘best practice’ within the report writer community. Skills & Experience • Recent experience installing and configuring SAP Data Services and/or SAP Data Integrator • Experience with using SAP ECC and BW as source and target with SAP Data Services Experience in Data Migration methodologies, specifically around legacy to SAP migration • Experience in Data Warehousing projects • Experience in modeling Data warehouses (physical and logical) • Knowledge of Inman and Kimball architectureExcellent SQL skills: Experience to write extracts, scripts and complex SQL statements • Experience in performance tuning of ETL and data models • Knowledge of the Oracle RDBMS 11gR2, Windows Server 2012; and experience with management of Business Objects in a Windows environment • Experience with Apache Tomcat • Knowledge of installation of the client tools, including but not limited to: Web Intelligence, Dashboards, Business View manager, Report Conversion Tool, Universe Design Tool, Query Tool • Experience level: 3+ years ETL and Business Objects universe development, report creation and management • Excellent MS Office skills • Excellent communication, organization and analytical skills Nice to Haves • Knowledge of National Delius Application / MIS data model • Knowledge of probation service • Knowledge of HANA • Agile, iterative product delivery experience Work Location Greenfield Hse, 32 Scotland St, Sheffield, S3 7DQ (with some time in London) Working Arrangments The role is Sheffield based, but there may be travel involved to other regions of the country including London. There is a £5000 limit on travel expenses: expenses will only be covered for meetings outside of Sheffield. Travel between Sheffield and the supplier’s location will not be covered. Security Clearance Basic Clearance required (disclosure scotland) No. of Specialists to Evaluate 5 Cultural Fit Criteria • Be multidisciplinary; have skills needed to deliver the product within the team, working together not individually, so that we minimise handoffs. • Communicate easily with other team members • Be self-organising and so get to choose how to deliver in a way that’s right for the thing being built and the people in the team. • Continuously improve their approach by reflecting on how to become more effective • Be accountable for the quality and reliability of the product. • Work collaboratively, on a daily basis, throughout delivery. • Prioritise the next most valuable thing to deliver. • Continuously focus on delivering a Minimum Viable Product; informed by emergent feedback, evidence and changing needs. • Demonstrate progress and value by measuring outcomes (ie impact on KPIs) rather than scope or features delivered. • Value continuous learning and so our product budgets account for iteration and continuous improvement, as well as contingency for unforeseen issues. • Embraces challenge and addresses the dysfunctions that emerge. • Consider improvements to the whole system, not just single areas of focus. • Limit work in progress and prioritises finishing over starting. Evaluation Weighting Technical competence 50% Cultural fit 20% Price 30% Questions from Suppliers 1. Please submit your application the the following email address recruitmentdigitalstudio+o0f40myuwnpt1zynpa9g@boards.trello.com 2. Send with a subject line of Business Objects Analyst/Developer - 'Candidate Name' - 20/04/2017 - #DOS 3. In the email body provide Supplier name, Supplier contact details , Candidate earliest availability. Attach: CV, and separate Skills & Evidence (any format). Please remove your email signature, and do not include the Candidate day rate. 4. Any specific format(pdf,doc) in which CVs has to be sent ? No 5. What would be the maximum day rate for this role? It is not mandatory for us to publish our budget range, and we do not wish to do so. The hope is that candidates will be put forward at rates that truly reflect their technical experience and attitude, not at rates that are put forward in response to a figure published by us. We haven't had any issues with this approach with previous roles - we've found candidates with lower rates than we expected, as well as some above our original budget that are worth a little extra spend. We hope this doesn't prevent any possible applications. Thanks! 6. Can the candidate get Disclosure of Scotland after the candidate is selected? The clearance required for this role is basic clearance. Disclosure of Scotland is not a specific level of clearance but is an example of the acceptable level. We are happy to consider candidates that have not yet gained the basic clearance, however it is recommended that once you reach evaluation (interview) stage, you begin the process. Alternatively, if you wish to wait until you've been selected for the role, that its fine. This does however need to be reflected in your earliest possible start date, which is considered during evaluation as many of our roles need to be filled urgently. 7. Is occasional remote working allowed? Remote working is allowed but will be by arrangement with the Product Team that requires this role. Our teams are self-governing and outcome oriented so regimented working arrangements are not part of our model.We will always take special needs into consideration when organising our work but there might be specific team days where studio attendance is expected. 8. Can more than one candidate per supplier be submitted for this role? Yes, separate emails have to submitted for each candidate. 9. Will this role be within IR35? MOJ have assessed that this role is outside IR35. The successful candidate is required to complete the HMRC online IR35 assessment and provide a pdf to both the supplier/agency and to recruitmentsheffield@digital.justice.gov.uk 10. Can any other security clearance such as CTC, SC or DV be considered for this role? Yes the above clearance is sufficient for the role 11. What is the lead time for feedback once the application is submitted? Lead time will be dependant on the number of candidates submitted against the requirement. We have already had a significant interest in this role therefore sifting will be an extended exercise. 12. What is the total number for positions open for this role? One 13. Will you consider BPSS clearance for this role ? Yes