Summary
Posted: May 16, 2024
Role Number: 200551001
Are you meticulously organized and highly observant? Join our Information Systems and Technology group and play a vital function on one of two Apple teams: Software and Services and Corporate Functions. From Apple ID to the Apple website to our data centers around the globe, our diverse collection of engineers, designers and creators manage the massive systems and services that so many people rely on every single day. We also build the custom tools that empower other Apple employees to solve problems on their own. Joining this group means you'll be part of the Apple nerve center. You could play a meaningful role in helping Apple connect with over a billion customer devices around the world. Or you could help over 130,000 employees stay connected with each other and our suppliers. Together, you and your team will help everyone at Apple do what they do best: explore every possibility. At Apple, new ideas have a way of becoming extraordinary products, services, and customer experiences very quickly. Bring passion and dedication to your job and there's no telling what you could accomplish. Would you like to work in an energizing environment where your abilities will be challenged on a day-to-day basis? If so, Apple's IS&T Ai & Data Platforms team is looking for highly motivated, detail oriented, technical savvy, results-oriented professionals who like to think creatively and want to be part of one of the largest data processing and analytics team! This role requires leading the design, development and deployment of data warehouse solutions for multiple business groups at Apple for Finance domain.
Key Qualifications

• 5 years of solid background in SQL, database application development and/or developing ETL pipelines.
• Should be able to troubleshoot in various RDBMS technologies and do root cause analysis of issues.
• Must have strong understanding of Massively Parallel Processing databases and column storage.
• Strong experience in Data Modeling, SQL performance tuning, and reporting is required, preferably using SAP HANA.
• Proficiency in Python and/or Shell scripting is essential, with a demonstrated ability to migrate mission-critical applications to cloud environments.

Description
This role entails providing solutions to near real time reporting needs using SAP HANA or a similar database, and overseeing fast-paced, intricate distributed database environments that support OLAP systems. The successful candidate will lead and collaborate with a diverse, multi-functional team, both locally and remotely, to design, develop, and support product and process development efforts for our next-generation products. Main responsibilities include: - Design, develop, deploy, and manage relational column tables in production environments, ensuring high availability, scalability, and disaster recovery. - Design, implement and optimize SQL stored procedures, views, data pipelines, issue detection and resolution, and log analysis. - Implement column and row level security for access. - Lead cross-functional teams to support large-scale databases with high transaction volumes and ensure continuous availability. - Lead the development of data pipelines to cloud environments such as Snowflake. - Design, develop and implement reporting solution on any one of the following : Tableau, Business Objects or custom UI solutions, ideally using NodeJS
Education & Experience
BS Degree in Computer Science or equivalent
Additional Requirements
Additional Requirements