Data Engineer

Company Overview TroyTech International Consulting Pte Ltd is a Singapore-based consulting firm specializing in SOA, EAI, JEE technical support, web and mobile solutions, and business integration with IBM and open source software. It serves Financial, Transportation, and Government sectors across APAC. Job Summary You will design and deliver high-performance back-office software solutions, collaborating with development teams and users to ensure robust application support and comprehensive documentation throughout the software development lifecycle. Responsibilities Gather and analyze software requirements to align solutions with business needs Design, develop, and maintain high-volume, performance-intensive back-office software applications Prepare and submit comprehensive SDLC deliverables including Business Rules, Software Requirement Specifications, Architecture and Design documents, Interface Specifications, Source Code, Testing Specifications, and User Manuals Provide day-to-day application support to resolve operational issues promptly Liaise effectively with users to clarify requirements, design considerations, and testing feedback Apply Agile development methodologies to deliver iterative and incremental software improvements Implement DevSecOps and CI/CD practices to enhance software delivery and security Conduct unit, integration, and end-to-end testing to ensure system stability and reliability Utilize advanced SQL and star schema design techniques for database interfacing and optimization Apply data analytics techniques such as clustering, time series analysis, and anomaly detection to support data-driven decision-making Develop Python programs for data transformation and analysis using Pandas and Snowpark libraries Develop Java API microservices using Spring Boot framework (preferred) Design UML models to support clear and effective software documentation Work within AWS environments and leverage AWS Sagemaker for machine learning tasks (preferred) Create interactive dashboards using Streamlit or Tableau for data visualization (preferred) Preferred competencies and qualifications Familiarity with AWS Sagemaker for machine learning workflows Skills in dashboarding libraries such as Streamlit or Tableau Experience in creating Java API microservices with Spring Boot