About the Role
One Acre Fund plans to serve 10 million farmers by 2030. To reach this goal, leaders across all of our business units need access to timely and actionable data. As a member of the Business Intelligence (BI) team, you’ll partner with leaders across the organization to identify strategic opportunities for data to drive value for our farmers. You’ll work with members of the tech division and data engineers to build our data warehouse, create datasets, and design dashboard and reporting solutions. You’ll become an expert on our data and its source systems through your work. At the root of it, you will identify the most effective ways to get data into the hands of decision-makers with the highest possible value addition; and then you’ll do it from start to finish.
As a successful candidate, you’ll be comfortable building relationships in a multi-country, cross-cultural environment and enjoy the challenge of designing global solutions that work in unique and complex local country contexts. You’ll work with both technical and non-technical peers. We’re looking for someone who will love working with data and seeing the results improve the lives of millions of farmers.
Responsibilities
Create an ETL package to pull impact data into our warehouse; perform transformations to create project-specific datasets, and design a portal to share with external researchers
Strategically expand self-service BI, empowering users across all teams to access data directly – we believe in getting data in the hands of those who know it best
Identifying data gaps within the Kenya program. Then designing pipelines to pull the data from source systems into our data warehouse, perform transformations and make it available to data analysts/scientists
Optimize SQL queries to improve report performance
Create a UAT strategy in coordination with our stakeholders; drive testing requirements for a new dataset in the data warehouse; and build confidence in the accuracy of our data across the organization
Career Growth and Development
We have a strong culture of constant learning and we invest in developing our people. You’ll have weekly check-ins with your manager, access to mentorship and training programs, and regular feedback on your performance. We hold career reviews every six months, and set aside time to discuss your aspirations and career goals. You’ll have the opportunity to shape a growing organization and build a rewarding long-term career.
Qualifications
Across all roles, these are the general qualifications we look for. For this role specifically, you will have:
Bachelor’s degree in computer science, mathematics, economics, statistics, finance, or a related technical field
3+ years of work experience or equivalent skills
Technical knowledge:
BI platforms: preferably Power BI; Superset, Metabase
ETL: building and testing ETL packages in SSIS, Jupyter notebooks, Kafka, Spark etc
SQL:write complex, optimized queries with large relational datasets
Programming Languages: Python, R
Data Warehouse/Lake solutions: MSSQL, Snowflake, Azure Data Lake
Data Modeling: SQL and NoSQL data
Documentation
Project management and collaboration skills
Fluency in English required
Apply via :
eacrefund.org
