Data Warehouse Engineer

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.

Pay & Benefits

• At Apple, base pay is one part of our total compensation package and is determined within a range. This provides the opportunity to progress as you grow and develop within a role. The base pay range for this role is between $138,900.00 and $256,500.00, and your base pay will depend on your skills, qualifications, experience, and location.Apple employees also have the opportunity to become an Apple shareholder through participation in Apple's discretionary employee stock programs. Apple employees are eligible for discretionary restricted stock unit awards, and can purchase Apple stock at a discount if voluntarily participating in Apple's Employee Stock Purchase Plan. You'll also receive benefits including: Comprehensive medical and dental coverage, retirement benefits, a range of discounted products and free services, and for formal education related to advancing your career at Apple, reimbursement for certain educational expenses - including tuition. Additionally, this role might be eligible for discretionary bonuses or commission payments as well as relocation.Learn more (~~~) about Apple Benefits.Note: Apple benefit, compensation and employee stock programs are subject to eligibility requirements and other terms of the applicable plan or program.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 Footer

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 (Opens in a new window) .

Apple will not discriminate or retaliate against applicants who inquire about,disclose,or discuss their compensation or that of other applicants. United States Department of Labor. Learn more (Opens in a new window) .

Apple will consider for employment all qualified applicants with criminal histories in a manner consistent with applicable law. If you're applying for a position in San Francisco,review the San Francisco Fair Chance Ordinance guidelines (opens in a new window) applicable in your area.

Apple participates in the E-Verify program in certain locations as required by law. Learn more about the E-Verify program (Opens in a new window) .

Apple is committed to working with and providing reasonable accommodation to applicants with physical and mental disabilities. Apple is a drug-free workplace. Reasonable Accommodation and Drug Free Workplace policy Learn more (Opens in a new window) .