INFORMATION SYSTEMS TECHNOLOGY CONSULTANT - 65596

Executive Service

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 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:

Data Management Team is responsible for all the data contained within the TennCare domain. This includes providing oversight over all data aspects including defining policies and procedures related to data, databases including security concerns, auditing capabilities and effective database designs.

Key Responsibilities:

• Collaborate with the business leads on new and existing enterprise data within the reporting and operational databases.
• Assist in the Data Ecosystem efforts including Master Data Management (MDM), data quality (DQ), data warehouse (DW), ETL development efforts, making sure that the business rules are implemented correctly through complex data analysis.
• Developing and maintaining standards for data management as well as building a library of database related tools to support the operations and user acceptance testing teams.
• Ensuring the proper handling and storing of sensitive (PII, PHI and FTI) data in compliance with State, Federal and TennCare guidelines.
• Creating/Analyzing conceptual, logical and physical data models within the TennCare Enterprise to provide key data insight to meet the needs of TennCare management and the business.
• Review existing implementations of on-prem and cloud RDMS for best practices and design issues.
• Oversee issue research and troubleshooting issues impacting all database systems.
• Ability to collaborate with multi vendors to solve complex data related issues and interoperability constraints.
• Examine and identify database structural necessities by evaluating required documentation and database designs.
• Analyze the proposed implementation of databases to ensure that they are effective database solutions and models to store and retrieve data efficiently and securely.
• Provide guidance and direction to the Data Management Team on any data related activities.

Minimum Qualifications:

• 3+ years of relational database and data warehouse design and support experience including MDM solutions.
• 3-5 years' experience with DBMS (Snowflake, Oracle, SQL Server, MySQL, PostgreSQL, etc.).
• 3-5 years' experience with ETL tools.

Excellent communication skills required including the ability to communicate with upper management on complex technical topics.

Desirable Qualifications:

• Experience with Oracle Audit Vault
• Experience with Service Now
• Experience working with and communicating with cross-functional groups (Architecture, Development, QA/Testing, Production Support, Systems Administration)

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.