The Growth Marketing Operations Team at Apple needs to automate targeting deliverables currently using SQL queries for customer segmentation, developing targeting cohorts, and lifecycle marketing to enable on-device communications and automated messaging for Apple's media products and services.
Requirements
- High proficiency with databases and data retrieval, including Trino SQL, Snowflake, Spark and REST APIs
- Experience working with R, Python, SAS, or other statistical programming languages
- Experience building operational dashboards and automated reporting, preferably in Tableau and/or Streamlit
- Hands-on experience with at least 2 of the following statistical models/techniques: recommendation systems, neural networks, deep learning, optimization and simulation, churn models, logistic regression, linear regression, forecasting, A/B Testing, clustering and segmentation, or others
Responsibilities
- Automating targeting deliverables currently using SQL queries, for the purposes of customer segmentation, developing targeting cohorts, and lifecycle marketing.
- Create meaningful business tools and dashboards that drive business decisions across the Growth Marketing organization.
- Building and maintaining data pipelines
- Creating reports and dashboards for stakeholders
- Ensuring data integrity through processing, cleansing, and validation efforts.
- Identify operational trends to develop technical solutions
- Maintain comprehensive documentation of targeting procedures and processes.
Other
- Serve as a critical bridge between data analytics and business operations.
- Translating business requirements into actionable audience targeting strategies
- Communicate effectively with business stakeholders
- Strong communicator with both upstream and downstream stakeholders
- Ability to adapt to changes, self-driven and multitasking in very fast paced environment are key success factors for the right candidate
