Data Analyst I

REALPAGE (PHILIPPINES), INC.; Pasig; Hybrid; PHP 300,000 - 420,000; Full time

Job summary

REALPAGE (PHILIPPINES), INC. is seeking a Data Analyst to analyze and monitor programs for affordable housing, collect vendor data, and import it into our database. The role involves mapping data from provider formats, reporting, and QA testing through the UI.

The ideal candidate has a four-year degree or equivalent, 1-2 years experience with Access/Excel, strong problem solving, and solid communication. Night shifts and flexible work arrangements are a plus, with on-site to hybrid options.

Qualifications

• Bachelor's degree or equivalent in any four-year course.
• 1-2 years' experience managing data with Access, Excel and data editors.
• Fresh graduates may apply.
• Working knowledge of relational database concepts.
• 1-2 years' experience with data analysis.
• Experience with Microsoft Windows operating systems.
• Experience gathering requirements and writing specifications.
• Strong written and verbal communication skills.
• Strong planning and time management; analytical track record.
• Strong attention to detail and accuracy.
• Experience with vendor/supplier data manipulation preferred.
• Willingness to work on site, work from home or hybrid.
• Willingness to work night shift.

Responsibilities

• Review resident files within contract timelines and escalate if needed.
• Communicate deficiencies and operate RPDM system to ensure timely reviews.
• Receive data, oversee transferring to the database, and analyze accuracy.
• Create conversion scripts for data from various sources into the destination format.
• Consolidate/merge duplicated data using comparison scripts or UI tools.
• Perform data matching between sources and present readable results.
• Write ad hoc queries to gather information such as coverage data and audit information.
• Develop new queries to be turned into standardized reports after gathering requirements.
• Develop a system for categorizing and storing scripts with documentation in a source control repository.

Skills

Data analysis

SQL queries

Excel

Relational databases

Analytical thinking

Attention to detail

Communication skills

Education

Four-year degree

Second-year college (no back subjects)

Tools

Access

Excel

Data editors

Job description

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.