Get To Know Our Team:

• The BI‑Infra organization owns Agoda’s core data warehouse architecture and operates the platforms that power analytics and BI across the company (e.g., SQL Server DW, SSAS, Vertica, StarRocks, Hadoop, Superset, Metabase, Tableau, Power BI Report Server). Our mission is to maximize system uptime and provide the best possible data and visualization experience to Agoda users. 

• The BI‑Infra DBA sub‑team focuses on database and BI platform reliability, performance, and cost efficiency — designing and operating scalable OLAP engines, tuning workloads, defining SLIs/SLOs, and partnering with BI and product teams to keep critical analytics systems healthy at scale. 

The Opportunity:

We are looking for a Senior/Staff Data Platform Engineer (BI Infra DBA) to lead the technical direction and operations of our analytics database and BI platforms (StarRocks as the primary analytics engine, Vertica, SQL Server DW, visualization backends, and related services). You will: 

• Own critical database and BI infrastructure end‑to‑end — architecture, performance, reliability, and security. 

• Lead multi‑team initiatives such as expanding StarRocks adoption and leading sql server datawarehouse migration, and major upgrades of visualization/BI tools. 

• Set engineering and operational standards for how we design, deploy, and monitor our BI data platforms, acting as the technical point of contact for BI‑Infra DBA 

What You’ll Do:

• Design and evolve Agoda’s BI data warehouse architecture across SQL Server DW, Vertica, StarRocks, and related services, focusing on availability, scalability, and cost efficiency. 

• Lead migration and modernization projects such as: 

  • Migrating workloads off MSSQL DW to more sustainable platforms (Production standby, data lake, StarRocks, etc.). 

  • Decommissioning legacy components as part of the long‑term DW strategy. 

• Define and implement data and query engine standards (indexing/partitioning patterns, materialized views, retention strategies, governance and access patterns) for BI platforms. 

• Define SLIs/SLOs for key services (StarRocks, Vertica, Tableau, Superset/Metabase, MSSQL DW) and ensure they are instrumented, monitored, and reviewed regularly. 

• Lead incident response for BI‑Infra DBA‑owned platforms: diagnose cross‑system issues (Query Engine - Database, VIz tools, Compute, Storage, Network), post‑mortem/root‑cause analysis, and follow‑up improvements. 

• Partner with BI‑Infra Ops/Dev/Viz and DBDev/DBOps on end‑to‑end reliability — from ingestion pipelines to visualization queries and user traffic patterns. 

• Perform deep query and workload tuning for high‑impact systems (e.g., finance, supply, whitelabel analytics, experimentation, DQ), reducing CPU/memory/IO and improving latency at scale. 

• Optimize resource consumption and license/capacity planning for Query Engine – Database and BI tools. 

• Collaborate with infra and product teams to evaluate and adopt new query engines / database technologies where they materially improve reliability, performance, or cost. 

• Own upgrade and patching strategies for database and BI stacks (OS, engine, drivers), using canary/blue‑green and rollback plans to minimize downtime. 

• Improve and extend CI/CD and deployment automation for database objects, jobs, and configuration (GitLab, AWX/Ansible, ArgoCD, etc.). 

• Build and maintain observability for BI-Infra DBA services (Grafana, Prometheus/SLO dashboards, alerting, Hedwig/NOC integrations) to detect and act on issues proactively. 

• Implement and maintain secure access patterns for DW and BI platforms (service accounts, RBAC, gMSA, password rotation, SSO/OKTA integration, DR strategy). 

• Partner with security and data governance teams to remediate vulnerabilities within SLAs, enforce data residency constraints, and ensure that upcoming workloads (e.g., whitelabels) are compliant by design. 

• Act as technical lead for BI‑Infra DBA initiatives, collaborating closely with BI‑Infra Ops/Dev/Viz, Database Operation/Development, Infra, and BI product teams. 

• Mentor and coach junior engineers on database performance, reliability, and platform engineering best practices; help raise the bar for design reviews, runbooks, and incident hygiene. 

• Contribute to knowledge sharing - Documents [Confluence, Agoda Internal Document Framework], internal talks, runbooks and help shape the technical roadmap for BI‑Infra DBA. 

Required Qualifications:

• 5+ years of experience in data engineering / database engineering / DBA / platform engineering, with at least several years owning production OLAP/BI databases at scale. 

• Strong expertise with StarRocks (or similar modern MPP / columnar systems such as Vertica, ClickHouse, Presto/Trino, Druid, Doris, Impala) and solid SQL Server experience, including: 

  • Query execution internals and tuning (plans, statistics, partitioning, indexing, materialized views). 

  • Capacity planning, storage layout, and backup/restore. 

• Proven experience operating mission‑critical database or BI services in production: 

  • On‑call incident response, debugging across layers, and post‑mortem/root‑cause analysis. 

  • Designing and maintaining SLIs/SLOs, dashboards, and alerting for latency/availability/error budgets. 

• Solid understanding of data warehouse and ETL concepts (core DW tables like Fact-Dimension, MSSQL Replication/CDC, Staging patterns, data freshness & consistency, DQ processes). 

• Hands‑on experience with Linux and Windows in production environments (patching, hardening, troubleshooting resource issues). 

• Experience with infrastructure automation and CI/CD: 

  • Pipelines and deployment automation (GitLab CI, Ansible/AWX, ArgoCD, or similar). 

  • Git‑based workflows for database objects. 

• Strong communication and collaboration skills: 

  • Able to represent BI‑Infra DBA as the technical point of contact in cross‑team design and incident discussions at IC4 level. 

  • Comfortable explaining complex trade‑offs to both technical and non‑technical stakeholders. 

Preferred Qualifications:

• Experience with StarRocks or similar modern OLAP engines, including: 

  • Designing schemas and materialized views for BI workloads. 

  • Operating clusters across multiple environments (DR, performance/capacity testing, cost tuning). 

• Hands‑on work with Superset, Metabase, Tableau, Power BI Report Server as data consumers — understanding how visualization patterns translate into backend workload and SLOs. 

• Exposure to Hadoop / Data Lakehouse ecosystems (e.g., Impala, Spark, Hive) and strategies for moving workloads from DW to lake/next‑gen engines. 

• Experience with observability stacks (Prometheus, Grafana, Hedwig/NOC dashboards and alerting), SRE practices, and especially using AI/LLM-based tools to help with log analysis, anomaly detection, or auto-remediation for database/BI engines — this will be a strong plus. 

• Prior technical leadership at IC4 level or equivalent, driving multi‑quarter cross‑team projects and raising engineering standards for reliability, performance, and maintainability. 

Capco, a Wipro company, is a global technology and management consultancy specializing in driving digital transformation in the financial services industry. With a growing client portfolio comprising of over 100 global organizations, Capco operates at the intersection of business and technology by combining innovative thinking with unrivalled industry knowledge to deliver end-to-end data-driven solutions and fast-track digital initiatives for banking and payments, capital markets, wealth and asset management, insurance, and the energy sector. Capco’s cutting-edge ingenuity is brought to life through its Innovation Labs and award-winning Be Yourself At Work culture and diverse talent.

Role Summary

The Cloud Engineer Lead is responsible for leading and governing the bank's cloud infrastructure and platform operations to ensure secure, reliable, scalable, and cost-effective cloud services. This role manages Cloud Operations and DevOps engineers, drives automation and infrastructure standardization, and ensures cloud operations comply with regulatory and security requirements applicable to a Virtual Bank.

What You’ll Do

• Govern cloud architecture, landing zone design, and cloud environment standards.
• Lead DevOps and Cloud Operations engineers to ensure stable and efficient operations.
• Implement and enforce infrastructure-as-code (IaC) and automation practices for provisioning, scaling, and configuration.
• Oversee deployment, monitoring, availability, and performance of cloud resources including compute, network, storage, and platform services.
• Ensure cloud security baseline, identity and access management, logging, and monitoring are implemented and maintained.
• Drive cloud cost optimization and usage governance. 
• Ensure cloud operations comply with regulatory and security standards (e.g. BOT, ISO 27001).
• Lead cloud-related incident response, major incident support, and root cause analysis. 
• Coordinate with Application, Network, Data Platform, and Security teams on cloud integration and operations.
• Liaise with cloud service providers and vendors, manage contracts, and monitor service-level agreements. 
• Maintain cloud architecture diagrams, operational procedures, and runbooks.
• Drive continuous improvement initiatives to enhance cloud security, reliability, and operational efficiency. 

What We’re Looking For

• Bachelor's degree in Computer Science, Information Technology, or related field; Master's degree is preferred.
• Minimum 5 years of experience in IT infrastructure or cloud operations.
• Strong hands-on experience with cloud platforms (Azure preferred; AWS or GCP is a plus).
• Solid knowledge of cloud networking, load balancing, application gateways, and cloud-native services. 
• Proficiency in automation, scripting, and infrastructure-as-code tools (e.g. Terraform, Ansible, PowerShell).
• Good understanding of IT security standards, regulatory compliance, and audit requirements in a regulated environment. 
• Strong leadership, communication, and problem-solving skills, with experience supporting 24x7 operations.
• Proficient in Thai and English at intermediate level or above, sufficient for technical discussions, meetings, and written documentation

Why Join CAPCO

• Work on engaging projects with some of the largest banks/insurance in the world, on projects that will transform the financial services industry
• Work in a collaborative, flat, and entrepreneurial consulting culture
• Access continuous learning, training, and industry certifications
• Be part of a team shaping the future of digital financial services
• Help shape the future of digital transformation across FS & Energy

We offer

• A work culture focused on innovation and creating lasting value for our clients and employees
• Ongoing learning opportunities to help you acquire new skills or deepen existing expertise in our financial services offerings
• A flat, non-hierarchical structure that will enable you to work with senior partners and directly with clients
• An agile, diverse, entrepreneurial, inclusive, meritocratic culture

Joining Capco means joining an organisation that is committed to an inclusive working environment where you’re encouraged to #BeYourselfAtWork. We celebrate individuality and recognize that diversity and inclusion, in all forms, is critical to success. It’s important to us that we recruit and develop as diverse a range of talent as we can and we believe that everyone brings something different to the table – so we’d love to know what makes you different. Such differences may mean we need to make changes to our process to allow you the best possible platform to succeed, and we are happy to cater to any reasonable adjustments you may require. You will find the section to let us know of these at the bottom of your application form or you can mention it directly to your recruiter at any stage and they will be happy to help.

We have been informed of several recruitment scams targeting the public. We strongly advise you to verify identities before engaging in recruitment related communication. All official Capco communication will be conducted via a Capco recruiter.

#LI-PW1 #LI-Hybrid