ETL Developer

Why Treehouse Needs You

As our ETL Developer, you’ll be joining a tiny but mighty team that provides the reporting, analytics, dashboards, and modeling that support informed decision-making across Treehouse. We need you to give some “TLC” to our data warehouse, which has not kept pace with the evolution of our product and schema. Your work crafting new ETLs, repairing outdated ones, and patching data will strengthen our reporting foundation, keep data analysis humming, and heighten the quality of business and product decisions across the company.

Why You Need Treehouse

The ETL Developer role is an opportunity to apply your experience, knowledge of industry best practices, and data skills in maturing our ETLs, data pipelines, and data quality at Treehouse. Your work will be highly valued by your teammates and other coworkers, and you’ll have the camaraderie and flexibility of a remote team, support for your continuing education and career development, and the satisfaction of contributing to Treehouse’s mission of bringing affordable technology education to people everywhere.

Who You Are

• You have expert SQL skills, including the ability to craft and tune complex SQL code
• You’ve spent at least two years developing or maintaining ETLs
• You‘re deeply familiar with relational databases and data warehousing
• You keep up to date with best practices in your field
• You’re familiar with Python or other programming languages
• You’re detail-oriented and fearless in the face of complexity
• You’re analytical and enjoy debugging and solving a thorny issue
• You have a knack for clear documentation and the discipline to do it
• You care about accuracy and reliability and like to find ways to improve things
• You work well independently and have keen time-management skills
• You communicate with ease and thrive in a collaborative, supportive team environment

Bonus Points For

(If you’re interested, please apply even if you don’t bring the experience below. These items aren’t so much about success in the role as they are about shortening your learning curve on arrival.)

• Experience working in a SaaS organization
• Experience deriving metrics or KPIs for business or product intelligence
• Experience working on a cross-functional team
• Advanced Python skills
• Experience working remotely
• Experience reading Ruby on Rails code
• Experience using Github or other version control system
• Experience with some of the Treehouse data stack, such as Fivetran, AWS S3, Luigi, Snowflake, Segment, Mode Analytics, and/or Tableau
• Experience with some of the Treehouse data sources such as Eloqua, Salesforce, Google Analytics, Mailchimp, Intercom, Optimizely, HotJar, and/or HelpScout
• Familiarity with GDPR requirements

In addition to joining a fun and innovative company and working in a team-centered, flexible workplace, you’ll enjoy the following:

• Healthcare: Full coverage for medical, dental, and vision insurance for you and your family
• PTO: 3+ weeks PTO, federal holidays, and 1 week off in late December
• Retirement: 401(k) contribution match - Dollar-for-dollar up to 6% of your salary
• Continued Learning: $1,500 annual education budget (conferences, books, classes, etc.)
• Friends & Family: Share Treehouse learning with the ones you love ($1,000 annual value)
• Paid parental leave
• Wellness Allowance

Treehouse is an online technology school that has taught coding skills to over 850,000 students. Our mission is to bring affordable technology education to people everywhere in order to help them achieve their dreams and change the world. We transform normal folks into great developers and designers, and then we help companies hire them successfully.

We believe in fostering an equitable, diverse, and inclusive workplace, and we’re proud to serve students of all colors, ages, genders, and sexual orientations. Our goal is to have the diversity of our team match the diversity of this country.