Terms of Reference: Data Consulting Engineer – Ethiopia


Terms of reference

Data consulting engineer

August 2022

Who we are

We are a global non-profit creative organization combining expertise in media, mobile, brand and international development, a unique blend of skills we use to solve global problems in new ways. Launched by the Nike Foundation in 2004, we are now an independent organization working from nine global locations in over 50 countries where girls are marginalized and vulnerable, focusing on Africa and Asia.

We use our deep understanding of girls’ real needs so they are empowered to make choices about their health, education and economic future. We use multiple touchpoints for storytelling and brand participation that millions of girls and boys love and interact with – from apps that build skills to TV series that explore life-saving issues to magazines written and distributed by girls.

We help girls change their lives by challenging social, cultural and gender norms – leveraging digital technologies to create change through creative content that engages and entertains audiences – designed to change and shift attitudes , knowledge and behaviors in a tangible and measurable way.

Our work is supported and funded by a wide range of people and organizations, from governments and philanthropists to NGOs and businesses. Recent examples include GAVI (The Vaccine Alliance), Bill and Melinda Gates Foundation, Facebook, UNICEF, Children’s Investment Fund Foundation (CIFF), Vodafone Foundation, Australian Department of Foreign Affairs and Trade (DFAT) , Nutrition International and the United States Agency. for International Development (USAID).


For over a decade, we’ve been developing technology that aims to create a safer, more accessible world for women and girls, using the insights and experiences girls share with us. For us, innovation is not necessarily about using the latest technology; it’s about using the right technology in the best way to reach girls and address their challenges.

For example, more recently, and given the number of girls now using messaging apps, we developed two chatbots: Big Sis and Bol Behen, live on Facebook Messenger and WhatsApp. Big Sis is our AI-powered chatbot that provides girls in South Africa with safe, private and non-judgmental information about topics they don’t feel comfortable discussing elsewhere, like sex and STIs . And Bol Behen (meaning “Speak! Sister”) answers questions from girls on sensitive topics like relationships and reproductive health living in India’s Hindi belt.

As technology evolves and girls’ habits change, we continually strive to adapt and improve the platforms, processes and infrastructure that underpin everything we do.

What we are looking for:

We have recently entered an exciting new period in our technology development – growing our in-house technical team, building relationships with new technology vendors and migrating our technology to new homes.

Our data infrastructure plays a critical role in this new technology ecosystem, providing us with evidence, guidance for our decision-making, and insight into our impact.

We are now looking for a consultant to help us manage our data infrastructure to meet the challenges and maximize the opportunities of our growing technology ecosystem, especially our chatbots.

Working closely with the Girl Effect technical team and our external vendors, the person can provide us with expert advice on maintaining and optimizing the current data visualization tools we use at Girl Effect in our chatbots and our programs and products more broadly.

Requirements will include, but not be limited to, proactively monitoring data pipelines, debugging any issues with the availability of our Tableau dashboards, and consulting with Girl Effect team members to implement the data requests.

Key areas described:

  • Developing Tableau Dashboards
  • Understand and help meet our data visualization requirements, including developing Tableau dashboards and managing users through Tableau Online
  • Monitoring of all data infrastructure
  • Monitor and raise concerns in ETL pipelines
  • Monitor AWS Infrastructure
  • Monitor Tableau infrastructure
  • Other
  • Keep abreast of trends and developments in the field of data and data technology and share them with the team as appropriate.
  • Provide information on new changes to chatbot development more broadly
  • Extract data from database and share with users
  • Apply exceptional levels of security to our data and protocols

Expected commitment

This will be a three-month part-time consultant contract, subject to renewal depending on future needs. The consultant must commit a minimum of 40 hours per month (i.e. 10-12 hours per week), which may vary depending on our budget and your fees.


The consultant will be remote and must be willing to work with teams in the UK, USA, Brazil, Sub-Saharan Africa and India.

Planned schedule

  • Specifications published: August 19, 2022
  • Response deadline: August 26, 2022
  • Selection of suppliers, contracting and briefing: end of August 2022
  • Project start: September 2022


This position will be managed by Girl Effect’s Chief Technology Officer, who will work with the successful consultant to ensure its timely and thorough execution.

Who are you

Skills and know-how:

  • B.Tech/BE/M.Tech Diploma
  • Minimum 5 years of technical and practical knowledge and experience in data warehousing, databases and ETL pipelines
  • Mastery of Python
  • SQL proficiency
  • Experience in Tableau development or equally relevant experience with similar tools
  • 2+ years of experience in AWS (lambda, redshift, ECR, API Gateway)
  • Working knowledge of Github, Docker and APIs
  • Understand how a chatbot works

Proposal submission

Interested consultants are requested to submit the following in support of their application (Max 5-10 pages):

  • Your understanding of the brief and why you feel well placed to advise us on it
    • Showcase any previous relevant work experience
  • Contact details of three referents who can attest to the scope and scale of similar assignments
  • CV with cover letter
  • Proposed consulting fees

Evaluation criteria

The criteria against which proposals will be evaluated are listed below:

Technical evaluation

  • Interpretation and understanding of this TOR-10%
  • Staff with relevant experience as evidenced by their CV – 20%
  • Technical leadership experience – 10%
  • Demonstrated technical knowledge in the field of software development – 20%
  • Proof of a minimum of three contactable references – 10%

Financial evaluation

  • Value for money/proposed budget allocation – 30%

Technical and financial proposals should be submitted in separate documents. The financial offers will not be opened before the technical evaluation and only for the proposals deemed qualified and compliant.

Please note that Girl Effect is not responsible for any costs incurred while preparing the award/contract, submitting or negotiating the award/contract. All materials and/or materials submitted will become and remain the property of Girl Effect.

The VALIDITY of the proposal will be 90 days from the closing date of submissions.

Equal opportunities

Girl Effect is committed to equal opportunity regardless of race, color, ancestry, religion, gender, national origin, sexual orientation, age, marital status, disability, sex, gender identity or expression. We are proud to be an equal opportunity workplace.

We are committed to building an organization that is truly representative of the communities we serve. To this end, due consideration will be given to obtaining consultancy services from organizations and individuals with in-depth understanding and experience of our programming markets and from diverse professional, academic and cultural backgrounds.


You may be required to perform backup checks. Shortlisted consultants will be assessed on our organizational values ​​at the interview stage. The successful consultant will be required to adhere to our Safeguard Policy. We encourage you to read and understand our backup policy, a summary of which can be found here. We have zero tolerance for all forms of violence against children, beneficiaries and staff.


Applicants are advised to ensure that they have a clear understanding of their tax situation with respect to the provisions of the tax laws of their local jurisdiction when developing their proposals.


GE reserves the right to determine the structure of the process, the number of shortlisted participants, the right to withdraw from the proposal process, the right to change this schedule at any time without notice, and reserves the right to withdraw this offer at at any time, without notice and without obligation to indemnify and/or reimburse any party. GE will notify the ONLY successful candidate(s). The process of negotiating and signing the contract with the successful candidate(s) will follow.

How to register

How to register

Please submit proposals, as described below, to[email protected] no later than August 26, 2022, 11:59 p.m. SAST. Please clearly mark your email with the subject ‘Data consulting engineer


Comments are closed.