Residential Service Contracts Administrator

We are a full-service mechanical contractor providing customers in the commercial, residential, and industrial sectors with innovative, energy-efficient heating and air conditioning services, automation and controls, industrial piping, new construction design and installation, and maintenance and replacement services.

About the role

Oversee accurate service contract record keeping and revenue generation. Assist in assuring timely completion of maintenance services. Research markets within our service area for potential market targeting for future contracts. Sell contracts by responding to customer requests and offer contracts through duties as backup CSR. Recapture terminated agreement customers. Process accurate SPIFF commission reporting.

Responsibilities

• Create new agreements
• Perform agreement cancellations
• Perform agreement renewals
• Ensure accurate asset model and serial number data
• Generate accurate monthly booking report
• Generate accurate maintenance billings
• Generate outstanding maintenance visit reporting
• Generate PM service orders
• Generate renewal letters
• Generate seasonal maintenance reminder communication
• Interact with customers to obtain payments, answer billing and T&C questions, provide requested documentation, perform requested updates, etc.
• Interact with dispatch team to perform accurate agreement updates
• Interact with sales team to ensure accurate SPIFF commission payout
• Maintain accurate agreement file records
• Maintain accurate location information in operating system and tracking spreadsheets
• Maintain accurate master list records
• Maintain accurate revenue schedules
• Research and resolve unallocated payments
• Track and submit SPIFF commission reporting for contract sales and pull through sales
• Customer service representative duties
• Assist in scheduling maintenance visits, as needed
• Assist on special projects as needed by service management
• Backup receptionist, as needed

Qualifications

Education and Experience

• High School diploma or equivalent required
• Three or more years of office or administrative experience preferred
• Experience in a demanding service environment or construction industry is a plus

Skills

Required Skills

• Advanced Microsoft Excel ability required (Must be proficient in Macros, VLOOKUP, XLOOKUP, Charts, CONCATENATE, Conditional Formatting, Countif, Filter, Flash fill, Index match, PivotTables, Proper, Replace, Round, Sum)
• Advanced experience with Microsoft Word required (Must be proficient in Mail Merge)

Required Attributes

• Must demonstrate the ability to perform basic business mathematical functions
• Must demonstrate the ability to work accurately and efficiently in a fast paced environment
• Must demonstrate the ability to think analytically to produce accurate and timely results
• Must demonstrate the ability to build positive working relationships with multiple levels of personnel and management
• Must demonstrate the ability to follow-up on tasks and assignments in a timely manner
• Must demonstrate extremely professional written and verbal communication skills
• Must demonstrate the ability to multi-task and work effectively in a busy team environment
• Must demonstrate the ability to prioritize work assignments and utilize independent thinking within the scope and authority of the position
• Must demonstrate the ability to follow standard operating procedures
• Must demonstrate the ability to work with minimal supervision through personal initiative and dedication to accuracy

Benefits

We offer employees a competitive salary and benefits package.