Analytical and process-oriented, with expertise in data engineering and analytics, delivering scalable BI solutions and actionable insights using diverse tools and platforms.
Data Engineering & Architecture
- Design, develop, deploy, and maintain end-to-end business analytics solutions, including data pipelines, data models, and data warehouse structures.
- Design comprehensive data model maps based on indicator requirements, ensuring scalability and integration with existing systems.
- Implement and manage Extract, Transform, Load (ETL) processes for integrating multi-source data into centralized infrastructure.
- Develop and manage multi-model master databases of indicators and metrics, ensuring optimal structure, performance, and data integrity.
- Design and manage data flows and warehousing systems to meet analytical requirements.
Data Analytics & Visualization
- Develop and maintain interactive reports and dashboards using Power BI and Tableau.
- Implement Row-Level Security (RLS) and other data security models.
- Identify, analyze, and interpret trends, patterns, and key insights from complex datasets.
- Optimize and maintain SQL queries for improved performance.
- Design infographics and data visualizations for dissemination and stakeholder reporting.
Data Quality & Management
- Conduct regular data quality checks, cleaning, and gap analysis to ensure accuracy, consistency, and completeness.
- Develop complex data collection tools using Kobo, DHIS2, or equivalent platforms.
- Maintain and manage large-scale datasets for monitoring, evaluation, and reporting purposes.
Research & Impact Evaluation
- Collaborate with research partners to align ongoing data analysis with impact evaluation and technology research.
- Contribute to organizational research agendas by integrating analytical outputs into program learning and decision-making.
- Work with local governments following a user-centered design to understand business requirements in the business intelligence context.
- Designed and mapped data model to execute efficient deep structure including performing SQL for data manipulation and extraction, as well as constructing data flows, and data warehouse.
- Prototyped, developed, and maintained Power BI reports to meet business requirements as well as routinely analyzed collected data to generate summarize, and generalize findings.
- Re-organized multi-model database structure, and routinely analyzed to fill any data gaps, cleaning, inconsistency, and accuracy checks including performing ad hoc testing of the Waliku apps (web and mobile) to understand the impact on the database.
- Designed and layout of Program Implementation Program Self-Reflection documents.
- Accepted the well-designed slide deck of the Centre for Evaluation and Research to Develop Insight and Knowledge (CERDIK) Proposal.
- Produce CRSA (Child Right Situation Analysis) data visualization and one-pager of clear and interesting strategy mapping of the Country Strategic Plan 2022-2024(Infographic).
- Cleaned and recoded GESA data to ensure it was ready for analysis.
- Provided insights and recommendations (Executive summary) to support decision-making by performing inferential analysis (univariate, bivariate, and multivariate) through key domains of GESA, as follows capacity, accountability, leadership, safeguarding, and culture.
- Layout the full report and factsheet ready for circulation.
- Reviewed and analyzed raw data to produce the baseline report for the BERMAIN Project.
- Led the end-line evaluation of the BERMAIN Project, including data collection, analysis, and reporting.
- Reviewed and provided input on the baseline report for the Coaching for Life program.
- Ensured program quality by applying the Quality Benchmark Tool; conducted monthly analysis and reporting.
- Regularly emphasized the Complaint and Feedback Mechanism (CFM), including follow-up actions and handling of resulting action plans.
- Developed data collection tools, data analysis, and data visualization tools that are needed by the Save the Children country office related to MEAL and research purposes.
- Conducted internal and external program/project evaluations including baseline, midline, and end-line evaluations relevant to the program indicators.
- Develop a Complaint and Feedback Mechanism system, including monthly regular analysis and recommendations to support better program implementation or decision-making.
- Developed data dissemination products such as infographics, summary briefs, and an in-house website (SharePoint web) from research conducted (Baseline, midline, end-line, assessment, situation analysis, etc.) to share complex information to a wide number of audiences.
- Managed all data processes related to the quality benchmark monitoring system including provided analysis and quarterly reports of the quality benchmark monitoring results.
- Ensured all staff had appropriate understanding/capacity on accountability principles and their purpose by developing a strategy for information sharing on existing organization programming.
Quantitative and qualitative research for the Exclusion Mapping Project, a preliminary project for Save the Children’s upcoming global campaign on “Every Last Child” (Country Piloted: Indonesia and Tanzania),and developed a base data(statistical data) for the Country Strategic Plan for 2019-2021.
- Collected all relevant statistical data regarding children in Indonesia across Save the Children’s main thematic issues (Child Education, Child Protection, Child Health and Nutrition, Child Poverty, and Child Right Governance).
- Developed and maintained the Exclude Children Mapping Portal using Power Bi/Tableau/VBA Dashboard.
- Deliver research and analytical projects, using both quantitative and quantitative data to apply inferential statistical approaches.
- Documented the project process for future replications of the model that is expected to be used by key stakeholders in the area of excluded children and also developed research findings and other data and information in an accessible and comprehensible form.
- Supported to build, migration, and maintenance of big data management systems for existing and new application platforms.
- Composed, evaluated, interpreted, and analyzed the data regarding key issues in Indonesia to ensure that the Member of Parliament is accurately informed.
- Conducted consultancy at the grassroots level, developed research and community development strategies, wrote reports, and analyzed decision-making.
Quantitative and qualitative research on popularity and electability of the Member of Parliament candidates in Indonesia.
- Maintained the multi-model database management using Oracle software including cleaning and migration process.
- Designed survey projects, including sources of information, procedures, and instruments.
- Analyzed and interpreted data using statistical and qualitative techniques.
- Generated the data result and developed the information pancaking through reports and infographics either offline or online.
