AVP, Data Analyst

AVP, Data Analyst
OTC Markets Group - New York, NY - Full Time

OTC Markets Group Inc., operator of premier US financial marketplaces, is seeking an AVP,  Data Analyst to join our IT Infrastructure team. We’re seeking a Data Analyst who loves diving deep into data, crafting meaningful dashboards, and optimizing SQL like a pro. In this role, you won’t just build reports — you’ll shape how the business thinks, plans, and grows. If you're passionate about solving complex problems and building analytical solutions that drive real business decisions, then we’re looking for you.

We invest heavily in employee satisfaction and offer all our employees a highly competitive compensation package. As a dynamic, growing company that fosters an open culture, we emphasize autonomy, responsibility, innovation, and self-discipline. We are looking for someone who wants to make an impressive impact at a company known for its reputation on quality and achievement.

Base compensation for this role is up to $100,000.00 annually, depending on experience. In addition, the position is eligible for our discretionary annual bonus and equity program .

What You’ll Do:

• Explore, analyze, and document structured and unstructured data across multiple systems
• Build effective BI dashboards, reports, and automated data feeds that empower decision-makers
• Develop and optimize advanced SQL queries, stored procedures, and functions using (Window functions, CTE, Joins & Pivots)
• Improve performance through query tuning and database optimization
• Investigate and resolve data quality issues to ensure accuracy and reliability
• Partner closely with business stakeholders to translate requirements into actionable insights
• Deliver analytics that directly influence strategy and operational excellence
• Additional responsibilities, as assigned.

What We’re Looking For:

• 4+ years of experience working with relational databases (one or more of the following: Informix, SQL Server, PostgreSQL, MySQL)
• 4+ years of experience with BI tools (one or more of the following: Jasper, AWS Quick Sight, Tableau, Power BI)
• Strong experience in SQL query development and tuning
• Hands-on experience with shell/python scripting and source code management tools such as GIT
• Experience working with AI tools
• Working knowledge of AWS services (RDS, Athena, S3)
• Familiarity with columnar databases
• Excellent communication and interpersonal skills
• Bachelor’s degree in computer science and / or appropriate certifications

What OTC Markets Offers its Team Members (Why You Should Choose Us):

Benefits:

• Generous Paid Time Off (PTO)
• Health, Dental, and Vision Coverage
• Health Savings Account (HSA)
• Flexible Spending Accounts (FSA) Dependent & Healthcare
• Limited Purpose Flexible Spending Account (LPFSA)
• Generous Paid Parental Leave Program
• Annual bonus and Stock Incentive Program
• 401(K) Plan - Retirement
• Commuter Transit & Parking Program
• Income Protection (Life Insurance, Short- & Long-Term Disability)
• Voluntary Benefits (Accident, Critical Illness, & Hospital Indemnity)

Perks:

• Hybrid Work Schedule
• Class Pass Partnership (Fitness & Wellness Programs)
• Citi Bike Membership Program
• Mondays – Breakfast Bagels & Wednesdays – Pizza Lunch
• Office Snacks and Beverages
• Monthly birthday celebrations

About OTC Markets Group Inc.

OTC Markets Group Inc. (OTCQX: OTCM) operates regulated markets for trading 12,000 U.S. and international securities. Our data-driven disclosure standards form the foundation of our public markets: OTCQX® Best Market, OTCQB® Venture Market, OTCID™ Basic Market and Pink Limited™ Market. Our OTC Link® Alternative Trading Systems (ATSs) provide critical market infrastructure that broker-dealers rely on to facilitate trading. Our innovative model offers companies more efficient access to the U.S. financial markets.

OTC Link ATS, OTC Link ECN, OTC Link NQB, and MOON ATS™ are each SEC regulated ATS, operated by OTC Link LLC, a FINRA and SEC registered broker-dealer, member SIPC.

To learn more about how we create better informed and more efficient markets, visit 

We are an equal opportunity and E-Verify employer and prohibit discrimination and harassment of any kind. All employment decisions are based on business needs, job requirements, and individual qualifications, without regard to race, creed, color, religion, gender, national origin, age, marital status, political belief, physical or mental disability, sexual orientation, military or veteran status, genetic information, family or parental status, gender identity, pregnancy, including childbirth or related medical condition, or any other characteristic protected by federal, state, or local law. We encourage applicants of all ages and backgrounds.

Applicants have rights under Federal Law:
Equal Employment Opportunity is the Law
Polygraph Protection Act
FMLA