Data Analyst I - Remote/Hybrid, SQL & Reporting

Realpage; Pasig; Hybrid; PHP 335,000 - 603,000; Full time

Job summary

Realpage is seeking a Data Analyst to analyze, monitor, and support on complex procedures regarding program requirements of affordable housing. The role includes collecting vendor data, importing into a database, and QA testing through the UI.

The analyst will review resident files, run ad hoc queries, create conversion scripts, and develop standardized reports while ensuring accuracy and timely delivery across multiple systems.

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.
• Receiving data, overseeing the transferring of the data to our database, and analyzing the data for accuracy and compared to what is in 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.

Skills

Data analysis

Attention to detail

Written and verbal communication

Time management

Analytical thinking

Problem solving

Data quality assurance

Education

4-year college degree

Fresh graduates welcome

Tools

MS Access

Excel

SQL basics

Job description

Realpage is seeking a Data Analyst to analyze, monitor, and support on complex procedures regarding program requirements of affordable housing. The role includes collecting vendor data, importing into a database, and QA testing through the UI.

The analyst will review resident files, run ad hoc queries, create conversion scripts, and develop standardized reports while ensuring accuracy and timely delivery across multiple systems.