: Baan Dek Foundation
: Nonprofits / องค์กรไม่แสวงหาผลกำไร
: 758
: 6 September 2023
25 September 2023
ORGANIZATION BACKGROUND
Established in 2002, Baan Dek Foundation (BDF) is a not-for-profit, non-governmental organization with the mission to provide access to essential education, health, and child protection services to disadvantaged children and families living in construction site camps. Through field projects and advocacy activities, BDF aims to improve access to services for the estimated 60,000 children connected to the construction sector in Thailand. BDF’s activities reach over 1,600 children and 10,000 workers in the construction industry per year.
As part of the systemic impact program work, BDF has launched the Building Social Impact (BSI) Initiative, a private sector engagement program to work in partnership with construction and real estate companies to improve the living conditions and access to public services for workers and children living in construction site camps across Thailand. Under this program, BDF has developed a Framework for Action, a set of 12 practical recommendations for companies to undertake in their construction site camps and a Toolkit for conducting self-assessments and developing action plans.
PROJECT BACKGROUND
With funding and support from Kindernothilfe (KNH), a German child rights NGO active in Thailand, and the German Federal Ministry for Economic Cooperation and Development (BMZ), BDF is implementing a 3.5-year project, entitled Building Social Impact in the Thai construction sector, to scale up the systemic impact work and the BSI Initiative. The overall project objective is that up to 14,000 migrant workers use the improved infrastructure in 36 construction camps and start to use public services for themselves and their children. The project area is the Bangkok Metropolitan Region.
The project has four key outputs 1) Camp managers and camp bosses from 12 construction companies apply the BSI Framework for Action and the related BSI Toolkit; 2) Relevant Thai Ministries create an enabling environment for integrating business and human rights principles in the construction sector‘s value chains; 3) Camp managers, camp bosses, camp residents, and the local service providers work together for the access to services for workers and children in the camps; 4) The voices of migrant workers and their children are incorporated into the BSI initiative. This consultancy falls under Output 1.
POSITION SUMMARY
We are seeking an individual with mastery of Google Sheets who can offer their expertise and experience in helping us maintain our Self-assessment tool (SAT), currently hosted on Google spreadsheets.
The SAT is a human rights due diligence tool tailored to assessing risks in construction camps where construction workers and their families live. The framework is based on four areas- Infrastructure, Welfare & Services, Health, and Education. These concepts are rated on a scale (low to critical), tracked on a quarter-by-quarter basis and then tabulated. Camp Management staff can use this Google sheet to assess the camp improvement across all camps under their supervision.
CONSULTANCY DESCRIPTION
Type of Contract: External Consultant for 3 months subject to extension
Department: Systemic Impact Department
Location: Remote work
Expected Start Date: ASAP
ROLES AND RESPONSIBILITIES
Adding, editing and removing rows and ensuring the input of correct and consistent formula for each sheet according to the requirements as provided by the BSI program team
Ensure the application of the appropriate formula for each sheet within the SAT tool
Communication with BSI program team and related technical support to resolve data errors
Maintenance support, occasional bug fixing and clean-up
Timeline
The contract period of the service provider is a 3-month contract working on a deliverable-by-deliverable basis and is subject to extension based upon the satisfactory performance of the consultant
Disclaimer
All Short-listed candidates will be invited to take part in a short test to assess their skills. Baan Dek Foundation will take affirmative action measures to avoid discrimination in advertisements for consultancies preventing discrimination against any consultant on the bases of race, color, gender, national origin, age, religion, creed, disability, sexual orientation, gender identity or gender expression. The selected consultant will be requested to comply with our Child Protection and Safeguarding, PSEA Policy, Anti-Corruption Policy.
Qualifications
Nationality: Thai nationality
Language requirements : Good command of written and spoken English & Thai.
Skills and competencies
● Knowledge of creating complex formulas, macros, indexing; Pivot tables; Basic scripting; Database ; Extensive knowledge of Microsoft Office Suite, particularly of Excel spreadsheets and Google workbooks.
● Compensation: To be defined based on experience and qualifications
PROPOSAL PROCESS
Interested consultants shall submit an initial expression of interest, upon which interested candidates will be sent an introductory Powerpoint Presentation of the Self-Assessment Tool Google Sheet demonstrating both the current version and the proposed changes on which consultants can base their estimations for the financial proposal. The expression of interest shall contain the candidates’ CV, at least 2 examples of previous similar work and contact details of at least 2 references. After having received the Powerpoint PResentation, candidates shall send a completed financial proposal as detailed below.
The financial proposal shall encompass the consultant’s daily rate and any other applicable costs for carrying out the assignment VAT if applicable and any other costs necessary to undertake the assignment
Applicants should submit their quotations in digital form to james@baandekfoundation.org and werapong@baandekfoundation.org
Deadline for submission of expression of interest
25/09/2023 no later than 23:59 Bangkok time.
Financial proposals shall be sent no later than 3 working days following the candidates’ receipt of the Powerpoint Presentation on the Self-Assessment Tool Google Sheet.
IMPORTANT
In line with donor requirements, all financial proposals should be printed, signed by hand, not e-signature, and then scanned and submitted as a PDF
Applicants are required to address their financial proposals to:
Kids Home Development Network Foundation
27 Moo 5, Soi 4, Chiang Mai-Doi Saket Road, San Phranet, San Sai, Chiang Mai 50210
Tel: +66 (0) 53-2222-11
Tax ID: 0993000105711
CONTACT
For any questions or feedback on this consultancy, please contact the Research and Program Quality Coordinator, James Eckford at james@baandekfoundation.org and Senior Program Manager - Advocacy and Private Sector Engagement, Thanadon Chanthathadawong at Thanadon@baandekfoundation.org
