Tupande Data Engineer at One Acre Fund

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