Equity Data Analyst/Associate - Trading Firm in Midtown
The Equity Data Analyst role at a reputable trading firm in Midtown New York involves managing and analyzing financial data to support trading activities, risk management, and analytics. The position requires 2-5 years of experience with strong data management skills using SQL, VBA, or Python, offering exposure across the trading business in a growing firm environment.
About Careertakes
👉 Important disclosure: Careertakes is a third-party recruiting platform supporting this hiring process. If selected, you will be employed directly by our client, Financial Services, Banking, Investment Banking (Trading Firm).
Applicants for this role may also receive access to additional matched opportunities through the Careertakes platform.
What You’ll Do
Confidential Client is hiring an Equity Data Analyst / Associate to support trading, analytics, and risk teams in Midtown Manhattan. You will work directly with traders and quants to manage, validate, and analyze equity market data used for execution, P&L analysis, and risk controls.
- Own and clean large equity datasets; ensure data quality across sources
- Build SQL queries, ETL scripts, and small tools (Python/VBA) to automate data flows
- Produce analytics and dashboards for trading strategy performance and risk monitoring
- Collaborate with trading desks to translate business questions into data requirements
- Identify data issues, implement fixes, and document processes and assumptions
- Support intra-day and end-of-day reconciliations and investigations
Who You Are / Required Qualifications
- 2–5 years of relevant experience in financial services, trading, or a related analytics role
- Strong SQL skills (complex joins, window functions, performance tuning)
- Proficiency in at least one scripting language: Python or VBA
- Hands-on experience with data cleaning, validation, and ETL concepts
- Comfortable working with traders and technical teams in a fast-paced environment
- Bachelor’s degree in Finance, Computer Science, Mathematics, Engineering, or related field
Preferred / Nice-to-Have
- Prior experience at a trading firm or hands-on exposure to equity markets
- Familiarity with risk management concepts and trade lifecycle
- Experience with analytics/visualization tools (e.g., Tableau, Looker) or building internal dashboards
- Strong communication skills and attention to detail
- Experience with version control or basic software engineering practices
Why Join
- Work at a fast-growing trading firm with exposure to front-office analytics and risk
- High-impact role sitting at the intersection of trading, data, and technology
- Collaborative team culture focused on data quality and continuous improvement
Location & Employment Type
- Location: New York, NY (Onsite — Midtown)
- Employment type: Full-time
- Level: Associate (early-career to mid-level; 2–5 years experience)
Equal Opportunity & Hiring Transparency
Careertakes and our client are Equal Opportunity Employers committed to building a diverse and inclusive workforce. We prohibit discrimination or harassment of any kind. To support a fair and efficient hiring process, AI tools may be used to assist with application review or resume screening. These tools do not replace human decision-making. Final hiring decisions are made by people.
If you have questions about how your data is used, please contact us directly.
Negotiate a higher salary! Check the salary ranges for this job type in your area.
View My Salary Range