Database and Front-End Developer

Position:………..Database and Front-End Developer
Terms:…………..This is a temporary position (3-6 months full-time, or part-time equivalent)
Salary:…………..£29,000 pa (pro rata)
Starting date:…..Negotiable (late June/early July 2020 preferred)
Location:……….The work can be done remotely or in our premises in Edinburgh’s West End  (subject to Government guidance on social distancing)
Closing date:…..15 May 2020

About us

Scottish Language Dictionaries is Scotland’s independent lexicographical body for Scots. It is also a publicly-funded charity. Our Scottish National Dictionary and Dictionary of the Older Scottish Tongue are national institutions and are available through our online Dictionary of the Scots Language (https://dsl.ac.uk): together they provide a unique record of the language — and of the history, culture and traditions — of Scots-speaking peoples.

About the role

Scottish Language Dictionaries maintains the lexicographic record of Scots. We continually monitor usage of Scots vocabulary and record our findings for subsequent evaluation. For many years this evidence was recorded in a Microsoft Access database, but this data is no longer viewable or editable. We have decided to create a new database with a web interface that will satisfy our present-day needs.
We have acquired permission to use a working prototype from another dictionary organisation. This is a web app built entirely in Javascript using Node.js and React. The web app connects to a Postgres database (currently populated with sample data).

We are looking for someone who will:

• Create a detailed project plan for our agreement.
• Modify the Postgres database to our specifications.
• Restructure, clean up, and migrate the data from our existing MS Access database to the new database.
• Modify the React app according to our specifications.
• Upload/install the final modified app to our Microsoft Azure-based cloud service.
• Provide authorised staff with access to the new database and enable them to assign access permissions to others.
• Document the work undertaken to facilitate any future work or data migration.
• Prepare a database User Guide.

Essential experience, skills and knowledge

• Experience of database development and front-end development.
• A good working knowledge of Node.js, React.j, SQL databases (Postgres, MS Access), and Microsoft Azure Cloud Services.
• Experience of successfully helping non-technical colleagues/clients (a) articulate their technical requirements and (b) understand essential technical information.
• A determination to understand the full extent of colleagues’/clients’ needs/preferences and a willingness to adapt solutions accordingly.
• Well organised, self-motivated and able to plan own workload to meet deadlines.

Other information

• A description of the existing MS Access data and a high-level overview of the front-end requirements will be made available to longlisted candidates on request.
• Applicants are expected to provide and maintain their own computer and office equipment when working remotely.
• Reasonable travel expenses will be reimbursed for visits to our offices from locations outside Edinburgh.
• Holiday entitlement for full-time staff is 34 days’ paid holiday pa (including public holidays).

If you require further information, please contact the CEO, Rhona Alcorn, at jobs@dsl.ac.uk.

.
Scottish Language Dictionaries reserves the right to vary the candidate information or make no appointment at all. Neither in part, nor in whole does this information form part of any contract between Scottish Language Dictionaries and any individual.

Application procedure

Please send your CV (maximum 2 pages), covering letter (maximum 1 page), and details of two referees to jobs@dsl.ac.uk by 5pm on 15 May 2020. Your covering letter should outline the reasons for your interest in this position and your suitability for the role. We will not contact your referees unless required at a later stage of the process, and then only with your consent.

Selection procedure

Longlisted candidates will be notified by 22 May 2020 and will be invited to provide a preliminary project plan (maximum 1 page) by 5 June 2020 to demonstrate their understanding of, and preferred approach, to the project. There will be an opportunity to ask us questions to inform the detail of this plan. Shortlisted candidates will then be invited to attend an interview (in person or by video chat) during the week beginning 8 June 2020.