68064839 - SENIOR DATA BASE ANALYST

Requisition No: 851004

Agency: Agency for Health Care Administration

Working Title: 68064839 - SENIOR DATA BASE ANALYST

Pay Plan: Career Service

Position Number: 68064839

Salary: $1,907.10 - $3,448.27 biweekly

Posting Closing Date: 04/20/2025

Total Compensation Estimator Tool

Agency Overview

The Agency for Health Care Administration (AHCA) is Florida's chief health policy and planning entity. The Agency is responsible for administering the Florida Medicaid program, the licensure and regulation of nearly 50,000 health care facilities, and empowering consumers through health care transparency initiatives.

Under the direction of the Agency Secretary, AHCA is focused on advancing Governor DeSantis’ vision for Florida’s health care system to be the most cost-effective, transparent, and high-quality health care system in the nation. Current Agency initiatives include implementing Florida’s groundbreaking Canadian Prescription Drug Importation Program, overhauling Florida’s healthcare technological ecosystem, and increasing insight in the cost of health care services.

The Medicaid program provides low-income families and individuals with access to health care. If you have a desire to use your talent and skills at an organization that provides critical services to millions of individuals and families across the state, AHCA invites you to apply to become an essential member of our team. As one of Florida’s leading state agencies, AHCA’s diverse workforce community of more than 1,400 employees is proud of its efforts to serve the people of Florida.

Agency Objectives

HIGH QUALITY

Emphasizing quality in all that we do to improve health outcomes, always putting the individual first.

TRANSPARENT

Supporting initiatives that promote transparency and empower consumers in making well informed healthcare decisions.

COST-EFFECTIVE

Leveraging Florida’s buying power in delivering high quality care at the lowest cost to taxpayers.

Position Overview

This is an exciting opportunity to help shape the quality of health care in Florida. We are seeking to hire a Senior Data Base Analyst who desires to work to enhance the delivery of health care services through the Florida Medicaid Program. This position requires a candidate who is creative, flexible, innovative, and who will thrive in a fast-paced, team-based work environment.

This position is located in the Bureau of Medicaid Data Analytics. Join Data Analytics as we gather, explore, and examine data to provide meaningful and impactful analysis that shapes the future of Florida Medicaid. As the Agency hub for analytics, reporting, and visualization, the Bureau of Medicaid Data Analytics examines critical aspects of Floridians’ health, health care services and costs, and is vital to managed care rate setting, health care economics, and health plan evaluation.

This Position Is Responsible For

Data Analysis and Rate Setting

• Participate in rate setting as well as analyses, studies or research projects.
• Perform data analysis, including summarizing, reviewing, verifying, and reconciling data as needed for rate setting and other actuarial unit projects.
• Actively seek to ensure data integrity and accuracy and identify discrepancies.
• Develop cost estimates and assist in financial analysis and budget preparation.
• Create reports under the direction of the supervisor to meet needs both internally and externally.
• Keep electronic documentation on all rate settings and data analysis.
• Participate in developing models that rely on statistical and actuarial analysis such as health care cost impact models, trend, IBNR, forecasting, etc.; verify or change calculation logic when needed, under the direction of the supervisor; participate in model brainstorming; suggest ways to improve model processes; document model revisions and instructions.
• Assist in actuarial reporting including Federal rate filings.
• Facilitate the finalization and implementation of rates.
• Work with other units to ensure all issues impacting rate setting are conveyed to the actuarial vendor.
  
  

Deliverable Review

• Review deliverables for actuarial vendor, other vendors, another agency, or within AHCA for accuracy and consistency.
• Review managed care rates to determine compliance with applicable state and federal laws, rules, and regulations.
• Ensure all deliverable requirements are met.
• Perform other deliverable review duties outlined in office procedures or as assigned.
  
  

Support

• Provide technical and analytical support to Agency staff and contracted entities on work related to State Medicaid managed care plans, capitation rates, financial analysis/projections.
• Serve as a subject matter expert on rate setting and actuarial reports.
• Provide assistance in responding to inquiries and external requests related to rate setting and other actuarial services unit projects and tasks.
• Represent AHCA in meetings with outside vendors or contractors.
• Respond to inquiries and explains actuarial methodology to health plans and other appropriate parties, concerning rate setting, providing supporting documentation.
• Participate in peer-review processes.
  
  

Rules and Regulations

• Maintain up-to-date knowledge concerning the Florida Medicaid program, including pertinent Federal laws and regulations, state statutes and rules, and the Florida Medicaid State Plan.
• Participated in continuing education of Medicaid and other Agency functions.
• Assist in estimating the impact of legislative changes.
• Review proposed legislation.
  
  

Projects

• Work on or assist in unit assigned projects.
• Serve on committees and teams.
• Other ad hoc projects as assigned.
  
  

Data Systems

• Maintain up-to-date knowledge of the Florida Medicaid data systems, including Florida Medicaid Management Information Systems (FMMIS), Florida Medicaid Data Warehouse/Decision Support System (DSS), and the SQL server.
• Keeping up-to-date technically and knowing one's own jobs' and related jobs' functions.
  
  

General Office Procedures

• Attend meetings both internally with other units and bureaus within the Agency, as well as externally with health care plans.
• Document, organize and standardize work process, improve file quality and speed up work process whenever possible.
• Keep documentation on noteworthy events, monthly magic, and Agency payments.
• Ensure the accuracy of work assigned through the development and use of reconciliation techniques.
• Facilitate meetings and calls both with the actuarial vendor and other entities; keep track of notes and action items.
• Show initiative and participate in brainstorming ways to improve all processes; propose new ideas to supervisor.
• Participates in strategic planning for Agency goals.
• Follow all unit, bureau, and Agency procedures.
• Perform other duties as assigned.
  
  

Serve in a leadership role and mentor junior analysts professionals.

This position is not a remote or telework position.

Benefits Of Working For The State Of Florida

Working for the State of Florida is more than a paycheck. The State’s total compensation package for employees features a highly competitive set of employee benefits including:

• State Group Insurance Coverage Options, including health, life, dental, vision, and other supplemental insurance options;
• Flexible Spending Accounts;
• State of Florida retirement options, including employer contributions;
• Generous annual and sick leave benefits;
• 9 paid holidays a year and 1 Personal Holiday each year;
• Career advancement opportunities;
• Tuition waiver for courses offered by Florida’s nationally ranked State University System;
• Training and professional development opportunities;
• And more!
  
  

For more information about the Bureau of Medicaid Data Analytics, please visit our website at http://ahca.myflorida.com/Medicaid/index.shtml.

Join us at the Agency for Health Care Administration in fulfilling our mission to provide “Better Health Care for all Floridians.”

Knowledge, Skills, And Abilities

• Experience with Excel.
• Experience with Access, SQL, SAS, or other Database programs.
• Experience working with large data sets. Preferably, health care data experience.
• Ability to collect fact-finding research.
• Ability to collect, evaluate, and analyze data to develop alternative recommendations and solve problems.
• Ability to communicate technical concepts effectively.
• Ability to organize data into logical format for presentation in reports, documents, and other materials.
• Ability to multi-task, work in a fast-paced environment, and follow-through on assignments.
• Ability to work well both independently and with others.
• Ability to establish and maintain effective working relationships with others.
• Ability to organize electronic notes and document processes.
• Knowledge of the methods of data collection and analysis.
  
  

Minimum Qualifications Requirements

• Three years of professional experience utilizing Excel.
• Three years of professional experience utilizing Access, SQL, SAS, or other Database programs.
• At least one year of actuarial experience in managed care is preferred.
• Passed three (3) actuarial exams preferred. Three (3) VEE credits may substitute for one exam.
• A bachelor's degree in mathematics, actuarial science, statistics, or related field preferred.
  
  

Licensure, Certification, Or Registration Requirements

N/A

CONTACT: KELLI BOTTCHER (850) 412-4026

BACKGROUND SCREENING

It is the policy of the Florida Agency for Health Care Administration that any applicant being considered for employment must successfully complete a State and National criminal history check as a condition of employment before beginning employment, and, if applicable, also be screened in accordance with the requirements of Chapter 435, F.S., and Chapter 408, F.S. No applicant may begin employment until the background screening results are received, reviewed for any disqualifying offenses, and approved by the Agency. Background screening shall include, but not be limited to, fingerprinting for State and Federal criminal records checks through the Florida Department of Law Enforcement (FDLE) and Federal Bureau of Investigation (FBI) and may include local criminal history checks through local law enforcement agencies.

The State of Florida is an Equal Opportunity Employer/Affirmative Action Employer, and does not tolerate discrimination or violence in the workplace.

Candidates requiring a reasonable accommodation, as defined by the Americans with Disabilities Act, must notify the agency hiring authority and/or People First Service Center (1-866-663-4735). Notification to the hiring authority must be made in advance to allow sufficient time to provide the accommodation.

The State of Florida supports a Drug-Free workplace. All employees are subject to reasonable suspicion drug testing in accordance with Section 112.0455, F.S., Drug-Free Workplace Act.

VETERANS’ PREFERENCE. Pursuant to Chapter 295, Florida Statutes, candidates eligible for Veterans’ Preference will receive preference in employment for Career Service vacancies and are encouraged to apply. Certain service members may be eligible to receive waivers for postsecondary educational requirements. Candidates claiming Veterans’ Preference must attach supporting documentation with each submission that includes character of service (for example, DD Form 214 Member Copy #4) along with any other documentation as required by Rule 55A-7, Florida Administrative Code. Veterans’ Preference documentation requirements are available by clicking here . All documentation is due by the close of the vacancy announcement.