Portfolio Analytics for CDO HF
A recruiter reached out to me recently regarding an opening for a portfolio analytics position at a CDO/ABS HF. Conversation was going pretty well but I feel like it took a turn after he asked me if I use SQL in my current role. I told him I do not as my current position does not require it. I’m on the technology side as a business analyst at a bank for our cash equities desks & primarily work with software that is integrated with the trading stack there. The recruiter mentioned that one of the main things they were looking for is the ‘culture fit’ / being able to interact with traders and certain personalities in a high pressure environment & I definitely satisfy that req (deal with it on the daily & manage it pretty well). I also mentioned that I used SQL extensively in college & a prior internship & would really only need about a week to go back through my textbook & dial it in (SQL is basically just a syntax to search for things). Well it’s been about a month & I haven’t heard anything back so I’m assuming it’s a no. Wondering if anyone has advice on how to move into that space particularly on the fixed income side coming from my type of background?
Based on the most helpful WSO content, here’s what you need to know:
SQL Proficiency is Key: Many roles in portfolio analytics, especially in CDO/ABS hedge funds, require strong SQL skills. While you mentioned using SQL in college and internships, recruiters may prioritize candidates with recent, hands-on experience. To bridge this gap, consider dedicating time to refresh and enhance your SQL skills. Platforms like LeetCode, HackerRank, or even SQL-focused courses can help you quickly regain proficiency.
Highlight Transferable Skills: Your experience as a business analyst on the technology side for cash equities desks is valuable. Emphasize your ability to work with trading systems, manage high-pressure environments, and interact with traders. These are critical skills for roles in fixed income analytics.
Networking and Persistence: If you haven’t heard back, it’s worth following up with the recruiter. A polite email reiterating your interest in the role, your willingness to upskill in SQL, and your relevant experience could make a difference. Additionally, networking within the fixed income space can open doors. Attend industry events, connect with professionals on LinkedIn, and seek informational interviews to learn more about the field.
Broaden Your Search: If this opportunity doesn’t pan out, consider other roles in fixed income analytics or related areas where your background aligns. Look for positions that value your experience with trading systems and technology, and use them as stepping stones to your ultimate goal.
Upskill Strategically: Beyond SQL, consider learning Python, VBA, or other tools commonly used in fixed income analytics. As noted in WSO threads, having a robust technical toolkit can set you apart in the job market.
By focusing on these areas, you can position yourself more effectively for future opportunities in portfolio analytics within the fixed income space.
Sources: S&T Summer Analyst Lateral to IB FT?, LinkedIn Strategy & Analytics - Ask Me Anything, Q&A: Non-Target School to Portfolio Manager at a Top Hedge Fund – 6 Years Out of Undergrad, Q&A: Barclays IB to MM Private Equity, https://www.wallstreetoasis.com/forum/job-search/buyside-viewpoint-from-a-fixed-income-pm?customgpt=1
Yeah, the SQL part probably hurt your chances, but it’s not a dealbreaker long-term. Since you already handle high-pressure trading environments, the key is positioning yourself better for these roles. I’d brush up on SQL now so it’s not a weakness next time—just knock it out so you can confidently say you use it. Also, start getting familiar with structured credit and fixed-income analytics (Fabozzi’s Handbook of Fixed Income Securities is a good place to start). Networking is huge too—connect with people in similar roles at credit-focused funds and see how they made the jump. If this one doesn’t work out, no big deal. Just use it as a lesson, level up where needed, and go after the next opportunity stronger.
Great advice. Thank you!
Ea suscipit animi rerum sed quia. Voluptatem nostrum minima sed quia doloribus. Vero facere enim ratione est minima deserunt.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...