Data Analytics Support Engineer (Retail)

Job Responsibilities

Key Responsibilities Data Management and Integration

• Create, maintain, and optimize ETL processes to consolidate data from various sources into different BI platforms like Power BI, Tableau, SAP BO.
• Extract and build datasets from regional data lake EDP by business requirement.
• Ensure data quality, accuracy, and reliability across all analytics platforms.
• Work on different databases (MSSQL, MySQL and Oracle DB), data warehouse/lake for data aggregation, preparation and integration.
• Attend to ad hoc requests for data extraction, data cleansing, and data patching. 
• Provide documentation on the data flow of dashboard/reports.

Analytics and Reporting

• Maintain and enhance existing dashboards and reports on Tableau, Power BI and SAP BO platform, ensuring day-to-day operational and commercial dashboards & reports are delivered timely and accurately.
• Build new reports and dashboards using Power BI to provide actionable insights and support decision-making.
• Analyze datasets to identify issues, trends, and patterns.

Collaboration and Support

• Work closely with users to understand business needs and translate them into technical requirements.
• Provide data & dashboard-related support to business users, including but not limited to data extraction, visualization, troubleshooting data inconsistencies, system performance related issues, dashboard enhancement and etc.
• Collaborate with GIT and regional data team on local data requirements, clarification, bridging communication with local users, and knowledge exchange. 
• Work with vendors to ensure correct business requirements are captured,  solution design, development and delivery are according to expectations.
• Provide training and support to end-users on data analytics tools and best practices.

Job Requirements

• Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
• Two (2) or more years of experience in data engineering, analytics, or a similar role.
• Proficiency in Oracle / MS SQL scripting, SQL stored procedure, and Python. 
• Experience with data visualization tools such as Tableau, Power BI, or similar.
• Strong knowledge of ETL processes, data warehousing, and data integration techniques.
• Knowledge on data lake and cloud data engineering platform like Databricks is an added advantage.
• Ability to problem solve, research and communicate effectively with minimal supervision. 
• Take ownership of tasks & work independently in a fast-paced, dynamic environment.

Key Performance Indicators (KPIs)

• Delivery: Number of dashboards/reports delivered
• Report/Dashboard Accuracy: Number of errors or discrepancies identified in the dashboards and/or generated reports.
• ETL Process Efficiency: Time taken to extract, transform, and load data from various sources.
• Stakeholder Satisfaction: Feedback scores from stakeholders on data solutions and support.
• Project Timeliness: Percentage of projects completed within the agreed timeframe.
• Innovation: Number of new data solutions or improvements implemented.

Watsons Malaysia is part of AS Watsons Group, the world’s largest international health and beauty retailer operating over 16,000 stores under 12 retail brands in 28 markets, with over 130,000 employees worldwide. For the fiscal year 2022, AS Watsons Group recorded revenue of US$22 billion. Every year, we are serving over 5.5 billion shoppers via our O+O (Offline plus Online) technology-enabled platforms. Watsons Malaysia is the leading health and beauty retailer with more than 650 Watsons stores and growing in the country serving the needs of all Malaysians. Watsons continues to inspire our customers to enjoy life to the fullest and set the standards in the health, wellness, and beauty market, providing personalised advice in health, beauty, and personal care on top of its market-leading product ranges, making customers LOOK GOOD, DO GOOD, FEEL GREAT every day. Since 2009, Watsons has been the No.1 pharmacy/drugstore brand in Asia Pacific for the 13th year running*. On top of that, Watsons Malaysia won Platinum Award for the Best in Retail Category 2022 by Putra Brands Award, a premier and only brand award in Malaysia voted by Malaysian consumers. Watsons Malaysia is also the No. 1 Retailer Most Preferred Graduates Employers to Work for by Talentbank Graduates' Choice Award 2022. *Campaign Asia-Pacific “Asia’s Top 1000 Bands online study over 8,000 respondents across 14 markets in Asia Pacific region”.