APCD Senior Data Analyst

State of Indiana•Indianapolis, IN

11d

About The Position

The Senior Data Analyst serves as the day-to-day health care analytics expert for the Indiana All-Payer Claims Database (APCD), which is under development. The APCD will contain medical and pharmacy claims, eligibility, and provider files collected from private and public payers. It is intended to identify health care needs, inform health care policy, compare costs across treatment settings and approaches, provide information to consumers and purchasers, and improve the quality and affordability of health care and coverage in Indiana. The role is responsible for health and medical claims data analysis and for database design, administration, performance, security, integrity, availability, and operational support. This position may lead software projects and provide technical assistance to lower-level staff. It is exempt from overtime compensation; additional work hours may be required to complete essential or assigned work. Employees must report at least 75 hours per pay period of work and/or paid leave to receive their base biweekly salary. A degree is not required; at least nine years of relevant experience may be considered. Supervisory responsibilities may apply based on agency needs.

Requirements

Advanced knowledge of the DBMS and operating system used for a data warehouse or data mart.
Advanced knowledge of software and utilities related to supported DBMS, such as reorganization, backup, recovery, load, and unload tools.
Advanced knowledge of capacity planning and disaster recovery.
Advanced knowledge of relational database and data warehouse design techniques and dimensional modeling.
Advanced knowledge of computer hardware and software capabilities and configurations.
Advanced knowledge of a variety of computer languages.
Advanced knowledge of, and ability to apply, complex diagnostic, structural, logical, performance, and tuning procedures related to the operating system.
Advanced knowledge in database administration and/or system software specialty areas such as communications, storage management, operating systems, or capacity planning.
Advanced knowledge of application development and maintenance.
Ability to analyze, communicate, and recommend future needs and direction for the agency’s data-processing software and hardware environment.
Ability to apply theories, principles, and methodologies to existing and new computer hardware and software.
Ability to manage multiple hardware and software projects and priorities.
Ability to guide and coordinate the work of others.
Effective oral and written communication skills.
Ability to perform advanced logic analysis.
A degree is not required; at least nine years of experience applying the outlined knowledge, skills, and abilities in a similar role may be considered.
Ability to perform essential functions with or without reasonable accommodation.

Responsibilities

Design and implement moderately complex logical and physical databases.
Determine aggregation, partitioning, and indexing strategies for physical data.
Monitor and tune database performance.
Administer end-user access and security at the database level.
Protect data through database backups and related strategies.
Load database software or assist with loading it, and apply fixes based on the complexity of the environment.
Assist with evaluating and selecting infrastructure components.
Provide operational database support to ensure data integrity, availability, and performance.
Implement and maintain database catalogs and dictionaries.
Integrate database systems using standardized database design techniques.
Resolve technical problems.
Develop innovative procedures and methods by applying product capabilities to meet users’ goals and objectives.
Assist management with short- and long-range planning for hardware and software changes and additions.
Serve as a project lead for software products.
Provide technical assistance to lower-level staff.
Prepare reports that help management understand current hardware and software conditions, performance, and future trends.
Analyze health and medical claims data for the APCD.

Benefits

Three medical plan options, including prescription coverage, as well as vision and dental plans.
Wellness Rewards Program with gift card rewards for completed wellness activities.
Health savings account with biweekly state contributions.
Deferred compensation 457(b) account with employer match.
Two fully funded pension plan options.
Paid leave policies, including up to 150 hours of paid New Parent Leave and up to eight weeks of paid Childbirth Recovery Leave for eligible mothers.
Up to 15 hours of paid community service leave.
Combined 180 hours of paid vacation, personal, and sick leave.
12 paid holidays, or 14 in election years.
Education Reimbursement Program.
Group life insurance.
Referral Bonus program.
Employee assistance program with covered behavioral health visits.
Eligibility as a qualified employer for the Public Service Loan Forgiveness Program.
Free parking for most positions.
Free LinkedIn Learning access.