AVP, Data Analyst

OTC Markets Group
New York, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 100K

Job location

New York, United States of America

Tech stack

Artificial Intelligence
Algorithmic Trading
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Applicant Tracking Systems
Databases
Relational Databases
PostgreSQL
Microsoft SQL Server
MySQL
Query Optimization
Power BI
SQL Stored Procedures
SQL Databases
Tableau
Informix
Scripting (Bash/Python/Go/Ruby)
Freeform SQL
Database Optimization
GIT
Information Technology
Software Version Control

Job description

  • 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., 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 www.otcmarkets.com.

Requirements

  • 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

Benefits & conditions

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., + 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

About the company

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.

Apply for this position