SummaryPosted: Aug 1, 2024
Role Number:
200558909Apple is where individual imaginations gather together, committing to the values that lead to great work. Every new product we build, service we create, or Apple Store experience we deliver is the result of us making each other’s ideas stronger. That happens because every one of us shares a belief that we can make something wonderful and share it with the world, changing lives for the better. It’s the diversity of our people and their thinking that inspires the innovation that runs through everything we do. When we bring everybody in, we can do the best work of our lives. Here, you’ll do more than join something - you’ll add something. 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.
DescriptionThis 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
- 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.
Preferred Qualifications- Proficiency in Python and/or Shell scripting is essential, with a demonstrated ability to migrate mission-critical applications to cloud environments.
- BS Degree in Computer Science or equivalent
Education & ExperienceAdditional RequirementsMore
- Apple is an equal opportunity employer that is committed to inclusion and diversity. We take affirmative action to ensure equal opportunity for all applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, Veteran status, or other legally protected characteristics. Learn more about your EEO rights as an applicant.
