Data Engineer (SQL, Java, Python)

ADVANCE SOFTWARE ENGINEERING PTE. LTD.; Singapore; On-site; SGD 120,000 - 160,000; Full time

Job summary

ADVANCE SOFTWARE ENGINEERING PTE. LTD. in Singapore is seeking a Data Engineer with strong SQL skills and backend experience in Java/Python to enhance our Data Management Platform. You will write complex queries, tune performance, and build server-side processing on Linux.

You will collaborate with product and engineering teams to design data platform architecture, create microservices and APIs, and ensure scalable data solutions for analytics and reporting.

Qualifications

• 5–10+ years of hands-on SQL development, debugging, and optimization.
• 2+ years of Python/Java development on Linux.
• Fundamentals: OOP, data structures and algorithms.
• Familiarity with ETL, data warehousing, and data masking.
• Willingness to learn new tools and technologies.

Responsibilities

• Write complex SQL queries to support ETL, data analysis and debugging.
• Develop server-side data processing logic for high performance.
• Create microservices or APIs in Java/Python to invoke SQL functions or procedures.
• Fine-tune or optimize queries to support increasing data volumes.
• Write reusable and efficient code in SQL, Python/Java.
• Collaborate with product owners and engineering teams on data platform architecture.

Skills

SQL

Java

Python

APIs

Tools

Linux

Job description

Key Responsibilities:

• We are looking for a Data Engineer with intermediate to advance knowledge of SQL, and intermediate Java/ Python and API skills to help us build and evolve our Data Management Platform.
• Your primary focus will be the writing complex SQL queries, fine tuning and development of all server-side backend data processing logic, ensuring high performance and responsiveness to requests from the front-end / API requests on Linux environment.
• Writing complex SQL queries to serve new requirements for ETL, data analysis and debugging.
• Writing SQL functions, procedures as required based on the requirements
• Finetune or optimize queries to support the increasing volume of data.
• Writing reusable and efficient code in SQL, Python/Java.
• Communicate closely with all product owners, Business, and engineering teams to develop approaches for data platform architecture.
• Create microservices or API’s in java/Python that will invoke the created SQL functions or Procedures.

Key Requirements:

• 5 - 10+ years of experience having hands on experience in writing, debugging, and optimizing SQL queries, functions and stored procedures.
• 2+ years of experience with hands on experience in writing, debugging Python / Java on Linux environment.
• Basic knowledge of Computer Science fundamentals - OOPS, Data Structures and Algorithms.
• Basic understand of regular Linux commands and usage.
• Willingness and ability to learn new tools/languages as needed.
• Process oriented with excellent oral and written communication skill with a desire for customer service.
• An excellent team player and communicator who can work effectively with cross functional teams and ability to navigate ambiguity.
• Knowledge of ETL’s and basics of Data warehousing, Data Masking.