What are the responsibilities and job description for the Assistant Project Coordinator position at Lensa?
Lensa is a career site that helps job seekers find great jobs in the US. We are not a staffing firm or agency. Lensa does not hire directly for these jobs, but promotes jobs on LinkedIn on behalf of its direct clients, recruitment ad agencies, and marketing partners. Lensa partners with DirectEmployers to promote this job for WSP. Clicking "Apply Now" or "Read more" on Lensa redirects you to the job board/employer site. Any information collected there is subject to their terms and privacy notice.
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
Required Qualifications
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
- 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.
- 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
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.
- 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.