特斯拉Fixed Asset Analyst
社招全职财务地点:上海状态:招聘
任职要求
Bachelor’s degree in Accounting, Finance, Information Systems, Computer Science, or related field. Proficiency in SQL and Python for data extraction, transformation, and automation. Advanced Excel (Power Query); strong BI skills (data modeling, DAX, visualization); VBA is a plus. Experience with ERP and data sources such as AX, WARP FA/PO, TRT, and GL Cube; familiarity with APIs is preferred. Working knowledge of fixed asset concepts (asset lifecycle, subledger vs GL, reconciliations, SOX-style control evidence) or demonstrated ability to learn them quickly in a manufacturing environment. Proven ownership of recurring deliverables under a hard calendar (month-end / reporting deadlines); comfort with both hands-on execution and driving durable tools (self-built or with IT). Fluency with AI tools as part of normal professional work, with the judgment to verify outputs and the competency to explain and defe…
登录查看完整任职要求
微信扫码,1秒登录
工作职责
Job Description: Tesla Shanghai is seeking a Fixed Asset Analyst to own a defined portfolio of fixed asset BAU processes and to drive automation, data pipelines, and analytics that improve accuracy, speed, and scalability for both that portfolio and the broader Fixed Asset accounting team at the Lin Gang manufacturing site. This role executes recurring close, control, and reporting work end-to-end, then systematically reduces manual effort through reusable solutions. It is the primary driver of process automation and tooling for the Fixed Asset team—partnering with FA accountants to capture requirements, validate outputs, and hand off tools FA accountants can run in day-to-day work. Automation is delivered both through solutions the analyst builds directly and through initiatives scoped and driven with the IT development team. The analyst owns the business problem, process design, validation, and adoption. The team works extensively with AI tools across day-to-day work and automation. Fluency in using AI productively is expected, with full personal accountability for the quality, accuracy, and defensibility of all deliverables. Responsibilities Fixed asset BAU ownership (assigned portfolio): Own end-to-end execution of the assigned task portfolio across monthly, quarterly, semi-annual, and annual cadences, including but not limited to: Journal entry and amortization packs and related GL account reconciliations (e.g. casting die). SOX and operational controls (e.g. Vendor GRIR recon), with complete evidence and review packs. Subledger controls (e.g. asset PO flag review, AUC aging review), with exception-based review where tools allow. External, statutory, and cycle reporting packs (e.g. local statistics bureau submissions, NDRC-related reports, APAC fleet analysis). Meet close and submission deadlines; maintain runbooks, checklists, and version-controlled working papers for each owned process. Investigate breaks and data issues early; escalate accounting policy or judgment items to FA accountants / the Fixed Asset Manager as needed while retaining process ownership. Process automation and team enablement (primary improvement mandate): Map high-manual-effort workflows—starting with owned controls and reports—and automate data extraction, validation, matching, pack generation, and exception queues. Build lighter-weight tools and scripts where appropriate (SQL, Python, Excel, BI) and maintain shared self-service tools that FA accountants can use on their desks. Partner with the IT development team to scope, design, test, and roll out larger or system-integrated automation; act as business owner for requirements, UAT, data validation, runbooks, and go-live readiness. Partner with FA accountants to translate pain points into a prioritized automation backlog; deliver, document, and train so adoption sticks beyond the builder. Continuously retire manual steps; track time saved, error reduction, and control evidence quality. Data integration, quality, and historical analytics: Build data pipelines and ETL-style refreshes that connect ERP and FA source systems with quality checks. Implement validation rules and anomaly detection to surface recon breaks, aging risk, and incomplete control populations before deadline. Develop dashboards and standardized reports for control status, recon results, aging, and submission readiness. Analyze historical trends and prior-period patterns to explain variance and improve process design. Documentation and stakeholder partnership: Maintain technical and process documentation for models, transformations, runbooks, and control evidence standards. Work with Finance, Operations, Supply Chain, Manufacturing, and IT on data access, process changes, and system or report changes that affect the owned portfolio.
包括英文材料
SQL+
https://liaoxuefeng.com/books/sql/introduction/index.html
什么是SQL?简单地说,SQL就是访问和处理关系数据库的计算机标准语言。
https://sqlbolt.com/
Learn SQL with simple, interactive exercises.
https://www.youtube.com/watch?v=p3qvj9hO_Bo
In this video we will cover everything you need to know about SQL in only 60 minutes.
Python+
https://liaoxuefeng.com/books/python/introduction/index.html
中文,免费,零起点,完整示例,基于最新的Python 3版本。
https://www.learnpython.org/
a free interactive Python tutorial for people who want to learn Python, fast.
https://www.youtube.com/watch?v=K5KVEU3aaeQ
Master Python from scratch 🚀 No fluff—just clear, practical coding skills to kickstart your journey!
https://www.youtube.com/watch?v=rfscVS0vtbw
This course will give you a full introduction into all of the core concepts in python.
Excel+
https://edu.gcfglobal.org/en/excel/
In this free Excel tutorial, learn how to create formulas and charts, use functions, format cells, and do more with your spreadsheets.
https://www.youtube.com/watch?v=wbJcJCkBcMg
This is the beginning Excel course that you've been waiting for! Learn everything you need to effectively use Excel by watching just one video.
还有更多 •••
相关职位