Snowflake Data Engineer - Ads

About the role

Every solution we build is rooted in trust, connection, and impact: respecting user privacy, integrating advertising seamlessly into the Apple experience, and delivering value for advertisers of every size—from small app developers to global brands. When advertising is done right, it benefits everyone.

What you'll do

• Administer Snowflake accounts, virtual warehouses, and database objects — including configuring auto-scaling, monitoring warehouse utilization
• Manage the full lifecycle of database objects, roles, and account-level parameters across development, staging, and production environments
• Proactively monitor and tune workloads using Snowsight Performance Explorer and the Account Usage schemas
• Optimize query execution by analyzing query profiles for disk spillage, identifying Cartesian joins
• Implement autonomous warehouse management by right-sizing clusters based on real-time usage patterns

What you need

• 5–8 yrs of experience
• Snowflake
• Python
• SQL
• AWS
• Data warehousing
• Redshift
• Any graduate

Good to have

• IAM
• LLMs
• Prompt engineering
• ETL
• dbt
• Airflow