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.
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.
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.
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 email@example.com