Previous Job
Data Analyst
Ref No.: 18-13552
Location: NYC, New York

Manager looking for SQL, MS Access, Excel and have a working knowledge of Tableau

Data Analyst to rack, monitor and analyze data from new systems and legacy system to improve billing performance. 
Investigate and manage and correct data exceptions in the company meter data management system 
Investigate and correct exception queues in the new systems 
Identify data patterns and issues with new system synchronization. 
Create process summaries necessary for data and account resolution 
Organize system database exports into formal reporting structures for analytics and issue resolution purposes. 
Candidate must be a self-starter that actively engages issues seeking resolution. 
Candidate must utilize system-generated exception work queues for work assignment, self-reporting on progress, and transaction correction through User Interface as issues are identified and corrected. 
Candidate must be able to communicate and engage in a team environment.

Experience with developing and refining database reporting tools. 
Billing or Customer account transaction management experience 
Experience with data collation and reporting for analytics and issue resolution purposes. 
Experience with large data set management, discrepancy investigation and data cleanup 
Experience with data presentment and analysis from multiple databases. 
Experience with account transaction investigation and correction through data scripts or User Interface 
Ability to learn applications with proper training. 
Ability to communicate clearly with business users and technical support teams 
Demonstrated capability to develop and refine business process documents 
Strong verbal skills - with the ability to clearly communicate issues and resolution 
Ability to interpret business requirements and technical documents 
Database synchronization troubleshooting experience is required - data management and comparison experience between multiple systems.

The following are not required for this position but would be considered as a valuable asset in a potential candidate. 
Experience with defect management and reporting tools (i.e. Rational) for issue identification, work assignment, communication and resolution. 
Experience with executing business system test scripts, documenting and reporting testing results. 
Experience with data analysis and interpretation and account/field/record correction. 
Experience with utility energy management systems or billing systems 
Demonstrated experience with data retrieval from databases, and running comparison scripts to identify discrepant information.