Database Quality Control Analyst - Cobourg, Canada - The MEARIE Group

The MEARIE Group

Verified Company

Cobourg, Canada

3 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

JOB VACANCY

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:

Postsecondary 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.