Assistant Project Coordinator

Overview

Assist with billing, database upkeep, and customer service for a stormwater utility.

Key Responsibilities

• excel invoicing
• report development
• database management
• billing transactions
• client communication
• payment reminders

Tasks

-Prepare and/or send excel spreadsheets, new invoices or copies of invoices to customers -Develop summary and trend reports to support billing accuracy, revenue tracking, and program performance -Research and contact customers for calls as instructed by client -Preparing letters to customers -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. -Communicate billing details, updates, and policy information accurately and effectively -Research and answer customer calls and emails as needed -Respond to client concerns promptly and works collaboratively to resolve issues -Build and maintain strong client and customer relationships through clear communication and follow-up -Record each call and email in appropriate database -Contact customers for payment reminder purposes. This includes locating current phone numbers. -Create billing and payment transactions as needed

Requirements

• word
• excel
• access
• sql server
• project coordination

What You Bring

-Proficiency in Microsoft Word required for document preparation, formatting, and editing. -Must have strong Microsoft Excel skills, including the ability to manage datasets, use formulas, and develop summary reports. -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. -0-2 years of experience in project coordination

People Also Searched For

About Wsp

-Partners with clients to create sustainable, efficient, and resilient solutions. -Known for iconic projects like the One World Trade Center and London's Crossrail. -Provides cutting-edge services in transportation, energy, water, and commercial developments. -Blends technical expertise with deep industry knowledge to solve complex challenges globally.

Sector Specialisms