Description :

- Design, build, and maintain scalable and secure relational and cloud-based database systems.

- Migrate data from spreadsheets or third-party sources into databases (PostgreSQL, MySQL, BigQuery).

- Create and maintain automated workflows and scripts for reliable, consistent data ingestion.

- Optimise query performance and indexing to improve data retrieval efficiency.

- Implement access controls, encryption, and data security best practices to ensure compliance.

- Monitor database health and troubleshoot issues proactively using appropriate tools.

- Collaborate with full-stack developers and data researchers to align data architecture with application needs.

- Uphold data quality through validation rules, constraints, and referential integrity checks.

- Keep up-to-date with emerging technologies and propose improvements to data workflows.

- Leverage tools like Python (Pandas, SQLAlchemy, PyDrive), and version control (Git).

- Support Agile development practices and CI/CD pipelines where applicable.

Requirements :

- Strong SQL skills and understanding of database design principles (normalisation, indexing, relational integrity).

- Experience with relational databases such as PostgreSQL or MySQL.

- Working knowledge of Python, including data manipulation and scripting (e.g., using Pandas, SQLAlchemy).

- Experience with data migration and ETL processes, including integrating data from spreadsheets or external sources.

- Understanding of data security best practices, including access control, encryption, and compliance.

- Ability to write and maintain import workflows and scripts to automate data ingestion and transformation.

- Experience with cloud-based databases, such as Google BigQuery or AWS RDS.

- Familiarity with cloud services (e.g., AWS Lambda, GCP Dataflow) and serverless data processing.

- Exposure to data warehousing tools like Snowflake or Redshift.

- Experience using monitoring tools such as Prometheus, Grafana, or the ELK Stack.

- Good analytical and problem-solving skills, with strong attention to detail.

- Team collaboration skills, especially with developers and analysts, and the ability to work independently.

- Proficiency with version control systems (e.g., Git)