IT Analyst

IT support (Data Analyst) Job description:
1. Capturing and recording important data
- Taking existing data from a separate document and inputting it into Excel.
- Creating a financial strategy or budgeting plan from scratch and typing it into Excel.
- Transferring a schedule from an outside source and rebuilding it in Excel.

2. VLOOKUP
- Using shortcuts and formula functions
- If you’re gathering data scattered throughout another Excel spreadsheet, this function can help you locate it and quickly transfer it to your current spreadsheet.

3. Building charts and graphs

4. Sorting and filtering data

5. Utilizing pivot tables

When you need to summarize large quantities of data, you can use a pivot table to group and reorder these findings in a way that makes it easier to organize. You can categorize different number sets and list them accordingly to make it easier to sort through and find the information you’re searching for. You can segment various numbers and data by date, percentage or any other variable you desire.

Ability to:

- Recognize and resolve system related problems
- work independently and make necessary decisions throughout the systems process within department guidelines. Willing to Work extra hours
- Work under pressure
- The ability to push yourself forward, stay motivated, and manage multiple responsibilities at once by focusing on one task while keeping track of others
- Be punctual on timing.

**Salary**: RM2,000.00 - RM3,500.00 per month

Schedule:

- Day shift
- Monday to Friday

Supplemental pay types:

- Yearly bonus

Ability to commute/relocate:

- Port Klang: Reliably commute or planning to relocate before starting work (required)

Application Question(s):

- Do you have experience on PIVOT TABLE AND VLOOK UP?