Database Quality Control Analyst | Lakefront Utility Services

JOB VACANCY 

Lakefront Utility Services Inc. (LUSI) is located in the Town of Cobourg on Lake Ontario, half hour east of Oshawa.  As a multi-service utility providor, Lakefront is proud to provide reliable and cost effective electric, water and fibre distribution services in the Town of Cobourg. We also provide water operations in Grafton, and electrical service in the Village of Colborne. For more information, please visit our website at: https://www.lakefrontutilities.com/

Database Quality Control Analyst

JOB DESCRIPTION: 

Lakefront Utility Services Inc. requires a dynamic, highly motived, and proactive Database Quality Control Analyst. Reporting directly to the Regulatory Compliance & Billing Supervisor, you will work in a team environment. This is an excellent opportunity to use your knowledge and experience in a fast-paced, environment of professionals dedicated to customer service, collaboration, and cooperation.

Lakefront delivers access to career and development opportunities, safe and healthy workplaces, effective training, and positive work-life balance, so that employees can perform at their best and contribute to their communities.

RESPONSIBILITIES INCLUDE:

The Database Quality Control Analyst gathers, analyzes, and reports data related to Lakefront Utility Services customers. Responsible for: ensuring data is correct; supporting management with information that assists with decision-making; and enhancing the process of reporting on accuracy and performance. This role includes performing queries, analyzing customer accounts, updating financial spreadsheets, and performing database analysis.

• Calculate, prepare and issue documents related to customer accounts, including billings and other account consumption and revenue information. 
• Monitor and review by conducting control audits, the quality assurance of bills produced by the billing department.
• Review quality control of credit balances, refunds, and advise on adjustments and/or corrections to customer accounts.
• Ensure billing department is compliant with established practices, overseeing all billing processes, adjustments and corrections and reporting on billing accuracy.
• Maintain and review revenue generation metrics, ensuring department goals are met.
• Monitor the data integrity of systems ensuring proper quality controls are in place.
• Ensure the integrity of research project data, possibly including data extraction, processing, storage, manipulation, and analysis.
• Support new product development and continuous improvement by integrating quality control tools into processes.
• Act as a point of contact between the customer information system service provider(s) for support and troubleshooting.
• Responsible for logging support tickets to our respective software support companies.
• Develop methods to enable the accurate measurement of quality results.
• Assess the quality of the systems and processes in place in order to identify shortfalls.
• Analyze exception reports to track inconsistencies and identify core issues. 
• Produce monthly reports showing the quality assurance results from the team; present findings and weaknesses, as well as a plan of action to correct or mitigate the weaknesses. 

QUALIFICATIONS:

• Post-secondary education in Business /Statistics/Computer Science or a related field.
• Advanced Microsoft Office Excel.
• SQL, Power Query Editor, Python, or similar query writing experience.
• 2 years' experience in database interrogation and/or database management considered an asset.
• Experience in the utility industry is an asset.
• Ability to read and interpret procedure manuals and reports.
• Strong mathematical and analytical skills.
• Strong presentation skills, both verbal and written, using software to analyze and present results.
• Attention to detail and accuracy.
• Excellent interpersonal skills, with the demonstrated ability to engage and communicate effectively with both internal and external clients and foster positive relationships.
• Effectively manage multiple activities of varying complexity while under time constraints. 

Interested candidates are invited to submit a resume, in confidence, by 4:30 p.m. April 7th,2023, to the attention of Human Resources, 207 Division Street, PO Box 577, Cobourg, ON K9A 4L3 or by email to hr@lusi.on.ca. Please indicate the position title in the subject line of your email.

 We appreciate the interest of all candidates, however, only those selected for an interview will be contacted. The successful candidate will be required to submit a satisfactory criminal screening and three satisfactory reference checks as a condition of employment.

Lakefront Utility Services Inc. is committed to fairness and equity in employment and our recruitment and selection practices. We encourage applications from Indigenous peoples, people with disabilities, members of sexual minority groups, members of racialized groups, and any others who may contribute to the further diversification of our organization. Accommodation will be provided in all parts of the hiring process. Applicants need to make their requirements known in advance to: hr@lusi.on.ca

Please note that vaccination against COVID-19 is a requirement as a condition of employment, subject to the Ontario Human Rights Code.