Data and Process Automation Analyst (fm) – Temporary Contract for 15 months

ACGF - Afghan Credit Guarantee Foundation; Berlin; Vor Ort; EUR 50.000 - 70.000; Vollzeit

Zusammenfassung

An international foundation in Berlin is seeking a Data and Process Automation Analyst to enhance operational processes in grant implementation. The role involves analyzing data handling systems, automating workflows, and supporting reporting processes. Ideal candidates should hold an economics or systems degree and possess at least three years of experience in data analytics. The position offers a collaborative environment, competitive salary, and opportunities for personal growth.

Leistungen

Flexible working hours

Relocation support

Subsidy for Urban Sports Club

Free Deutschlandticket

Qualifikationen

• 3 years of experience in data analytics, process improvement or digitalization in finance.
• Understanding of credit guarantee or grant processes.

Aufgaben

• Analyze and automate operational processes related to guarantees and grants.
• Develop and maintain automated reporting tools and dashboards for tracking.
• Train teams on newly developed tools and processes.

Kenntnisse

Advanced Excel (Power Query, pivot automation, VBA)

Proficiency in Python (Pandas, NumPy, OpenPyXL)

Experience with Power BI

Analytical and problem-solving abilities

Clear communication style

Ausbildung

University degree in economics, data science, information systems

Tools

Power BI

Tableau

SQL

Jobbeschreibung

Overview

Job title: Data and Process Automation Analyst
Job type: 40 hours per week
Employer: ACGF Afghan Credit Guarantee Foundation
Location: Berlin
Start: ASAP

What You’ll Do

You will analyze, automate, and improve key operational processes related to guarantee and grant implementation with a strong focus on data handling systems usage and process efficiency.

Your work will support the automation of guarantee issuance monitoring claims refunds and fee invoicing while strengthening data quality reporting and system usage across ACGF and partner institutions.

You will act as a link between the Transactions Department, the Data & Reporting Department, and the MIS system provider translating operational requirements into technical solutions and enabling practical implementation by staff and partners.

This is a hands‑on position combining data engineering, process analysis, user support, and operational understanding.

Operational Processing

• Process guarantees, refunds and fees by collecting, cleaning and processing operational data from partner institutions and local teams
• Prepare documentation for decision making and ensure appropriate handling of data within the management information system

Automation & Process Optimization

• Analyze existing workflows and identify opportunities for digitalization or automation in close coordination with the Data Department particularly of guarantee issuance portfolio monitoring claims and refunds guarantee fee calculations and invoicing
• Develop and implement data processing tools (e.g. using Python-based scripts, Pandas, NumPy, OpenPyXL, Power Query, Excel automation, automated validation and reconciliation tools semi‑automated upload and report processes) to reduce manual work
• Design and document automation scripts for data validation, uploads and report generation
• Support teams in adopting new tools and ensure proper documentation and version control

Reporting & Performance Tracking

• Develop and maintain automated reporting tools and dashboards (Power BI, Excel, Python) for guarantee and grant portfolio tracking, process KPIs (processing time bottlenecks compliance gaps), partner performance and data quality
• Design standardized reporting templates and data models for operational use
• Support the preparation of management and donor reports

Capacity Building & Documentation

• Train ACGF headquarters and local teams on the use of newly developed tools and automated processes
• Prepare user manuals, step‑by‑step guides and process documentation
• Provide basic troubleshooting and support for tool users
• Develop simple guides for minor adjustments and maintenance of tools

System & Process Integration

Explaining processes from an operational perspective

• Act as a liaison between the Transactions Department and the Data & Reporting Department
• Translate operational business processes into specific system and data requirements
• Support the Data Department and MIS provider by helping define system adaptations needed for guarantees and grants, testing new functions and tools from a user perspective, and supporting increased and improved use of the MIS by the operations team

Your Profile

Education & Experience

• University degree in economics, data science, information systems or related field
• 3 years of experience in data analytics, process improvement or digitalization within development finance, credit administration or banking

Technical Skills

• Advanced Excel (Power Query, pivot automation, VBA or similar)
• Proficiency in Python (Pandas, NumPy, OpenPyXL, data cleaning, automation, scripting)
• Experience with Power BI, Tableau or similar BI tools
• Familiarity with SQL or structured databases is an asset
• Understanding of process mapping, data flow and reporting structures
• Understanding of credit guarantee or grant processes

Soft Skills

• Strong analytical and problem‑solving abilities
• Clear communication style with both technical and non‑technical colleagues
• Structured, reliable and able to translate complex problems into practical solutions
• Curious, proactive and motivated by continuous improvement and impact

What We Offer

• A job in a distinctly international environment offering steep learning curves and close cooperation with your team
• Opportunity to contribute to a visible economic development impact in Afghanistan
• Great opportunity for learning and professional growth
• An open and cooperative working atmosphere
• Short communication and decision‑making processes
• Competitive salary
• Participation in training courses
• Flexible working hours including mobile working possibilities (by arrangement three days a week)
• An office in the heart of Berlin easily accessible by public transport
• Working abroad up to 4 weeks per year
• Free Deutschlandticket
• Subsidy for Urban Sports Club
• Regular team lunches and events
• Relocation support if needed

We are looking forward to getting to know you! For more information about us please visit our website at .

Please apply here with a CV and remuneration expectation. Applications are reviewed on a rolling basis.

For questions regarding this position please contact Cynthia Walbaum at .