ตำแหน่ง Data Analyst

บริษัท เมเชอร์โทรนิกซ์ จำกัด

ที่อยู่บริษัท 2425, 2 Lat Phrao Rd, Saphansong, Wang Thonglang, Bangkok 10310

เงินเดือน สำหรับสมาชิกเท่านั้น

ลักษณะงานที่ทำ
- Manage the databases of the Sales, Cal, Warehouse departments by using data to perform Cleansing Data & Manage Data to make the data is accurate and can be used more conveniently.
- Take data from all parties that have passed Cleansing Data & Manage Data to make Reports & Dashboard using Excel to make it easier for all parties to see the overall picture of their own department.
- Create a Data Center Project by using data from every business team. Come together to do Cleansing Data, Manage Data, Report & Dashboard using Excel and present to executives. and adjust additional information as desired by the executives.
- Prepare sales department information each month and present it to management by using Power Bi.

ตำแหน่ง Data Management & Analyst (Marketing Team)

บริษัท Solve Group

ที่อยู่บริษัท 23 ซ. พาสนา 2 แขวงพระโขนงเหนือ เขตวัฒนา กรุงเทพมหานคร 10110

เงินเดือน สำหรับสมาชิกเท่านั้น

ลักษณะงานที่ทำ
1.Manage the company’s internal database by conducting Cleansing Data & Manage Data processes to ensure data accuracy and make it easier for future usage.
2.Analyze customer segments from the Official channel database to identify customers with frequent repurchases, including which SKU items they repurchased and the total purchase value.
3.Prepare data as requested by the Sales team, such as customer purchase volume and ranking customers by reward points from highest to lowest, to support sales promotions and CRM initiatives.
4.Analyze annual sales data from the Shopee channel to determine which regions the orders come from and the corresponding order volume, for the marketing team to target those markets effectively.
5.Analyze TikTok channel performance on a monthly basis, including sales, commissions, KOL (Key Opinion Leader) activity, advertising expenses, and other relevant metrics.
6.Manage and analyze product data featured in external programs or events for CRM purposes.
7.Record competitors’ information such as (number of ad campaigns, sales volume, and revenue on Shopee, Lazada, and Tiktok) for comparative analysis and brand marketing improvement.
8.Create and manage a Google Sheet for the ad campaign team to input daily ad spend across platforms (Shopee, Lazada, Tiktok, Official, etc.) and record the corresponding daily sales per channel.
9.Develop Dashboard & Report using Google Sheet & Excel, showing sales from different channels, ad spend, sales by SKU, monthly and yearly sales, including performance metrics like Growth Rate, %YOY, Ratio, ROAS, and ROI.
10.Provide data and analysis as requested by the Marketing Manager, covering both Official and E-Commerce platforms.