Job Summary:

The Computer Programmer Analyst II performs independent work analyzing data collected in COMPAS, the licensing and enforcement database application, generating ad hoc and routine reports, and identifies data integrity issues.  

Job Description:

• Perform data analysis for the COMPAS database and data warehouse

• Develop advanced SQL queries and create reports for routine and ad hoc report requests for DOH employees to support program management and reporting requirements

• Generate ad hoc reports for the general public

• Produce reports for the MQA Annual Report, the Secretary’s Quarterly Report, and legislative performance measures

• Review and analyze reports prior to release to ensure the integrity of the data

• Research, collate, and compile data for special projects

• Monitor the SPS tracking system to ensure incoming requests are processed in a timely manner

• Perform data entry into SPS tracking system to provide status updates and document report completion

• Provide customer service to the general public and answer questions received via e-mail, the internet, and telephone

• Generate invoices, track payments, burn reports to CD, and mail CDs to public customers

• Analyze and identify requirements for new software and software modifications

• Design custom client/server software applications using Microsoft Access

• Perform requirements analysis and write design specifications, other technical documentation, and instruction manuals

• Develop, install, and maintain custom software applications, reports, and data conversion and validation programs

• Provide training and support to users as needed

• Perform project management as needed

• Follow defined business processes within specified time frames

• Prepare project documentation including but not limited to, Statements of Work, project plans, status reports, and project completion reports

• Serve as the COMPAS Navigator for the office, which includes being a liaison between the office and Systems Support Services on all COMPAS issues, and for SSS initiatives

• Serve as the first point of contact for training needs, technical support, information dissemination, and trouble-shooting user problems

• Train new employees in the use of COMPAS

• Attend all COMPAS Navigator meetings or send a back-up

• May assist with set-up and changes to form letters and task inventories, data cleanup and other issues related to COMPAS

• May produce COMPAS reports as needed

• Perform related work as required. 

• Ability to write computer programs for various purposes

• Ability to communicate effectively with others in writing as indicated by the needs of the audience

• Ability to understand written sentences and paragraphs in work related documents

• Ability using logic and analysis to identify the strengths and weaknesses of different approaches

• Ability finding ways to structure or classify multiple pieces of information

• Ability to conduct tests to determine whether equipment, software, or procedures are operating as expected

• Ability to teach others how to do something

• Ability to identify the nature of problems

• Ability working with new material or information to grasp its implications

• Ability to listen to what other people are saying and to ask questions as appropriate

• Ability to determine what is causing an operating error and deciding what to do about it

• Knowledge of computer software including applications

• Knowledge of numbers, their operations, and interrelationships including one or more of the following: arithmetic, algebra, geometry, calculus, statistics, and their applications

• Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar

• Knowledge of data processing flowcharting techniques

• Knowledge of administrative and clerical procedures and systems

• Knowledge of media production, communication, and dissemination techniques and methods including alternative ways to inform and entertain via written, oral, and visual media.