Fixed Income Reporting Analyst

Jobtailor; Minnesota; On-site; USD 85,000 - 120,000; Full time

Job summary

Jobtailor is seeking a fixed income reporting professional to perform analytic reporting on portfolios using Excel, SQL, and SAS. The role will implement new reporting initiatives and support existing analytics through third‑party vendor models like Yield Book and Aladdin.

Responsibilities include assisting in portfolio operations for Investment Portfolio, BOLI, and Equity Investments, and deriving dashboards to meet investment objectives with strong attention to detail.

Qualifications

• Bachelor’s degree in finance or economics, or equivalent fixed income operational support experience.
• Typically three or more years of related experience.
• Proficiency in Excel and MS SQL; able to transform large datasets into structured reports.
• Experience with Yield Book and BlackRock Aladdin.
• Experience with Intex, Trepp, Bloomberg.
• CFA preferred.

Responsibilities

• Initiates and conducts reporting analysis of fixed income securities.
• Implements new reporting initiatives and supports existing reporting using 3rd‑party vendor solutions.
• Assists in operations support for Investment Portfolio, BOLI, and Equity Investments by analyzing actual and projection amounts.
• Assists in analyzing the composition of investment portfolios and derives portfolio reporting dashboards.

Skills

Independent & team work

Time management

Analytical skills

Presentation & interpersonal

Multi-tasking in fast-paced env

Education

Bachelor’s degree in finance or economics

CFA preferred

Tools

Microsoft Excel

MS SQL

SAS

VBA

Yield Book

BlackRock Aladdin

Intex

Trepp

Bloomberg

Job description

Responsibilities

• Initiates and conducts reporting analysis of various individual fixed income securities or classes of fixed‑income securities using sources such as industry reports, trade journals, technical periodicals, and brokers’ and management reports.
• Implements new reporting initiatives and supports existing reporting functions using 3rd‑party vendor solution models applied in portfolio analytics.
• Assists in operations support for Investment Portfolio, BOLI, and Equity Investments programs by analyzing, documenting, and communicating actual and projection amounts.
• Assists in analyzing the composition of investment portfolios and assists in deriving portfolio reporting dashboards to fulfill investment objectives.

Requirements

• Bachelor’s degree in finance or in economics, or equivalent fixed income operational support experience
• Typically three or more years of related experience
• Strong knowledge and experience with different asset classes of fixed income securities such as agency mortgage‑backed securities, asset‑backed securities, and commercial mortgage‑backed securities.
• Ability to work independently and collaboratively in a team environment.
• Effective time management skills with ability to implement, lead and follow through to completion.
• Proficiency in Microsoft Excel and MS SQL is required along with ability to transform large data sets into structured reports.
• Experience with reporting utilizing 3rd‑party vendor solution models applied in portfolio analytics such as Yield Book and/or BlackRock Aladdin.
• Strong analytical, presentation and interpersonal skills, with particular attention to detail
• Experience with Intex, Trepp, Bloomberg, Yield Book, and/or BlackRock Aladdin
• Programming background utilizing SAS and familiarity with MS VBA
• Ability to multi‑task in a fast‑paced environment
• CFA preferred

Core Competencies

Demonstrates strong analytical skills in fixed income securities reporting and portfolio analytics, with proficiency in Microsoft Excel, MS SQL, and programming in SAS. Capable of implementing reporting initiatives and transforming large data sets into structured reports while collaborating effectively in a team environment.