Senior Data & Reporting Analyst

WAYS YOU CAN CONTRIBUTE

Data Analytics

• Conduct basic data analytics as necessary for reports and internal needs
• Collate, structure, and enable integration of multiple different types of data sets for analyses
• Provide ad hoc support for data analytics requests (e.g., aggregation, disaggregation, pivot tables)

Data Quality and Information management

• Monitor and maintain data for quality, completeness, and structure for optimal utilization
• Maintain knowledge of what data the Foundation has and where / how it is stored
• Maintain knowledge of relevant external data sources that are most heavily utilized by the Foundation (e.g., where to go to retrieve, limitations and characteristics of the data, periodicity of updates, levels of quality, etc.)
• Ensure adherence to data dictionary, definitions, and governance protocols
• Engage with counterparts in functional teams (e.g., Programs, Impact, Finance, IT, KM) to ensure on-going robust data quality control and intake
• Maintain data privacy standards and protocols
• Manage data equity issues necessary (e.g., addressing data biases, data ownership, collection methods
• Determine protocols and infrastructure necessary for data collection, validation, storage, structure, retrieval and utilization to help build out the function

Program Performance and Strategic Insights

• Delivering program performance Decks for board and leaderships discussion
• Delivering Strategic Insights papers on Foundation's key investment areas and Impact analytics for leaderships strategic decision.

Reporting & visualization

• Assess business questions and develop prototypes of the front-end solutions to fit each business question & ensure efficient performance of the solution
• Create data transformation list for each of the visualization and work with the BI Back-End Developer to decide where to execute the said transformations (back-end or front-end) and develop the solution accordingly
• Advise on the ETL (Extraction, Transforming, Loading) data process required to reach user-defined objectives in visualizations
• Develop the visualizations using pre-aligned set of tools

Data Engineering

• Automating data ingestion processes
• Enhance data sets by creating automated match rules
• Automating data pre-processing, cleansing and verifying the integrity
• Optimizing Big Data system performance for data pre-processing and Machine Learning algorithms running, including code optimization, Map/Reduce fine tuning, etc.

BI Project Management & Capacity Development

• Analyze, plan and develop requirements and standards in reference to scheduled projects
• Establishes and implements project communication plans, providing status updates to affected staff and stakeholders.
• Managing change requests from the users and managing the versioning / release schedule of the solution
• Monitoring the solution usage

Business Partnering

• Engage with requestor(s) to refine understanding of the business needs underlying BI requests and tailor outputs to meet needs, iterating as necessary
• Lead and Facilitate Program Performance and Stewardship Council sessions
• Champion the use of data and improve data literacy through education of Foundation staff
• Provide support to program team with external data collection activities from time to time if necessary

WHO YOUR ARE

• Strong comfort with, and experience in, retrieving, structuring, analyzing, and visualizing data across most well-establish data analytics platforms (e.g., Tableau, PowerBI, R, Advanced Excel)
• Familiarity with complex data structures and tasks, procedures, processes to maintain
• Experience monitoring and maintaining data quality utilizing best practices
• Familiarity with most common modes of preparing and presenting data insights (e.g., PPT, Word, e-mail, SharePoint)
• Experience driving adoption of BI tools
• Demonstrated full toolkit of data management and analytics (e.g., cleaning, structuring, validating, correlations, regressions, statistical analyses, advanced analytics)
• Ability to work with complex data sets and understand how to transform and combine disparate data to enable effective analytics
• Ability to translate data insights and outputs into appropriate, consumable formats (e.g., PowerPoint, Word, e-mails, SharePoint, Prezi)
• Ability to retrieve data from data warehouses using SQL queries
• Ability to business partner with requestors to clarify substance of requests; act with a “Service mindset,” and strive to become a trusted partner
• Understand use case methodologies, how data insights are utilized by different audience, nuances of how to prepare and present data outputs for different uses
• Ability to flexibly engage other analytics capabilities within the org (e.g., Impact) and outside the org (e.g., Impact Partner Organizations) to execute against co-owned deliverables
• Self-directed and requires minimal guidance to produce most on-going reporting, data analytics, and visualization outputs
• Resilience and flexibility to maintain productivity through shifting priorities, parameters, rapidly changing context, and across time zones and geographies
• Resilience and persistence to ask the right questions, clarify requests, and iterate as necessary to provide the right outputs
• Solid judgment on prioritizing requests and seeking guidance when appropriate
• Listening actively to understand needs and provide constructive/receive feedback
• Aptitude for and keen interest in learning new information design and communication technology
• Resilient, intrapreneurial and flexible mindset comfortable working in a dynamic and ambiguous environment
• Strong self-direction balanced with collaborative and creative approach
• Meticulous detail-orientation and track record of delivering timely results under pressure
• Service mindset for responsiveness to requests and striving towards becoming trusted business partners to drive common Foundation goals
• Exceptional communication skills to support a culture of change  
• Professional maturity, cultural sensitivity, impeccable integrity in alignment to Foundation mission and values