Marketing Operations and Analytics Specialist

Fannie Mae•Washington, DC

1d•$85,000 - $110,000

About The Position

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 colleague on our Marketing and Risk Operations Front Office team, you will help drive the reporting necessary to support our Strategic Work Management framework and provide marketing leadership with clear, data-driven visibility into what the team is delivering for Fannie Mae. You will develop reports from scratch using visualization tools to inform operational Marketing resource and project capacity. THE IMPACT YOU WILL MAKE The Marketing Operations and Analytics Specialist 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: Contribute to the development and advancement of our strategic work management framework to advance organizational objectives and goals through data-driven analyses and visualizations. Write SQL queries and develop data visualizations to improve awareness and understanding of Marketing team priorities against capacity of the team. Conduct data mining and deep dive analyses into digital marketing results to develop recommendations, optimizations, and/or improvements to Marketing work management. Assist the Marketing team with ad-hoc requests from a variety of internal stakeholders. Develop reporting timelines and requirements. Gather and analyze data and information for reports to be presented to internal and/or external stakeholders. Design or produce reports using information gathered. Work with key stakeholders to ensure that reports meet the business or regulatory need. Review reports for accuracy and timeliness, provide insightful analysis, and explain reporting results.

Requirements

2 years of experience developing business intelligence reports using SQL and data visualization tools.
Advanced SQL proficiency, including ability to write complex queries and navigate relational data warehouse environments.
Hands-on experience building reports and dashboards from scratch in platforms such as Power BI or Tableau.
Strong analytical skills with the ability to identify trends, interpret data, and translate findings into actionable insights.
Effective communication skills to present data-driven insights to both technical and non-technical stakeholders.
Ability to synthesize information from structured or unstructured data and convey clear, big-picture conclusions.

Nice To Haves

Bachelor's degree or equivalent work experience.
Experience creating workforce capacity or resource utilization reporting.
Familiarity with graphic design principles for presenting reports and dashboards.
Experience with DAM or CMS tools (e.g., Acquia, Drupal).
Experience with Adobe Workfront or similar workflow/project management platforms.
Knowledge of DAX for Power BI.
Experience working with Amazon Redshift or similar cloud data warehouse environments.
Understanding of content management practices, including taxonomy design, metadata schema, and tagging conventions.
Background in digital asset management, including ingestion, tagging, archiving, and retrieval workflows.

Responsibilities

Contribute to the development and advancement of our strategic work management framework to advance organizational objectives and goals through data-driven analyses and visualizations.
Write SQL queries and develop data visualizations to improve awareness and understanding of Marketing team priorities against capacity of the team.
Conduct data mining and deep dive analyses into digital marketing results to develop recommendations, optimizations, and/or improvements to Marketing work management.
Assist the Marketing team with ad-hoc requests from a variety of internal stakeholders.
Develop reporting timelines and requirements.
Gather and analyze data and information for reports to be presented to internal and/or external stakeholders.
Design or produce reports using information gathered.
Work with key stakeholders to ensure that reports meet the business or regulatory need.
Review reports for accuracy and timeliness, provide insightful analysis, and explain reporting results.

Benefits

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume