Systems Analyst: Automate Workflows & Dashboards

Private Advertiser; Singapore; On-site; SGD 60,000 - 90,000; Full time

Job summary

Private Advertiser is seeking a capable analyst to document current financing, dealer, customer and administrative workflows, identify duplication and automation opportunities, and draw clear process diagrams. You will build and maintain dashboards in BI tools covering loan book, disbursement, credit quality and collections, and help standardize reporting across teams.

You will gather requirements, write simple user stories, track open questions, and support rollout with user guides and training

Qualifications

• 1–3 years of relevant experience (business analysis, data, or systems support).
• Comfortable with Excel or Google Sheets.
• Basic SQL, or willingness to learn quickly.
• Organised, careful with detail, and reliable in following through on tasks.
• Clear written communication for documenting processes and reports.

Responsibilities

• Help document the company’s current financing, dealer, customer and administrative workflows.
• Note where there is duplicated work, manual effort or room for automation, and raise these to the GM.
• Draw clear workflow diagrams of existing and proposed processes.
• Build and maintain dashboards and reports under the GM’s direction, covering areas such as the loan book, disbursement, credit quality and collections.
• Help keep reporting consistent so everyone works from the same numbers.
• Check data for errors and inconsistencies, and help clean up records.
• Use Excel or Google Sheets, and business intelligence tool such as Power BI, Tableau or Looker Studio.
• Help gather requirements from users and write them up clearly for the GM to review.
• Prepare simple user stories, notes and acceptance criteria.
• Help track open questions, pending decisions and outstanding items, and follow up on them.
• Support communication with external development partners, with the GM holding the relationship.
• Prepare and run user acceptance testing on new features against agreed requirements.
• Record bugs, gaps and improvement requests clearly.
• Help re-test fixes and confirm systems are ready before use.
• Help prepare user guides, SOPs and simple training materials.
• Support staff in learning new systems and workflows.
• Check in on how systems are being used after launch and gather feedback.
• Build simple spreadsheets, calculators or trackers where useful.
• Try low-code, no-code or AI-assisted tools to test ideas quickly, under guidance.
• Always check with the GM or the development partner before changes that could affect live systems or data.

Skills

Business analysis

Data analysis

SQL (basics)

Excel / Google Sheets

Documentation

Tools

Power BI

Tableau

Looker Studio

Notion

Trello

ClickUp

Job description

Private Advertiser is seeking a capable analyst to document current financing, dealer, customer and administrative workflows, identify duplication and automation opportunities, and draw clear process diagrams. You will build and maintain dashboards in BI tools covering loan book, disbursement, credit quality and collections, and help standardize reporting across teams.

You will gather requirements, write simple user stories, track open questions, and support rollout with user guides and training