68900498 - OPS GOVERNMENT OPERATIONS CONSULTANT II

State of Florida • Tallahassee, FL

6d • $22 - $35

About The Position

The OPS Government Operations Consultant II, working title RHTP Data Analyst, serves as a mid-level data analyst for the Rural Health Transformation Program (RHTP), a five-year Centers for Medicare & Medicaid Services (CMS) cooperative agreement supporting rural health initiatives across Florida’s four Super Regions. The position reviews, validates, analyzes, and compiles sub-awardee data to support accurate program monitoring, grant oversight, and federal reporting.

The position reports directly to the RHTP Deputy Director and receives assignments from both the Deputy Director and the Data Base Consultant. The Data Base Consultant establishes data methodologies, metrics, definitions, and validation rules, and reviews analytic products for quality assurance. The incumbent applies those established standards and submits compiled summaries and reports to the Data Base Consultant; the position does not establish program data policy or final analytic methodology.

The role includes reviewing sub-awardee reports and supporting documentation, analyzing and compiling data, maintaining dashboards and visualizations, documenting and managing data, supporting the grants management system, and responding to ad hoc requests. The position is 100% grant-funded under the RHTP. Funding is currently approved for five years (2026–2031), and continuation depends on renewal or extension of grant funding. A good attendance record is essential; the employee is expected to report to work daily and on time, and leave must be requested in advance except in emergencies.

Requirements

• Two years of professional experience using Microsoft Excel, SQL, SAS, R, or similar software to clean, validate, analyze, and summarize data.
• One year of professional experience preparing data reports, summaries, or presentations.
• Knowledge of data analysis methods, descriptive statistics, and data validation and quality control techniques.
• Advanced proficiency with Microsoft Excel, including pivot tables, lookup functions, formulas, and Power Query; working knowledge of Microsoft Access.
• Working knowledge of SQL, SAS, R, or similar software for querying, cleaning, and analyzing data.
• Experience producing dashboards and data visualizations using Power BI, Tableau, or similar tools.
• Ability to detect errors, inconsistencies, and anomalies in data with a high degree of accuracy and attention to detail.
• Ability to apply established data definitions, business rules, and procedures consistently.
• Ability to write clear, concise data summaries for technical and non-technical audiences.
• Ability to communicate professionally with sub-awardees and external partners to resolve data issues.
• Ability to manage multiple assignments, prioritize work, and meet strict deadlines.
• Ability to take direction, incorporate quality assurance feedback, and work independently and as part of a team.
• Knowledge of data confidentiality and data security practices.
• A good attendance record is essential; the employee is expected to report to work daily and on time.

Nice To Haves

• Familiarity with GIS mapping tools such as ArcGIS.
• Bachelor’s degree from an accredited college or university in statistics, mathematics, public health, health administration, information systems, economics, or a related field.
• Experience analyzing health care, public health, or grant-funded program data.
• Experience reviewing and validating data submitted by external reporting entities.
• Experience using Power BI, Tableau, or GIS software.
• Experience with grants management or performance reporting systems.

Responsibilities

• Review sub-awardee performance measure reports, progress reports, deliverable documentation, and quarterly and annual reports for completeness, accuracy, timeliness, and conformance with program requirements and reporting standards.
• Meet specified review deadlines: initial quarterly report reviews within 10 business days, initial annual report reviews within 15 business days, and corrected resubmission reviews within five business days; submit review results and compiled summaries within the same timeframes.
• Apply established validation and business rules to identify missing values, duplicate records, outliers, out-of-range values, calculation errors, and inconsistencies across reporting periods.
• Reconcile reported data with source documentation, prior submissions, grant agreement performance targets, and approved work plans.
• Maintain a data issues log; request corrections from sub-awardees and Regional Leads, track issues through resolution, and verify resubmitted data.
• Track reporting-calendar compliance and notify the Data Base Consultant and Regional Leads about late or incomplete submissions.
• Escalate recurring, systemic, or unresolved data quality issues to the Data Base Consultant and, as appropriate, the Deputy Director, with documentation and recommended corrections.
• Extract, clean, merge, and transform datasets using SQL, SAS, R, Microsoft Excel, or similar tools.
• Compile data summaries at sub-awardee, initiative, Super Region, and statewide levels using established metrics and methodologies.
• Calculate descriptive statistics and baseline-to-current and period-over-period comparisons.
• Monitor progress toward performance targets and milestones and flag sub-awardees that are not on track.
• Prepare draft reports, tables, charts, and plain-language narrative summaries for quality assurance review.
• Compile data for CMS reporting, Non-Competing Continuation applications, external evaluation data requests, and leadership briefings.
• Refresh and maintain program dashboards using Power BI, Tableau, or similar tools, following approved designs and update schedules.
• Produce standard charts, tables, and county- and region-level maps using GIS tools such as ArcGIS, and verify visualization figures against source data before publication.
• Maintain organized, version-controlled datasets, analytic files, submission trackers, and report archives.
• Document the steps, queries, and data sources used for recurring reports to ensure results are reproducible.
• Assist the Data Base Consultant with updates to the data dictionary, reporting templates, and data standard operating procedures.
• Enter, upload, and validate data in the grants management system and perform user acceptance testing as directed.
• Safeguard confidential and sensitive data according to Agency policies, applicable state and federal privacy requirements, and public records retention schedules.
• Complete ad hoc assignments and data requests from the Deputy Director and Data Base Consultant, including legislative requests, public records requests, media inquiries, and leadership briefing data, within required deadlines.
• Respond to specific data questions arising from analyses and reviews of the datasets assigned to the position.
• Perform other related duties as assigned.

Benefits

• No state income tax for Florida residents.
• State Group Insurance coverage options, subject to eligibility, including health, life, dental, vision, and supplemental insurance.
• Savings and Spending Accounts.
• 401(a) FICA Alternative Plan administered through VALIC (tax-deferred retirement savings plan).
• Participation in the Florida Deferred Compensation Plan (457b).

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed