Who You Are:

You apply subject matter expertise to collect, refine and model data generated throughout the product life cycle. You will be responsible for architecting data models and building data pipelines to fuel analytics teams across multiple verticals: marketing & user acquisition, marketplace shopping, and financial analytics.

What You’ll Do:

• Design and develop Data Warehouse Dimensional & Relational Models that will ultimately arm Fair with the insights to completely transform the vehicle ownership experience
• Collaborate with product managers, engineers, BI analysts, data scientists, and business stakeholders to design, implement and deliver insightful analytic solutions
• Build, test and refine data pipelines (ETL) across our analytics teams
• Automate data quality monitoring and improve auditing capabilities
• Research and promote new tools and techniques to shape the future of our data warehouse environment

What You’ll Need:

• Experience working with both schema-on write and schema-on read data warehouse technologies
• Data modeling for analytics and reporting scalability
• Experience in at least one scalable ETL & workflow management tool
• Expert understanding of SQL
• Proficiency in Python
• Excellent communication ability

Bonus Points:

• Experience with the following:
• Hive, Redshift, Treasure Data
• Airflow, Luigi
• Tableau, Looker
• AWS