Job Description

Locations

• China, 31, Shanghai, Shanghai, 31, People's Republic of China

Salary

Skills Required

• - 5+ years of professional experience in data warehouse including ETL and optimization for large(multi-TB+) data setsintermediate
• - Master in SQL and Experience in scripting for automation (e.g. Python)intermediate

Required Qualifications

• - Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field (degree in bi)
• - 5+ years of professional experience in data warehouse including ETL and optimization for large(multi-TB+) data sets (experience, 5 years)
• - Master in SQL and Experience in scripting for automation (e.g. Python) (experience)
• - Proven problem solving skills, attention to detail, and exceptional organizational skills. (experience)

Preferred Qualifications

• - Experience in data mining and using databases in a business environment with large-scale, complex datasets (experience)
• - Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift (experience)
• - Ability to deal with ambiguity and competing objectives in a fast paced environment. (experience)

Responsibilities

• Data Warehouse Design, Development, Maintenance and Optimization: Architect, build and manage secure, flexible and scalable data warehouse solutions. Ensure the iterations adapt to the ever-changing global technology and new business demand.
• Performance Optimization: Write complex and efficient SQL queries for data manipulation, transformation, and aggregation. Optimize SQL queries to improve performance and efficiency.
• ETL Process Management: Design, implement, and maintain ETL (Extract, Transform, Load) processes. Ensure accurate and efficient data integration from various sources into the data warehouse and the optimal model to fit downstream usage.
• Data Quality and Governance: Implement data quality checks, balances, and controls to ensure the accuracy and integrity of data within the data warehouse. Co-work with Risk Control Management Team to ensure the optimal data quality and compliance.
• Collaboration and Support: Work closely with Global Team to ensure the data foundation is consistent with global standards and adapted to the latest technology; Co-work with other business analyst, business intelligence engineer, and other stakeholders to run the data foundation ecosystem and translate data needs to robust data solutions
• Continuous Improvement: Stay informed of industry trends and advancements in AWS based technologies. Recommend and implement improvements to processes and technologies to enhance data warehouse functionality and efficiency.

Tags & Categories