Job Location: New York, NY
Summary
Posted: Aug 25, 2022
Role Number:200418396
At Apple, we work every day to build products that enrich peopleโs lives. Our Advertising Platforms group makes it possible for people around the world to easily access informative and creative 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 Senior Data Warehouse Engineer specializing in building high performance data stores to enable next gen 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, implementation and delivery of Enterprise Data Warehouse Architecture supporting our suite of customer experiences in addition to scheduled and ad hoc reporting. 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 running cloud based data warehouse platforms. Working with multiple data storage and analysis toolsetsโincluding current distributed technologies such as Snowflake, SparkSQL, Presto, Hive, Kafka, or Verticaโis a plus.
Key Qualifications
- Background in computer science, mathematics, or similar quantitative field with a minimum of 5 years professional experience building, deploying, and maintaining complex Cloud Data Architectures
- Expertise in building Cloud Data Warehouses in Snowflake, Redshift, BigQuery or analogous architectures
- Deep SQL expertise, data modeling, and experience with data governance in relational databases
- Experience with the practical application of data warehousing concepts, methodologies, and frameworks using traditional (Vertica, Teradata, etc.) and current (SparkSQL, Hadoop, Kafka) distributed technologies
- Refined skills using one or more scripting languages (e.g., Python, bash, etc.)
- Experience using ETL/ELT tools and technologies such as Talend, Informatica, SSIS or DBT a plus
- Embrace data platform thinking, design and develop data pipelines keeping security, scale, uptime and reliability in mind
- Expertise in relational and dimensional data modeling
- UNIX admin and general server administration experience required
- Presto, Hive, SparkSQL, Cassandra, or Solr other Big Data query and transformation experience a plus
- Experience using Spark, Kafka, Hadoop, or similar distributed data technologies a plus
- Able to expertly express the benefits and constraints of technology solutions to technology partners, business partners, and team members
- Most importantly, a sense of humor and an eagerness to learn
Description
Understand our current data model and infrastructure, proactively identify gaps, areas for improvement, and prescribe architectural recommendations with a focus on performance and accessibility. Define and design logical and dimensional data models. Partner across engineering teams to design, build, and support the next generation of our analytics and reporting systems. Partner with business and analytics teams to understand specific requirements for data systems to support both development and deployment of data workloads ranging from Tableau reports to ad hoc analyses. Own and develop architecture supporting the translation of 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 while maintaining a proactive approach to assure solutions demonstrate high levels of performance, privacy, security, scalability, and reliability upon deployment Provide guidance to partners on effective use of the data warehouse platform through collaboration, documentation, and associated standard methodologies. Work in progressive environment and perform effectively in a sprint based agile development environment.
Education & Experience
Apple is an Equal Opportunity Employer that is committed to inclusion and diversity.
Additional Requirements
Submit CV To All Data Science Job Consultants Across United States For Free
๐ Explore All Related ITSM Jobs Below! ๐
โ
Select your preferred “Job Category” in the Job Category Filter ๐ฏ
๐ Hit “Search” to find matching jobs ๐ฅ
โ Click the “+” icon that appears just before the company name to see the Job Detail & Apply Link ๐๐ผ

Leave a Reply