Assistant Project Coordinator

Job Description

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.