Senior 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 complex data and information delivery? We are!
Our Retail Business Intelligence team within ASO is looking for a resourceful, energetic Senior Data Engineer to lead and assist with the data needs of projects by crafting creative solutions to deliver data to end users. You’ll work with cross-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
Working in a global organization, this position plays a substantial role in defining how data is structured, organized and evaluated for consistent understanding and interpretation. A key success factor for this role is the ability to understand diverse partner needs, investigate complex data sets and propose creative solutions to senior management and business partners. In this role, you will:
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:
- Engage as a SME in global multi-functional projects to ensure the planned impact will be measurable and quantifiable
- Define how data is structured, organized and interpreted by building certified datasets for consistent analytics and reporting
- Work closely with project managers, stakeholders and IT to deliver data requirements by leading the reporting track from requirements gathering through to successful UAT
- Develop web reports and analytical tools
- Define, build and deploy relevant metrics and perform ad hoc analyses
- Provide consultation and training to users of analytical tools and data sets
- Lead regular design and code reviews and perform debugging and coding to resolve issues
- The ideal candidate has a real passion for quality and an ability to understand complex systems
Minimum Qualifications
- 4+ years of SQL experience with advanced-level proficiency
- Extensive Semantic layer (ESL) development experience in relational database and data lake environments
- Experience with data visualization tools (e.g.: Tableau)
- Fluent in English and Mandarin
- BA/BS or equivalent experience in Information Technology, Mathematics, Computer Science, or a minimum of 6 years directly relatable experience
Key Qualifications
Preferred Qualifications
- Ability to pick up new tech skills independently
- Ability to establish effective relationships and influence partners in a global multi-functional team environment
- Structured problem solver with the ability to easily break down ambiguous problems and propose creative solutions
- Experienced at contributing to and influencing the deliverables of projects as part of a large global cross functional team
- 5+ years advanced proficiency and demonstration of SQL skills
- 5+ years ETL and query optimization experience
- Experience with Finance, Operations, Retail or Contact Center systems and data sets
- Strong business mentality - ability to grasp business needs, translate into technical needs; ability to communicate complex technical concepts to business leaders
- Proactive in bringing new, innovative ideas to the table and inspiring change across projects, programs and processes
- Ability to lead, take action and provide goal-oriented direction in the face of ambiguity
- Experience with one of the following languages : Python, PHP, Java
- Extensive experience doing data validation against complex disparate systems
- Expert ability to write business requirements in an IT friendly format