[6 months, 4-5 days/week] Name of Project: TEV Market and Sales Analysis Dashboard Objectives: - Establish integrated database of TEV product and Market data - Analyze the KPI demand of each function in TEV Sales Management Team, identify and design the best-fit automate dashboard based on the database - Support to improve working efficiency of TEV Sales Management Team Main Tasks: - Deep understand each TEV Sales and Market relevant KPIs and corelations among the KPIs - Develop the master data for the key KPIs with good solution of efficient updating workflows - Design and implement the visualization of the data analysis result in Dashboard - Other ad-hoc analysis work Key Learning Opportunities: - Project Management & Stakeholder Management - Sales & Product insight & expertise - Data analysis within Sales & Marketing - Gain experience in enterprise-level data management processes and business scenario analysis. - Open learning environment to quickly enhance practical skills. Key Qualifications: - Advanced Excel skills, including expertise in pivot tables, slicers, Power Query, and Power Pivot. - Familiarity with data visualization tools (e.g., Power BI, Tableau) to design and implement interactive dynamic reports. - Experience in writing VBA (Excel macros) to automate report operations. - Proficiency in Python, for efficient data cleaning and logical processing. - Ability to use supporting tools to implement scheduled tasks. - Capable of extracting data from multiple sources (e.g., files, databases) with basic SQL skills being a plus. - Strong analytical skills to design logical rules based on business requirements, ensuring accurate and relevant report presentations. - Ability to quickly learn new tools and technologies to efficiently solve practical problems. - Good Communication skills & Self-motivation Language: Chinese: Proficient English: Proficient Education: Degree: Bachelor or above Major: Computer Science