VP, Data Engineer
About The Position
OTC Markets Group Inc. is seeking a Data Engineer to join its IT Infrastructure team and help build and maintain the company’s data ecosystem. The role focuses on creating scalable data systems and reliable, high-quality data assets that support analytics, insights, and informed decision-making across the organization. The position works with data warehouses and data lakes, integrating and transforming data from multiple platforms while ensuring performance, quality, and integrity. The role includes participation in a weekly on-call rotation for production ETL support and collaboration with technical and non-technical teams. The position is based in New York City and offers a hybrid work schedule. Base compensation is up to $180,000 annually, depending on experience, with eligibility for a discretionary annual bonus and equity.
Requirements
- 8+ years of hands-on experience building and managing ETL or data pipelines.
- 8+ years of experience with one or more relational databases: Informix, SQL Server, PostgreSQL, or MySQL.
- Expertise in database schema design, table partitioning, and indexing strategies.
- Demonstrated experience developing SQL stored procedures and tuning SQL query performance.
- Hands-on experience with Linux and shell scripting.
- Experience providing urgent production support and analyzing, troubleshooting, and resolving ETL or data issues.
- Experience working with AI coding assistant tools and source code management tools such as GIT.
- Working knowledge of AWS services such as RDS, Athena, S3, and Glue.
- Excellent communication skills and ability to collaborate across technical and non-technical teams.
- Bachelor’s degree in computer science or a related field and/or relevant certifications.
Nice To Haves
- Familiarity with columnar databases.
Responsibilities
- Design, build, and optimize scalable ETL pipelines that move data from operational systems into data warehouse and data lake environments.
- Integrate data from multiple platforms and perform complex transformations, aggregations, and calculations.
- Design and implement data models, schemas, tables, views, indexes, and stored procedures.
- Embed validation and monitoring into pipelines to ensure data integrity, quality, and consistency.
- Tune and optimize SQL stored procedures and queries for performance and efficiency.
- Troubleshoot and resolve production ETL issues as part of a weekly on-call rotation.
- Partner with cross-functional teams to translate business needs into reliable, high-performing data solutions.
- Perform additional responsibilities as assigned.
Benefits
- Generous paid time off (PTO).
- Health, dental, and vision coverage.
- Health Savings Account (HSA).
- Dependent and healthcare Flexible Spending Accounts (FSA).
- Limited Purpose Flexible Spending Account (LPFSA).
- Paid parental leave program.
- Discretionary annual bonus program.
- Stock incentive program and equity.
- 401(k) plan.
- Commuter transit and parking program.
- Life insurance and short- and long-term disability coverage.
- Voluntary accident, critical illness, and hospital indemnity benefits.
- Hybrid work schedule.
- ClassPass partnership for fitness and wellness programs.
- Citi Bike membership program.
- Office breakfasts, lunches, snacks, and beverages.
- Monthly birthday celebrations.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
