The Business Intelligence (BI) / Data Analyst illuminates and provides insight into the best ways the Food Bank can achieve its mission of feeding people in need and mobilizing our community to eliminate hunger. The BI/Data Analyst is intrigued by data and is curious about the story it can tell stakeholders about the progress we are making. The Analyst will be passionate about evaluating current programs and initiatives using heat-maps, charts, trendlines, and geo location-based map visualizations. The Analyst will also be enthusiastic about data governance, working with IT colleagues to create and maintain documentation for data analysis efforts including requirements, technical design and user manuals. This position reports to the Director of IT & PMO, but works closely with executives, such as the Chief Programs Officer, and other stakeholders within the organization.
Duties and Responsibilities
Provide analytic and consultative support to a broad spectrum of internal customer areas within the Food Bank, in support of our mission:
Provide assistance with and/or lead the interpretation of raw data, statistical results or otherwise compiled information, from internal or external sources.
Gather data from various sources, model the data, develop tools to visualize patterns and trends, and work with key stakeholders to analyze need, trends, and/or evaluate current programs and initiatives.
Present analyzed data via tools such as heat-maps, charts, trendline, and geo location-based map visualizations.
Assist key stakeholders to identify key performance indicators (KPIs) and measurements, and work to put systems in place that can make that information available to the resources that need it.
Assist stakeholders in arriving at data-driven recommendations such as possible new programs that directly impact individuals struggling with food insecurity.
Assist in driving the vision of a data-driven organization to reality by assisting in various data infrastructure and data governance efforts:
Work with other resources within IT, and the rest of the organization, to support and improve the organization’s data policies, procedures and data security guidelines.
Perform requirements analysis for data efforts that feed reports and dashboards.
Create and maintain documentation for data analysis efforts including requirements, technical design and user manuals.
Extract and combine data from multiple data sources for reporting and analysis.
Ability to readily synthesize complex or diverse information into strategic insights.
Separates assumptions from hard evidence in gathering data.
Categorizes information into groups having similar qualities or attributes.
Adept at comparing data from different sources to draw conclusions and choosing an appropriate course of action or solution.
Uses analytical ability to determine how efforts are adding or subtracting value.
Strong data visualization skills using a tool such as Microsoft PowerBI, Tableau or equivalent.
Strong Excel and PowerQuery experience.
Experience utilizing spatial data in analysis and presentation.
Knowledge of statistics and experience using a statistical package for analyzing large datasets (Excel, SPSS, SAS, Python Pandas, etc.).
Ability to understand database relationships and write queries to obtain relevant data for analysis.
Experience in one or more data analysis languages such as Python, R, Data Analysis Expression Language (DAX), or equivalent is a plus (but not required).
Salesforce experience is a plus (but not required).
Planning and Organizing
Able to set realistic expectations.
Works positively and effectively in ambiguous circumstances.
Demonstrates consistent enthusiasm for achieving results.
Skilled at resolving problems by taking action consistent with known facts, constraints, and probable consequences, while being able to apply creativity in finding solutions.
Is quick to identify and put a stop to wasted efforts or efforts that do not produce valuable results.
Able to effectively facilitate discussions and draw out feedback from stakeholders.
Invites opinion from people who have different experiences or perspectives.
Conducts self in a manner that mirrors the mission and core values of the Food Bank.
A bachelor of science or greater in, or related to, Computer/Information Science, Mathematics/Statistics, Economics, Engineering or Operations Research.
Experience and demonstrated proficiency as a Data Analyst, ability to demonstrate equivalent training / experience in a business or non-profit environment with direct responsibility for applying technology.
2 to 4 years relevant experience.
Demonstrated ability to work in a fast-paced environment with multifaceted demands.
Proven ability to successfully handle multiple projects and meet critical
Excellent written, oral communication, and presentation skills.
Ability to obtain clearance of background investigation (Act 33 and 34).
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified.