Database Quality Control Analyst

**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**:

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