INTERNSHIP DETAILS

财务分析部数据处理实习生

CompanyABB
LocationHuangpu District
Work ModeOn Site
PostedMay 20, 2026
Internship Information
Core Responsibilities
The role focuses on collecting, cleaning, and integrating financial and operational data from various departments to create standardized analysis reports. It also involves using Excel VBA and macros to automate manual data processing workflows and improve efficiency.
Internship Type
full time
Company Size
143927
Visa Sponsorship
No
Language
Chinese
Working Hours
40 hours
Apply Now →

You'll be redirected to
the company's application page

About The Company
ABB is a technology leader in electrification and automation, enabling a more sustainable and resource-efficient future. The company’s solutions connect engineering know-how and software to optimize how things are manufactured, moved, powered and operated. Building on over 140 years of excellence, ABB’s more than 110,000 employees are committed to driving innovations that accelerate industrial transformation. www.abb.com Privacy notice & house rules: https://social.abb/social-media-information Before applying for a job at ABB, please read our Fraud Warning: https://careers.abb/global/en/fraud-warning
About the Role

At ABB, we help industries outrun - leaner and cleaner. Here, progress is an expectation - for you, your team, and the world. As a global market leader, we’ll give you what you need to make it happen. It won’t always be easy, growing takes grit. But at ABB, you’ll never run alone. Run what runs the world.

This role sits within ABB's Robotics business, a leading global robotics company. We're entering an exciting new chapter as we’ve announced the plan for SoftBank Group to acquire ABB Robotics. SoftBank is a globally recognized technology group and investor/operator focused on AI, robotics, and next-generation computing.  By joining us now, you’ll be part of a pioneering team shaping the future of robotics—working alongside world-class experts in a fast-moving, innovation-driven environment.

This Position reports to:

Finance Manager


 

财务分析部数据处理实习生
岗位职责
1. 负责日常对接各业务及职能部门,主动沟通协调需求,常态化向各部门收集、汇总、核对各类业务数据;
2. 负责各类财务数据营运数据的整合、导出、筛选与清洗工作,规范数据格式,剔除异常数据,保障数据准确性与完整性;
3. 协助完成财务日常数据报表的制作,将零散数据整理为规范、可直接使用的分析报表;
4. 依托Excel及宏/VBA,优化现有手工数据处理流程,搭建自动化数据处理模板,替代重复手工操作,实现数据处理轻量化、便捷化;
5. 配合部门完成数据核对、台账整理、数据汇总等基础工作,提升财务数据处理效率;
6. 无需搭建维护数据库、无需使用SQL,全程基于现有Office软件完成所有数据工作,无额外软件部署与运维工作。
任职要求
1. 专业要求:统计学、应用统计、信息管理与信息系统、计算机类、大数据相关专业优先,财务类专业(具备数据处理能力)亦可,不强制要求深厚财务专业知识;
2. 核心技能:精通Excel高阶操作,熟练使用数据透视表、VLOOKUP/XLOOKUP、数据合并、数据分列等功能,必须掌握Excel宏/VBA基础操作,能录制、修改简单宏代码,搭建自动化处理模板;
3. 能力要求:细心严谨,对数字敏感,具备较强的数据清洗、逻辑梳理能力,学习能力强,能快速理解财务数据处理逻辑;具备良好的沟通表达与跨部门协作能力,能够清晰对接业务及财务同事需求,同步工作进度、反馈数据问题;
4. 经验要求:有数据整理、报表自动化、Excel流程优化相关实习经验或校园项目经验者优先;
5. 其他:熟练使用Office办公软件,做事踏实有责任心,能保证稳定实习时长。
我们期望你
能快速上手财务数据营运数据处理工作,针对性优化现有手工Excel数据处理模式,用轻量化、无额外软件成本的方式,实现部门数据处理智能化、模板化,减轻团队手工操作负担,且后续无需专人维护流程。

We value people from different backgrounds. Could this be your story? Apply today or visit www.abb.com to read more about us and learn about the impact of our solutions across the globe.

Key Skills
Advanced ExcelVBAMacrosData CleaningPivot TablesVLOOKUPXLOOKUPData AnalysisCross-departmental CollaborationFinancial Reporting
Categories
Data & AnalyticsFinance & AccountingTechnology