VP, Data Engineer

OTC Markets Group•New York, NY

2d•Hybrid

About The Position

OTC Markets Group Inc. is seeking a Data Engineer to join its IT Infrastructure team. The role builds and maintains the data ecosystem that supports analytics, insights, and organizational decision-making. It focuses on designing scalable data systems, optimizing performance, and delivering reliable, high-quality data assets. The position is based in New York City and follows a hybrid work schedule. Base compensation is up to $180,000 annually, depending on experience; the role is also eligible for a discretionary annual bonus and equity.

Requirements

At least 8 years of hands-on experience building and managing ETL/data pipelines.
At least 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/data issues.
Experience 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 with 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 in 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.