Customer Master Record Administrator

City of Edmonton•Edmonton, AB

1d•Onsite

About The Position

Join a dedicated team at the heart of the City of Edmonton’s financial operations. As a Customer Master Record Administrator, you will play a key role in maintaining the integrity of our Customer Master records—from initial creation and governance to strategic account management. This is a dynamic opportunity to apply your expertise in accounting principles while providing top-tier service to City departments and ensuring the accurate, timely collection of outstanding accounts in alignment with City policy.

Requirements

A recognized accounting certificate and one (1) year of experience in an office environment.
Demonstrated competency in the use of spreadsheet and word processing applications
One (1) year of experience in an office environment and demonstrated competency in the use of spreadsheet and word processing applications
Knowledge of corporate and departmental policies, procedures, bylaws and processes in the performance of accounts receivable duties
Knowledge and understanding of provincial and federal legislation regarding the accounts receivable duties
Competency in the use of Microsoft Word and Excel, and Google applications & others financial softwares (i.e. SAP AR module)
Basic knowledge of accounting, administrative procedures and regulations including GAAP, POPA and GST
Ability to contribute as a positive team player in a customer focused service environment
Strong organizational skills with the ability to work independently and accurately with attention to detail
Strong communication skills, being courteous, positive problem-solving skills and being respectful when administering established policies and practices
Strong customer service skills and abilities to deal courteously with the public, and in making decisions within established policies/procedures
Alignment to our Cultural Commitments and Leadership Competencies (https://bit.ly/4brRrXm)
Embracing a culture of equity, diversity, reconciliation and inclusion

Responsibilities

Create Customer Master Records on a timely basis, completely and accurately. Ensure that an account doesn't already exist for the customer being billed
Research incomplete addresses through search tools available
Communicate changes to the customer master record to the affected business area, collection agency and with Legal services
Record notes to a customer master record to ensure data integrity
Block master records must be reviewed monthly for inactive records
Check, verify, validate and ensure adequate supporting documentation is collected upon request to create a customer master record and are attached in SAP
Manage the Banking Information in SAP Master record maintenance for Pre-Authorized Debit payment customers
Apply accounting principles and practices in the maintenance and updating of accounts receivable records
Update records to identify and mark for deletion of any duplicate accounts
Research incomplete addresses and other missing fields through search tools available
Ensure appropriate contacts are identified to verify information is complete
Improve customer master data to reduce unnecessary effort associated with clarifying information when pursuing outstanding receivables
Update the key interest indicator prior to interest run for accurate calculation on a monthly basis.
Ensure timely review to avoid duplication by the use of consistent search terms by AR as set out in the standard operating procedure
Identify and report customer master accounts that are being requested to create with the same owner but under different names with poor payment history including bad debts written off and for accounts being deemed uncollectible
Update master record when customer payment history is declining or remaining unpaid
Maintain good public relations in the performance of Accounts Receivable duties by being courteous and make decisions within established policies and procedures
Additional related duties as required