Siam Makro Public Company Limited

Retail Data Warehouse Engineer

Siam Makro Public Company Limited

full-time

Posted on:

Location Type: Hybrid

Location: Bangkok • Thailand

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

ETLOracleSQL

About the role

  • Design, develop, and maintain Oracle Retail Analytics Data Warehouse solutions.
  • Build and optimize dimensional models (fact and dimension tables).
  • Ensure data accuracy, consistency, and performance.
  • Develop and maintain ETL pipelines using Oracle Data Integrator (ODI).
  • Integrate data from retail systems such as POS, merchandising, and supply chain.
  • Implement data quality checks and optimize ETL performance.
  • Develop dashboards using Oracle Business Intelligence Enterprise Edition (OBIEE).
  • Create operational and management reports using BI Publisher (BIP).
  • Translate business requirements into analytics solutions.
  • Strong SQL and PL/SQL for transformation and performance tuning.
  • Handle large-scale datasets efficiently.
  • Apply best practices in data modeling and query optimization.
  • Monitor data loads and reports.
  • Troubleshoot production issues and performance bottlenecks

Requirements

  • Bachelor’s or Master’s degree in Computer Science, Engineering, or related field.
  • 5+ years of experience
  • Oracle Retail Analytics
  • OBIEE
  • BI Publisher (BIP)
  • Oracle Data Integrator (ODI)
  • Strong SQL / PL-SQL
  • Data Engineering skills

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLPL/SQLETLdata modelingquery optimizationdata quality checksdimensional modelsdata transformationperformance tuningdata engineering
Certifications
Bachelor’s degreeMaster’s degree