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