Senior Data & Reporting Analyst

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