District Attorney III

LOCATION OF (1) POSITION TO BE FILLED: DEPARTMENT OF HEALTH

SUMMARY: Under general supervision, is responsible for professional statistical analytic and programming work of considerable difficulty and performs related work as required.

DISTINGUISHING FEATURES: This is the advanced-working-level class in the Statistical Programmer Specialist sub-series. An employee in this class writes complex programs to obtain statistical data and reports. This class differs from that of Statistical Programmer Specialist 1 in that an incumbent of the latter writes mostly queries and conducts statistical computer programming of less complexity.

Other Requirements

• Writes complex statistical programs in a variety of programming languages that instruct the computer to extract data and solve specific problems; designs statistical programs to create meaningful reports; codes each variable of the data to be extracted (i.e. gender, race, position title, salary); identifies and corrects errors in program; modifies data and variables to achieve the desired information for accurate analysis of results for projects or requests; creates data dictionaries and code-books; describes variable locations, names, and values; records history and origin of data; defines file formats.
• Compiles and analyzes data to provide answers to users' requests or questions; accesses databases; performs descriptive, predictive, and inferential statistical analyses; identifies supply and demand, expenditures, and trends; calculates frequency distributions, percentiles, measures of central tendency, variability, sampling error, correlations, analysis of variance, chi square, regression, and other related statistical measures; creates graphical representations of outcomes produced by data analysis.
• Reviews output data to ensure requested information for project analysis has been met (e.x., number of female lawyers practicing in the State of Tennessee); ensures all fields are complete; ensures variable values are accurate; checks for duplicate records; verifies consistency between data and code-book.
• Develops and maintains databases, program libraries, and report libraries; creates databases for file storage; determines how and where files are stored; scans databases to ensure all fields are completed; backs-up and archives databases; checks data for accuracy.
• Confers with systems analysts to develop new or to modify existing computer programs as needs arise or change; develops data entry and recording systems in a variety of software packages; reviews software and system operation manuals to learn system procedures; implements system checks; tests system to identify hardware and software problems; assists in writing new or modifying existing programs.

Education and Experience: Graduation from an accredited college or university with a bachelor's degree, including at least nine quarter hours of statistics or computer science and experience equivalent to one year full-time professional statistical programming or database administration work.

Substitution of Graduate Education for Experience: Graduate course work credit received from an accredited college or university statistics or computer science may substitute for the required experience on a month-for-month basis to a maximum of one year (e.g., 36 graduate quarter hours in one or a combination of the above listed fields may substitute for one year of the required experience).

Note: A transcript is required for a proper evaluation for this class.

Competencies (KSA's)

NECESSARY SPECIAL QUALIFICATIONS: None.

EXAMINATION METHOD: Education and experience rating, 100%.

State Employee Benefits

• Insurance There are a variety of insurance options available to state employees including:
• Health Insurance
• Dental Insurance
• Vision Insurance
• Life Insurance
• Annual Leave Full-time employees earn annual leave each month at a rated based on years of service as follows:

Years of Service
• 0 up to 5
• 5 up to 10
• 10 up to 20
• 20 or more

Annual Leave Earned per Month
• 1 day
• 1 and ½ days
• 1 and ¾ days
• 2 days

Maximum Allowable days
• 30 days
• 36 days
• 39 days
• 42 days
• Leave earned in excess of the maximum allowable days will be transferred to the employee's sick leave account annually on the employee's anniversary hire date.
• Sick Leave All full-time employees accrue 1 day (7.5 hours) of sick leave per month, provided they work the major portion of that month.
• Bereavement Leave Leave with pay is granted for three days in the event of the death of an employee's spouse, child, stepchild, grandchild, parents, grandparents, siblings, stepparents, foster parents, or parents-in-law without charge to the employee's leave time. Two additional days of sick leave may be granted to provide a total of five days absence for this purpose.
• Family Medical Leave Allows up to twelve work weeks of leave* each year to eligible employees for certain family and medical reasons. Continued health insurance coverage is provided during the leave period, and the employee is reinstated to the same or an equivalent position once the leave period has ended.
• Leave may or may not be paid leave, depending on individual employee's leave balances for earned leave.
• Parental Leave Parental leave is an absence from work granted any employee who has been employed in state service for at least 12 consecutive months as a full-time employee. Parental leave is a combination of sick, annual, or special leave without pay for a period not to exceed four months following the birth of a child.
• Military Leave Granted in accordance with applicable state and federal laws, rules and regulations.
• Holidays Each year, full-time state employees receive 11 holidays off with pay.
• Retirement State employees are automatically members of the Tennessee Consolidated Retirement System . (TCRS) Employees must accrue 5 years of creditable state service to be vested (guaranteed retirement benefits when age requirements are met). Vested members of TCRS become eligible for service retirement upon completion of 30 years of creditable service or upon attainment of age 60.
• Deferred Compensation Employees may choose to make pre-tax contributions to a variety of investment options through the 401(k) plan or the 457 plan. A minimum $20 monthly contribution is required to participate in the plans. For the 401(k) plan, the state will match the $50 per month minimum contribution. The $50 match policy is evaluated on an annual basis.
• Flexible Benefits Plan Under this program certain specific expenses (e.g.,medical and dental insurance premiums, medical expenses, dependent day care expenses) can be deducted from an employee's paycheck prior to taxes, resulting in a lower taxable income level.
• Higher Education Fee Discounts and Waivers A 25% discount on undergraduate tuition at any state operated institution of higher learning in Tennessee is available to children 23 years of age or under of full time state employees. In addition, full-time state employees with six months of continuous service are eligible to have tuition fees waived for one course per semester at a state institution. For further information on higher education discounts, click on Chapter 1540 on the Secretary of State Rules and Regulations web page.
• Baccalaureate Education System Trust (BEST) Program (BEST) The Baccalaureate Education System Trust (BEST) was created by the Tennessee General Assembly for the purpose of providing Tennessee families with a means to save for their children's future college education costs.
• Wellness Program The State Employee Wellness Program works to increase employees´ knowledge of options for healthier lifestyles through information and events that focus on improving behaviors affecting your health. Some specific benefits offered through the program include health risk assessments, fitness events, smoking cessation programs, and various other benefits.
• Employee Assistance Program (EAP) EAP is a confidential counseling and referral service for all employees and their dependents. All services are strictly confidential and can be accessed 24 hours a day, 365 days a year.

01

Please carefully review the minimum qualifications listed below for STATISTICAL PROGRAMMER SPEC 2 and then answer the question which follows. Education and Experience: Graduation from an accredited college or university with a bachelor's degree, including at least nine quarter hours of statistics or computer science and experience equivalent to one year full-time professional statistical programming or database administration work. Substitution of Graduate Education for Experience: Graduate course work credit received from an accredited college or university statistics or computer science may substitute for the required experience on a month-for-month basis to a maximum of one year (e.g., 36 graduate quarter hours in one or a combination of the above listed fields may substitute for one year of the required experience). ____________________________________________________ Q. To the best of your understanding of the minimum qualifications listed above, do you believe you meet the requirements for STATISTICAL PROGRAMMER SPEC 2? Please Note: Your qualifications must be documented in your application and are subject to verification. For any education completed outside of the United States, an evaluation report for U.S. equivalency should be submitted with your application. The evaluation report must be from an acceptable foreign education credential evaluation service. Call 615-741-4841 if you need further information.

• Yes
• No
• Required Question