Varsity Tutors is looking for a Senior Data Engineer for our Data/Platform team. As part of the data team they will be responsible for creating and maintaining: fact_tables, ETLs, data pipelines from 3rd parties. As well as collaborating with Developers, Business Intelligence, and Data Science teams for reporting needs, accuracy, optimizations, and warehousing. They will assist with DBA duties and provide guidance and recommendations to other teams. Collaboration with Infra for Disaster Recovery, scaling, replication, and availability. 

Will work to maintain our existing technologies while also working towards future goals of improvements.

This position is a full-time remote opportunity!

Who you are:

Note: There is no such thing as a “perfect” candidate, even if you don’t meet all the requirements for the position, you should apply. Everyone can grow at Varsity Tutors.  We strongly encourage members of underrepresented groups and people of diverse backgrounds to apply. Apply now if this is a role that would make you excited to come into work every day! 

Your customers are other engineering teams, your toolchain encompasses the right tool for the job, and you know tough challenges can create innovative ideas. 

In this position, you will…

• Architect and administer replication between heterogeneous databases
• Advise on transactional database design for live systems
• Plan for high availability, disaster recovery, and efficient cluster sizing
• Administer our MySQL and PostgreSQL relational databases in AWS RDS
• Administer our AWS DynamoDB tables
• Administer our Redshift based data warehouse
• Manage and automate secure access to databases for humans and systems
• Build reporting tables in Redshift
• Build data eventing streams and ingestion pipelines
• Optimize tables, indexes, and queries 
• Monitor scheduled data batch jobs
• Automate database configuration using infrastructure as code

Qualifications: 

Required Skills

• Logical and physical database modeling
• Relational DBMS : MySQL/MS Sql/Oracle/PostgreSQL
• SQL query design, optimization
• Redshift, Snowflake or equivalent
• Source code management: git/scm/mercurial/subversion
• Configuration: Terraform, CloudFormation, Puppet, Chef, or Ansible

Nice to have

• NoSql: DynamoDb, MongoDb, Cassandra, Redis, HBase, or Cosmos
• Big Data: BigQuery/Hadoop/Spark/Presto
• Tiered data storage design
• Eventing: Kafka, SQS, RabbitMQ
• Programming languages: Python/Go/Ruby/Java
• Understanding of how different ORMs convert code into SQL
• Containerization: Docker or Vagrant
• AWS Services: RDS, Lambda, Kinesis, DMS, Batch
• AWS IAM expertise

What We Offer:

• Opportunity to help revolutionize how the world learns

• Collaborative team-oriented work environment with a feedback rich culture

• Remote First Culture

• Hackfest!

• Work-life balance

• Competitive Salary plus Equity (RSUs)

• Healthcare Plans (Medical, Dental, Vision, Life)

• 401k Company Matching Plan

• Flexible PTO plus a floating holiday (for your birthday!)

• Paid VTO ("Volunteer Time Off" to do community service/charity work)

• 52 hours of Free Learning Sessions per year for you or immediate families members and free access to our Virtual School Day classes and School@Home program

Varsity Tutors is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

About Nerdy

Nerdy (NYSE: NRDY), the parent company of Varsity Tutors, is a leading platform for live online learning, with a mission to transform the way people learn through technology. The Company’s purpose-built proprietary platform leverages technology, including AI, to connect learners of all ages to experts, delivering superior value on both sides of the network. Nerdy’s comprehensive learning destination provides learning experiences across 3,000+ subjects and multiple formats—including one-on-one instruction, small group classes, large format group classes, and adaptive self-study. Nerdy’s flagship business, Varsity Tutors, is one of the nation’s largest platforms for live online tutoring and classes. Its solutions are available directly to students and consumers, as well as through schools and other institutions. Learn more about Nerdy at https://www.nerdy.com/. The company publicly listed on the New York Stock Exchange on September 21, 2021.

We succeed thanks to a diverse mix of talented people who want to come, to stay, and do their best work. If you love learning, technology, and making a true impact, you’re going to love working here!