Assistant Project Coordinator

This Opportunity

WSP is initiating a search for a full-time Assistant Project Coordinator, located near Brentwood, TN or Dallas, TX. WSP USA, Inc. serves as the third-party billing contractor for a local stormwater utility. As the third-party billing contractor, WSP maintains the storm water customer account databases and is responsible for invoicing and accounting of receipt of the storm water fees.

Your Impact

Database Maintenance

+ Update and maintain approximately 35 databases including tables, queries, and macros as needed, to ensure data accuracy and integrity. The databases are for reporting and QA/QC, special requests, creating bills and payments, reconciling and reviewing accounts.

+ Develop summary and trend reports to support billing accuracy, revenue tracking, and program performance

Customer Service

+ Research and contact customers for calls as instructed by client

+ Research and answer customer calls and emails as needed

+ Record each call and email in appropriate database

+ Create billing and payment transactions as needed

+ Prepare and/or send excel spreadsheets, new invoices or copies of invoices to customers

+ Preparing letters to customers

+ Contact customers for payment reminder purposes. This includes locating current phone numbers.

Client Relations

+ Build and maintain strong client and customer relationships through clear communication and follow-up

+ Communicate billing details, updates, and policy information accurately and effectively

+ Respond to client concerns promptly and works collaboratively to resolve issues

Who You Are

** Required Qualifications*
* + 0-2 years of experience in project coordination

+ Must have strong Microsoft Excel skills, including the ability to manage datasets, use formulas, and develop summary reports.

+ Proficiency in Microsoft Word required for document preparation, formatting, and editing.

** Preferred Qualifications*
* +

Experience with Microsoft Access for data entry and database management.  The majority of the storm water data is stored in a Microsoft SQL Server with various Microsoft Access databases as connections to the data.  Numerous queries designed for the utilization of the data are located in Access.

LI-SR1