Capital Markets Data Engineer — P&L & Dashboards

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

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.