Data Engineer (9 months)

Job Description

Project Scopes:

· Migrate current BAS database onto Snowflake platform.

· Develop whole new ETL pipelines to ingest sales out data from external distributors.

· Develop new ETL pipelines to ingest offtake data of Chain customers.

· Enhance BAS to manage additional master data: Sales org, Territory, Alignment, …

· Develop PBI sales out related reports to replace current SMS.

Key responsibilities:

· Ingest data from multiple data sources (both internal & external) in varying formats and structures.

· Design high quality data model for data storage and business intelligence.

· Develop and deploy resilient data pipelines in data lake and data warehouse.

· Deliver high quality reports/dashboard in Power BI, MS Excel.

· Deliver high quality datasets for downstream reporting purposes.

· Monitor and optimize data workflow for storage efficiency and performance.

· Perform administrative tasks on data platform.

Job Requirement

·       At least 3 YOE as a data engineer or a software engineer.

·       Strong programming skills in SQL (must have), Python or any other similar languages (a plus).

·       Hands on experience of building ETL pipelines in cloud data platforms: Snowflake (Preferable), or any other similar platforms.

·       Proficient in data analysis using advanced MS Excel, or data visualization tools (Power BI, Tableau, …).

·       Familiar in using MS Access is a plus.

·       Familiar with sales & distribution business process in consumer healthcare, FMCG, or relevant industry is highly preferred.

·       Bachelor’s in Computer Science, Software Engineering, Business Analytics, or any relevant majors.

·       Working time: Monday - Friday (50% hybrid, 50% in office)