Data & Reporting Analyst

Merah Putih Initiative; Jakarta Pusat; On-site; IDR 140,000,000 - 240,000,000; Full time

Job summary

Merah Putih Initiative (TMPI) seeks a Data and Reporting Analyst to join the District Labs under Education Impact Area, supporting government counterparts in credible policy execution of Indonesia’s national priority programs.

Role focuses on program recording, data management, and producing consistent, reader-friendly reports by integrating inputs from multiple workstreams. Strong Excel/Sheets skills and bilingual communication are essential.

Qualifications

• Minimum 3 years in programme or project administration, preferably in education and with government institutions.
• Bachelor’s degree in a relevant field (see education).
• Familiarity with government units, official correspondence and disposition flows.
• High attention to detail and strong records management.
• Strong spreadsheet skills (pivot tables, lookups, data validation) and dashboards.
• Trustworthy with sensitive documents.
• Experience supporting audits by internal government auditors or BPK is a plus.
• Excellent report writing, presentation, and stakeholder engagement in Bahasa Indonesia and English.

Responsibilities

• Set up standardized correspondence templates and an official filing system compliant with ministry procedures.
• Partner with the Programme Coordinator to build and maintain the programme record system, logs, and highlights.
• Archive records from the school year start and draft guiding documents for staff and ministry counterparts.
• Track deliverables, deadlines and follow-ups to support executive decision-making.
• Coordinate logistics for field trips, including letters, bookings, vouchers, and SBM-compliant costs.
• Coordinate admin setup for workshops, meetings, and team assemblies with invitations and notes.
• Manage expert honoraria with the finance team and ensure tax documentation (PPh 21/23).
• Prepare audit-ready accountability files and consolidate progress reports and templates.
• Aggregate data across workstreams for annual programme reporting and annexes.

Skills

Spreadsheet skills

Data management

Report writing

Stakeholder engagement

Bilingual Indonesian/English

Google Workspace / Microsoft 365

Education

Bachelor's degree in public administration, management, accounting, economics, public policy, education or related field

Tools

Google Workspace

Microsoft 365

Job description

Jakarta-based, Client-site and TMPI Office

Reporting to

Target Start Date

Immediate, October 2026

Commitments

Full-time Engagement

The Merah Putih Initiative (TMPI) is an independent and non-government institution , formed out of a deep commitment to addressing Indonesia’s evolving policy environment. Our mission is to set a new benchmark on how the country’s policy priorities are designed, executed, and improved.

As national policy priorities expanded in scale and ambition, many lacked clear public articulation and faced challenges in grassroots execution, resulting in suboptimal impact despite their long-term importance. TMPI exists to help close these gaps and strengthen how policy intent translates into credible development outcomes in Indonesia.

The Opportunity

We are seeking a Data and Reporting Analyst to join TMPI’s District Labs under Education Impact Area, the arm dedicated to supporting government counterparts in delivering credible policy execution of Indonesia’s national priority programs.

This is a rare opportunity to strengthen a national priority program operating at scale in Indonesia. This role is ideal for professionals who thrive in complex, high-stakes environments, have a problem-solving mindset, and are passionate about education policy delivered at national scale; ensuring that rapid expansion is matched by consistent quality, clear accountability, and measurable outcomes.

Key Responsibilities

• Implement standardized correspondence templates and an official filing system compliant with ministry procedures.
• Partner with the Programme Coordinator to build and maintain the programme record system, tracking decision logs, event timelines, issue logs, and good practice highlights.
• Retroactively trace and archive records from the school year start, authoring record-keeping guidance for team members and ministry counterparts.
• Track deliverables, deadlines, and follow-up actions across all workstreams to support executive decision-making.

Logistics, Event Coordination & Travel Management

• Oversee travel arrangements for field trips (including assignment letters, travel bookings, expense vouchers, and receipts) strictly adhering to government standard cost rules (SBM).
• Lead administrative setup for workshops, public discussions, weekly coordination meetings, and monthly team assemblies (managing invitations, rosters, meeting notes, and action logs).
• Manage expert and speaker honoraria in coordination with the finance team, ensuring complete tax documentation (PPh 21/23).

Financial Accountability, Compliance & Reporting

• Prepare audit-ready accountability files for each payment stage, consolidating evidence of outputs, progress reports, and proof of expenditure.
• Synthesize inputs across all four workstreams into standardized monthly progress reports and periodic government reporting templates.
• Compile records, figures, and data annexes for the annual programme report, delivering the final complete archive and audit-ready files to the ministry.
• Map existing systems, applications, data flows, and technology contracts across the program.
• Assess each system’s fitness for purpose, overlap, integration gaps, and total cost of ownership, and identify where duplication creates inefficiency or data inconsistency.

Experience & Qualifications

Professional Experience

Role focus: Run the program recording and data management system and serve as the main writer of program reports, stitching input from all workstreams into consistent, readable documents.

• Minimum 3 years in programme or project administration, exposure in the education sector and experience working with or within government institutions are preferred.
• A bachelor’s degree in public administration, management, accounting, economics, public policy, education or a related field.
• Familiarity with how government units work, including official correspondence and disposition flows.
• High attention to detail and strong records and information management.
• Strong spreadsheet skills (pivot tables, lookups, data validation) and experience managing documents in Google Workspace or Microsoft 365 and establishing monitoring dashboards.
• Careful, organised and trustworthy with sensitive documents.
• Experience supporting audits by internal government auditors or BPK is a plus.
• Excellent report writing, presentation, and stakeholder engagement skills both in Bahasa Indonesia and English.

What We Offer

• Opportunity to strengthen policy delivery of Indonesia’s national priority programs.
• Direct engagement with senior government officials and passionate leadership committed to Indonesia’s development.
• Competitive compensation commensurate with experience.
• Growth opportunity as TMPI expands.