Data Warehouse Engineer
New York City, New York, United States
Software and Services
At Apple, we work every day to create products that enrich people’s lives. Our Advertising Platforms group makes it possible for people around the world to easily access informative and imaginative content on their devices while helping publishers and developers promote and monetize their work.
Our technology and services power advertising in Apple News and Search Ads in the App Store. Our platforms are highly performant, deployed at scale, and set new standards for enabling effective advertising while protecting user privacy.
The Ad Platforms Data team is seeking a Data Engineer specializing in building high performance data stores to enable next generation analytical solutions. In this role, you will work as a key member of a data-centric team to drive the development, execution, and continuous improvement of core data infrastructure and processes. You will have a key role in the joint design and development of the data model, pipelines, implementation and delivery of the analytical data warehouse supporting our suite of customer experiences in addition to ad hoc and advanced analytics.
You will be a key enabler for teams of architects, engineers, analysts, data scientists, and business users. A successful candidate will have experience building data processing pipelines, data models and managing cloud based data warehouse platforms.
Key Qualifications
- Minimum 5+ years experience in Cloud Data Engineering, preferably with a background in computer science, mathematics, or a related quantitative field.
- Expertise in building Cloud Data Warehouses in Snowflake, Redshift, BigQuery or analogous architectures.
- Deep SQL expertise, data modeling, dimensional modeling and experience with data governance
- Experience with the practical application of data warehousing concepts, methodologies, and frameworks.
- Experience using data processing tools and technologies such as Python, Spark, Talend, Informatica, SSIS or DBT.
- Embrace data platform thinking, design and develop data pipelines keeping security, scale, uptime and reliability in mind.
- Able to confidently express the benefits and constraints of technology solutions to technology partners, stakeholders, and team members.
Description
- Analyze our data model and infrastructure, spotting gaps and suggesting architectural improvements.
- Collaborate with engineering teams to design and support the next generation of analytics and reporting systems!
- Work with product and analytics teams to understand their specific data system needs.
- Automate and optimize existing data processing tasks, recognizing patterns and implementing solutions.
- Ensure high performance, privacy, security, scalability, and reliability in our solutions!
- Guide partners on effective use of the data warehouse platform through knowledge sharing and best practices.
- Comfortably work as part of a distributed team.
Education & Experience
Additional Requirements
- Apple’s most important resource, our soul, is our people. Apple benefits help further the well-being of our employees and their families in meaningful ways. No matter where you work at Apple, you can take advantage of our health and wellness resources and time-away programs. We’re proud to provide stock grants to employees at all levels of the company, and we also give employees the option to buy Apple stock at a discount — both offer everyone at Apple the chance to share in the company’s success. You’ll discover many more benefits of working at Apple, such as programs that match your charitable contributions, reimburse you for continuing your education and give you special employee pricing on Apple products.
- Apple benefits programs vary by country and are subject to eligibility requirements.
- 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. Apple is committed to working with and providing reasonable accommodation to applicants with physical and mental disabilities. Apple is a drug-free workplace.