Analytics Engineer

| Greater NYC Area

About Us 

 
At Teachers Pay Teachers (TpT), we're unlocking the power of educator-created content. More than 3 out of 4 teachers in the U.S., Canada, and Australia come to TpT every year to get teacher-tested, engaging, and rigorous materials. What began as a humble exchange for teachers looking to share lesson plans has since exploded into a massive online marketplace where teachers have created 4 million resources for all aspects of PreK-12 education. More than six million educators worldwide (including teachers, administrators, and parents) have downloaded TpT resources more than a billion times. According to Fast Company, Teachers Pay Teachers is one of the top 50 Most Innovative Companies in the world! If you haven't heard of TpT yet and want to learn more, just ask a teacher.

Who we are looking for

We’re a team of good people doing great things. We listen first. We love our work. And we are all teachers and learners in whatever we do. We believe that productivity is never an accident. It’s the result of a commitment to excellence, intelligent planning, passionate teamwork, and focused effort. We want every day to be fun and to matter.

Role

As an Analytics Engineer at TpT you will be working with other members of the Data Engineering team, the Analytics team, and business teams including Product, Marketing, and Finance to ensure that everyone at TpT has access to clean, reliable, understandable, curated data. You’ll help to build and improve our Data Warehouse and Business Intelligence systems, using your ability to think systematically, abstractly, and empathetically. 

Qualities for a successful candidate

  • Intermediate to Advanced SQL skills, including windowing functions, nested queries, regular expressions, and a solid understanding of how relational databases work.
  • At least one year of industry experience working with business data.
  • Experience with creating reports and data visualizations in a Business Intelligence tool (e.g., Looker, Tableau).
  • Some programming experience in any language.
  • Comfortable working in a product and business-driven, fast-paced, dynamic environment.
  • Enjoys working collaboratively with peers across business and engineering teams.
  • Outstanding communications skills, including the ability to speak clearly to technical and nontechnical audiences and to write clearly.

Extra Credit for

  • Experience with data warehouse development, including dimensional modeling.
  • Experience with Ed-Tech or online marketplaces.
  • Experience as a Business Analyst.
  • Experience with the primary tools we use: BigQuery, dbt, Looker (LookML).
  • Experience with the tools and processes of software development, including git/GitHub, the command line, and text editors.
  • Relevant education, such as a degree or substantial coursework in an IT field such as Computer Science, or Library and Information Science.
Read Full Job Description

Technology we use

  • Engineering
    • JavascriptLanguages
    • ElixirLanguages
    • ReactLibraries
    • Node.jsFrameworks

Location

111 E 18th St, New York, NY 10016

An Insider's view of Teachers Pay Teachers

What are some social events your company does?

Every month a different team in the office will host a Teacher's Lounge. These can be anything ranging from a pumpkin-carving contest, to Office Olympics, where teams of TpT-er's represented a variety of different countries to compete for Office Olympic gold.

Emily

Technical Recruiter

What projects are you most excited about?

My team works on the cloud infrastructure that we run all of our applications on, and we’re excited about creating pre-production environments for every pull request a developer opens. Using Kubernetes, we'd create temporary environments that mimic production but are isolated for testing purposes. This empowers our team to build with confidence.

Lucas Chi

Engineering Manager

What are some things you learned at the company?

One of our company values is “We Learn and Grow Together”. The first few members of the Schools team started right around the same time, so we really had to embody that value! We were building a new set of features and got to make a lot of decisions. Looking back at the code we were writing when I started at TpT, we’ve definitely learned a lot.

Julia Sterling

Software Engineer

What are Teachers Pay Teachers Perks + Benefits

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Child Care & Parental Leave Benefits
Generous Parental Leave
Family Medical Leave
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Game Room
Stocked Kitchen
Some Meals Provided
Happy Hours
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Diversity Program
More Jobs at Teachers Pay Teachers13 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
HR
Marketing
Content
Marketing
new
New York
Data + Analytics
new
New York
Marketing
new
New York
Content
new
New York
Developer
new
New York
Developer
new
New York
Developer
new
New York
Marketing
new
New York
Data + Analytics
new
New York
Finance
new
New York