INFORMATION SYSTEMS CONSULTANT - 66542

Executive Service

TennCare compensation is equitable and will be based on education and experience for a qualified candidate in accordance with Department of Human Resources (DOHR) policy.

The Division of TennCare is dedicated to providing our employees with a hybrid work environment. All TennCare positions have a combination of work from home and work in the office, which varies by position, department, and business need. You may review the specific expectations with our hiring team.

Background Check:

This position requires a criminal background check. Therefore, you may be required to provide information about your criminal history in order to be considered for this position

Who we are and what we do:

TennCare is Tennessee's managed care Medicaid program that provides health insurance coverage to certain groups of low-income individuals such as pregnant women, children, caretaker relatives of young children, older adults, and adults with physical disabilities. TennCare provides coverage for approximately 1.7 million Tennesseans and operates with an annual budget of approximately $14 billion. It is run by the Division of TennCare with oversight and some funding from the Centers for Medicare and Medicaid Services (CMS).

TennCare's mission is to improve the lives of Tennesseans by providing high-quality cost-effective care. To fulfill that purpose, we equip each employee for active participation and empower teams to communicate and worked collaboratively to improve organizational processes in order to make a difference in the lives our members. Because of the positive impact TennCare has on the lives of the most vulnerable Tennesseans, TennCare employees report that their work provides them with a sense of meaning, purpose, and accomplishment. TennCare leadership understands that employees are our most valuable resource and ensures professional and leadership development are a priority for the agency.

Job Overview:

The position is necessary for Analyzing and Testing using SQL, PL/SQL and other languages, working with the staff of TennCare' s MMIS Facilities Manager Contractor, Gainwell which includes Business Analyst Developers and Testers for validating Bureau priority projects to support MMIS/TEDS Operations. Priority Projects include but not limited to interfaces through TennCare Eligibility Determination System (TEDS), Department of Intellectual Development Disabilities (DIDD) new waiver projects, Financial, Enrollment and validating Eligibility. Develop and maintain low to medium complexity programs in SQL/UNIX, EZ-Retrieve, PL/SQL, C++ or other programming languages, for retrieving data, verifying system test and production output, and creating reports related to enrollee eligibility, financial, and/or other subsystems. Review low to high complexity system specifications and operations manuals to define the capabilities and deficiencies in the existing system.

Review production output on a daily basis to ensure the system is performing according to guidelines specified by TennCare. Research, document, and recommend solutions for low to high complexity issues encountered in production systems or specific programs; interprets messages or outputs, or answers questions from a project manager and end users when unexpected or potentially incorrect outcomes occur in the execution of Design and writes low to high complexity eligibility, financial, and/or other system business requirements according to TennCare eligibility business rules for low to high impact sub-systems; develop sub-system flows, write and review design narratives, and test plans detailing requirements necessary to accomplish TennCare eligibility business goals; work with vendors (Gainwell, etc.) to translate into procedural source code; assist vendor in identifying test conditions and contingencies; review written program code and check program results against expected outcome specified in the test plan. Analyze low to high complexity program changes by vendors for accuracy and functionality specified by management including developing and executing code for verifying output. Other duties as assigned may include duties assigned by Director, attending meetings, working in multiple areas as needed, create records for Director/Manager. Position requires ability to present written and oral skills along with logical thinking.

Key Responsibilities:

1. Lead the validation of UAT result.
2. Understands federal and state legislation/regulations such as guidelines, laws, and policies
3. Review low to high complexity system specifications and operations manuals to define the capabilities and deficiencies in the existing system.
4. Develop and maintain medium to high complexity programs in SQL, PL/SQL, Excel or other programming languages, for retrieving data, verifying system test and production output, and creating reports related to enrollee eligibility, financial, and/or other subsystems.
5. Review production output on a daily basis to analyze the system is performing according to guidelines specified by TennCare.
6. Research, document, and recommend solutions for low to high complexity issues encountered in production systems or specific programs; interprets messages or outputs, or answers questions from project manager and end users when unexpected or potentially incorrect outcomes occur.
7. Analyze low to high complexity program changes by vendors for accuracy and functionality specified by management including developing and executing code for verifying output.
8. Gathers requirements and Review system and business requirement from stakeholders to develop automated solutions to business problems.
9. Develop, review, and distribute reports and date extract.
10. Evaluates information systems operations, activities, and functions within area of expertise and makes recommendations for improvements in overall planning, economy, efficiency, and quality in these areas by Run PLSQL and SQL queries.
11. Analyzes the technology portfolio for trends impacting costs, schedules, and quality.
12. Attend work group and project related meetings and supervise a team in the prioritization of work based on business user priorities as defined by the subsystem work groups

Minimum Qualifications:

Education and Experience:

• Graduation from an accredited college or university with a bachelor's degree and five or more years of experience in any of the following:
• Systems training, systems analysis, systems design, technical support (i.e., the diagnosis and resolution of software and hardware malfunctions for computer or other information systems, as well as the technical justification for procuring software or hardware products), applications programming, network design, or telecommunications design.

OR

• Leading, supervising, consulting, directing, or managing the process involved in planning and implementing new information systems, or planning and integrating new technologies into existing systems.

Substitution of Experience for Education:

• Professional experience in any of the following areas may substitute for the required bachelor's degree on a year-for-year basis to a maximum of four years:
• Systems training, systems analysis, technical support, applications programming, network design, or telecommunications design

OR

• Leading, supervising, consulting, managing, or directing the processes involved in planning and implementing new information systems or planning and integrating new technologies into existing systems.

Desirable qualifications:

• Knowledge of a Programming Language
• Knowledge of Data Structure
• Knowledge of Testing Techniques
• Knowledge of Programming Concepts
• Knowledge of Systems Development Life Cycle
• Knowledge of Cloud AWS platform.
• Routinely write SQL queries in relational databases like PostgreSQL, Oracle in a cloud or on-premises setup.

Pursuant to the State of Tennessee's Workplace Discrimination and Harassment policy, the State is firmly committed to the principle of fair and equal employment opportunities for its citizens and strives to protect the rights and opportunities of all people to seek, obtain, and hold employment without being subjected to illegal discrimination and harassment in the workplace. It is the State's policy to provide an environment free of discrimination and harassment of an individual because of that person's race, color, national origin, age (40 and over), sex, pregnancy, religion, creed, disability, veteran's status or any other category protected by state and/or federal civil rights laws.