Senior Business Intelligence Data Analyst (10-month contract)

ABOUT MASTERCARD FOUNDATION

Mastercard Foundation seeks a world where everyone has the opportunity to learn and prosper. Through its Young Africa Works strategy and Canadian EleV program, the Foundation works with partners to ensure that millions of young people, especially young women, access quality education, financial services, and dignified work. Mastercard Foundation was established in 2006 through the generosity of Mastercard when it became a public company. The Foundation is independent with its own Board of Directors and CEO.

THE WORK AT THE FOUNDATION

We are currently in an exciting period at the Mastercard Foundation as we intensify the implementation of the Young Africa Works strategy, aiming to empower 30 million young people throughout Africa to access dignified and fulfilling employment.

To ensure the Foundation's accessibility to our partners and program participants, we have established offices in Rwanda, Kenya, Ghana, Senegal, Ethiopia, Nigeria, and Uganda. These offices provide strong in-country support for the implementation of Young Africa Works. We collaborate with governments, the private sector, educators, and other funders to enhance the quality of education and vocational training, equip young individuals with the necessary skills for the workforce, expand access to financial services for entrepreneurs and small businesses, and facilitate connections between job seekers and meaningful employment opportunities.

Our values serve as our guiding principles, transcending and surpassing all other considerations. We wholeheartedly encourage you to bring your bold ideas, curiosity, and expertise to your work.

If you are an experienced professional in Data Analytics looking to increase your impact, read on!

THE OPPORTUNITY 

Reporting to the Business Intelligence Operations Lead, the role will be responsible for executing reporting and data requests by pulling, structuring, analyzing, and organizing data outputs.

WAYS YOU CAN CONTRIBUTE 

• 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).
• 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, Knowledge Management) to ensure ongoing robust data quality control and intake.
• Maintain data privacy standards and protocols.
• Manage data equity issues necessary (e.g., addressing data biases, data ownership, and collection methods.
• Determine protocols and infrastructure necessary for data collection, validation, storage, structure, retrieval, and utilization to help build out the function.
• Assess business questions and develop prototypes of the front-end solutions to fit each business question & ensure efficient performance of the solution.
• Create a data transformation list for each 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 visualizations using a pre-aligned set of tools and automating data ingestion processes.
• Enhance data sets by creating automated match rules and 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.
• Analyze, plan, and develop requirements and standards for 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 and engaging with the requestor(s) to refine the understanding of the business needs underlying BI requests and tailor outputs to meet needs, iterating as necessary.
• Champion the use of data and improve data literacy through education of Foundation staff.
• Provide support to the program team with external data collection activities from time to time if needed.

WHO YOU ARE

• Bachelor’s degree in Data Science, Data Analytics, Social Sciences, Data Visualization, SQL, and Data Engineering.
• 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, and processes and experience driving the adoption of BI tools.
• Experience monitoring and maintaining data quality utilizing best practices.
• Familiarity with the most common modes of preparing and presenting data insights (e.g., PPT, Word, e-mail, SharePoint).
• 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 the 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 audiences, and nuances of how to prepare and present data outputs for different uses.
• Ability to flexibly engage other analytics capabilities within the organization (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 ongoing 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
• Strong self-direction balanced with a 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.
• Flexible, adaptable, and able to execute a range of job duties in response to dynamic needs.
• Possess excellent verbal, written, and presentation skills with the ability to articulate information to a variety of constituents across cultures.
• Possesses a global mindset and professional maturity and demonstrates sensitivity to working within different cultures.
• You have a commitment to Mastercard Foundation’s values and vision.

Deadline for Applications is April 11, 2024.

Mastercard Foundation (the “Foundation”) values and respects your privacy. By submitting an application for this opportunity, you hereby agree to the Foundation’s collection, use and disclosure of your personal information in accordance with its Privacy Policy (available at https://mastercardfdn.org/privacy/). Please note that the Foundation may share your personal information with third-party agencies that support the Foundation’s recruitment activities, and such third-party agencies may contact you directly regarding this opportunity. If you have any questions or concerns, please contact the Foundation’s Privacy Officer at the address indicated in its Privacy Policy.

The Mastercard Foundation values the unique skills and experiences each individual brings to the organization and we are committed to creating and maintaining an inclusive and accessible environment for everyone.

Completion of satisfactory business references and background checks are essential conditions of employment.

For more information and to sign up for the Foundation’s newsletter, please visit http://www.mastercardfdn.org/
Follow the Foundation on Twitter at @MastercardFdn

NB: To avoid missing email communication about your application, please check your spam/junk folder and mark our emails as "not junk".