Ad Platforms: Analytics Engineer

Summary

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 Insights team is seeking a Reporting Data Engineer supporting the development of next generation of 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 analytics infrastructure and processes. You will be a key enabler for teams of analysts, data scientists, and business users. Successful candidates will have experience building data aggregations, Tableau dashboards, and developing automation pipelines and ETLs. In addition, the ideal candidate will have hands-on experience working with multiple data storage and analysis toolsets—including modern distributed technologies such as SparkSQL, Presto, Hive, Kafka, Redshift, and Snowflake—is a plus.

Key Qualifications

Background in computer science, mathematics, or similar quantitative field with a minimum of 3 years professional experience
Experience working with business users and translating their needs into technical solutions and the ability to communicate technical concepts to a business-focused audience
UNIX admin and general server administration experience required
Tableau Desktop/Server development and administration
Experience with the practical application of data warehousing concepts, methodologies, and frameworks using traditional (Vertica, Teradata, etc.) and modern (SparkSQL, Hadoop, Kafka) distributed technologies
Advanced skills using one or more scripting languages (e.g., Python, bash, etc.)
SQL expertise, data modeling, and relational database experience
Hive, SparkSQL, Cassandra, Snowflake and Redshift experience a plus
Experience using Spark, Kafka, Hadoop, or similar distributed data technologies a plus
Most importantly, a sense of humor and an eagerness to learn

Description

Collaborate with leads on developing and executing on the Analytics Tooling road map. This entails defining policies operational standards, and predictable upgrade cadences in support of the Analytics community at Ad Platforms.
Partner with business and analytics teams to understand specific requirements for data systems to support both development and deployment of data workloads.
Partner with engineering teams to design, build, and support the next generation of analytics and reporting systems
Own and develop solutions that translate analytical questions into effective reports that drive business action.
Automate and optimize existing data processing workloads by recognizing patterns of data and technology usage and implementing solutions.
Strong understanding of the intersection between analytics and engineering and a proactive approach, focusing on reusable solutions to improve efficiency and time to insight.
Advise partners on effective use of Tableau and other data technologies based on business and technology needs.
Must be able to work in a rapidly changing environment and perform effectively in a sprint based agile development environment.
Must be comfortable working as part of a distributed team

‌