Senior Financial Engineer - Capital Markets

Fannie Mae; Washington (District of Columbia); Hybrid; USD 109,000 - 142,000; Full time

Job summary

Fannie Mae in Washington, DC seeks a Senior Financial Engineer - Capital Markets to design and maintain data pipelines, analytics, and automated validation for large financial datasets. You will partner with Finance and Technology teams to deliver scalable, well-governed solutions.

You will develop Tableau dashboards to explain P&L, ROE, funding costs, and key drivers, and translate complex findings into clear visuals and documentation for technical and non-technical audiences.

Qualifications

• 2+ years of data, analytics, automation, or reporting experience in a finance, risk, or capital markets environment.
• Strong proficiency in SQL, including complex joins, aggregations, data profiling, and large datasets.
• Hands-on experience using Python for data analysis, automation, ETL, validation, or analytical app development.
• Experience developing and supporting Tableau dashboards, including data connections, calculated fields, and validation of outputs.
• Experience with software development practices: version control, modular code, testing, peer review, controlled releases.
• Curiosity and adaptability in learning and applying new technologies, including AI.

Responsibilities

• Design, develop, and maintain Python- and SQL-based data pipelines, analytics utilities, and automated validation routines for large financial datasets.
• Partner with Finance, Treasury, Risk, Accounting, and Technology stakeholders to translate reporting and analytical needs into technical designs and data models.
• Build and enhance Tableau dashboards and analytical views that explain P&L, ROE, funding cost, and key performance drivers.
• Translate complex data findings into clear visualizations, documentation, and conclusions for technical and non-technical audiences.
• Collaborate with developers and data engineers to troubleshoot data issues and improve platform performance.

Skills

SQL

Python

Tableau

R

Education

Bachelor's Degree

Tools

Tableau

AWS

Redshift

Job description

Playing an essential role in the U.S. economy, Fannie Mae is foundational to housing finance. Here, your expertise can help fuel purpose-driven innovation that expands access to homeownership and affordable rental housing across the country. Join Fannie Mae to grow your career and help people find a place to call home.Job DescriptionAs a valued colleague on our team, you will develop and enhance data and analytics solutions supporting Treasury Capital Markets P&L, capital, and return-on-equity reporting. You will use Python, SQL, Tableau, and, where appropriate, R to automate data pipelines and controls, build decision-ready dashboards, investigate complex financial data, and partner with Finance and Technology teams to deliver scalable and well-governed solutions.THE IMPACT YOU WILL MAKEThe Senior Financial Engineer - Capital Markets role will offer you the flexibility to make each day your own, while working alongside people who care so that you can deliver on the following responsibilities:Design, develop, and maintain Python- and SQL-based data pipelines, analytical utilities, and automated validation routines for large financial datasets.Partner with Finance, Treasury, Risk, Accounting, and Technology stakeholders to translate reporting and analytical needs into technical designs, data models, and reusable solutions.Build and enhance Tableau dashboards and analytical views that explain TCM P&L, balance, funding cost, required capital, ROE, and key performance drivers.Develop prototypes and production-ready analytical code, including data transformations, reconciliations, exception monitoring, and scenario or attribution analysis.Translate complex data and technical findings into clear visualizations, documentation, and conclusions for technical and non-technical audiences.Collaborate with application developers, data engineers, and financial subject-matter experts to troubleshoot data issues, optimize queries, and improve platform performance and reliability.Perform code reviews, unit and regression testing, source-to-target reconciliations, data-quality checks, release validation, and production support for internally developed tools and dashboards.THE EXPERIENCE YOU BRING TO THE TEAM Minimum Required Experiences:2 years of experience developing data, analytics, automation, or reporting solutions in a finance, risk, or capital markets environment.Strong proficiency in SQL, including complex joins, aggregations, data profiling, query optimization, and working with large datasets.Hands-on experience using Python for data analysis, automation, ETL, validation, or analytical application development.Experience developing and supporting Tableau dashboards, including data connections, calculated fields, performance tuning, and validation of data and visual outputs.Experience with software development practices such as version control, modular code, documentation, testing, peer review, and controlled releases.Shows curiosity and adaptability in learning and responsibly applying new technologies, including artificial intelligence, to reimagine how we work.Desired Experiences:Bachelor degree or equivalent in Computer Science, Engineering, Data Science, Analytics, Finance, Financial Engineering, or a related discipline.Experience with R for statistical analysis, modeling, or data transformation is preferred but not required.Knowledge of AWS, Redshift, data warehousing, APIs, ETL frameworks, or cloud-based analytics platforms.Knowledge of accounting P&L, capital markets products, mortgage finance, funds transfer pricing, required capital, or ROE concepts.Experience implementing data-quality controls, monitoring, reconciliation frameworks, and production support for business-critical reporting.Capital Markets CFO - Financial Engineering - Senior AssociateTarget Pay Range: $109,000 - $142,000 a year#LI-Hybrid #LI-ME1QualificationsEducation: Bachelor's Level Degree (Required)The future is what you make it to be. Discover compelling opportunities at Fanniemae.com/careers.For most roles, employees are expected to work onsite on a regular basis at their designated office location. In-office work cadence is determined by your manager. Proximity within a reasonable commute to your designated office location is preferred unless the job is noted as open to remote.Fannie Mae is an equal opportunity employer and considers qualified applicants for employment without regard to race, color, religion, sex, national origin, disability, age, sexual orientation, gender identity/gender expression, marital or parental status, or any other protected factor. Fannie Mae is committed to providing reasonable accommodations to qualified individuals with disabilities who are employees or applicants for employment, unless to do so would cause undue hardship to the company. If you need assistance using our online system and/or you need a reasonable accommodation related to the hiring/application process, please complete this form .The hiring range for this role is set forth below. Final salaries will generally vary within that range based on factors that include but are not limited to, skill set, depth of experience, certifications, and other relevant qualifications. This position is eligible to participate in a Fannie Mae incentive program (subject to the terms of the program). As part of our comprehensive benefits package, Fannie Mae offers a broad range of Health, Life, Voluntary Lifestyle, and other benefits and perks that enhance an employee's physical, mental, emotional, and financial well-being. See more here .Requisition compensation: 109000to 142000