
Data Automation & Retrieval Engineer (PostgreSQL/Go)
Archipelago International
Jakarta, Indonesia
Information Technology
Job Descriptions:
Handle ad-hoc data retrieval requests from internal teams by writing and optimizing PostgreSQL queries- .Analyze data requirements and design efficient query structures or views for reuse
- .Develop, test, and maintain Go-based tools to automate recurring data extraction, transformation, and delivery processes
- .Integrate automated tools with APIs, dashboards, or internal systems to streamline access to requested data
- .Maintain detailed documentation of all automation tools, data flows, and reusable query components
- .Collaborate with business and technical stakeholders to identify high-impact automation opportunities
- .Ensure data security, performance, and integrity within the PostgreSQL environment
- .Monitor scheduled jobs, pipelines, and tool performance, and handle troubleshooting when needed
.
Job Requirement
- s:Strong proficiency in PostgreSQL (schema design, query optimization, stored procedures, indexes, and performance tuning). SQL Server proficiency is a bonu
- s.Hands-on experience with Go (Golang) for scripting, automation, or backend developmen
- t.Familiarity with AWS lambda is a bonu
- s.Solid understanding of ETL processes and data access pattern
- s.Familiarity with REST APIs and integration of Go tools with data endpoint
- s.Ability to analyze and transform business requests into efficient technical solution
- s.Basic knowledge of version control systems (Git
- ).Experience with cron jobs, Docker, or CI/CD pipelines for automation deploymen
- t.Exposure to message queues or data streaming concept
- s.Understanding of data governance and security best practice
- s.Bachelor degree in any fiel
About the company
Company website•Hospitality and Hotels and Motels
Archipelago is Southeast Asia's largest privately-owned hotel management group, with over 45,000 rooms in 200+ locations across Southeast Asia, Africa, the Caribbean, the Middle East, and Oceania. Our diverse portfolio of 11 award-winning brands caters to various traveler preferences, ensuring memorable stays. We are committed to providing exceptional experiences for our guests, employees, and partners by embracing diverse cultures, prioritizing guest feedback, empowering our staff, and partnering with like-minded owners and investors. Our innovative approach and dedication to excellence have earned us numerous awards and recognitions in the hospitality industry. As we continue to expand our global presence, we remain true to our roots, creating exceptional experiences and lasting memories for travelers worldwide.