Data Engineering Intern

Apollo is building out a data lake using an already-established medallion architecture (Bronze / Silver / Gold), and expanding it as we bring on new clients and migrate existing ones. A large part of this work is moving business logic out of Tableau workbooks and into a centralized, documented Gold layer. We're looking for a Data Engineering Intern to support that effort. You'll work alongside our data engineering team on pipeline development, SQL implementation, and — importantly — the discovery work that has to happen before anything gets migrated: figuring out how a report actually calculates a number today, writing an equivalent SQL definition, and documenting it so it can be validated and standardized. This is a hands-on role. You won't be setting technical direction, but you will be doing real work that ships, with your output reviewed by senior engineers before it reaches clients. **Overview** Location: On-site/remote (White Plains, NY) Type: Part-time (20 hours per week) Compensation: $2500 monthly **Responsibilities** * Reverse-engineer existing Tableau reports to identify how metrics are calculated — calculated fields, LOD expressions, filters, and context filters * Contribute to on external data imports as part of client management & onboarding * Write SQL implementations of those metrics and compare outputs against Tableau to confirm they match * Document metric definitions using our standard templates so report owners can confirm or correct proposed logic * Write and optimize complex SQL queries against large datasets; Write and test SQL queries against Gold layer views and tables * Build web scraping tools to source external data as needed * Support ETL pipeline development in Python under the direction of the data engineering team; Help maintain extraction and metadata tooling used across client environments **Requirements** * Currently pursuing a degree in Computer Science, Data Science, Information Systems, Statistics, or a related field * Working SQL knowledge, including joins, aggregations, and window functions * Python experience, including familiarity with pandas * Comfort reading and reasoning about code or data structures you didn't write * Attention to detail — much of this work is confirming that two implementations produce identical results * Ability to communicate clearly in writing, including with non-technical stakeholders * Able to work 20 hours per week **Nice to Have** * Exposure to Tableau or Power BI, whether as a builder or a user * Familiarity with cloud data platforms, ideally Azure Synapse or Azure Data Lake * Experience with Git / Github * Coursework or projects involving ETL or data pipelines * 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 [email protected]. 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. Pay: $2,500.00 per month Work Location: Hybrid remote in White Plains, NY 10601