Data Warehouse Assistant (Fixed-Term)
Provide technical support and data management for finance systems.
Overview
Provide technical support and data management for finance systems.
You have:
- A bachelor's degree in IT, Computer Science, or a related field is preferred but not required.
- Minimum 1 year in giving IT related support and coordination.
- Competent in Microsoft Excel and Word.
- Possess strong analytical and everyday problem-solving skills.
- Must have good communication and interpersonal skills.
- Fluent in written and verbal communication in English.
- Has experience in using any helpdesk tool like ServiceNow or SMAX.
- Has experience in any data analytics tools and application.
With 75 years of experience, our focus is on helping the most vulnerable children overcome poverty and experience fullness of life. We help children of all backgrounds, even in the most dangerous places, inspired by our Christian faith.
Come join our 33,000+ staff working in nearly 100 countries and share the joy of transforming vulnerable children’s life stories!
Employee Contract Type:
Local - Fixed Term Employee (Fixed Term)Job Description:
As Data Warehouse Assistant you will provide help desk support, technical assistance to the various users of the assigned finance system and assist in keeping Global Finance Systems (GFS) Datawarehouse updates and initiatives. This includes identification, prioritization and resolution of end-user service requests. Interact with business customers to provide application support, incident tracking, documentation and training. Administer daily data loading in various systems of reporting supported by the OLAP group.
KEY RESPONSIBILITIES:
Ensure high-quality technical support is provided to customers. This includes, but is not limited to the following:
Provide first point of contact and day-to-day technical support to end users, responding to level 1 support requests via email and escalate issues to the Data Admin Associates accordingly.
Enter and monitor request data into the tracking system (ServiceNow) on issues including user access service, diagnosing problems by evaluating multiple options, developing checklists and scripts for resolving routine problems, documenting problem status and resolution in tracking log.
Conduct research/troubleshoot/ ”fact-finding” as needed to resolve customer issues.
Ensure completeness, reliability and timeliness of data within Data Warehouse. This includes, but is not limited to the following:
Uploading of different sets of data into Datawarehouse.
Processing of OLAP cubes after data loading
Validating data from source file vs SQL Tables and OLAP Cubes.
Analysing invalid data from codes to values.
Updating of fields and dimensions
Updating of PowerBI Templates and Dashboards.
Communicating changes, corrections and updates to users.
Provide Technical Support to projects/initiatives led by GFS OLAP/Datawarehouse group. This includes but not limited to the following:
Assist in gathering facts, data, inventory, etc during project implementation
Manage SSRS Distribution list for different groups
Assist in documenting processes and requirements
Performs other related functions as may be necessary and delegated from time to time
QUALIFICATIONS:
A bachelor's degree in IT, Computer Science, or a related field is preferred but not required.
Minimum 1 year in giving IT related support and coordination
Competent in Microsoft Excel and Word
Possess strong analytical and everyday problem-solving skills.
Must have a good communication and interpersonal skills
Fluent in written and verbal communication in English
Preferred but not required:
Has experience in using any helpdesk tool like ServiceNow or SMAX
Has experience in any data analytics tools and application
Applicant Types Accepted:
Local Applicants Only
Potential interview questions
Can you describe a time when you resolved a technical issue for a user? | This question assesses your problem-solving skills and ability to provide support. | Detail the situation, your approach, and the outcome. |
How do you prioritize multiple support requests from users? | The interviewer wants to understand your time management and prioritization skills. | Pro members can see the explanation. |
Give an example of how you ensured data accuracy in a project. | Pro members can see the explanation. | Pro members can see the explanation. |
What strategies do you use when communicating technical information to non-technical users? | Pro members can see the explanation. | Pro members can see the explanation. |
Describe your experience with using helpdesk tools. What challenges have you faced? | Pro members can see the explanation. | Pro members can see the explanation. |
How familiar are you with data processing and OLAP cubes? | Pro members can see the explanation. | Pro members can see the explanation. |
What methods do you use to troubleshoot a fault in a software application? | Pro members can see the explanation. | Pro members can see the explanation. |
Can you explain a project where you utilized data analytics tools? | Pro members can see the explanation. | Pro members can see the explanation. |