
Marketing Operations and Analytics Specialist
Fannie Mae
full-time
Posted on:
Location Type: Hybrid
Location: Washington • District of Columbia • Texas • United States
Visit company websiteExplore more
Salary
💰 $85,000 - $110,000 per year
Tech Stack
About the role
- 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.
- 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.
Benefits
- Health, Life, Voluntary Lifestyle, and other benefits and perks
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLdata visualizationreportingdata mininganalytical skillsDAXworkforce capacity reportingresource utilization reportingcloud data warehousegraphic design principles
Soft skills
effective communicationanalytical thinkingsynthesis of informationpresentation skills