> Markdown version of [/jobs/ext/4519609-apcd-senior-data-analyst](https://www.wearedevelopers.com/jobs/ext/4519609-apcd-senior-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # APCD Senior Data Analyst - **Company:** State of Indiana - **Location:** Indianapolis, IN, United States - **Experience:** Expert - **Salary:** $55,224.0 - **Contract:** Permanent contract - **Skills:** Data Analysis, Databases, Data Mart, Data Warehousing, Relational Databases, Database Design, Dimensional Modeling, Disaster Recovery, Software Engineering, Software Systems, System Software, Data Processing, Data Storage Management, Database Optimization, Database Performance, Computer Equipment, Programming Languages - **Published:** November 2, 2026 - **Apply:** https://www.careerjet.com/job/used1a564c815e46037054e27923e77d9a/eaa ## About the Role * Advanced knowledge in the technology of both the DBMS and the operating system chosen for the data warehouse or data mart. * Advanced knowledge in software and utilities related to supported DBMS such as Reorg, Backup, Recovery, Load and Unload. * Advanced knowledge of capacity planning and disaster recovery. * Advanced knowledge of relational database and data warehouse design techniques and dimensional modeling processes. * Advanced knowledge of computer hardware/software capabilities and configurations. * Advanced knowledge of a variety of computer languages. * Advanced knowledge of and the ability to apply complex diagnostic, structure, logic, and performance and tuning procedures relative to the operating system. * Advanced knowledge of specialty area(s) of database administration and/or system software such as communication, storage management, operating systems or capacity planning. * Advanced knowledge of applications development and maintenance. * Ability to analyze, communicate and recommend future needs and direction for agency's data processing software/hardware environment. * Ability to apply theories, principles and methodologies to existing and new computer hardware/software. * Ability to manage multiple hardware/software projects and priorities. * Ability to guide and coordinate the work of others. * Effectively communicate, both orally and in writing. * Ability to perform advanced logic analysis. A degree is not required. However, at least 9+ years of experience applying the outlined knowledge, skills, and abilities in a similar role may be considered. Individuals should have the ability to perform essential functions with or without reasonable accommodation. Supervisory Responsibilities/Direct Reports: This role may be utilized in a supervisory capacity based on agency needs. ## Description The purpose of the Indiana Department of Insurance is to protect Hoosiers as they purchase and use insurance products to keep their assets and their families from loss or harm. Consumers may need assistance with certain claim situations or just help in understanding how their policies work. Our other primary obligation is to monitor the financial solvency of the insurance companies domiciled in Indiana so that the legal promises made in insurance policies are honored. To these ends, our Department staff is committed to providing exceptional customer service for both our consumers and our companies, and to maintain a fair and objective viewpoint as we examine each issue and circumstance within our jurisdiction. Role Overview: The purpose of the Indiana Department of Insurance is to protect Hoosiers as they purchase and use insurance products to keep their assets and their family from loss or harm. Currently under development, the Indiana All-Payer Claims Database (APCD) is a large state database that will include medical claims, pharmacy claims, and eligibility and provider files collected from private and public payers. (See Indiana Code 27-1-44.5) The purpose of the APCD is to identify health care needs, provide information for healthcare policy, compare costs between various treatment settings and approaches, provide information to consumers and purchasers of health care, and improve the quality and affordability of patient healthcare and health care coverage in Indiana. Serving as the day-to-day health care analytic expert for the division, the Senior Data Analyst is responsible for health/ medical claims data analysis., The essential functions of this role are as follows: * Designs and implements logical and physical databases of a moderately complex nature. * Determines aggregation, partitioning and indexing strategies for physical data. * Monitors and tunes database performance. * Administers end-user access and security at the database level. * Ensures that data is appropriately protected via database backup and related strategies. * Loads, or assists in load, process of database software and application of fixes dependent upon the complexity of the environment. * Assists with the evaluation and selection of infrastructure components. * Provides operational support for the database ensuring data integrity, database availability and performance. * Implements and maintains database catalogs and dictionaries. * Develops integration of database systems through standardized database design techniques. * Provides resolutions to technical problems. * Implements innovative procedures and methods through understanding of product capabilities and utilizes those capabilities in unique ways to fully use products on the system and meet user's goals and objectives. * Assists management with short/long-range planning for hardware and software changes and additions. * Serves as a project lead for software products. * Provides technical assistance to lower-level staff. * Prepares reports which assist management in understanding the current hardware/software conditions, performance and future trends. The job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Other duties, responsibilities and activities may change or be assigned at any time. This position is exempt from overtime compensation for additional work hours which may be required to complete essential functions or other assigned work. Exempt employees may work more than 75 hours in a pay period without additional compensation and must report a minimum of 75 hours per pay period of work hours and/or paid leave taken to receive their base biweekly salary. What You'll Need for Success: Individuals in this role should minimally be able to articulate or demonstrate the following