Job description

Equinox is seeking a Sr. Data Engineer to join our technology team. This hands-on role will build and continuously evolve the data platform, business applications, and integration tools. You will play a pivotal role in shaping our data strategy; ensuring scalability, reliability and secure solutions. The ideal candidate is going to be a hands-on engineer, with strong knowledge of AWS Products to help build out data pipelines, create jobs, manage the quality of the data warehouse and integrated tools. This is a hybrid-role located in our NYC office. You will be in office 4X a week. RESPONSIBILITIES • Design, implement, and maintain scalable data architecture, pipelines and modeling strategies that power our enterprise data warehouse on AWS • Build and manage data models and schemas in Redshift and other data technologies, enabling self-service analytics • Monitor, optimize, and troubleshoot data jobs, ensuring high availability and performance of data infrastructure • Implement data quality checks, validation rules, and alerting mechanisms to ensure trust in data • Leverage AWS services like Glue, Lambda, S3, Athena, and EMR to build modular, reusable data solutions • Partner with Data Science, Analytics, and Business teams to understand data needs, prioritize use cases, and deliver reliable datasets and models • Drive improvements in data lineage, cataloging, and documentation to ensure transparency and reusability of data assets • Create and maintain technical documentation and version-controlled workflows (e.g., Git, dbt) • Contribute to and promote a culture of continuous improvement, mentoring peers and advocating for scalable and modern data practices • Participate in sprint planning, code reviews, and team retrospectives as part of an Agile development process • Promote reusable patterns, modular designs, and automation where possible to ensure long-term scalability • Stay current on industry trends and emerging technologies to identify opportunities for innovation and automation • 6+ years of experience in software/data engineering, with a proven track record of building robust data systems (prior leadership or mentorship experience is a plus) • Expertise in designing and implementing enterprise data warehouses, including star schemas and dimensional modeling techniques • Expert in SQL, with ability to write complex queries, optimize performance, and work across large datasets; python proficiency is a strong plus • Hands-on experience with AWS data ecosystem including Redshift, S3, Glue, Athena, EMR, EC2, DynamoDB, Lambda, and Redis • Familiarity with dbt Labs and modern ELT/analytics engineering practices • Experience working with structured, semi-structured, and unstructured data • Knowledge of data governance, quality assurance, and observability tools to ensure data integrity and trust • Proficiency in creating technical documentation, SOPs, and maintaining clear communication with cross-functional teams • A problem-solving mindset, with the ability to take ownership and drive solutions from design to deployment Pay Transparency: $145k - $160k AS A MEMBER OF THE EQUINOX TEAM YOU WILL RECEIVE: • We offer competitive salary, benefits, and industry leading commission opportunities for club employees • Complimentary Club membership • Perks and incentives with our products and services including Personal Training, Pilates, Spa and Shop NOTE: This job description is intended to describe the general requirements for the position. It is not a complete statement of duties, responsibilities or requirements. Other duties not listed here may be assigned as necessary to ensure the proper operations of the department.  Equinox is an equal opportunity employer. For more information regarding our career opportunities, please visit one of our clubs or our website at  careers.equinox.com All your information will be kept confidential according to EEO guidelines. Must have a legal right to work in the United States.

Requirements

Must-haves

This is a hybrid-role located in our NYC office. You will be in office 4X a week.
Design, implement, and maintain scalable data architecture, pipelines and modeling strategies that power our enterprise data warehouse on AWS
Build and manage data models and schemas in Redshift and other data technologies, enabling self-service analytics
Monitor, optimize, and troubleshoot data jobs, ensuring high availability and performance of data infrastructure
Implement data quality checks, validation rules, and alerting mechanisms to ensure trust in data
Leverage AWS services like Glue, Lambda, S3, Athena, and EMR to build modular, reusable data solutions
Partner with Data Science, Analytics, and Business teams to understand data needs, prioritize use cases, and deliver reliable datasets and models
Drive improvements in data lineage, cataloging, and documentation to ensure transparency and reusability of data assets
Create and maintain technical documentation and version-controlled workflows (e.g., Git, dbt)
Contribute to and promote a culture of continuous improvement, mentoring peers and advocating for scalable and modern data practices
Participate in sprint planning, code reviews, and team retrospectives as part of an Agile development process
Promote reusable patterns, modular designs, and automation where possible to ensure long-term scalability
Stay current on industry trends and emerging technologies to identify opportunities for innovation and automation
Expertise in designing and implementing enterprise data warehouses, including star schemas and dimensional modeling techniques
Expert in SQL, with ability to write complex queries, optimize performance, and work across large datasets; python proficiency is a strong plus
Hands-on experience with AWS data ecosystem including Redshift, S3, Glue, Athena, EMR, EC2, DynamoDB, Lambda, and Redis
Familiarity with dbt Labs and modern ELT/analytics engineering practices
Experience working with structured, semi-structured, and unstructured data
Knowledge of data governance, quality assurance, and observability tools to ensure data integrity and trust
Proficiency in creating technical documentation, SOPs, and maintaining clear communication with cross-functional teams
A problem-solving mindset, with the ability to take ownership and drive solutions from design to deployment
Pay Transparency: $145k - $160k
AS A MEMBER OF THE EQUINOX TEAM YOU WILL RECEIVE:

Nice-to-haves

6+ years of experience in software/data engineering, with a proven track record of building robust data systems (prior leadership or mentorship experience is a plus)

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

awsagilesqlpython

Platform: smartrecruiters
Effort: medium