Credit Analysis and Financial Reporting Intern

FHLBank Topeka; Topeka (KS); On-site; USD 21,000 - 28,000; Part time

Job summary

FHLBank Topeka is offering a paid internship for a student pursuing a finance or accounting degree. The role focuses on monitoring the financial condition of members and counterparties, and strengthening data analytics, reporting, and visualization capabilities.

You will prepare financial analyses, assist with credit reviews, support regulatory processing, and help develop tools in Python and Power BI, with Excel and Cognos familiarity.

Qualifications

• Sophomore year or higher in finance or accounting completed or 12 college hours in those fields.
• One year of related work experience preferred but not required.
• Ability to work independently.
• Strong verbal and written communication skills.
• Experience with financial/economic analysis and statistics.
• Advanced computer skills, especially in Excel development, Python scripts, querying methods, data mining/analytics.
• Familiarity with MS Office (Word, Excel, PowerPoint).

Responsibilities

• Prepare detailed financial analyses and form credit opinions for members.
• Assist with financial analysis for vendors, servicers, and custodians.
• Support regulatory examination processing including ordering, receiving, evaluating, destruction, and follow-up.
• Develop financial data analysis tools and visualizations (Python, Power BI).
• Assist with analytics related to pledging securities collateral.
• Monitor equity prices and CDS spreads for public counterparties.

Skills

Python

Power BI

Excel

Data analytics

Financial analysis

Communication

Independent work

Statistical analysis

MS Office

Querying methods

Education

Sophomore year or higher in finance or accounting

Tools

Python

Power BI

Excel

Cognos

Job description

This is a paid internship designed for a student to work while completing their degree.

The emphasis of this position will be to assist with the monitoring of the financial condition of FHLBank members, investment and derivative counterparties as well as enhancing the department's financial data analytics, data visualization initiatives and other reporting capabilities.

In This Role, You Will:

• Support the review of the financial condition of existing members and housing associates by assisting with the preparation of detailed written financial analysis, forming a credit opinion, call reports, NAIC statutory statements, and SEC filings.
• Assist with financial analysis and credit review activities for FHLBank vendors, loan servicers and loan custodians.
• Help maintain and monitor regulatory examination processing, including support with ordering, receiving, evaluating, destruction, and follow-up.
• Provide support in developing financial data analysis tools (python, data bricks), data visualization (Power BI), and other reporting capabilities.
• Assist with analytics related to pledging securities collateral in accordance with minimum eligibility requirements.
• Help monitor equity prices and credit default swap spreads for FHLBank publicly traded counterparties.

Requirements:

• Twelve hours of college accounting or finance or the completion of at least sophomore year of college working toward an undergraduate degree in finance or accounting is preferred.
• One year of similar or related work experience is preferred but not required.
• Ability to work independently.
• Strong verbal and written communication skills.
• Ability to conduct financial economic analysis, and statistical analysis.
• Advanced computer skills are a plus, particularly in spreadsheet (excel) development, Python scripts, and querying methods, data mining/data Analytics, Python, Cognos, or similar report writer and Power BI.
• Basic knowledge of financial statements and bank call reports is desirable.
• Knowledge and proficient use of MS Office products, including Word, Excel, and PowerPoint.

FHLBank Topeka EEO Policy

FHLBank Topeka is an equal employment opportunity employer. We recruit, employ, train, compensate and promote without regard to race, color, creed, religion, sex, age, sexual orientation, national origin, ancestry, pregnancy, parental status, citizenship status, disability, genetic information, military status, gender identity and expression or marital status.

Accommodation Request

Should you need an accommodation during the application or interview process, please contact us at [e-mail].