AVP, Data Analyst
AVP, Data Analyst
OTC Markets Group - New York, NY - Full Time
- 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.
- 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
- 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)
- 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
Recommended Jobs
Sous Chef
The Dinex Group, Chef Daniel Boulud’s internationally acclaimed restaurant group, is excited to announce the first steakhouse to its extensive profile, La Tête d’Or by Daniel. This new concept will…
General Manager - Lomography USA (NYC)
Do you embrace challenges and want to work in a fast-paced, multicultural, creative environment? Are you hardworking and interested in photography and filmmaking products? If you enjoy sales and mark…
Manufacturing Electrician Supervisor
This position will focus on overseeing and guiding a team of electricians, ensuring projects are completed efficiently, safely, and within budget, while also managing the team's performance and provi…
Payroll Administrator
Join a team where your professional growth directly impacts vulnerable families across New York City by providing crucial housing services and eviction prevention legal support that helps clients ach…
Principal Consultant
Job Description Why Oracle NetSuite? One word - transformation. Do you want to advance your career with the world's first cloud company? Since 1998, Oracle NetSuite has been on a missi…
Software Engineer, Glamour
Job Title: Software Engineer, Glamour About Bombas: Bombas is a comfort focused premium basics brand with a mission to help those in need. The company launched in 2013, after the founder…
Administrative Assistant - Physician Assistant Program (3507)
Be the First to Apply Job Description Job Summary: Serve as a member of a dynamic and collaborative administrative support team within Ithaca College, in a forward-facing role suppor…
Affiliate Marketer (US)
At bunq, we're not just building a banking app; we're reshaping how people around the world experience financial freedom. As our Affiliate Marketer (US) , you will be the driving force behind our gr…
Customer Service Representative
We are seeking a Customer Service Representative to join our team! This is an in-person role and you will be responsible for helping customers by providing product and service information and helping…
Oracle Cloud Finance (Healthcare) - Director
Specialty/Competency: Oracle Industry/Sector: Not Applicable Time Type: Full time Travel Requirements: Up to 60% A career in our Finance team, within our Oracle consulting practice, wi…