Assistant Project Coordinator

WSP•Brentwood, TN

42d

About The Position

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.

Requirements

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.

Nice To Haves

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.

Responsibilities

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