Analytics Engineer - BI & Planning, Shopee

What you'll do

We seek an experienced Analytics Engineer who will be in charge of (1) building automation solutions for analytics processes; and (2) optimization and maintenance of local data pipelines to ensure analytics efficiency and governance.  

The Analytics Engineer will work closely with Functional BI teams and business users to understand the data logic and workflow, then architect and build solutions to automate the data flow and manual tasks.  

Automation

• Partner closely with stakeholders across business units and Functional BI teams to understand their challenges and translate requirements into technical solutions
• Drive process automation by developing intelligent tools for eKYC processing, tax validation, and other critical business operations

Data Engineering

• Build robust data foundations by designing and implementing scalable ETL processes that seamlessly extract, transform, and load data from our internal platforms
• Architect data pipelines that integrate smoothly with existing systems and power automated workflows across the business
• Optimize data infrastructure including local tables, data models, and data mart architecture for peak performance and reliability

Analytics Modelling Implementation and Maintenance

• Implement and maintain predictive analytics and automated data processing solutions
• Write SQL queries and Python code that support features engineering and EDA in complex datasets

Data Quality and Governance

• Maintain code quality through disciplined source control practices, branch management, and collaborative code reviews
• Ensure system reliability by monitoring, troubleshooting, and optimizing data pipeline performance

Requirements

• Bachelor’s degree in Computer Science, Software Engineering, or related field
• 2+ years of experience in data engineer role or similar role
• Strong SQL skills with experience writing complex queries for data extraction and transformation
• Strong proficiency in Python for developing automation solutions, and experiencing using libraries for data processing, API integration, and system automation
• Experienced with ETL processes and data pipeline development in various databases and data pipeline development
• Able to communicate complex business or technical information effectively
• Strong camaraderie, analytical skills, problem-solving solving and solution-oriented mindset, especially when issues arise
• Take initiative and show flexibility in a fast-paced environment
• Experience with AI/ML implementation in business processes
• Data engineer certification (e.g., IBM Certified Data Engineer) is a plus
• Experience in RPAframework
• Background in e-commerce industries