Analyst - Valuations & Business Intelligence Reporting

Analyst - Valuations & Business Intelligence Reporting AGNC Mortgage Management, LLC - 5.0 Bethesda, MD Job Details Full-time 5 hours ago Qualifications Data visualization software proficiency Data transformation pipeline development Software coding SQL APIs Data analytics tools Data warehouse Python Database software proficiency

Full Job Description Overview:

We are seeking a technically driven Analyst to join our Valuations & Business Intelligence Reporting team at AGNC. This is a quantitative, engineering-forward role for someone who thrives at the intersection of software development and financial markets. In this role, you will help value AGNC's asset and liability portfolios by applying fixed-income models and financial market knowledge to business and financial data. You will also leverage advanced business intelligence tools and techniques to support reporting, analytics, and data-driven insights. In addition, this role will support the execution of our agency MBS prepayment forecasting process and related analyses. You will own the end-to-end data pipelines that drive daily fair-value pricing and prepayments across our MBS, debt, and derivatives portfolios. This includes but is not limited to fetching raw data via APIs and data warehouses through finalized Parquet outputs that power our dashboards and reports. This is an excellent opportunity for a junior software engineer eager to apply their technical foundation in a sophisticated financial environment and grow into a subject matter expert on fixed income valuation. No prior finance experience is required; we will teach you the business. What we need is someone who writes clean, production-quality Python code and has a genuine curiosity about fixed income markets and how they operate.

Responsibilities:

Valuation & Pricing Execute and monitor daily fair-value pricing for the Company's securities, debt, and derivatives portfolios for use by the Trade Desk, Risk Management, and Financial Reporting. Maintain valuation methodologies for mortgage-backed securities, other mortgage-related investments, and derivatives portfolios. Analyze prepayment forecasts from third-party models for reasonableness and incorporation into risk analytics and accounting forecasts. Conduct financial analysis and forecasting including interest rate/spread shock scenarios and sensitivity analysis. Discuss markets and fixed income concepts and trends with internal participants, including Trade Desk, Middle Office, and Financial Reporting. Data Engineering & Automation Build, maintain, and improve Python-based data pipelines that ingest data from external APIs, internal data warehouses, pricing services, and proprietary file sources. Produce and validate finalized Parquet data files that serve as the foundation for Power BI reporting dashboards. Automate and optimize recurring daily, monthly, and quarterly valuation and reporting processes. Implement robust data quality checks and exception handling within pipeline workflows. Reporting & Analysis Generate daily, monthly, and quarterly reporting packages for internal stakeholders (Trade Desk, Middle Office, Risk Management) and external/regulatory reporting. Identify, monitor, and report on pricing developments and trends. Maintain market intelligence through market research and frequent interaction with AGNC's trading desk, pricing services, and other third-party vendors. Controls & Compliance Maintain effective internal controls over financial reporting pursuant to SEC and other regulatory reporting requirements. Interface with internal and external auditors on valuation and prepayment-related matters. Complete special projects requiring financial services valuation expertise.

Qualifications:

Minimum Requirements 1+ year of relevant software engineering or data engineering experience. Bachelor's degree in Computer Science, Engineering, Mathematics, Statistics, or a related quantitative field. Strong Python proficiency, including experience with data engineering patterns: API consumption, file I/O, data transformation, and pipeline orchestration. Working knowledge of SQL for querying relational databases and data warehouses. Familiarity with columnar data formats (e.g., Parquet) and business intelligence tools such as Power BI. Strong analytical and problem-solving skills with high attention to detail. Genuine interest in learning fixed income markets, mortgage products, and financial valuation concepts. Preferred Qualifications Experience in financial services, fintech, or a quantitative research environment. Strong understanding of mortgage-backed securities, agency to-be-announced ("TBA") securities, and interest rate derivative products. Excellent analytical skills and ability to understand complex financial concepts such as DCFs, OAS, Duration, Convexity, spreads, valuations, etc. Master's degree in Finance, Financial Engineering, Computer Science, Mathematics, or a related discipline. CFA, FRM, or active progress toward either designation. Experience with Bloomberg's Terminal and excel API. Familiarity with mortgage prepayment models. Knowledge of cloud data warehouse environments.

PERSONAL PROFILE

Intellectually curious and excited to learn new domains and go deep on complex problems.

Ownership mindset:

takes initiative, follows through without requiring close supervision. Clear communicator who can translate technical findings into business-relevant insights for non-technical stakeholders. Collaborative and collegial; comfortable working across trade desk, risk, middle office, and finance functions. Comfortable in a fast-moving environment where processes are actively evolving and there is room to improve the tooling.