Data Analyst/Business Intelligence Engineer
Santa Clara Valley, CA
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 App Store. Our platforms are highly-performant, deployed at scale, and setting new standards for enabling effective advertising while protecting user privacy.
To support our advertising products we are looking for a big data reporting and analytics engineer to focus on new initiatives while working with complex multi-dimensional data sets.
8+ years designing data warehousing solutions.
Excellent knowledge in tableau dashboard design and visualization.
Experience with Hadoop, Hive is a must.
Expertise in writing optimized SQL for Oracle and Hive SQL
Strong knowledge of database concepts, systems architecture, and data structures is a must.
Good understanding of Tableau server architecture.
Extensive hands-on experience with Unix.
Process oriented with strong analytical and problem solving skills.
Strong interpersonal, written, and verbal communication skills, as well as strong presentation skills
Work independently with minimal supervision.
Knowledge of advertising industry is a plus
Knowledge of data science in an analytical context is a plus
As a member of the Data Engineering team you will be working as a liaison between engineering and business operations teams in meeting data reporting and analytical needs. In this role you will be responsible for creating Tableau dashboards to provide insights, writing SQL scripts to pull data from Hive, Presto and Oracle. Use your expertise in business analysis and the presentation of data to see beyond the numbers to develop a deep understanding of your area of responsibility and how it connects with the business as a whole. You will also be responsible for administering and trouble shooting Tableau server infrastructure to support business users.
BS/MS in computer science or an equivalent field with 8+ years relevant experience.