苹果People Analytics Developer and Software Engineer
社招全职Software and Services地点:上海状态:招聘
工作描述
Qualifications Minimum Qualifications 10+ years of professional experience developing and maintaining analytics products and reports, with proficiency in dashboard visualisation development. Strong data engineering skills including deep SQL expertise to develop optimised data sets across analytical and operational products. Good knowledge of Snowflake enterprise data warehouse technology and relational database technologies such as MySQL and PostgreSQL, including schema design and query optimisation. Proven ETL / data pipeline engineering: designing and operating extract-transform-load workflows across Snowflake and relational databases, including scheduling, incremental/near-real-time refresh, and caching strategies. Deep proficiency in Python - applied both to backend web development and to data processing and automation tasks. Solid Linux systems proficiency - Solid Linux systems proficiency - comfortable operating over SSH, managing long-running services and daemons (systemd, gunicorn/uwsgi, nginx/reverse proxies), and troubleshooting at the systems level including processes, networking, file systems, and performance diagnostics, unaided. Hands-on experience with containers (Docker or an equivalent OCI runtime): authoring Dockerfiles, building and deploying images, and troubleshooting container networking, stora…
登录查看完整工作描述
微信扫码,1秒登录
包括英文材料
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.
Snowflake+
https://www.youtube.com/watch?v=mP3QbYURT9k
MySQL+
https://juejin.cn/post/7190306988939542585
这是一篇 MySQL 通关一篇过硬核经验学习路线,包括数据库相关知识,SQL语句的使用,数据库约束,设计等。
[英文] MySQL Tutorial
https://www.mysqltutorial.org/
your go-to resource for mastering MySQL in a fast, easy, and enjoyable way.
https://www.youtube.com/watch?v=5OdVJbNCSso
MySQL SQL tutorial for beginners
https://www.youtube.com/watch?v=7S_tz1z_5bA
This beginner-friendly course teaches you SQL from scratch.
PostgreSQL+
[英文] PostgreSQL Tutorial
https://neon.com/postgresql/tutorial
This PostgreSQL tutorial helps you quickly understand PostgreSQL.
[英文] PostgreSQL Tutorial
https://www.pgtutorial.com/
This PostgreSQL tutorial will teach you about PostgreSQL from beginner to advanced.
https://www.youtube.com/watch?v=qw--VYLpxG4
It is the most advanced open source database system widely used to build back-end systems.
https://www.youtube.com/watch?v=SpfIwlAYaKk
Learn PostgreSQL, one of the world's most advanced and robust open-source relational database systems.
ETL+
https://www.ibm.com/think/topics/etl
ETL—meaning extract, transform, load—is a data integration process that combines, cleans and organizes data from multiple sources into a single, consistent data set for storage in a data warehouse, data lake or other target system.
https://www.youtube.com/watch?v=OW5OgsLpDCQ
It explains what ETL is and what it can do for you to improve your data analysis and productivity.
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.
Web+
https://web.dev/learn
Explore our growing collection of courses on key web design and development subjects.
Linux+
https://ryanstutorials.net/linuxtutorial/
Ok, so you want to learn how to use the Bash command line interface (terminal) on Unix/Linux.
https://ubuntu.com/tutorials/command-line-for-beginners
The Linux command line is a text interface to your computer.
https://www.youtube.com/watch?v=6WatcfENsOU
In this Linux crash course, you will learn the fundamental skills and tools you need to become a proficient Linux system administrator.
https://www.youtube.com/watch?v=v392lEyM29A
Never fear the command line again, make it fear you.
https://www.youtube.com/watch?v=ZtqBQ68cfJc
SSH+
https://www.digitalocean.com/community/tutorials/ssh-essentials-working-with-ssh-servers-clients-and-keys#how-to-use-this-guide
SSH is a secure protocol used as the primary means of connecting to Linux servers remotely.
https://www.redhat.com/en/blog/ways-use-ssh
Secure shell (SSH) is one of the most ubiquitous Linux tools.
https://www.youtube.com/watch?v=YS5Zh7KExvE
OpenSSH is the essential tool for secure remote access, and it’s a must-know for anyone in DevOps, cloud computing, system administration, hosting, and IT in general.
uWSGI+
https://docs.djangoproject.com/en/5.2/howto/deployment/wsgi/uwsgi/
uWSGI is a fast, self-healing and developer/sysadmin-friendly application container server coded in pure C.
https://uwsgi-docs.readthedocs.io/en/latest/WSGIquickstart.html
This quickstart will show you how to deploy simple WSGI applications and common web frameworks.
https://www.digitalocean.com/community/tutorials/how-to-deploy-python-wsgi-applications-using-uwsgi-web-server-with-nginx
As introduced in our Python Web Server Comparison article, uWSGI is a vast project, capable of doing much more than serving web applications alone.
Nginx+
[英文] Beginner’s Guide
https://nginx.org/en/docs/beginners_guide.html
This guide gives a basic introduction to nginx and describes some simple tasks that can be done with it.
https://www.youtube.com/watch?v=9t9Mp0BGnyI
NGINX is open-source web server software used for reverse proxy, load balancing, and caching. It's important to understand, especially if you are a backend developer.
还有更多 •••
相关职位
社招职能与支持
- 聪明,数据敏感,具备业务思维和好奇心,能快速捕捉关键数据信息。 - 精通SQL、Tableau、Python等工具,有丰富可视化看板及报告搭建经验,高效完成复杂数据处理,快能快速理解需求并高效完成
更新于 2026-06-18北京
社招Human Re
1, Regular monitor of CN Expense report and supporting internal/external audit. On top of the Conc
更新于 2025-12-09上海
社招3年以上A65208
1、系统经验:3年以上人力资源系统实施或运营经验; 2、业务理解:熟悉HR核心模块业务逻辑,具备模块配置和流程设计能力; 3、项目管理:具备方案设计和项目推进经验,能够协调跨部门资源高质量交付; 4、
更新于 2026-01-04上海