Data Engineer - DataMart

Key Responsibilities

• Design, develop, and maintain data marts to support business analytics and reporting needs
• Build and optimize ETL/ELT pipelines using scalable data processing frameworks
• Translate business requirements into dimensional models (star/snowflake schemas)
• Ensure data quality, consistency, and reliability across datasets
• Optimize query performance and data storage for efficient downstream consumption
• Collaborate with business stakeholders (Sales, Finance, Operations) to deliver actionable datasets
• Work closely with Data Analysts and BI teams to enable self-service analytics
• Implement data governance, documentation, and best practices across the data layer
• Monitor and troubleshoot pipeline performance and data issues

Requirements

• Bachelor's degree or above in Computer Science, Software Engineering, Statistics, or a related field
• 3+ years of experience in data engineering or data warehouse development, with hands-on experience building data marts or data warehouses end to end
• Strong experience in data mart / data warehouse modeling (Kimball methodology preferred)
• Hands-on experience with Databricks (Spark, PySpark)
• Solid experience in AWS data services (e.g., S3, Glue, Redshift, Lambda – depending on stack)
• Proficiency in SQL and at least one programming language (Python preferred)
• Experience building and maintaining ETL/ELT pipelines
• Understanding of data partitioning, indexing, and performance tuning
• Strong English proficiency required; spoken Chinese proficiency advantageous to support collaboration with regional colleagues and external stakeholders