Healthcare Data Analyst — Data Warehouse & BI

Vitana Pediatric & Orthodontic Partners; Plantation (FL); On-site; USD 55,000 - 85,000; Full time

Job summary

Vitana Pediatric & Orthodontic Partners in Florida is seeking a Data Analyst to help build the data infrastructure and reporting capabilities for a growing multi-location healthcare organization. You will design and maintain data schemas, develop extraction and validation processes, and build dashboards with Power BI, Looker Studio, or Tableau, translating business questions into analysis.

Collaborating with Finance, Operations, and Marketing, you will ensure accurate data and drive improvements

Qualifications

• Bachelor's degree in a related field.
• 0–3 years of relevant professional experience; internships or projects are encouraged.
• Experience with data warehouses such as BigQuery, Azure, Redshift, or similar.
• Proficient in SQL and Python.
• Experience with BI tools such as Power BI, Looker Studio, Tableau; data visualization skills.

Responsibilities

• Assist in designing and maintaining normalized data schemas for key business metrics, including production, collections, appointments, treatment starts, and KPIs.
• Build and maintain data extraction processes from multiple Practice Management Systems across locations.
• Develop validation processes to ensure data is complete, accurate, and consistent.
• Reconcile data in the data warehouse against reporting.
• Write and maintain SQL queries and Python scripts for extraction, transformation, validation, and analysis.
• Build and maintain dashboards and reporting using BI tools such as Power BI, Looker Studio, or Tableau.
• Collaborate with Finance, Operations, Marketing, and other departments to translate questions into analysis.

Education

Bachelor's degree in Data Science, Business Analytics, Statistics, Computer Science, Information Systems, or a related field

Tools

Google BigQuery

Microsoft Azure

Amazon Redshift

SQL

Python

Power BI

Looker Studio

Tableau

Job description

Vitana Pediatric & Orthodontic Partners in Florida is seeking a Data Analyst to help build the data infrastructure and reporting capabilities for a growing multi-location healthcare organization. You will design and maintain data schemas, develop extraction and validation processes, and build dashboards with Power BI, Looker Studio, or Tableau, translating business questions into analysis.

Collaborating with Finance, Operations, and Marketing, you will ensure accurate data and drive improvements