Data Analyst

About the job

The Data Analyst is responsible for extracting, analyzing, and synthesizing complex datasets from our Data Warehouse and health claims systems (such as PRISM) to drive business intelligence, program evaluations, and strategic policy development. Serving as a technical subject matter expert, this role combines advanced SQL querying, statistical and actuarial analysis, and cross-departmental collaboration to deliver actionable insights while ensuring strict adherence to healthcare data privacy and compliance standards. Core Data Querying and Analysis Develop, write, and execute complex SQL queries, including the use of joins, subqueries, aggregates, and functions, to extract and manipulate data from the Data Warehouse and other relevant systems (e.g., PRISM claims system). Extract and prepare data to support various departmental needs, including examining trends, evaluating claims processing, conducting program evaluations, and informing policy development. Perform statistical and/or actuarial analysis by applying appropriate protocols to analyze data and draw accurate conclusions. Analyze, summarize, and review data to report findings, interpret results, and/or make recommendations for management. Data Systems and Troubleshooting Act as a subject matter expert and technical resource for management and staff on data availability, structure, and extraction methods. Resolve difficult and unusual data problems, leveraging expert knowledge and experience with interfacing automated data systems. Review data production for potential issues and propose solutions, enhancements, and procedural changes to improve data quality and efficiency. Reporting and Collaboration Write or draft technical reports, articles, or related materials based on in-depth research, investigation, and data analysis. Meet and confer with management, end-users, and external contract providers to understand data needs, resolve problems, and coordinate services. Ensure all data access and handling practices adhere to strict confidentiality policies, especially when dealing with sensitive information like applicant or recipient data, as mandated by Medicaid/DHHS policy. Supplemental Information An offer of employment will be contingent on the applicant successfully passing a DHHS background check. This position may currently be a hybrid of both two (2) in-office and three (3) remote work days. Please note, a position's eligibility for remote work is established by agency management and is subject to change at their discretion, at any time, and for any reason. Risks found in the typical office setting, which is adequately lighted, heated and ventilated, e.g., safe use of office equipment, avoiding trips and falls, observing fire regulations, etc. Typically, the employee may sit comfortably to perform the work; however, there may be some walking; standing; bending; carrying light items; driving an automobile, etc. Special physical demands are not required to perform the work.