Senior Data Engineer
New York, NY

Job Description

About Aaptiv

Aaptiv is a pioneer in the digital health space that helps its members live a healthier life by giving them access to the best workout experience anytime, anywhere. Through its use of humanized technology, Aaptiv removes the barriers many face when trying to make fitness a priority.

Launched in 2016, Aaptiv has garnered nearly a quarter million members and has raised over $55M from leading venture capital firms and top companies, including the Amazon Alexa Fund and Disney.

Want to join our team? We're looking for people who are passionate about continuing to improve the Aaptiv experience that our members around the world have come to love.

About the role

We're looking for a Senior Data Engineer to help us design data access patterns, optimize integrations, and solve data problems. At Aaptiv, we thrive on building data driven solutions to help our members find workouts that best fit their lifestyles to pursue their wellness goals.

In this role, you'll be working with a team of Data Engineers tasked with data integrations, explorations and enabling stakeholders to find actionable data in a timely manner. You will spend the majority of your time working in the code, whether that's building new data pipelines, pairing with team members or reviewing pull requests. The remaining time will be spent mentoring other Software Engineers to apply best practices in schema design, optimize data access patterns, and enforce data standards. You'll coordinate and execute online schema changes, debug production issues and perform root cause analysis should things not work as expected.

In addition, you will work collaboratively with other data engineers, cross functional teams, analysts and stakeholders, and your input will have a large impact on how our product is built. Last but not least, you will ensure the team is delivering high quality code, streamline deployment process and respond to incidents as appropriate.

What You'll Do

* Provide technical guidance in designing data warehouse architecture, schemas and data pipelines that accurately represent our business model, and store data efficiently to enable fast application access and easy reporting.
* Enforce data precision through data guidelines and supporting software engineers in writing software that accesses and stores data in a way that's accurate and performant.
* Coordinate with software engineers to deploy online schema changes with minimal customer impact.
* Work closely with product managers, other data engineers and analysts to identify data gaps, brainstorm ideas, break down projects and estimate how long they will take.
* Be part of a team that's responsible for developing all data products, ensuring we are shipping only high quality code that's tested thoroughly and monitored appropriately.
* Be a champion of engineering best practices within your team. We want to build high-quality software that's easy to understand, easy to change and works the way it's supposed to.

Who You Are

* 6+ years of software engineering experience (with at least 3 of those years focused on data engineering.)
* You've designed and ran data warehouses in a production environment previously.
* You've previously held a more senior engineering position for longer than a year.
* You've developed best practices around ensuring data integrity.
* You value a collaborative environment where you'll work closely with the rest of engineering.
* You've leveraged toolkits to perform ETLs between data sources and data warehouses.
* You keep up to date with advances in data solutions and selectively choose new tools and approaches when appropriate to be more effective.
* Expert in data modeling.
* Strong Python programming skills
* Experience managing OLTP and OLAP data.
* Experience with both SQL and NoSQL datastores.
* Experience with Looker or Snowflake is a plus.
* Experience using AWS (RDS, EC2, Data Pipeline, Lambda) is a plus.



Not only will the work you do at Aaptiv be meaningful and rewarding, but you'll get to do it in a fun environment alongside a diverse group of friendly, talented people. In order to hire the best, we offer competitive salaries and equity, great benefits, and lots of perks, including catered breakfasts and lunches, unlimited vacation, and unbelievable views of New York City from our office at One World Trade Center.

It is the policy of Aaptiv to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, Aaptiv will provide reasonable accommodations for qualified individuals with disabilities.