Home
Urgently Jobs
Bangkok Metropolitan Region Industrial jobs Hotel jobs Internship Cooperative Education Disability Jobs Intern Connext findwork EWE Platform
Resume Search
Central Eastern Northern Northeastern Southern Western
Employer Job Seeker
Jobbkk News Contact us Help Center Ads rate How to pay

Please Login For Resume Information

Job Requirment

  • Position:

    Reporting Analyst (Excel, Power Query, VBA)

    Occupation:

    Analyst/Economics

    Sub Occupation:

    Data Analysis Officer

  • Position:

    Business Analyst

    Occupation:

    Analyst/Economics

    Sub Occupation:

    Data Analysis Officer

Interested business type

  • Retail
  • Automobile Industry
  • Others

Job Location

Nakhon Pathom (All)

Ratchaburi (photharam)

Bangkok (Nong Khaem)

Latest Salary

32,000 - 38,000 THB

Job Type

Full time

Availability

within 15 days

Working Bangkok

Yes

Work Upcountry

Yes

Willing to work oversea?

Yes

Education

2019 - Rajamangala University of Technology Rattanakosin

Faculty:Faculty of Business Administration
Major:Accounting
GPA 3.73 - Bachelor's Degree

Experience/ Internship

September 2020 toPresent  (5 Year 5 Month)
  • Last Position:
  • Accountant (Reporting / Data Consolidation)
  • Business Type:
  • Retail

Job Description

  • - Collected and analyzed customer discount data while tracking the status of refunds from Toyota Motor to prepare summary reports for management.
  • - Prepared monthly refund tracking reports, ensuring completeness and analyzing reasons for discrepancies in amounts.
  • - Summarized discount data and refund amounts from seven branches to provide management with a comprehensive overview for quicker decision-making.
  • - Compiled monthly service department target reports to evaluate performance and monitor bonus opportunities for each branch.
  • - Developed a dashboard for management, featuring graphs and figures that automatically update when data changes.
  • - Utilized Power Query to consolidate data from multiple files/sheets, reducing the need for numerous formulas and minimizing errors from copy-pasting.

Hard Skill

  •  - Microsoft Excel / Expert
  •  - Dashboard (Excel): PivotTable / PivotChart / KPI Report / Expert
  •  - Excel Advanced: XLOOKUP, INDEX/MATCH, SUMIF/SUMIFS, COUNTIF/ / Expert
  •  - Power Query (Intermediate-Advanced): Combine Files, Merge, A / Experienced
  •  - Power Pivot / Data Model: Relationship, Measures เบื้องต้น / Experienced
  •  - VBA Automation: UserForm, บันทึกข้อมูลลง Table อัตโนมัติ, ดึ / Experienced
  •  - Executive Reporting / Data Validation / Experienced
  •  - Microsoft Word / Skillfull
  •  - Microsoft PowerPoint / Skillfull
  •  - MAC-5 / Beginner

Soft Skill

  •  - Able to work under pressure
  •  - Behavioural traits
  •  - Complex Problem Solving
  •  - Focus mastery
  •  - Self Awareness
  •  - Growth Mindset
  •  - Collaboration

Language skills

  • Speaking

  • Listening

  • Reading

  • Writing

  • Thai
  • Excellent
  • Excellent
  • Excellent
  • Excellent
  • English
  • Medium
  • Medium
  • Medium
  • Medium

Typing Skills

  • Thai : 50 words / min
  • English : 40 words / min
Top