Data Analyst I

By | 11th July 2019
  • Pasig

Website Realpage

We are a leading global provider of software and data analytics to the real estate industry. Clients use our platform to improve operating performance and increase capital returns. Founded in 1998 and headquartered in Richardson, Texas, RealPage currently serves nearly 12,200 clients worldwide from offices in North America, Europe and Asia.

Summary

The Data Analyst I is responsible for 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.

Primary Responsibilities

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.

Updating existing data in the system using information provided by the Data Acquisitions supervisor.

Performing data matching based on common fields between disparate data sources and return the results in a readable format.
Learning the internal schema of the destination system to be able to find data in a timely manner.

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.

Create documentation around specific data scrubbing and loading processes within the destination system based on training provided by the Data Acquisitions supervisor.

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.

Also responsible for other duties as assigned including:
Assisting in the development and testing of enhancements to transformation tools.

Assist in quality assurance testing of data that was loaded into the system.

Requirements

College degree of any 4 year course or at least 2nd year college with out back subjects.

1-2 years’ experience managing data with Access, Excel and data editors .

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

To apply for this job email your details to francis.flores@realpage.com

Category: