• Assistant Project Coordinator

    WSP USA (Dallas, TX)


    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