Engineer - Full Stack

Apollo's core athlete management system is used daily by coaches, practitioners, and athletes, and keeping it fast, stable, and reliable is critical to how our clients work. We're looking for a Fullstack Engineer to join our staff and take ownership of maintaining and improving that system — working across our .NET Core backend and Angular frontend to debug issues, ship fixes, and keep the platform running smoothly in production.

This is not a new-product-development role. We're looking for someone who's energized by working inside an existing, real-world tech stack: improving performance, creating new tests, making the system as easy to use as possible, both internally and externally, and handling deployments with care. If you like understanding how a live system actually behaves and making it better rather than starting from a blank slate, this role is built for you.

Overview

Location: On-site (White Plains, NY)

Type: Full-time

Compensation: $80,000 - $90,000

Responsibilities
  • Lead the data lake build-out and expansion using our existing medallion architecture, onboarding both new and existing clients
  • Own external data imports as part of client onboarding
  • Lead all API-based data imports, ensuring API data is imported directly into the data lake rather than the transactional database
  • Design, build, and maintain ETL pipelines using Python
  • Write and optimize complex SQL queries against large datasets
  • Build web scraping tools to source external data as needed
  • Set technical direction and best practices for the team's data engineering work

Requirements

  • Experience with Azure Synapse (data lake)
  • Experience with Azure Data Lake Studio
  • Professional SQL experience, preferablyin a leadership role
  • Python experience, preferrably in production
  • Experience building and maintaining ETL pipelines
  • ETL experience using Python
  • Web scraping experience
  • Comfort owning deployments, not just writing code
  • Experience with Git/GitHub, Docker, or model deployment tools
  • Ability to clearly communicate insights to both technical and non-technical stakeholders
  • Ability to work independently and collaboratively in a fast-paced environment
  • Able to work 40 hours per week, in-office

Nice to Have

  • Experience with PySpark
  • Experience with Kafka
  • Experience with Flink
  • Microsoft 365 experience

Our Evaluation Method

    ‍

    Our process includes a practical component — we're interested in how quickly you can get up to speed on an existing database/data lake architecture, and we'll ask you to work through some complex SQL queries.

    Please submit your resume and a cover letter to info@apollov2.com.

    ApolloV2 is an equal opportunity employer with a commitment to hiring people with diverse backgrounds. We do not discriminate based on age, civil or family status, disability, ethnicity, gender, race, religion, or sexual orientation.