Manager, Data Visualizations and Reporting

The responsibilities may include, but will not be limited to the following: 

• Identify internal and external data visualization and reporting needs, in collaboration with the Assistant Director, Senior Director of Grants Management, Learning and Evaluation, Communications, and program teams.
• Fulfill data visualization and reporting needs across the Foundation through the development of intuitive, engaging, insightful, and attractive dashboards and visualizations in Power BI, or other data visualization tools. Kinds of visuals may include information on grant type, organizations, program strategies, grant activities and subjects, grantee locations and activity settings, as well as, grant products or outcomes.
• Prepare data visualizations and summarize key takeaways for presentations and reports, including grantmaking visuals presented to the Board and data visualizations for external sources.
• Clean and organize large datasets, primarily from the Fluxx secondary database, for analysis and visualization; verify and ensure accuracy, integrity, and consistency of data.
• Understand the implications of data, and interpret data in context, including identifying trends and outliers.
• Collaborate with the Assistant Director, Information Technology, and Operations staff to conduct comprehensive reviews of organization-wide data.
• Help with the selection and roll-out of data visualization tools and dashboards.
• Respond to ad-hoc requests for grant-related information and data visualizations.
• Develop documentation of key workflows and processes related to data visualization and reporting.
• Assist the Assistant Director with the maintenance of the Foundation’s grant classification framework (taxonomy), data mapping, and the publication of the Foundation’s grant data externally.
• Assist the Grants Management team with the development of Fluxx reports and system configuration and testing.
• Perform other job-related duties as assigned by the Assistant Director.
• Keep abreast of best practices in the use of technology in data visualization and evaluation and participate in relevant professional organizations for professional development.

Required Skills and Experience: 

The successful candidates will have the following qualifications: 

• A bachelor’s degree in data science, statistics, or a related field; master’s degree preferred. Or equivalent combination of education and experience.

• 5+ years of professional experience in a research and data visualization environment.
• Expertise building and creating engaging and effective dashboards and data visualizations with common visualization tools such as Power BI and Tableau.
• Experience working with multiple data systems, large relational databases, and SQL.
• Knowledge of statistical analysis, modeling, and tools such as R, STATA, SPSS, and Crystal Reports.
• Excellent visual skills and experience working with communications and branding professionals.
• Creative vision, a passion for learning and willingness to adopt and share new ideas.
• Excellent communication skills, with the ability to work with a wide variety of departments.
• Ability to manage and coordinate multiple projects and tasks simultaneously, with a careful attention to detail.
• Simultaneous ability to work as a member of a team and to work independently, and the ability to function effectively under uncertainty.

Mellon Foundation is an equal opportunity employer. The Mellon Foundation is committed to access and inclusion for our applicants. If you have accessibility requests to support your participation in the hiring process, please let us know at your earliest convenience. 

Mellon offers a generous total reward package that includes base salary and a comprehensive benefits program, as well as an excellent working environment. Mellon is committed to providing compensation that is competitive and equitable within the philanthropic sector. The estimated annual salary range for this role is $145000 - $155000. The amount of pay offered will be determined by several factors, including but not limited to qualifications, unique skills, credentials, or experience that is expected to impact the candidate’s contribution to the role. We will also consider market data as well as the Foundation’s internal pay equity framework.  

Please note that Mellon maintains a hybrid work schedule, with three days per week in person at the Foundation’s Manhattan offices.  

Candidates should apply by submitting a cover letter describing fit for the position and a resume to Natalie Leonard at nleonard@employcore.com. Applications will be reviewed on a rolling basis. Please note that incomplete applications will not be considered. 

The Foundation will consider each complete application carefully but only contact those individuals it believes are most qualified for the position.