Rural Health Transformation Data Analyst

Florida; Tallahassee (FL); On-site; USD 60,000 - 80,000; Full time

Benefits offered by this job

No state income tax

Health, dental, vision insurance

401(a) Retirement Plan

457(b) Deferred Compensation

Job summary

Florida is seeking an OPS Government Operations Consultant II to serve as the System Project Consultant for the Rural Health Transformation Program (RHTP). The role focuses on data extraction, cleaning, and validation to support CMS reporting requirements and program oversight.

You will collaborate with the Data Base Consultant, manage data quality, and generate summaries, dashboards, and visualizations using Power BI, Tableau, and GIS tools.

Qualifications

• Two years of professional experience using 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.
• Preference will be given to candidates with a bachelor’s degree in statistics, mathematics, public health, health administration, information systems, economics, or a related field.

Responsibilities

• Review sub-awardee data submissions, including performance measure reports, progress reports, and deliverable documentation, for completeness, accuracy, timeliness, and conformance with the RHTP data dictionary and reporting templates.
• Review sub-awardee quarterly and annual reports, including performance measure data, progress narratives, milestone and deliverable status, expenditure-related data elements, and supporting documentation, against grant agreement requirements, approved work plans, and prior reporting periods.
• Meet the following review timeliness standards, unless otherwise directed by the Deputy Director: complete the initial review of each quarterly report within ten (10) business days of receipt; complete the initial review of each annual report within fifteen (15) business days of receipt; verify corrected resubmissions within five (5) business days of receipt; and submit review results and compiled summaries to the Data Base Consultant within these same timeframes.
• Apply validation rules and business rules established by the Data Base Consultant to identify missing values, duplicate records, outliers, out-of-range values, calculation errors, and inconsistencies across reporting periods.
• Reconcile reported data against source documentation, prior submissions, grant agreement performance targets, and approved work plans.
• Maintain a data issues log; issue correction requests to sub-awardees and Regional Leads, track each issue to resolution, and verify resubmitted data before acceptance.
• Track sub-awardee compliance with the reporting calendar and notify the Data Base Consultant and Regional Leads of late or incomplete submissions.
• Escalate recurring, systemic, or unresolved data quality issues to the Data Base Consultant and, as appropriate, the Deputy Director, with supporting documentation and recommended corrections.

Skills

Excel

SQL

Data analysis

Data visualization

Education

Bachelor’s degree in statistics, mathematics, public health, health administration, information systems, economics, or related field

Tools

Power BI

Tableau

ArcGIS

Job description

Florida is seeking an OPS Government Operations Consultant II to serve as the System Project Consultant for the Rural Health Transformation Program (RHTP). The role focuses on data extraction, cleaning, and validation to support CMS reporting requirements and program oversight.

You will collaborate with the Data Base Consultant, manage data quality, and generate summaries, dashboards, and visualizations using Power BI, Tableau, and GIS tools.