Tupande Data Engineer at One Acre Fund

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 into 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

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

Application Deadline: 23 April 2023