Marketing Operations and Analytics Specialist

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.

THE EXPERIENCE YOU BRING TO THE TEAM

Minimum Required Experience

• 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.

Desired Experience

• Bachelors 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.

Marketing Reporting Senior Associate

Target Pay Range: $85000 - $110000 a year

Qualifications

Education:

The future is what you make it to be. Discover compelling opportunities at most roles employees are expected to work onsite on a regular basis at their designated office -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 employees physical mental emotional and financial well-being. See more here.

Requisition compensation:

to