Executive Service
HEALTH CARE DATA ANALYST
Division of TennCare
Fiscal
Nashville, TN
Salary: Minimum Monthly Salary $6,479/month. 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.
Closing Date: 11/04/2024
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. 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 work collaboratively to improve organizational processes in order to make a difference in the lives of 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 Health Care Data Analyst will be a junior member of the Health Care Informatics (HCI) group within TennCare's Fiscal Division. HCI is a dynamic team of 22 data professionals who provide comprehensive data and analytics services to various business units within TennCare and external stakeholders. The group is divided into two specialized teams: Program Integrity Analytics which focuses on investigating Medicaid-related waste, fraud, and abuse, and Managed Care Analytics, which handles fiscal and administrative reporting, supports operational decision-making across the enterprise, and contributes to program evaluation and research. Analysts on these teams are highly proficient in extracting, validating, analyzing, and reporting complex data using SQL, SAS, Tableau, and Power BI tools. They are responsible for developing reports, conducting in-depth analyses, and delivering actionable insights to stakeholders. Analysts count and characterize members and providers, monitor the services they utilize or provide, and track and validate the costs of providing health care. Health Care Data Analysts evaluate data to determine significant patterns and trends and then present and explain these findings to both lay and expert stakeholders within and outside of TennCare. HCI operates within an evolving technology environment. While our legacy systems are built around an Oracle data warehouse accessed through SQL IDEs, SAS, Tableau, and occasionally R or Python, we are transitioning to a new cloud-based data ecosystem. This new infrastructure is centered around a Snowflake enterprise data warehouse within Microsoft Azure, with Decision Support System using PowerBI, ArcGIS, and Azure Machine Learning.
Key Responsibilities:
- Communicating with stakeholders to clarify and refine requests for analytic reports or services
- Compiling and analyzing data to provide answers to user requests
- Writing SQL queries to extract data and/or SAS (and other language) programs to manipulate and analyze data to solve specific questions or create meaningful reports
- Performing descriptive, predictive, and inferential statistical analyses
Providing actionable analytic results to stakeholders:
- Writing reports, specializing in making technical details accessible to non-data-trained individuals
- Developing and maintaining dashboards
- Giving informal or formal verbal reports of findings
- Providing thorough documentation of projects and processes
- Complying with regulations and mandates for data privacy
- Continued professional development and learning
- Collaborating with management and internal teams to implement and evaluate process improvements
Minimum Qualifications:
Graduation from an accredited college or university with a master's degree in statistics, applied statistics, social or behavioral sciences, health sciences, business, business administration, or public policy and experience equivalent to two years full-time professional work developing research methodology and/or directing statistical research.
Substitution of Education for Experience: Additional graduate course work from an accredited college or university in statistics, applied statistics, social or behavioral sciences, health sciences, business, business administration, and/or public policy may substitute for the required experience on a year-for-year basis to a maximum of two years (e.g., an additional 36 graduate quarter hours in one or a combination of the above listed fields may substitute for one year of the required experience).
OR
Graduation from an accredited college or university with a bachelor's degree in statistics, applied statistics, social or behavioral sciences, health sciences, business, business administration, or public policy and experience equivalent to five years full-time professional work developing research methodology and/or directing statistical research.
Desirable qualifications:
- Experience using statistical programming languages is essential: experience using SAS is preferred, but Python and/or R for analytics are an additional asset (other languages can be considered)
- Experience with statistical analysis is essential, including thorough applied knowledge of descriptive and inferential statistical techniques; skills in or exposure to data mining methods
- Experience with databases is desirable, including a strong understanding and utilization of SQL for database querying and knowledge of table structures, table relationships, data elements, and query optimization
- Experience with one or more data visualization platforms such as Tableau or Microsoft Power BI is desirable
- Previous experience with health care data analytics is desirable, including analysis of claims data and utilization of standard health care codesets such as CPT/HCPCS, DRG, ICD-10, etc.
Desirable qualifications continued:
- Knowledge of Medicaid and general health insurance / health care industry standards, rules and regulations is useful
- Thorough problem-solving, analytical, and organizational skills are required
- A demonstrated ability to be inquisitive and detail-oriented and to continuously learn is highly valued
- Very good written and oral communication skills, including the ability to communicate effectively with technical and non-technical clients, are very useful
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.
#J-18808-Ljbffr