Multifamily COO - Data Management, Senior Associate

Fannie Mae

Reston (VA)

On-site

USD 109,000 - 142,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Fannie Mae in Reston, VA is seeking a data analyst to support multifamily data development within a cross-functional Scrum team. You will translate business needs into data requirements, analyze source data, and define mappings and validation criteria.

The role emphasizes strong SQL, Databricks, documentation, and collaboration with product owners and engineers to deliver trusted data and insights. Bachelor\'s degree and 2+ years of experience required, with knowledge of data warehousing, SDLC,

Qualifications

  • 2+ years of relevant experience.
  • Bachelor’s degree or equivalent.
  • Strong SQL and data-analysis experience; Databricks experience is preferred, or willingness to learn the platform.
  • Experience profiling, reconciling, validating, and investigating data across multiple datasets or systems.
  • Knowledge of relational databases, data warehousing, integration, lineage, metadata, and data quality concepts.
  • Strong communication, problem-solving, documentation, and organizational skills across business and technical teams.
  • Familiarity with Agile/Scrum and SDLC processes; multifamily, mortgage, or financial services experience is strongly preferred.

Responsibilities

  • Translate business and application needs into detailed data requirements.
  • Profile and analyze source data for structure, completeness, validity, relationships, anomalies, and fitness for intended use.
  • Perform impact assessments to identify how source, schema, or rule changes affect downstream data, applications, reports, processes, and consumers.
  • Define or support business rules, transformation logic, mappings, and downstream data representation in collaboration with technical partners.
  • Create process flows and concise documentation to communicate data requirements, findings, impacts, and recommendations.
  • Collaborate with the Scrum team to refine scope, support SDLC documentation, and contribute to stories and acceptance criteria.
  • Work with technology leads to translate data requirements and mappings into implementable specifications; production coding remains with engineering.
  • Develop and execute data-focused test cases, using SQL where appropriate to validate transformations, reconcile results, document defects, and assess acceptance criteria.
  • Maintain data requirements, source-to-target mappings, dictionaries, lineage, metadata, and related documentation for consistency and traceability.
  • Use SQL, Databricks, Excel, Jira, and related tools for analysis, documentation, testing, and delivery support.

Skills

SQL analysis
Data analysis
Agile/Scrum
Documentation

Education

Bachelor’s degree or equivalent

Tools

Databricks
Excel
Jira

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 Description

As a valued contributor to our team, you will support strategic Multifamily application and data-development initiatives as part of a cross-functional Scrum team. You will partner with Product Owners, Business Analysts, subject matter experts, governance partners, developers, and data consumers to translate business needs into data requirements; analyze source data and downstream impacts; define mappings, transformation rules, and validation criteria; coordinate governance and data quality activities; and test delivered data. Strong SQL analysis, documentation, and communication skills will be essential to delivering trusted, reliable data.

The Impact You Will Make
  • Partner with Product Owners, Business Analysts, subject matter experts, and stakeholders to translate business and application needs into detailed data requirements.
  • Profile and analyze source data for structure, completeness, validity, relationships, anomalies, and fitness for intended use.
  • Perform impact assessments to identify how source, schema, or rule changes affect downstream data, applications, reports, processes, and consumers.
  • Define or support business rules, transformation logic, mappings, and downstream data representation in collaboration with technical partners.
  • Create process flows and concise documentation to communicate data requirements, findings, impacts, and recommendations.
  • Collaborate with the Scrum team to refine scope, support SDLC documentation, and, based on experience, contribute to stories and acceptance criteria.
  • Work with technology leads developers to translate data requirements and mappings into implementable specifications; production coding remains with engineering.
  • Develop and execute data-focused test cases, using SQL where appropriate to validate transformations, reconcile results, document defects, and assess acceptance criteria.
  • Maintain data requirements, source-to-target mappings, dictionaries, lineage, metadata, and related documentation for consistency and traceability.
  • Use SQL, Databricks, Excel, Jira, and related tools for analysis, documentation, testing, and delivery support.
The Experience You Bring to the Team
Minimum Required Experience
  • 2+ years of relevant experience.
  • Demonstrates curiosity and adaptability by learning and responsibly applying new techniques, including artificial intelligence, to reimagine how we work.
Desired Experience
  • Bachelor’s degree or equivalent.
  • Experience as a Data Analyst, Data Quality Analyst, Business Data Analyst, or similar data-focused role.
  • Strong SQL and data-analysis experience; Databricks experience is preferred, or willingness to learn the platform.
  • Experience profiling, reconciling, validating, and investigating data across multiple datasets or systems.
  • Experience documenting data requirements, mappings, business rules, test cases, or acceptance criteria.
  • Knowledge of relational databases, data warehousing, integration, lineage, metadata, and data quality concepts.
  • Strong communication, problem-solving, documentation, and organizational skills across business and technical teams.
  • Familiarity with Agile/Scrum and SDLC processes; multifamily, mortgage, or financial services experience is strongly preferred.
Qualifications
  • Bachelor's Level Degree (Required)
Location and Hybrid Arrangement

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.

Equal Opportunity Employment

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.

Remuneration and Benefits

Requisition compensation: 109000 to 142000. 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.

About Fannie Mae

The future is what you make it to be. Discover compelling opportunities at Fanniemae.com/careers.

Tackle America’s biggest housing challenges using the latest technology and AI, while collaborating with experts in their fields.

As a Fortune 25 company, Fannie Mae expands access to housing across America. Powered by the latest tech and AI, our innovative products and services drive the mortgage industry forward. We believe that prioritizing our people’s growth and success is essential to achieving our business goals and fulfilling our purpose.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Multifamily Business Management - SVP
Multifamily Business Management - SVP

Fannie Mae • United States

On-site
USD 300,000 - 450,000
Advisor-Cloud & Observability Engineer
Advisor-Cloud & Observability Engineer

Fannie Mae • Reston (VA)

On-site
USD 155,000 - 209,000
Senior Associate – Strategic Portfolio Management
Senior Associate – Strategic Portfolio Management

Fannie Mae • United States

On-site
USD 85,000 - 110,000
Multifamily Underwriter - Principal
Multifamily Underwriter - Principal

Fannie Mae • United States

On-site
USD 175,000 - 239,000
Health benefits
Incentive program
Career development
Technology Risk Management - Lead Associate
Technology Risk Management - Lead Associate

Fannie Mae • United States

On-site
USD 123,000 - 161,000
Incentive program
Comprehensive benefits package
Product Management - Advisor
Product Management - Advisor

Fannie Mae • Reston (VA)

On-site
USD 141,000 - 184,000
Senior Software Engineer- Enterprise Platforms
Senior Software Engineer- Enterprise Platforms

Fannie Mae • Reston (VA)

On-site
USD 123,000 - 161,000
Single Family - Product Management - Senior Associate
Single Family - Product Management - Senior Associate

Fannie Mae • Reston (VA)

On-site
USD 109,000 - 142,000
Senior Cyber Security Configuration Management
Senior Cyber Security Configuration Management

Fannie Mae • Reston (VA)

On-site
USD 109,000 - 142,000
Software Engineer - Associate (AWS)
Software Engineer - Associate (AWS)

Fannie Mae • Reston (VA)

On-site
USD 109,000 - 142,000