Data Analytics Engineer

Shiseido Cosmetics Vietnam CO., LTD · Hồ Chí Minh

Type

Full-time

Work mode

On-site

Level

Staff

Industry

Engineering / Mechanical

Salary

Thương lượng

Location

Hồ Chí Minh, Hồ Chí Minh, Hồ Chí Minh

Overview

Data Warehouse Management & Optimization: Maintain, monitor, and optimize existing data warehouse layers within Microsoft SQL Server (Warehouse Staging SDW, Warehouse Enterprise SDW, and Data Marts). Ensure data governance, data quality, and schema consistency.
Pipeline Maintenance & Expansion: Maintain robust ETL/ELT pipelines orchestrated by Apache Airflow on a Linux VPS Cloud environment. Handle data ingestion from diverse sources: Web APIs (Shopee, Lazada, TikTok Shop, Facebook), AWS S3 (CDC), Internal DBs, Brand.com, and semi-structured/unstructured formats (JSON, Flat files, Excel, and HTML Scraping). Write new pipelines using Python and T-SQL…
End-to-End BI & Deep-Dive Analytics: Design, develop, and maintain high-impact dashboards in Power BI Desktop (using advanced DAX and Power Query), and manage deployment on Power BI Service (including workspaces, Row-Level Security, and refresh schedules). Conduct deep-dive business analyses covering both Offline and Ecommerce sales to provide strategic insights into Seasonality, Buyer…
AI/Automation Integration: Actively apply GenAI and automation tools (e.g., GitHub Copilot, ChatGPT, LLM-based agents) to speed up code writing, document metadata, automate repetitive reporting tasks, and optimize query performance.

Summary of facts from the official posting. View original ↗

You'll be taken to the employer's official application page.