Database Quality Control Analyst - Cobourg, Canada - The MEARIE Group
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.
More jobs from The MEARIE Group
-
Specialist, Financial Planning
Mississauga, Canada - 1 week ago
-
Line Sub-foreman
Halton Hills, Canada - 1 week ago
-
President & Chief Executive Officer (CEO) / Synergy North
Northwestern Ontario, Canada - 1 week ago
-
Journeyperson Powerline Technician
Orangeville, Canada - 1 week ago
-
Scada, Network
Innisfil, Canada - 1 week ago
-
Utility Arborist
Waterloo, Canada - 1 week ago