Apply on Employer Site

Confidential Company · 13 hours ago

Capital Markets Data Analyst

United States

Full-time

Remote

Entry, Mid Level

$70K/yr - $80K/yr

Confidential Company is seeking a Capital Markets Data Analyst to support the Capital Markets and Secondary Marketing functions. This role focuses on advanced data analysis, reporting, and automation to enhance data visibility and support leadership with timely analytics.

Transportation/Trucking/Railroad

Responsibilities

Develop, maintain, and enhance comprehensive Excel-based reports supporting Capital Markets and Secondary Marketing operations

Build complex reporting models utilizing pivot tables, advanced calculations, nested IF statements, and custom data categorizations

Analyze large data sets related to pricing, locks, fallout, delivery, and investor execution to support decision-making

Design and implement Excel VBA macros to automate recurring processes and improve efficiency, accuracy, and scalability

Partner with Capital Markets, Pricing, and Lock Desk stakeholders to translate business questions into analytical outputs

Perform ad hoc analysis and reporting to support market volatility, pipeline monitoring, and management requests

Assist in validating data accuracy and ensuring reporting consistency across systems and sources

Support ongoing efforts to modernize and migrate reporting to scalable data and BI platforms as applicable

Qualification

Advanced ExcelData analyticsMortgage Capital MarketsVBASQLPower BIAnalytical skillsProcess-oriented mindsetProblem-solvingCommunication

Required

Advanced proficiency in Microsoft Excel, including: comprehensive report building, Pivot tables and complex calculations, Nested IF statements and logical functions, Custom data categorizations and structured datasets

Data analytics experience, with the ability to interpret, analyze, and present actionable insights

Basic experience in Mortgage Capital Markets, including familiarity with secondary marketing concepts, pricing, or pipeline data

Working knowledge of VBA, including Excel macros and process automation

Must be able to verify identity and employment eligibility to work in the U.S