Data Quality and Reporting Analyst - Police Department

About the position

A vacancy exists in the Police Department, Administrative and Technical Information Services. This position involves creating programs to collect and input data into customized databases for management reporting tools, retrieving information, and producing reports from available databases. The role requires maintaining security and ensuring quality control of databases.

Responsibilities

• Creates programs to fulfill cyclical and ad hoc requests for data from numerous departments and agencies.
• Uses Structured Query Language to access data in relational database management systems.
• Builds and executes queries to accomplish complex inquiries and link subordinate files.
• Develops recommendations for data integrity issues and leads data integrity projects.
• Develops statistical control solutions.
• Writes programs to verify data and tests software.
• Plans and manages test activities.
• Works with programmers and vendor engineers to ensure systems are thoroughly tested.
• Finds and fixes database problems.
• Leads efforts to correct data and delegates projects for data correction.
• Educates staff on proper coding and data entry procedures.
• Oversees database maintenance.
• Develops efficiencies to increase reporting effectiveness.
• Identifies and implements ways to consolidate data.
• Maintains application security.
• Determines access rights of new users, deletes users, resets passwords, and provides instructions for system access.

Requirements

• Possession of a high school diploma or an appropriate equivalent.
• Three years of experience in the maintenance of complex databases including the entry and verification of data, two years of which were in the manipulation of data to generate reports.
• All applicants must be of good moral character and emotionally stable as determined by a comprehensive background investigation and drug test.