Junior Data Analyst/Developer

YOUR POSITION WITH TNC

Housed within The Nature Conservancy's Resilient Watersheds Strategy, the Nature for Water Facility ('N4W') is a technical assistance outfit that provides hand-in-hand support to local champions seeking to develop watershed investment programs ('WIPs'). Since its inception in early 2022, N4W has worked with 35+ prospective and existing WIPs worldwide to help them define, structure, and launch their local programs. N4W also provides funding for pilot activities and scale-up support to selected WIPs. For additional background on N4W, please see the About, Services, and Portfolio sections of the N4W website.

The Junior Data Analyst/Developer will be a critical part of N4W's Program Intelligence team, focusing on building and managing our data collection, processing, and analysis pipelines. The Program Intelligence platform enables N4W to gather and make sense of diverse information from a range of on-the-ground partner programs (Partners) and thereby produce relevant intelligence findings that support those Partners' effectiveness and growth, as well as focus on where investments can maximize long-term conservation impact.

The location for this position is flexible within countries in North America, Latin America, the Caribbean, Africa, and Europe where The Nature Conservancy is a registered NGO and has an established office (in North America these are USA, Canada; in Latin America these are Argentina, Belize, Brazil, Chile, Colombia, Guatemala, Mexico, Peru; in the Caribbean these are The Bahamas, Dominican Republic, Grenada, Jamaica, Puerto Rico, U.S. Virgin Islands; in Africa these are Angola, Gabon, Kenya, South Africa, Tanzania, Zambia; in Europe these are Croatia, Belgium, Germany, and the UK). Salary ranges will vary depending on the selected candidate's location.

ESSENTIAL FUNCTIONS

N4W's Program Intelligence team is focused on understanding (1) what kind of impact we are helping drive on the ground, (2) what we are learning from individual Partners that can be mainstreamed across our N4W team, TNC, and the broader water sector; and (3) where N4W and TNC should be strategically investing to maximize impact over the long term. Our systems also provides the operational reporting and day-to-day analytical needs for our Partners to be able to confidently raise, effectively deploy, and appropriately report on multi-million dollar funding streams.

The key focus for this Junior Data Analyst / Developer role will be supporting the expansion and management of a central Program Intelligence system which uses KoboToolbox, ArcGIS online, Python, and the Databricks Platform to ingest, store, and process data, and then visualizes outputs in Tableau and Power BI. The functions and outputs of this Program Intelligence system are critical for several parties, such as Partners, funders, TNC leadership, and N4W scientists and economists. Many of these parties receive bespoke output tables or dashboard visualizations from the system, which the Junior Data Analyst / Developer will help build. For example, these include N4W's 'Impact Dashboard', which is used to report to funders, and 'Decision Support Systems', which are used by Partners.

The Junior Data Analyst / Developer will also work closely with N4W colleagues who use tools such as SageMaker, MATLAB, and Microsoft Excel to provide key inputs to the Program Intelligence system. The Program Intelligence team includes one full-time senior developer, a team lead, N4W's science technical director, and several other N4W colleagues who contribute to Program Intelligence with between 20-40% of their time.

RESPONSIBILITIES & SCOPE

• [Back-end] Ensuring smooth alignment with, and integration of, data capture and storage systems, templates and procedures.

• [Processing] Building and managing data processing pipelines, primarily using Python code within Databricks, to update and analyse data.
• [Front-end] Owning the building and updating of visualization suites using Power BI or similar software, as well as
• [Maintenance] Helping troubleshoot bugs across the entire Program Intelligence platform, maintaining high levels of data quality, and adding or updating features for existing processes as required.
• [Continuous Improvement]: Thinking systematically across all the programs supported by the Program Intelligence Platform and identifying ways to streamline or improve upon the existing build.

Because of the geographic distribution of other core team members, t