Intern, Data Analyst

If you are motivated by working with an innovative fund manager mandated to deliver positive climate change and development outcomes across emerging markets, and if climate change and human development remain issues central to your worldview, and important considerations in your future career aspiration we would like to hear from you. Play an active part in creating a sustainable future by joining Climate Fund Managers Finance team, as a Data Analyst Intern, based at our Africa office in Claremont, Western Cape, South Africa.

Climate Fund Managers (CFM) is a leading blended finance fund manager dedicated to securing a sustainable future by investing across global emerging markets. CFM has a long-term vision to structure cutting edge financing facilities around thematic areas of climate change mitigation and adaptation, including renewable energy, water, sanitation, and oceans. CFM is established as a joint venture between the Dutch development bank FMO and Sanlam InfraWorks – part of the Sanlam Group of South Africa.

We provide financing solutions across the entire project lifecycle (development, construction, and operational stages). With our offices in The Netherlands, South Africa, Singapore, and Latin America we believe in a world where sustainable investing and profitability are not mutually exclusive.

The successful Data Analyst Intern will support the CFM finance team in its efforts to design a workflow app within PowerApps environment to collect and retrieve information at will, relating to a workflow execution of a business process.

Outlining projects’ rationales:

Project: Automation of summarizing legal agreement requirements

Rationale:

Automate the agreements matrix that involves creating an application that allows easy searching on a periodic or event procedure and linking that to the workflow in a team.

Project: Automation of the Know your supplier process

Rationale:

Automate the Know your supplier process that involves a defined workflow with multiple parties contributing information based on the Procurement Policy.

Project: Automation of the Transaction Route Map process

Rationale:

Automate the sequential stages of the Transaction Route Map Process based on the defined workflow with multiple parties contributing information.

General functionalities of a workflow app:

Automated workflow management in adherence with the documented process, such that mandatory steps are not missed

Required support attached and readily available: Ability to track stage of the workflow, preferably with a visual component; Create data connection such that information flow allows for inflow and outflow from Dataverse to:

1. Microsoft dynamics
2. ExpensePoint
3. iLevel
4. Power BI for visualizations

Components to developing a workflow app:

Collect users’ feedback on app design requirements

Create a Canvas app in Power Apps: create an appropriate table design in Dataverse, such that information is correctly and efficiently stored and can be easily retrieved for data manipulation; design front-end look of the app; create JavaScript functions for simple data management tasks, create Microsoft Flows for the complex data manipulations**- Special focus should be on maximizing efficiency of execution time - a**utomated tests using JavaScript

Qualifications and Experience

• Very good working knowledge of the MS Office suite
• High proficiency in JavaScript, Python, Power Query, Power Bi
• Good data extraction, analysis, manipulation, database design and report writing skills
• A passion for wanting to learn new things and to grow within the business
• Provide solutions that can be easily interpreted and acted upon by management and users
• Able to communicate with various internal and external stakeholders