Agriculture is the key to unlocking a better future for billions of people. But while rural families sustain the world, they struggle to sustain themselves. At the same time, they face increasingly urgent challenges, from volatile crop prices to extreme weather.

Root Capital is a social impact investor that provides financing and business training to agricultural enterprises so that they can transform rural communities. We work with enterprises in the "missing middle" of agricultural finance: those whose credit needs are too big for microfinance and too small or risky for commercial banks.

Since 1999, we have loaned over $1.9B to more than 800 businesses and we have trained more than 1,800 ones-improving the lives of 10 million people. As these agricultural businesses succeed and scale, they become engines of impact for their local communities, raising incomes, creating jobs, uplifting women and young people, preserving vulnerable ecosystems, and building rural prosperity.

Headquartered in Cambridge, Massachusetts, Root Capital currently works in a dozen countries in Latin America, Africa, and Southeast Asia, and has staff in Costa Rica, Mexico, Nicaragua, Colombia, Peru, Ghana, and Kenya.

Proud winner of the 2024 SCA Sustainability Award for Non-Profits.Learn more here.

The Advisory Services Department provides technical and support services in Digital Business Intelligence Advisory through Root Capital's Cultivar Data Platform. Critical to achieving the organization's mission, the Cultivar Data Platform is a tool for small and growing agribusinesses that allows digitalization and integration of various data sources for analysis, and decision-making to improve their businesses and livelihoods of the producers leading to sustainable agriculture.

The Cultivar Data Engineer designs and implements new business requirements and improvements primarily within the data warehouse, as well as making significant contributions to ETL (extract, transform, load) processes that support data analysis and reporting. In this role, the Data Engineer would be responsible for end-to-end implementation of data warehouses using the Snowflake platform, providing support for integration and ETL processes using Alteryx, and support for data visualization tools such as PowerBI and Tableau. Collaborating with IT Operations Manager and DBI Systems Admin is critical in delivering high-quality data solutions facilitating agribusiness digital transformation that enables Root Capital to achieve its mission of championing sustainable agriculture.

Analyze (60%)

Conceptual: Depth of knowledge of processes

• Analyze and assess business requirements from various stakeholders and to ensure that information informs the design and structure changes of the data platform, including data pipelines, processes, and visualization in tools such as Tableau, PowerBI and Excel.
• Identify security and access controls issues in the design of data warehouses and data pipelines and implement improvements to ensure the integrity and security of data.

Applied: Application of concept into transactions/projects

• Design and maintain Extract, Transform, Load (ETL) processes (primarily in Alteryx) and SQL procedures and queries (primarily in Snowflake) based on new business requirements and opportunities for process improvement to optimize performance and efficiency of the data platform.
• Lead and initiate development and maintenance of automations, scripting tools (primarily using Python), stored procedures, REST API and JSON by providing insights to improve ETL pipelines.

Collaborate (20%)

Internal: Internal team communication

• Engage Root Capital teams during the design of the data warehouse, data pipelines, automation and scripting tools to ensure that these address business requirements and client needs.
• Advise users, data analysts, and technical liaisons on incoming data quality control best practices to optimize the use of the data warehouse.

External: External communications with clients and collaborators outside of the team

• Collaborate with data analysts, developers, and technical liaisons during development of enterprise data warehouse to implement solutions that address data issues and client needs.

Manage the Project Cycle (20%)

Timeliness: Delivery against timeframes and internal coordination, and the deployment of resources

• Assess data systems and processes to simplify and streamline operational and technical workflows and ensure quality and integrity of data.
• Review and set standard response times to resolve technical issues, ensuring timely resolution of issues and mitigate adverse impact to Root Capital operations.

Quality: Improving and strengthening quality standards and performance against established metrics

• Optimize data platform documentation structure and processes to align with Root Capital standards, and create and maintain technical documentation to ensure accessibility and clarity for multiple team members to support effective maintenance and future development of all related systems.
• Review data systems, policies, and processes consistently to ensure compliance with legislation and alignment to Root Capital data governance and security standards, and recommend innovations to the tech stack based on this review and identified client needs.

Previous Relevant Experience Required

• SQL (Snowflake preferred), postgresql.
• ETL/ELT pipeline development (Alteryx preferred).
• Scripting (Python, Javascript).
• Experience with data visualization tools such as Tableau or PowerBI.
• Familiarity with data modeling and design principles.
• Exposure to data governance frameworks and practices.
• Data management and integration experience.
• UI/UX experience (Delphi, Kotlin, C++) preferred.
• Exposure to Microsoft Azure App Service/Web Application hosting preferred.

Knowledge, Skills, and Requirements

• 3-5 years of relevant experience or in a related role and University Degree in Computer Science, Information Technology or any related field.
• Experience with data governance frameworks and familiarity with data modeling and design principles.
• Experience serving rural, underserved communities desirable/preferred.
• Must be authorized to work in one of the following countries: Peru, Mexico, Costa Rica, Nicaragua, Honduras, Colombia, USA, or Kenya.
• Root Capital is a bilingual organization. Fluent in spoken and written English. Spanish is recommended.
• Elite customer service orientation.
• Ability to interface with technical and non-technical stakeholders.
• Strong and creative problem-solving skills, responsiveness, pride in work, and enthusiasm for innovation through technology.
• Self motivation and desire to excel.
• Enthusiasm for working in a multicultural environment; experience in a global and multi-location work environment is highly desired.

• Committed to prioritizing diversity, equity, and inclusion and embracing transparency and authenticity in daily work life.
• Proactive approach to problem-solving with demonstrated decision-making capabilities.
• Strong attention to detail and the ability to manage multiple projects simultaneously and adapt to a dynamic environment.
• Experience working and communicating in a remote environment.
• Committed to practicing and supporting wellbeing and a work-home life balance.
• Passionate about Root Capital mission.
• Flexibility to travellocally or regionally is required according with the nature of the role, including the possibility ofvisiting clients in rural areas.

More information about Root Capital is available atwww.rootcapital.org. Applications are accepted on a rolling basis. Candidates are encouraged to apply using the form below as soon as possible, making sure to include a resume and cover letter that describes your interest, qualifications, language abilities, salary requirements, and how you learned of the position. Finalist candidates will be required to provide at least three work-related references.

U.S applicants:Root Capital Inc. participates inE-Verifyand will provide the federal government your I-9 information to confirm that you are authorized to work in the U.S. For more information,see here. Learn more about yourright to work.

Root Capital provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, creed, religion, sex, national origin, ancestry, active military or veteran status, age, physical or mental disability, medical condition, pregnancy (which includes pregnancy, childbirth, medical conditions related to pregnancy and childbirth, and breastfeeding and expressing breast milk), sexual orientation, gender, gender identity, gender expression, genetic information, or any other characteristic protected by law. Root Capital is committed to creating a dynamic work environment that upholds our leadership principles of: empowerment, equity, integrity, service, and transparency.