Data Analyst I

RealPage, Inc.; Manila; On-site; PHP 420,000 - 660,000; Full time

Job summary

RealPage, Inc. is seeking a Data Analyst in the Manila area to analyze and monitor data for affordable housing programs. The role involves collecting vendor data from client systems, importing into databases, mapping formats, reporting, and QA testing through UI.

The candidate will also develop queries and scripts, ensure data quality, and support operations with ad hoc data tasks. This position requires a four-year degree (or 2nd year college), 1–2 years of data experience with Access/Excel,

Qualifications

• College degree of any four-year course or at least 2nd year college without back subjects.
• 1-2 years’ experience managing data with Access, Excel and data editors.
• Fresh Graduates may apply.
• Working knowledge of relational database concepts and processes required.
• 1-2 years’ experience with a proven track record in data analysis.
• Experience with Microsoft Windows operating systems.
• Experience gathering requirements and writing specifications.
• Very good written and verbal communication skills.
• Strong planning and time management skills with a proven track record of meeting deadlines under pressure. Analytical track record.
• Strong attention to detail and accuracy.
• Strong work and attendance ethics.
• Experience with vendor/supplier data manipulation preferred.
• Must be flexible in terms of work arrangement (work on site, work from home or hybrid).
• Must be willing to work in Night Shift.

Responsibilities

• Review resident files within the time frames outlined in a contract or request assistance should some circumstance prevent a timely review.
• Communicate regarding the deficiencies found in the resident files and operate the RPDM system to ensure the timely review of files submitted.
• Receivingdata,overseeingthetransferringofthedatatoourdatabase,andanalyzingthedataforaccuracyandcomparedtowhatisinthe destination system.
• Creating conversion scripts for data from various sources into the standard format for the destination system.
• Consolidating/merging duplicated data in the existing system by creating and using existing comparison scripts or using existing user interface tools.
• Performing data matching based on common fields between disparate data sources and return the results in a readable format.
• Assisting the operations team by finding out information from the system by writing ad hoc queries for tasks such as coverage data and audit information.
• Develop new queries that will later be turned into standardized reports by gathering requirements about specific needs from the operation team and gathering data.
• Develop a system for categorizing and storing scripts with documentation around the purpose of the scripts in a source control repository such as Visual Source Safe or Team Foundation Server.

Skills

Data analysis

Ad hoc querying

Data manipulation

Excel

Access

SQL / relational databases

Requirements gathering

Analytical thinking

Written and verbal communication

Attention to detail

Time management

Vendor data manipulation

Education

Bachelor's degree in any four-year course

Fresh graduates may apply

Tools

Visual Source Safe

Team Foundation Server

Windows OS

Microsoft Excel

Job description

Overview

The Data Analyst is responsible for analyzing, monitoring and providing support on a variety of complex procedures regarding program requirements of various affordable housing programs. They are also responsible for the collection of vendor data from various client systems and importing this data into a database. The overall process from receiving data through final reporting will require data analysis, mapping the data from the provider’s format to ours, reporting and monitoring at various stages within the process. Also requires Quality Assurance testing through the application user interface.

Responsibilities

• Review resident files within the time frames outlined in a contract or request assistance should some circumstance prevent a timely review.
• Communicate regarding the deficiencies found in the resident files and operate the RPDM system to ensure the timely review of files submitted.
• Receivingdata,overseeingthetransferringofthedatatoourdatabase,andanalyzingthedataforaccuracyandcomparedtowhatisin the destination system.
• Creating conversion scripts for data from various sources into the standard format for the destination system.
• Consolidating/merging duplicated data in the existing system by creating and using existing comparison scripts or using existing user interface tools.
• Performing data matching based on common fields between disparate data sources and return the results in a readable format.
• Assisting the operations team by finding out information from the system by writing ad hoc queries for tasks such as coverage data and audit information.
• Develop new queries that will later be turned into standardized reports by gathering requirements about specific needs from the operation team and gathering data.
• Develop a system for categorizing and storing scripts with documentation around the purpose of the scripts in a source control repository such as Visual Source Safe or Team Foundation Server.

Qualifications

• College degree of any four-year course or at least 2nd year college without back subjects.
• 1-2 years’ experience managing data with Access, Excel and data editors.
• Fresh Graduates may apply.
• Working knowledge of relational database concepts and processes required.
• 1-2 years’ experience with a proven track record in data analysis.
• Experience with Microsoft Windows operating systems.
• Experience gathering requirements and writing specifications.
• Very good written and verbal communication skills.
• Strong planning and time management skills with a proven track record of meeting deadlines under pressure. Analytical track record.
• Strong attention to detail and accuracy.
• Strong work and attendance ethics.
• Experience with vendor/supplier data manipulation preferred.
• Must be flexible in terms of work arrangement (work on site, work from home or hybrid).
• Must be willing to work in Night Shift.