Junior Database Engineer

• 
  Pillar 1: Stronger national level enabling environment for sub-national service delivery.
• Pillar 2: Better sub-national governance for service delivery.
• Pillar 3: Greater participation, representation and influence for women, people with disabilities and vulnerable groups.

At DT Global Asia Pacific, we aim to positively impact people’s lives through delivery excellence. As a leading implementing partner across Asia and the Pacific, we co-create locally led solutions in partnership with governments, communities, and stakeholders. We bring together talented teams and deep regional expertise to deliver initiatives that promote inclusive economic growth, essential services, and resilient, secure communities. With over 1,500 staff, experts in 22+ countries and more than 60 years of development experience, we tackle complex community, national and transnational challenges — from governance and justice systems to climate resilience, infrastructure and social equity — with innovative thinking and a commitment to long-term impact.

• Assemble large-scale survey datasets by leveraging expertise in managing sources such as Susenas, Sakernas, Podes, and other relevant socio-economic data, including data from sectoral ministries (Satu Sehat, Dapodik). This includes extracting key information, cleaning and transforming data and conducting statistical analysis. Identify, design and implement infrastructure for scalability, optimize data delivery and automating manual processes.
• Build required infrastructure for extraction, transformation and loading of data from various data sources using SQL technologies.
• Develop mock ups on SEPAKAT analytical intervention menu ready to be linked with SIPD and SIKD.
• Develop analytical mock-ups that integrate SEPAKAT and SIKD data to support policy and planning processes.
• Perform analytical skills to interpret data, identify trends, patterns, and correlations, and generate actionable insights for different sets of data including Regsosek/DTSEN, Susenas, Sakernas, Podes, and other relevant socio-economic data. Apply statistical methods to draw meaningful conclusions from these datasets.
• Conduct data quality assurance and quality control in SEPAKAT application regularly to ensure data presented of highly standard and can be utilized fully.
• Provide technical expertise and work closely with SKALA-GEDSI team to identify and interpret pattern and trends on specific GEDSI data to ensure data on women, disabilities and vulnerable individual and their needs are available and accurate.
• Provide technical input to national and sub-national regulatory and policies frameworks ensuring coherence and synergy related to GEDSI data integration and utilization.
• Provide technical facilitation to BAPPENAS on the discussion on dataset analysis for SIPD-SEPAKAT integration.
• Work collaboratively with programmers to identify process improvement opportunities, propose system modifications, and data governance mechanism that will ensure GEDSI data are accessible.
• Other tasks as requested by SKALA.

• Comply with DFAT, DT Global and SKALA policies on gender, disability, fraud and anticorruption, child protection, PSEAH and the environment.
• Ensure compliance and adherence to various operational policies, guidelines and manuals issued by DT Global and SKALA.

• Work environment involves only infrequent exposure to disagreeable elements and minor physical exertion and/or strain.
• Work may require long, and flexible hours as needed. Travel is based on need.

• Technical analysis report on the infrastructure of database that is used in SEPAKAT and other systems such as SIPD and SIKD.
• Technical input on infrastructure for extraction, transformation and loading of data for SEPAKAT.
• Mock-ups on SEPAKAT analytical intervention feature ready to be linked with SIPD and SIKD.
• Develop analytical mock-ups that integrate SEPAKAT and SIKD data to support policy and planning processes. Technical input on national socio-economic data interoperability mechanism and run various exercises for data matching and data checking.
• Guidelines and documented process of consultation.
• Report on GEDSI regarding data analysis and utilisation in the planning process, i.e. RPJMD, Renstra, RPJMDes, RKPD, etc.
• Improved the integration between SEPAKAT, SIPD and SIKD application.
• Input to SEPAKAT monitoring and updating processes.
• Frequently asked questions and answers for SEPAKAT and SIPD.

• Bachelor degree in Information System, Statistics, with a minimum of 6 years’ experience in database, data analysis, information system, research, data science, machine learning including for its utilization in local planning and budgeting processes.
• Proficient in data processing tools: Demonstrate fluency in various data processing tools such as Microsoft Excel, Stata, SAS, R, or Python. Leverage these tools to manipulate and transform data, conduct exploratory data analysis, and implement statistical models.
• Technical proficiency regarding database design development, data models, techniques for data mining, and segmentation.
• Proficiency in statistics and statistical packages like Excel, STATA, SPSS to be used for dataset analysis
• Adept at using data processing platforms.
• Excellent interpersonal skills and written and verbal communication skills.
• Excellent problem-solving skills.
• Ability to work both independently and as part of a team to achieve goals.

• Experienced working with Government of Indonesia.
• Experienced working on community development projects involving government and development partners, especially related to social protection for people with disabilities.

DT Global is committed to child protection and safeguarding the welfare of children in the delivery of our international development programs. We are committed to Safety and the Prevention of Sexual Abuse and Harassment (PSEAH), and bribery prevention. DT Global is an equal opportunity employer and we encourage women, men, people with diverse backgrounds and people living with disabilities to apply. This program is funded by the Australian Government and Managed by DT Global.