Capital Markets Mortgage Desk Intern

Federal Home Loan Bank of Dallas; Irving (TX); On-site; USD 28,000 - 41,000; Part time

Job summary

Federal Home Loan Bank of Dallas is offering an internship opportunity to gain hands-on exposure to a trading desk environment. You will learn mortgage portfolio management, support pricing of advances and mortgages, and automate reports using Excel, VBA, SQL, and Power BI.

Ideal candidates are pursuing finance or economics degrees with a quantitative focus, have knowledge of fixed income instruments, and possess strong Excel skills and analytical abilities.

Qualifications

• Pursuing a degree in finance, economics, or similar with quantitative focus.
• Working knowledge of fixed income financial instruments and risk measures.
• Exposure to data science and computer science preferred.
• Proficiency in MS Office Suite, especially Excel; ability to create and maneuver spreadsheets and data.
• Knowledge in VBA, SQL and Power BI.
• Attention to detail is a must.
• Analytical and IT skills related to financial asset pricing and risk measurement.
• Excellent interpersonal, communication, and organizational skills.

Responsibilities

• Learn about mortgage portfolio management.
• Support product pricing (advances and mortgages) and facilitate transaction verification.
• Automate reports and processes using VBA/SQL/Power BI.
• Test new products and systems.
• Identify and collect market information; verify with multiple sources.
• Conduct market research and ad hoc analyses for portfolio management strategies.

Skills

Excel proficiency

Fixed income knowledge

Data analysis

Attention to detail

Interpersonal & communication

Education

Pursuing a bachelor's or master's degree in finance/economics with quantitative focus

Tools

VBA

SQL

Power BI

Job description

FHLB Dallas actively pursues dedicated and hardworking individuals to be a part of our professional team. Positions are offered on an as-needed basis for all departments. View our current opportunities by clicking the View Open Positions tab above.We are offering a rare opportunity to gain first-hand insight into the day-to-day workings of a trading desk! You will work with treasurers/portfolio managers/traders and soak in the daily bustling trading activities. You will learn about our pricing methodologies, funding practices, and hedging philosophies. You will also have opportunities to interact with other areas of the Bank including but not limited to Risk, Accounting, and IT.PRIMARY RESPONSIBILITIES* Learn about the management of a mortgage portfolio* Support product pricing (advances and mortgages); facilitate transaction verification and documentation* Automate reports and processes using SSRS/ VBA/SQL or Power BI* Test new products and systems* Identify and collect market information; verify information validity with multiple sources* Conduct market research; perform ad hoc analyses in support of portfolio management strategiesREQUIREMENTS* Pursuing a bachelor's or master's degree in finance, economics, or similar fields with a quantitative focus;* Working knowledge of fixed income financial instruments and risk measures required;* Exposure to data science and computer science preferred;* Proficiency in MS Office Suite, especially Excel; must be able to create and maneuver spreadsheets and data;* Knowledge in VBA, SQL and Power BI;* Attention to detail is a must;* Conceptual, analytic, and information technology skills appropriate to financial asset pricing and risk measurement;* Excellent interpersonal, communication, and organizational skills combined with ability to plan, organize, and carry out multiple project assignments.Hours are flexible and depend on the student's class schedule, course requirements (if applicable), and availability. - **Hours Per Week**: 30 - 40# FHLB Dallas Offers a Professional, Inclusive CultureFHL Bank Dallas employees are committed to and exemplify the following principles:* Service to our members is first and foremost* All business will be conducted honestly and ethically* Each employee contributes to customer service by directly serving our members or supporting those who do* Interaction with members should focus on building professional relationships and helping customers achieve their goals* Cooperation and teamwork throughout and across all levels of FHLB Dallas are essential to its effectiveness* Colleagues and members will be treated with the utmost respect and dignityFHLB Dallas provides equal employment opportunity to all individuals without regard to race, religion, color, sex, age, marital status, ancestry, veteran status, disability, or national origin. FHLB Dallas will consider for employment all persons on an individual basis consistent with job-related criteria without regard to visible and non-visible disabilities. Equal opportunity applies to all employment practices, including recruitment, screening, hiring, compensation and training, as well as other conditions and privileges of employment.