Circuit Court Of Jackson County, Missouri
	Vacant Position
	Date: 01/21/2022 Posting No.: 2021083
	REVISED & REPOSTED

Salary Range For Internal/Rehire Applicants: $29.75 - Hourly

EXTERNAL APPLICANTS CLICK HERE TO APPLY; INTERNAL APPLICANTS GO TO EPICOR ESS (The internal application for promotion/transfer may be obtained on the HR ICON on Lotus Notes) Employment Specialist: Amanda RIley. Applicants for clerical positions which require skill testing must be tested for consideration. ALL CURRENT EMPLOYEES APPLYING FOR THESE POSITIONS MUST SUBMIT AN INTERNAL APPLICATION FORM TO HUMAN RESOURCES.

POSITION PURPOSE: To utilize analysis and design techniques to solve problems using information technology to include designing, developing, and implementing timely and accurate reports to assist in management decisions for the Family Court.

MAJOR TASK STATEMENTS AND REPRESENTATIVE ACTIVITIES (Percentage of Time):
(The information contained herein is not intended to be an all-inclusive list of the duties and responsibilities of the job; other tasks/duties may be assigned. The area to which the job is assigned will govern which duties apply. Management reserves the right to amend and change responsibilities, work shift/schedule, facility, or department to meet business and organizational needs as necessary, including but not limited to the re-assignment of employees and positions, elimination of positions, and opening, moving, or closing of facilities and units.)

60% Design, develop, and modify reports, data, and/or databases, per user specifications.

· Create and maintain management reports to meet data analysis needs.
· Proactively investigate and identify reporting improvement opportunities to meet information service needs and solve problems.
· Design a meaningful system of audits (checks and balances) to ensure data provided from reports is reflected accurately.
· Monitor and improve the quality and accuracy of data analysis and reporting.
· Validate and analyze data applying critical thinking and analytical abilities.
· Produce recurring metrics and reports as well as create new reports as requested.
· Serve as a primary contact for all ad hoc reporting requests and help build and maintain a self-service reporting model.
· Develop ad hoc reporting and analyses into standardized tools that can be used by management.
· Create and run reports from Microsoft Access with users input.
· Troubleshoot technical problems experienced by users of Access databases in various functional areas.
· Develop and create dashboards (using dashboard software, i.e., Tableau) to share data pulled from JIS to present data to Family Court decision makers.
· Maintain dashboards for regular reporting (daily, weekly, monthly, quarterly, annually).
· Perform related work as required to include but not limited to serve on teams/committees as assigned, cross-training for other jobs as assigned, and special projects as assigned.

· Ensure there is a common understanding of the goals, features, and constraints of reporting projects.
· Work collaboratively with Family Court staff to apply subject matter expertise to determine best practices and working procedures.
· Consult with employees across functions and management to determine their data entry practices and data requirements.
· Develop agency standards and procedures for inputting data into JIS and other databases and train employees to follow them.
· Document data access procedures and train users in the access and use of reports.

· Consult with management staff to identify and solve a variety of problems and to clarify management objectives.
· Consult with requester regarding requirements for information and presentation of data.
· Confer with management and users about format, distribution, and purpose of reports to assist in identifying problems and improvements.
· Identify how to improve databases and implement improvements with input from users.
· Provide project management support in designing systems, implementing changes and training/motivating others to use the systems.

· Create and develop website graphics, content navigational methods and informational databases, which involve the use of applicable programming language and processes.
· Develop, update, and modify Adobe products and information on the Internet site.
· Develop, update, and modify the Family Court’s intranet site to provide information to employees that will assist them in their jobs.
· Train employees to update information on the internet and intranet sites as needed.

MINIMUM EDUCATION AND EXPERIENCE:

(Education above the minimum stated may be substituted on a year for year basis for the required general experience; experience above the minimum stated may be substituted on a year for year basis for the required education.)

EDUCATION: Bachelor’s degree in educational or social sciences, economics, data analytics, statistics, information technology, or related field. Master’s degree in educational or social sciences, economics, data analytics, statistics, information technology, or related field ,or certification in data analytics is preferred, but not required.

EXPERIENCE:Two years’ experience manipulating data contained in computer information systems/databases and in the use of specialized report development software; experience may be acquired from educational practice or work experience in an information services or business environment. Experience must also include some website design.

Education, experience, or a combination thereof must demonstrate ability to manipulate data contained in computer information systems/databases.

SPECIAL REQUIREMENTS:

· Must be proficient in Microsoft Office applications.
· Must have strong organization, analytical, critical thinking, and innovative problem solving skills.
· Familiarity with dashboard software (i.e. Tableau) preferred.
· Must submit to and pass criminal background check as prescribed by Courts.
· Sex offender registry check and MO & KS child abuse and neglect checks.
· Employees in this position are subject to random and reasonable suspicion testing for illegal drug use.

· Knowledge of the principles of personal computer business processing and software applications, i.e. Microsoft Office.
· Ability to become proficient in the use of specialized report development software, specifically Microsoft Access, Cognos Report Net Studio, and Tableau.
· Ability to manipulate data and write code/syntax for computer information systems/databases.
· Ability to communicate effectively, both orally and in writing.
· Ability to prepare clear, complete and concise reports which can be detailed and statistical in nature.
· Ability to identify and interpret user business requirements to assist in data analysis/reporting.
· Ability to train employees.
· Ability to present material clearly and logically both orally and in writing.
· Ability to establish and maintain effective working relationships with others {employees, judges, attorneys, court officials, and/or the general public}.
· Ability to produce accurate detailed work within tight deadlines.
· Ability to tackle a problem by using a logical, systematic, sequential approach.
· Ability to show initiative, good judgment, and resourcefulness.