Reporting Data Engineer

With Apple in Austin TX US

More jobs from Apple

Posted on November 27, 2019

About this job

Job type: Full-time
Role: System Administrator


hadoop, sysadmin, bigdata

Job description

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 data engineer specializing in reporting to support 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. A successful candidate will have experience building data aggregations, Tableau dashboards, and administering Tableau Server. Working with multiple data storage and analysis toolsets, including modern distributed technologies such as SparkSQL, Presto, Hive, Kafka, Vertica, and Druid.

  • 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 to design, build, and support the 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 - Solid grasp 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

Skills & requirements

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

BS or MS Computer Science, Mathematics, or similar quantitative field

Apply here