Data Engineer - Retail Business Intelligence
Shanghai, Shanghai, China
Corporate Functions
Imagine what you could do here! The people here at Apple don’t just create products — they build the kind of wonder that’s revolutionized entire industries. It’s the diversity of those people and their ideas that inspires the innovation that runs through everything we do, from amazing technology to industry-leading environmental efforts. At Apple, inclusion is a shared responsibility, and we work together to foster a culture where everyone belongs and is inspired to do their best work.
Here on the Apple Store Online team, we are responsible for Apple’s largest store. Our main goal is to deliver a magical, personal digital experience where customers can shop, buy and learn everything Apple, wherever they are. Each customer should feel like they are our only customer and our job is to set the bar for the experience they receive. To run such an extraordinary store, it takes extraordinary people, and we are looking for someone to help us do extraordinary things.
Do you love problem solving and thinking beyond an obvious solution? Are you passionate about data accuracy and improving operational efficiency by managing sophisticated data and information delivery? We are!
Our Retail Business Intelligence team within ASO is looking for a resourceful, energetic Data Engineer to lead the data needs within projects by crafting creative solutions to deliver data to end users. You’ll work with multi-functional teams to stitch data from various systems into unified, high-performance and low-latency reporting layers for end-to-end analyses of projects. Join us, and you’ll help provide the data needed for the organization to effectively run the business and improve our customer experiences across the world.
Description
As a Data Engineer on the Retail Business Intelligence team, you will play a pivotal role in demonstrating your extensive understanding of data, including attributes, measures, and KPIs, to accurately measure and evaluate our business initiatives. Collaborating closely with peers and global multi-functional partners, you will be instrumental in addressing their data and reporting needs. Your expertise will be instrumental in designing, building, testing, and deploying robust reporting solutions that empower our customers to make data-driven decisions.
Day-to-day responsibilities include partnering with IT teams to build critical data pipelines, ad hoc data analyses, troubleshooting data and supporting project teams during all stages of projects including, requirement gatherings, gap reviews, development and testing. Other responsibilities include:
- Contributing to Business Initiatives: Participating in global cross functional projects, support unit integration, and system implementations/upgrades to ensure measurable impacts
- Data Analytics and Reporting: Enhancing and troubleshooting web reports and analytical tools, assist in defining and building metrics, and perform ad hoc analyses
- User Support: Engaging in consultation, training, and user acceptance testing (UAT) for analytical tools and data sets
- Technical Proficiency: Participating in regular design and code reviews, debugging, and coding to resolve issues
- Data Governance: Participating in data governance discussions and facilitate data harmonization conversations with global stakeholders
- Maintain Data Knowledge: Maintaining the data dictionary for Retail Online
Minimum Qualifications
- 3+ years of SQL experience with advanced-level proficiency
- Experience with data induction, validation, normalization, maintaining data definitions, quality rules, lineage, and dictionaries
- Fluent in English and Mandarin
- BA/BS or equivalent experience in Information Technology, Mathematics, Computer Science, or a minimum of 4 years directly relatable experience.
Key Qualifications
Preferred Qualifications
- Ability to build effective relationships and collaborate in a global, matrixed team
- Proactive, driven self-starter with innovation, integrity, a strong work ethic, and attention to detail
- Comfortable working in a fast-paced, learning-oriented environment.
- Experience in delivering projects, while working with multiple teams and across multiple time zones
- Demonstrated proficiency in Semantic layer (ESL) development
- 4+ years of data extraction experience
- Experience with data visualization tools (e.g.: Tableau)
- Strong business mentality - ability to grasp business needs, translate into technical needs; ability to communicate complex technical concepts to business leaders
- Driven to continuously search for ways to improve and enhance data reliability and performance
- Strong root-cause analysis skills with attention to detail
- Experience with one of the following languages : Python, PHP, Java
- Experience in writing requirements and executing UAT as part of large enterprise project team