As a member of the Finance Operations & Analytics team, you'll focus on implementing scalable systems and processes that provide metrics visibility for our senior leaders, enable business analysts to generate insights, and power our mission-critical reporting as a public company.

We are looking for a seasoned Data Engineer to build multiple analytics datasets for us. The successful candidate will have experience working with enterprise data warehouses, be able to ramp up quickly and adapt in new environments, and have strong critical thinking skills.

What you'll do :

• Build three detailed diagnostic datasets to allow our Business Operations partners to analyze metrics quickly and all in one place
• User Growth & Engagement Diagnostics
• User Impressions & Conversions Diagnostics
• Regional Revenue Diagnostics
• Collaborate with both central technical teams and business stakeholders to ramp quickly
• Analyze existing data sources independently in Hive using Presto/Spark SQL and be able to create design recommendations
• Build an ETL pipeline using Airflow with queries optimized for scale and large datasets

Skills

What we're looking for :

• Hands-on experience in principled data warehouse design, data visualization, and data pipeline design and development
• 4 years of hands-on experience with data platforms (Hadoop, Hive, Presto, Spark and Snowflake )
• Expert-level proficiency in writing complex, highly-optimized SQL queries across large datasets
• Experience with Airflow and associated Python data libraries (Pandas, NumPy, Matplotlib)
• Experience working with Business Teams

This is a temporary contract position at Pinterest. As such, the contractor who fills this role will be employed either by our staffing partner (PRO Unlimited) or by an agency supplier partner, and not an employee of Pinterest. All interviews will be scheduled and/or conducted by the Pinterest assignment manager. When a finalist has been selected, PRO Unlimited or the agency supplier partner will extend the offer and provide assignment details including duration, benefits options and onboarding.

Education:

Bachelors degree in Computer Science, Softare Engineering, or similar degree.

Skills

Required

• DATASETS
• HIVE
• HADOOP
• SQL QUERIES
• ETL

Additional

• PYTHON
• SQL
• METRICS
• DATA PIPELINES
• DATA SOURCES
• STAFFING
• DATA WAREHOUSES
• FINANCE
• DATA WAREHOUSE
• DATA VISUALIZATION
• BUSINESS OPERATIONS
• OPERATIONS