Waliku Data Analyst (Consultant)

The Opportunity

Waliku is a Save the Children technology team that provides bespoke solutions for digital data capture and analytics on learner education and well-being. Since inception in 2016, Waliku has grown from a proof-of-concept study and pilot to supporting Save the Children projects in multiple sites globally. Apart from designing and developing digital data capture tools, analytics and dashboards for NGO projects, we also provide theem support to roll out and use these tools. In doing so, we expect projects and particularly educators, be it in formal or non-formal schooling to recognize and address gaps in learner attendance, education progression, and their health and well-being in a timely manner.

End users of our tools could be project office staff, frontline workers, or counterparts in the community- district education officers, school supervisors, school principals / administrators, teachers, community educators, parents and caregivers. In connecting various stakeholders digitally, we also facilitate communication and coordination between them to meet children’s right to education, well-being and achieving their fullest potential.

Waliku is seeking a skilled Data Analyst to join our team, responsible for developing data capture forms, performing data cleaning, implementing ETL procedures, including using SQL, and conducting analytics using Power BI. The ideal candidate will have a strong understanding of data manipulation techniques, database management, and data visualization.

Key Responsibilities

1. Develop data capture forms with relevant validations to collect raw data using survey builders such as Kobo and Commcare.
2. Perform data cleaning and validation to ensure accuracy, completeness, and consistency of data.
3. Design and implement ETL (Extract, Transform, Load) procedures to transform raw data into usable formats for analysis.
4. Develop and optimize queries for data extraction, transformation, and loading processes.
5. Collaborate with cross-functional teams to understand the key indicator requirements and business objectives.
6. Create and maintain documentation for data capture processes, data cleaning procedures, and ETL workflows.
7. Build and maintain data pipelines to automate data ingestion and processing tasks.
8. Conduct exploratory data analysis to uncover insights and identify patterns within the data.
9. Develop interactive dashboards and reports using Power BI to visualize key indicators and trends.
10. Support with the maintenance of the dashboards, its distribution list, ensuring new data is brought in as needed.
11. Support with creating additional features on top of the dashboards and database using AI to ensure users get insights they need for improving on their activities.

Qualifications, Skills and Experience

Requirements

• Advanced data visualization knowledge and skills using software such as Power BI
• Strong understanding and skills in ethics, data confidentiality and security
• Fluency in written and spoken English
• Strong task management and organizational skills
• Intermediate experience with SQL queries and basic experience with a relational database management software – such as Microsoft SQL Management Studio or PostgreSQL
• Intermediate experience with Power BI Desktop – including DAX expressions, Power Query and data visualizations (experience with M Formula language also preferred).   
• Basic to intermediate experience with web-based Power BI tools – including Dataflows, Datamart, Datasets, Row-level Security and Embedded Reports
• Experience with a variety of data testing and cleaning procedures (test scripts, randomized data, front end testing)
• Familiarity with data capture software such as Commcare, Kobotoolbox, power apps or google forms.
• Basic understanding of front-end terminology and languages (HTML, CSS, JavaScript)

Additional Assets

• Experience researching and developing MEAL indicator frameworks
• Statistical analysis experience – including linear and logistical regression
• Masters Degree in monitoring and evaluation or related subjects with strong data analytics background
• Advanced skills in use of multiple software related to data collection, cleaning and analyses, both for quantitative and qualitative studies
• Knowledge of cloud computing using platforms such as Azure and its analytic capabilities with machine learning/ AI
• Knowledge and/or experience using various digital systems that use old, current or new technology for education and health
• Intermediate experience with dimensional data models and basic experience with relational data models
• Contributions to reports and articles

Behavioural Competencies:

• A commitment to high quality of work and efficiency.
• Commitment to and understanding of Save the Children’s aims, values and principles including rights-based approaches. 
• Low resistance to change.
• Problem-solving ability
• Concern for detail.
• Interest and passion to develop knowledge and skills in child rights

The Organisation

We employ approximately 25,000 people across the globe and work on the ground in over 100 countries to help children affected by crises, or those that need better healthcare, education and child protection. We also campaign and advocate at the highest levels to realise the right of children and to ensure their voices are heard.

We are working towards three breakthroughs in how the world treats children by 2030:

• No child dies from preventable causes before their 5th birthday 
• All children learn from a quality basic education and that,
• Violence against children is no longer tolerated

We know that great people make a great organization, and that our employees play a crucial role in helping us achieve our ambitions for children. We value our people and offer a meaningful and rewarding career, along with a collaborative and inclusive workplace where ambition, creativity, and integrity are highly valued. 

Application Information

Please apply using a cover letter and up-to-date CV as a single document. Please also include details of your current remuneration and salary expectations in Indian Rupees in the cover letter. A copy of the full role profile can be found at www.savethechildren.net/careers

Closing Date for Application: 23 April 2024

We need to keep children safe so our selection process, which includes rigorous background checks, reflects our commitment to the protection of children from abuse.

All employees are expected to carry out their duties in accordance with our global anti-harassment policy.