BRF Junior Database Analyst, Francis Crick

• Demonstrated experience in a related field
• Experience of working with Microsoft’s office portfolio of tools, especially Excel skills for data manipulation & reporting, with a good knowledge of pivot tables and other advanced features
• Proven experience with or willingness to work with animal models
• Able to take the lead, work independently and drive a project forward
• Experience of contributing effectively to the work of a team, a flexible and cooperative approach to working with others
• Excellent project planning, timekeeping, organisational and record-keeping skills
• Proven & demonstrable experience of database management, as well as an understanding of the code and programming behind the programme
• Ability to organise and prioritise their own workload to meet defined and conflicting deadlines, fluctuations in function and resource availability and maintain standards
• Successful experience of interacting with all levels of staff and of providing an excellent level of customer service
• Ability to think beyond the immediate work area and make links between area
• Conscientious and reliable
• Strives for continuous improvement in performance
• You must be able to understand and convey technical ideas, concepts and procedures in clear, concise and accurate English

Desirable

• Reports to: Chris Staines
• The BRF Junior Database Analyst will be part of the BRF’s Business Support team and will support and report to the BRF Data Analyst
• The role will help the BRF Data Analyst in support of the BRF helpdesk functions, deliver training in the use of the chosen animal registration systems to promote standardisation of working practices across the institute, and support the wider BRF Business Support team
• The helpdesk function provides a means to support the end users with any database related issues, as well as providing bespoke reporting functions, as necessary
• Additionally, the role will maintain and support the development of existing and new reports using tools such as Power BI, SQL and Python
• To provide technical support for all stakeholders via the Service Now ticketing system
• Be available for ad-hoc visits from users and BRF staff
• Liaise with the IT helpdesk team, and provide in person support within the BRF units
• Contribute to the management and use of reporting platforms such as Power BI (including scheduling of data refresh, publishing of reports into designated workspaces, Apps, dashboards and assisting with documentation and version control)
• Demonstrate and promote the use of available reporting tools to others
• Be able to develop and implement data pipelines and workflows to facilitate Extract Transform and Load processes as a precursor to generating reports and dashboards, primarily using SQL and Python
• Develop and maintain reports for stakeholders to assist with routine operation of the business
• Be involved with the delivery & development of the training programs for different user groups
• Be available to staff for troubleshooting and training, and regularly work from within the unit encouraging best practice
• To develop a ‘BRF systems user manual’ covering all key platforms (Service Now; MCMS; ARMIS; SharePoint; Notion), which will be used to inform use policies for each system – i.e. role profiles to be assigned to each user group, responsibilities of certain user roles and links to Crick SOPs where appropriate
• To carrying out extensive beta testing of new developments within the systems ahead of deployment
• Support to the senior management team and director of the BRF on any other appropriate project as required
• In addition, the postholder is expected to assist with the wider responsibilities of the Business support team as necessary
• Providing cover for the Administrative Assistant and assisting in the basic duties of the administrative support team
• Learning the basics of the Shipping Team, to be able to provide support and cover as well as assisting in simple shipments
• Assisting the Education & Training team with administrative work supporting their IT systems

• Closing Date: 31/Jan/2025 23.59 GMT