About the Role:
We are seeking a talented and motivated Python Database Engineer to design, build, and maintain the tools, databases, APIs, and Python software necessary for managing all scientific data produced within our organisation. This role will require a deep understanding of data systems and the ability to transform raw scientific outputs into actionable insights for users. You will play a critical role in developing infrastructure that supports innovation and accelerates our scientific endeavours.
Responsibilities:
- Database Development:
- Design and implement efficient PostgreSQL database schemas to store and query scientific test station data, synthesis data, and materials data.
- Optimise database performance for scalable and reliable data access.
- API and Backend Development:
- Develop and maintain a Python-based API hosted on AWS to interface with the database, including ingesting files from S3 and enabling efficient querying for user insights.
- Ensure robust and secure data exchange between the API, database, and users.
- Tooling and Integration:
- Build a Python package to streamline interactions with the API for uploading and querying data from scientific test stations.
- Create Python-based dashboards to visualise and provide actionable insights into the data.
- Cloud Infrastructure:
- Utilise AWS services such as S3, RDS, CDK, and ECS to deploy, manage, and scale applications and infrastructure.
- Ensure the reliability, scalability, and security of cloud-hosted solutions
Experience & Attributes:
- Solid understanding of relational database concepts.
- Demonstrated expertise in:
- Designing and implementing PostgreSQL schemas.
- Developing APIs with Python to interact with databases and manage data ingestion.
- Building Python UIs or dashboards for data visualisation and user interaction.
- Creating Python packages interacting with APIs.
Advantage:
- Hands-on experience with AWS services, including S3, RDS, CDK, and ECS.
- Experience working with scientific or experimental data.
- Familiarity with CI/CD pipelines and modern DevOps practices.
- Strong communication skills to collaborate effectively with scientists and other stakeholders.
