Position: Data Analyst

Organization: Educate Girls

Location: Mumbai

Apply: https://docs.google.com/forms/d/e/1FAIpQLScZiClinQp5bnoy2K2W58rU42IA-q1o57hQGCVAdmrA6-UXLg/closedform

Scope & overview of the role:

The Data Analyst is expected to harness the power of data to help Educate Girls maximize its impact. Through the generation of actionable insights, this role will be instrumental in enabling rapid course correction in program delivery. Efficient management and mining of primary and secondary data sources to enable timely and error-free reporting to our stakeholders will also be a key responsibility of this role. This role will help grow data-driven decision making in the organization.

This role will report into the Manager, Data Analytics and Donor Reporting and will be part of the Measurement, Learning & Evaluation (MLE) function in the organization.

Areas of Responsibility:

Data Analysis & Management

• Build efficient and well documented methods for easy, repeatable extraction & cleaning of primary and secondary data sources. 
• Maintain a data dictionary that documents the meanings and use of internal and external stakeholder Interpret data, analysing results and trends, using statistical techniques where appropriate
• Generate high quality formal analytical reports on key program delivery outcomes such as Enrolment, Retention and Learning, as per defined calendar
• Conduct periodic data quality assessments through pattern and outlier analysis
• Develop dashboards to monitor performance & quality of program delivery
• Process ad hoc data requests and the deliverable should be timely, accurate and supported by definitions and insights where appropriate

Donor & Government Reporting

• Apply donor specific or State specific rules to extract and clean data for donor and government reports.
• Analyse the data for inaccuracies and outliers and highlight possible risks in reporting that data
• Prepare donor and government report data on time and error-free

Design & Documentation

• Design new data collection formats and reports for new programs/ interventions
• Maintain process maps and other documentation for the MLE function
• Carry out any other additional responsibilities as required

Liaise with (internal & external stakeholders)

• Internal: Program & Operations
• External: None

Education Background:

• Minimum is a Bachelor’s Degree in a relevant data science field or a related field of study.

Work Experience:

• Minimum 1 to 3 years of relevant work experience data analytics/data visualization/ data management
• Basic to intermediate level of SQL programming experience and demonstrated ability to design and analyze data in relational databases. Experience with PostgreSQL desirable.
• At least 1-2 years’ experience in data manipulation/cleaning using basic to intermediate Python and/or R.

Skills Set:

Soft skills:

• Excellent communication skills
• Critical & analytical thinking
• Target driven
• Interpersonal skills

Technical skills:

• Demonstrated analytical and assessment skills of quantitative and qualitative data (minimum one year).
• Excellent oral and written presentation skills.
• Intermediate to advanced proficiency in Excel required, especially in visualization (minimum one year).
• Basic to intermediate skills in SQL (minimum one year)
• Basic to intermediate skills in R / Python.
• Strong skills in data analysis and reporting.
• Strong skills in Microsoft Office tools such as Word, Excel, and PowerPoint. Visio knowledge desirable.
• Knowledge of statistical analysis software (such as Stata, SPSS) and experience with GIS software would be a bonus.
• Demonstrated experience in dashboard design & development. Experience with Google Data Studio desirable