Database Analyst

University of Kentucky - Lexington, KY

Full-time - Mid Level

Lexington, KY

Educational Services

About the position

The Institute for Biomedical Informatics is seeking a Database Analyst to join our team. This position is located in Frankfort, Kentucky, and is a research contract with the KY Cabinet for Health and Family Services (CHFS) designed to support program evaluation research and improving the effectiveness, economy, and the quality of services delivered to Medicaid beneficiaries. The person chosen for this position must be able to write complex SQL queries for data extraction from health data claims, specifically Kentucky Medicaid data. This position designs, tests, implements, and maintains data collection and reporting systems to support research activities using complex database statistical methods. The ability to visualize data utilizing business intelligence tools like Tableau is required. Working knowledge of Python, R, SAS are highly preferred. The ability to conduct simple statistical data analysis is highly preferred. Working knowledge of database cloud technologies (Azure Synapse) is highly preferred. The Database Analyst will work with both internal and external stakeholders and must be able to provide support to clients with varying levels of technical expertise. The position is currently remote, but may require some in-person meetings in Frankfort, KY.

Responsibilities

• Write complex SQL queries for data extraction from health data claims, specifically Kentucky Medicaid data.
• Design, test, implement, and maintain data collection and reporting systems to support research activities.
• Visualize data utilizing business intelligence tools like Tableau.
• Provide support to clients with varying levels of technical expertise.

Requirements

• Strong communication skills (verbal and written).
• Development and management skills in BI/BA tools, Informatica, Tableau, T-SQL and PL/SQL.
• Knowledge and experience in a health care environment.

Nice-to-haves

• Working knowledge of Python, R, SAS.
• Ability to conduct simple statistical data analysis.
• Working knowledge of database cloud technologies (Azure Synapse).
• Preferred experience in working with various data types including healthcare data.
• Basic statistical skills preferred.
• Driver's license preferred.

Benefits

• Amazing health insurance options.
• Employee discounts.
• 200% retirement match.
• Annually accrue 3 weeks of paid vacation.
• 12 sick days.
• 10 holidays.