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 YOU 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
Interested and Qualified Candidates Should Apply Here
Ameenah Hassan
Ameenah Hassan is a content writer with experience in public relations. She has contributed to Arbiterz since 2021, writing research-based news and features on business. She is currently pursuing a degree in Mass Communication at the University of Lagos.
