Data Analyst

Role Summary:

Support GBF's education data reporting: maintain and extend the analytics dashboards that track teacher engagement with the learning management platform lessons across DepEd regions, divisions, and schools.

Key Responsibilities:

1. Write and maintain SQL queries (PostgreSQL + MySQL) powering the analytics dashboards
2. Build and update dashboards: usage funnels, download counts, engagement-level breakdowns, school/division rollups
3. Validate data quality - reconcile teacher registration lists, lesson mappings, and activity logs; flag discrepancies
4. Run recurring reporting cycles (monthly/quarterly completion reports) and turn results into clear summaries for program staff
5. Handle ad-hoc data requests from program and partnership teams
6. Document query logic and metric definitions so numbers are reproducible and consistent across reports

Required Skills:

1. Solid SQL: joins, aggregations, CTEs, window functions, date logic
2. Spreadsheet fluency (Google Sheets/Excel) pivot tables, lookups, cleaning messy CSVs
3. Basic BI tool experience (Metabase, Looker Studio, Power BI, or Tableau. Metabase preferred)
4. Able to translate a vague business question into a concrete query
5. Careful and detail-oriented; comfortable saying this number looks wrong and digging in

Job Profile:

1. 0–2 years experience; fresh graduates welcome (Statistics, Math, Economics, CS, IS, Engineering, or equivalent self-taught portfolio)
2. Communicates findings in plain language to non-technical stakeholders
3. Comfortable with ambiguity and asking questions early