OTC Markets Group Inc. VP, Data Engineer OTC Markets Group - New York City - Full Time
OTC Markets Group Inc., operator of premier US financial marketplaces, is seeking a Data Engineer to join our IT Infrastructure team. We're looking for a talented and driven Data Engineer to help power our data ecosystem. In this role, you won't just maintain pipelines - you'll build the foundation that enables analytics, insights, and informed decision-making across the organization. If you're passionate about designing scalable data systems, optimizing performance, and turning complex data into reliable, high-quality assets, we'd love to talk to you.
Base compensation for this role is up to $180,000.00 annually, depending on experience.In addition, the position is eligible for our discretionary annual bonus program and equity.
What You'll Do:
Design, build, and optimize scalable ETL pipelines that move data from operational systems into our data warehouse and data lake environments
Integrate data from multiple platforms and perform complex transformations, aggregations, and calculations
Design and implement robust data models, schema, tables, views, indexes, and stored procedures
Ensure data integrity, quality, and consistency by embedding validation and monitoring into pipelines
Tune and optimize SQL stored procedures & queries to maximize 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
Additional responsibilities, as assigned.
What We're Looking For:
8+ years of hands-on experience building and managing ETL/data pipelines
8+ years of strong experience with relational databases (1 or more of: Informix, SQL Server, PostgreSQL, MySQL)
Expertise in database schema design, table partitioning and indexing strategies
Demonstrated experience in SQL stored procedure development, and SQL query performance tuning
Hands-on experience with Linux and shell scripting
Experienced in providing urgent production support, analyzing, troubleshooting and resolving ETL/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
Familiarity with columnar databases
Excellent communication skills and the ability to collaborate across technical and non-technical teams
Bachelor's degree in computer science (or related field) and/or relevant certifications
What OTC Markets Offers its Team Members (Why You Should Choose Us):
