Equinox is seeking to build and evolve its data platform, business applications, and integration tools to support its business needs.
Requirements
- Advanced Python, including experience building APIs, scripting ETL processes, and automating workflows
- Expert in SQL, with ability to write complex queries, optimize performance, and work across large datasets
- Hands-on experience with AWS data ecosystem including Redshift, S3, Glue, Athena, EMR, EC2, DynamoDB, Lambda, and Redis
- Strong understanding of data warehousing and data modeling principles (e.g., star/snowflake schema, dimensional modeling)
- 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
Responsibilities
- Design, develop, and maintain scalable, efficient data pipelines to support ETL/ELT processes across multiple sources and systems
- Monitor, optimize, and troubleshoot data jobs, ensuring high availability and performance of data infrastructure
- Build and manage data models and schemas in Redshift and other data technologies, enabling self-service analytics
- 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
- Create and maintain technical documentation and version-controlled workflows (e.g., Git, dbt)
- Participate in sprint planning, code reviews, and team retrospectives as part of an Agile development process
Other
- 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)
- A problem-solving mindset, with the ability to take ownership and drive solutions from design to deployment
- Proficiency in creating technical documentation, SOPs, and maintaining clear communication with cross-functional teams
- Must have a legal right to work in the United States
- Must be local to the NYC metro area
