Data Analyst, Grants Management & Administration, Public Health Programs Save

Are you seeking an opportunity to bring your professional expertise to a global organization focused on re-imagining public health?
The Data Analyst will collaborate with leadership across all programs within the Public Health, Environment/Climate/Urban Health, and Finance Divisions to identify, analyze, and convert existing programmatic and financial data into powerful reports and visualizations that enable analysis for decision-making in a timely manner. Under the supervision of the Director for Grants and Administration and as part of the Grants Management and Administration team, the Data Analyst will work with Power BI to develop and maintain reports and budget monitoring dashboards. The incumbent will be trusted to develop the appropriate data accession, normalization, and programming structure to enable reporting in Power BI and to develop visually useful dashboards. to respond to divisional needs and optimize divisional use.

Vital Strategies is an international public health organization. Our programs strengthen public health systems and address the world’s leading causes of illness, injury and death. We currently work in 73 countries, supporting data-driven decision making in government, advancing evidence-based public health policies, and mounting strategic communication campaigns. Vital Strategies’ priorities are driven by the greatest potential to improve and save lives. They include non-communicable disease prevention, tobacco control, road safety, obesity prevention, overdose prevention, environmental health, vital statistics systems building and multidrug-resistant tuberculosis treatment research. Our programs are primarily concentrated in low- and middle-income countries in Africa, Latin America, Asia and the Pacific; the Overdose Prevention Program is our first initiative in the U.S. Please visit our website at www.vitalstrategies.org to find out more about our work.

Vital Strategies is committed to building a diverse, equitable and inclusive (DEI) organization. We believe our programs are strengthened when they are developed and supported by individuals with diverse life experiences, whose understanding of social and cultural issues can help make our work and workforce more inclusive. We welcome applications from people of all backgrounds and do not discriminate on the basis of race, color, religion or creed, gender, national origin, ancestry, actual or perceived age, physical or mental disability, veteran or military status, marital status, sexual orientation, predisposing genetic characteristics, alienage or citizenship status, gender (including gender identity or expression), partnership status, arrest or conviction record, status as a victim of domestic violence, status as a victim of sex offense or stalking, or any other basis protected by local, state, or federal laws.

Read about Diversity, Equity and Inclusion and Vital Strategies: https://www.vitalstrategies.org/diversity-equity-and-inclusion-at-vital-strategies/

Job Purpose

The Data Analyst will collaborate with leadership across all programs within the Public Health, Environment/Climate/Urban Health, and Finance Divisions to identify, analyze, and convert existing programmatic and financial data into powerful reports and visualizations that enable analysis for decision-making in a timely manner. Under the supervision of the Director for Grants and Administration and as part of the Grants Management and Administration team, the Data Analyst will work with Power BI to develop and maintain reports and budget monitoring dashboards. The incumbent will be trusted to develop the appropriate data accession, normalization, and programming structure to enable reporting in Power BI and to develop visually useful dashboards. to respond to divisional needs and optimize divisional use. 

This is a full-time position based in our New York office, where a hybrid, 2-day-per-week office schedule is in place. Vital Strategies offers highly competitive compensation and comprehensive benefits. The salary range for this position is $105,000 USD to $115,000 USD. The candidate must have authorization to work legally in the US at the time of hire.

Duties & Responsibilities

• Oversee budget management dashboard development, forecasting, and maintenance across many distinct data sources, including the full-stack development of budget monitoring dashboards from data back-end (adapting, designing, and implementing data models, data tables, data pipelines, etc.) to user-facing front-end (user interfaces, dashboards, reports, tools, and visualizations) rendering.
• Serve as internal consultant providing data-based recommendations and guidance to program leadership, and stakeholders in the areas of budget management/forecasting and programmatic data monitoring/evaluation/reporting via Power BI.
• Work with the Grants Team, other division leaders, and staff within the organization as a Subject Matter Expert to assess data needs, troubleshoot issues with existing dashboards, and oversee identified design and data development issues.
• Proactively meet with program staff to discern business problems and derive required reporting and dashboard requirements. Map out and develop dashboards, and any relevant back-end structures, based on business analysis.
• Using data design best practices, collaborate with program staff to adapt and refine existing dashboards, reports, and tracking tools from other platforms (NetSuite, Excel, Smartsheet, etc.) into automated dashboards using data visualization and analysis tools like Power BI.
• Perform data manipulation and cleansing to prepare datasets for implementation, reviewing for trends and patterns to draw conclusions, automate data flows, and improve data quality.
• Works closely and collaboratively with program staff and other stakeholders to increase user adoption by enabling program staff to make efficient use of the reports and dashboards, providing technical support, guidance, training, and addressing any issues that may impede optimum usage.
• Leads in the application of validation and QA efforts as they pertain to reporting, data, dashboard creation and execution, and dashboard quality.
• Work with Grant Managers to complete quarterly reconciliation of accounting monthly close reports, submitted donor reports, and Power BI to ensure accuracy across all mediums.
• Create processes and procedures to help the Grants Team streamline the completion of commonly requested and donor report generation for program inquiries.
• Ensure proper configuration management and change controls are implemented utilizing best practices in business intelligence and dashboard development.
• Develop best practices, documentation standards, processes, and procedures for dashboard design and publishing, creating flowcharts and diagrams as required.
• Monitor Power BI Service usage, and capacity in order to make recommendations for performance tuning, implementing performance improvements as appropriate.
• Other duties as assigned by the Director.

Qualifications

Education & Degree

•    Bachelor’s degree in data science or data Analytics preferred.

Skills & Abilities

• Knowledge and direct experience using Power BI (DAX functions, Power Query/M formula language).
• Advanced understanding of database management system technology and architecture.
• Technical expertise regarding data models, database design development, data mining, and segmentation techniques.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Ability to effectively communicate with a range of stakeholders.
• Ability to build strong, ongoing, impactful relationships at all organizational levels and across a diverse range of cultural, generational, ethnic, racial, educational, and social backgrounds.
• Demonstrated commitment to valuing diversity and contributing to an inclusive working and learning environment.

Experience Required:

• Minimum 8 years of related work experience;
• Experience with data management, data visualization, and statistical systems
• Experience using Power BI (DAX functions, Power Query/M formula language),

Experience Preferred:

• Knowledge and direct experience using NetSuite;
• Knowledge and direct experience using related components of the Microsoft Power platform (i.e., Power Automate, Power Apps).
• Programming experience with scripting languages (Python, R, etc.) for data analysis and visualization.
• Experience writing and reviewing SQL queries in any dialect.
• Interest and/or experience in grants management.
• Prior experience working in non-profit, grants, or finance sectors.