Power BI expert at Proforest Africa

Proforest is a mission driven organisation with a 20+ year track record of supporting the transition to sustainable production and sourcing of agricultural and forest commodities. We are a not-for-profit group with a global presence across Latin America, Africa, Europe and Southeast Asia, and work with governments, the private sector and civil society to deliver positive outcomes for people, nature and climate in the places agricultural commodities are produced.

Our clients are well-known consumer brands, such as Unilever, Nestlé, PepsiCo and Mars, and some of the world’s largest traders and integrated producers including Cargill, Olam, Wilmar and Cofco. We combine our consultancy work with longer-term programmes supported by institutional funders, with all profits re-invested in delivering our mission.

Job Description

Purpose

• Proforest is seeking the services of an individual consultant with expertise in Microsoft Power BI and Smartsheet data integration.
• The consultant must have extensive knowledge and experience with setting up and maintaining multiple sheets connection between Smartsheet and Power BI for real-time updates, using scripts or API.
• S/he must also understand how to create and implement custom reports and dashboards to support our project teams make insightful management decisions with project data.
• Additionally, s/he must be conversant with the best practices for data security and governance when integrating different data platforms.

Responsibilities

• Understand Proforest’s Smartsheet workflows and Power BI visualisations, how these two platforms work together to produce custom reports/dashboards and the limitations of both platforms.
• Coordinate effectively with cross-functional teams from the finance office, projects and programmes to understand their reporting and data needs and incorporate them into the integration.
• Design and implement a data pipeline for extracting, transforming, and loading data from various sources and sheets into a database.
• Ensuring that the data is being pulled from Smartsheet into Power BI in real-time using API or custom scripts.
• Develop custom dashboards and reports in Power BI that pull data from Smartsheet in real-time.
• Test, monitor and optimise the data integration and troubleshoot any issues that may arise.
• Document the data integration and data visualisation process and provide training to users.
• Use Power BI to create dashboards and interactive visual reports.
• Convert business requirements into technical specifications and implement them through reports that support decision-making.
• Establish relationships between data and develop tabular and multi multidimensional data models.
• Design, Development, Testing, providing Power BI scripts, performing detailed analysis.
• Perform DAX queries and functions in Power BI
• Redefining changes to improve existing business intelligence systems and designing technically / strategically
• Creating customized diagrams and user-defined calculations as needed

Required Skills or Experience

• 2-3 years of experience in data-related roles
• Advanced working knowledge and experience with Power BI and Smartsheet
• Excellent understanding of BI and data visualisation
• Technical skills in SQL, Python or R to automate the manual process with data extraction and manipulation are required.
• A demonstration or examples of similar exercises done in the past.
• Experience in working with data from various sources and accounting platforms like Smartsheet, Sage, Salesforce and Concur is desirable.
• Mastery in data analytics