It seems that most people who follow the news have wondered at some point, why Government contracts keep going wrong. That’s where OpenOpps.com fits in, we’re a small agency that gathers public procurement data and uses it to improve the way public bodies spend money and combat fraud, as well as helping suppliers to engage with Governments. We do all of this in the open, so that everyone can benefit from our work. We have a range of digital products that companies and Governments rely on to help them improve procurement.
We’re looking for a Database Administrator to help manage our growing database and to support our clients to get the most out of our API and other products.
What you’ll be doing:
This unique role needs someone who can be responsive to our client’s queries, whilst making sure that our data ETL is working effectively and that our data is meeting the highest possible quality standards. You’ll also be responsible for addressing some of our technical debt and bringing new datasets into our product.
We’re using a PostgreSQL datastore on a Heroku server, as well as an Elastic Cloud datastore. You’ll be responsible for maintaining our daily ETL processes as well as overseeing some manual elements of our data updates. You’ll also be making sure that our data is logically structured and that it complies with the Open Contracting Data Standard (http://standard.open-contracting.org/latest/en/). At the same time, you’ll be responding to day-to-day queries from clients.
On the one hand, you’ll need to have good technical knowledge and an eye for detail, on the other hand, you’ll need to be a concise and personable communicator, who can help with non-technical staff resolve issues and make the best use of our products.
What is on offer?
A salary of between £30,000 and £38,000 depending on experience and knowledge. 24 days leave. We would welcome applications from remote workers provided you can work with us during UK office time and have an excellent understanding of UK public institutions.
be an excellent database administrator with strong SQL skills;
be able to manage a large PostgreSQL data store (120m lines) and to work with Elastic products;
be able to interpret and comply with JSON data standards;
be a personable and efficient communicator, who is able to communicate how we’re dealing with issues and fixes to non-technical customers;
be able to identify problems in data sources and direct developers to fix those problems;
understand the value of open data versus, licensed data and;
be genuinely interested in public policy and the way that public money is spent.
Having some Python knowledge would be a significant advantage, but it is not essential.
This is a great opportunity to join a small, friendly team, and to develop your career and to grow your skills. You’ll need be a self-starter, someone who is ready to accept responsibility and be utterly committed to the details of our data.
If this sounds like you, please send a CV and a short email detailing some of the projects you’ve completed and why you’re a good fit for this job to: email@example.com. We’re not looking for War and Peace, but we are looking for something specific to the job, generic responses will go in the bin.
NO AGENCIES. (If you’re thinking "that means every other agency except us”, then I’m afraid you’re wrong. Spamming from agencies wastes our resources and annoys our staff. If you send us an unsolicited email, we’ll reply with a request to be forgotten).