Data Warehouse Engineer

{
  "content_hash": "ecbe6110b6c265dd64644bfbb0d9c6b84bc1ac3bacbc44d72539d6210c2ddf12",
  "source_hash": "4a04f2b61ddb6ba9eecf9625adc41d5a9d1fc948cfc93e6e68d2118fc7c43a78",
  "last_changed_at": "2026-05-30T05:43:51.380Z",
  "active_status": "active"
}

{
  "language": "en",
  "location": {
    "raw": "Hong Kong, Hong Kong, 000000, Hong Kong",
    "city": "Hong Kong",
    "region": "Hong Kong",
    "country": null,
    "is_remote": false,
    "confidence": 0.8
  },
  "salary_max": null,
  "salary_min": null,
  "inferred_at": "2026-06-06T19:39:10.800Z",
  "launch_scope": {
    "reason": "bamboohr_production_catalog",
    "included": true,
    "location": {
      "raw": "Hong Kong, Hong Kong, 000000, Hong Kong",
      "city": "Hong Kong",
      "region": "Hong Kong",
      "country": null,
      "is_remote": false,
      "confidence": 0.8
    },
    "countries": []
  },
  "remote_policy": null,
  "salary_period": null,
  "workplace_type": null,
  "salary_currency": null
}

{}

{
  "list_job": {
    "id": "179",
    "isRemote": null,
    "location": {
      "city": "Hong Kong",
      "state": "Hong Kong"
    },
    "atsLocation": {
      "city": null,
      "state": null,
      "country": null,
      "province": null
    },
    "departmentId": "18751",
    "locationType": "0",
    "jobOpeningName": "Data Warehouse Engineer",
    "departmentLabel": "Business Intelligence",
    "employmentStatusLabel": "Full-Time"
  },
  "detail_errors": [],
  "detail_job_opening": {
    "location": {
      "city": "Hong Kong",
      "state": "Hong Kong",
      "postalCode": "000000",
      "addressCountry": "Hong Kong"
    },
    "datePosted": "2026-05-28",
    "atsLocation": {
      "city": null,
      "state": null,
      "country": null,
      "countryId": null
    },
    "description": "<p><span style=\"font-weight: bold\">About RedotPay</span></p>\n<p>RedotPay is a global crypto payment fintech integrating blockchain solutions into traditional banking and finance infrastructure. Our user-friendly crypto platform empowers millions globally to spend and send crypto assets, ensuring faster, more accessible, and inclusive financial services. RedotPay advances financial inclusion for the unbanked and supports crypto enthusiasts, driving the global adoption of secure and flexible crypto-powered financial solutions. Join us in shaping the future of finance and making a meaningful impact on a global scale.</p>\n<p><br><br></p>\n<p><span style=\"font-weight: bold\">Job Description</span></p>\n<p>We are looking for an experienced, self-driven <span style=\"font-weight: bold\">Data Warehouse Engineer</span>. You will be responsible for the architectural design of the company's core data warehouse, data model development, and optimization of ETL data pipelines.</p>\n<p><br></p>\n<p><span style=\"font-weight: bold\">Responsibilities</span></p>\n<ul>\n<li><span style=\"font-weight: bold\">Data Warehouse Modeling &amp; Development</span>: Design and develop the company-level data warehouse models, including building the ODS, DWD, DWS, and ADS layers, ensuring the data models are scientific, stable, and scalable.</li>\n<li><span style=\"font-weight: bold\">ETL Pipeline Development</span>: Build efficient and stable ETL/ELT data processing workflows, write high-quality data processing scripts, and ensure timely data delivery (SLA compliance).</li>\n<li><span style=\"font-weight: bold\">Business Data Support</span>: Deeply understand the business, collaborate closely with Product, Operations, BI, and Data Analytics teams, accurately capture data requirements, and provide agile data mart support and metric system development.</li>\n<li><span style=\"font-weight: bold\">Performance Tuning &amp; Maintenance</span>: Perform SQL optimization and Hive/Spark job performance tuning in large-scale data environments, resolving issues such as data skew, scheduling delays, and resource waste.</li>\n<li><span style=\"font-weight: bold\">Data Quality &amp; Governance</span>: Participate in the construction of data quality monitoring systems (DQC), manage metadata, map data lineage, ensure consistency of data definitions, and maintain the accuracy of data assets.</li>\n</ul>\n<p><br></p>\n<p><span style=\"font-weight: bold\">Requirements</span></p>\n<ul>\n<li>Bachelor’s degree or above in Computer Science, Mathematics, Statistics, or related fields.</li>\n<li>3+years of experience in data warehousing or big data development.</li>\n<li>Solid theoretical foundation in data warehousing, with a deep understanding of dimensional modeling</li>\n<li>Proficient in designing fact tables, dimension tables, Slowly Changing Dimensions (SCD), and subject domains.</li>\n<li>Excellent SQL writing and extreme performance tuning skills.</li>\n<li>Proficient in Hive, Spark, and other big data computing frameworks. Familiar with the working principles of HDFS and YARN.</li>\n<li>Good to have at least one mainstream big data scheduling system such as Dolphin Scheduler, Airflow, or Azkaban.</li>\n</ul>",
    "compensation": null,
    "departmentId": "18751",
    "locationType": "0",
    "seekPromoted": false,
    "jobCategoryId": null,
    "jobOpeningName": "Data Warehouse Engineer",
    "departmentLabel": "Business Intelligence",
    "jobOpeningStatus": "Open",
    "minimumExperience": "Experienced",
    "jobOpeningShareUrl": "https://redotpay.bamboohr.com/careers/179",
    "employmentStatusLabel": "Full-Time"
  }
}