Data Analyst

• Compiles, validates, and submits required monthly program reports, ensuring all submissions are complete, accurate, and delivered within established contractual deadlines.
• Collects, analyzes, and monitors program performance measures and key performance indicators (KPIs) to evaluate utilization, service delivery, access, outcomes, and achievement of contractual objectives.
• Develops, maintains, and enhances dashboards, scorecards, and recurring analytical reports that provide leadership with visibility into program performance, trends, service utilization, and areas requiring improvement.
• Maintains and supports program logic models, including measurement definitions, data sources, performance targets, reported results, and required annual updates.
• Coordinates the collection, validation, and electronic submission of required data set elements and other County-required data, adapting reporting processes as new data elements, performance measures, and KPIs are established.
• Analyzes client access and service-delivery data, including demographics, presenting needs, screenings, referrals, care coordination, service connections, and continuing-care activities to support program evaluation, performance monitoring, and reporting.
• Supports required Florida Department of Children and Families (DCF) and other governmental reporting requirements, including the preparation, validation, reconciliation, and submission of electronic healthcare data files generated through the organization’s EHR and related reporting systems.
• Gathers and documents business, functional, data, and reporting requirements by working with clinical, operations, finance, quality, technology, and leadership stakeholders to understand program processes, reporting obligations, data needs, and expected outcomes.
• Creates and maintains supporting analytical and process documentation and artifacts, including business requirements, data dictionaries, metric definitions, calculation specifications, source-to-target mappings, reporting specifications, validation rules, and other documentation necessary to support consistent and reproducible reporting.
• Develops workflow diagrams and process maps that document program activities, departmental handoffs, dependencies, decision points, data collection requirements, and reporting responsibilities to support process standardization and continuous improvement.
• Develops data-flow diagrams and data maps that document how information is captured, stored, transformed, validated, transferred, and reported across the EHR, databases, reporting applications, spreadsheets, external systems, and County or State reporting processes.
• Translates contractual, regulatory, operational, and clinical reporting requirements into defined data elements and technical reporting requirements, working with business and technical stakeholders to identify data sources, calculation methodologies, validation requirements, and reporting outputs.

These essential job functions are not to be construed as a complete statement of all duties performed. Employees will be required to perform other job related marginal duties as required.

• Proficiency in SQL, including querying, joining, filtering, aggregating, and validating data from relational databases.
• Advanced proficiency in Microsoft Excel, including formulas, PivotTables, lookups, data reconciliation, and analysis.
• Experience developing and maintaining Power BI dashboards, data models, visualizations, and performance reports.
• Experience with SSRS, Crystal Reports, or comparable enterprise reporting tools.
• Ability to extract, transform, reconcile, and validate data from EHR/EMR systems, databases, spreadsheets, CSV files, and other structured data sources.
• Understanding of relational database structures, data mapping, data dictionaries, and reporting specifications.
• Ability to perform data-quality analysis, identify discrepancies and missing information, determine root causes, and coordinate corrections with business and technical teams.
• Experience developing and maintaining KPIs, performance measures, dashboards, recurring reports, and automated reporting processes.
• Ability to understand technical reporting specifications and support electronic data submissions, including structured healthcare data files such as XML and CSV formats, where applicable.
• Working knowledge of healthcare data privacy and security requirements, including HIPAA and 42 CFR Part 2., * Computer Science, Data Science, Information Systems, Business Analytics, Healthcare Informatics, or a related field.
• Associate degree with three years’ experience or
• Bachelor’s degree with two years’ experience
• Master’s degree with one year’s experience

A comparable amount of training, education, or experience may be substituted for the above minimum qualifications

ESSENTIAL PHYSICAL SKILLS:

• Able to sit at a keyboard/desk for extended periods of time
• Able to differentiate between colors for screen definition
• While performing the duties of this job, the employee is regularly required to stand, walk, use hands and fingers, to handle, or feel objects, tools, or controls; and talk or hear. The employee frequently is required to sit and reach with hands or arms
• The employee must frequently lift and/or move up to 50 or more pounds. Specific vision abilities as required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus
• Able to use multiple monitors at once

Reasonable accommodations will be made for otherwise qualified individuals with a disability.

LICENSES, CERTIFICATIONS OR REGISTRATIONS:

• Microsoft Certified: Power BI Data Analyst Associate - Preferred
• Microsoft Certified: Azure Data Fundamentals - Preferred
• Microsoft Certified: Fabric Analytics Engineer Associate - Preferred
• Microsoft Certified: Azure Database Administrator Associate- Preferred, * Ability to travel locally for project-related meetings and site visits.