Junior or Senior Backend Data Engineer (SQL / PostgreSQL / Data Integration)
About the Role
We are looking for a motivated Data Engineer to join our engineering team and contribute to building, maintaining, and optimizing data-driven applications and backend services.
The ideal candidate should have a strong foundation in SQL, PostgreSQL, relational database concepts, and data processing, along with basic knowledge of Java, Spring Boot, and REST API development.
This role offers an opportunity to work across database engineering, data integration, ETL processes, backend development, and cloud-native applications. Under the mentorship of senior engineers, the candidate will gain hands‑on experience in designing efficient database structures, developing data pipelines, building REST APIs, and integrating databases with backend services.
The candidate will also gain exposure to modern development practices, containerization, testing frameworks, and AI-assisted development workflows.
Key Responsibilities
- Design, develop, and maintain relational databases, primarily using PostgreSQL.
- Write, execute, and optimize SQL queries involving joins, subqueries, CTEs, window functions, and aggregate functions.
- Develop and maintain database schemas, tables, views, indexes, constraints, and relationships.
- Support data extraction, transformation, and loading (ETL) processes.
- Perform data cleansing, validation, transformation, and quality checks to ensure data accuracy and consistency.
- Work with large datasets and perform data manipulation, analysis, and troubleshooting.
- Develop and maintain stored procedures, functions, and database triggers as required.
- Identify and troubleshoot database performance issues, including slow-running queries and inefficient database operations.
- Develop and maintain backend services and REST APIs using Java 17+ and Spring Boot 3.x under senior guidance.
- Integrate PostgreSQL and other relational databases with Java-based applications using Spring Data JPA, Hibernate, or JDBC.
- Understand and contribute to microservices architecture, service boundaries, API contracts, and data models.
- Write clean, maintainable, and testable code following coding standards and SOLID principles.
- Write and execute unit tests using JUnit and basic integration tests for backend services.
- Participate in debugging, bug fixing, and root‑cause analysis of application and database‑related issues.
- Support deployment and release activities, including basic Docker containerization.
- Use logging and monitoring tools to identify application and database performance issues.
- Use AI‑assisted development tools such as GitHub Copilot, ChatGPT, and Claude to improve productivity, troubleshoot issues, and support development while reviewing and validating AI‑generated outputs.
- Use Git for version control and participate in code reviews and collaborative development workflows.
- Participate in Agile ceremonies, including daily stand‑ups, sprint planning, and retrospectives.
- Continuously learn and adopt modern data engineering, database, and backend development practices.
Required Qualifications
- 25 years of relevant experience in data engineering, SQL development, database management, backend development, or related technical projects.
- Strong understanding of SQL fundamentals, including SELECT, INSERT, UPDATE, DELETE, JOINs, subqueries, CTEs, and aggregate functions.
- Hands‑on experience with PostgreSQL or other relational database management systems.
- Good understanding of relational database concepts, including primary keys, foreign keys, constraints, indexes, and relationships.
- Knowledge of database design, normalization, schema design, and data modelling concepts.
- Understanding of ETL processes and basic data integration concepts.
- Ability to perform data validation, cleansing, transformation, and troubleshooting.
- Basic understanding of database performance optimization and query execution plans.
- Familiarity with database tools such as pgAdmin, DBeaver, or similar platforms.
- Understanding of database transactions, ACID properties, and data integrity.
- Solid understanding of Java fundamentals, including OOP principles, collections, exception handling, and basic multithreading concepts.
- Basic hands‑on experience with Spring Boot, including REST endpoints, dependency injection, and application configuration.
- Basic understanding of RESTful API design and microservices concepts.
- Familiarity with JPA/Hibernate or JDBC for database connectivity and data access.
- Familiarity with Git for version control, including branching, commits, and pull requests.
- Basic understanding of Docker and containerization concepts.
- Basic hands‑on familiarity with AI coding assistants such as GitHub Copilot, ChatGPT, or Claude, with the ability to review and validate AI‑generated code and queries.
- Strong analytical thinking, problem‑solving abilities, and attention to detail.
- Good communication skills and ability to collaborate within a team.
Preferred Qualifications
- Academic, internship, or bootcamp project experience involving SQL, PostgreSQL, Java, Spring Boot, or data engineering.
- Exposure to Python libraries such as Pandas and NumPy for data manipulation and processing.
- Familiarity with advanced PostgreSQL features, including JSON/JSONB, stored procedures, functions, and query optimization.
- Exposure to database migration tools such as Flyway or Liquibase.
- Basic knowledge of data pipeline development and ETL tools.
- Familiarity with data warehousing concepts, dimensional modelling, and OLTP/OLAP systems.
- Basic understanding of cloud database services such as AWS RDS, Azure SQL Database, or Google Cloud SQL.
- Exposure to Spring Security concepts, including authentication and authorization.
- Familiarity with testing frameworks such as JUnit and Mockito.
- Basic understanding of messaging systems such as Apache Kafka or RabbitMQ.
- Familiarity with Docker, CI/CD pipelines, and basic cloud deployment concepts.
- Exposure to logging and monitoring tools for application observability.
- Knowledge of data visualization and reporting tools such as Power BI or Tableau.