Data Analyst: Build Our Scalable Data Warehouse

Vitanapdp; Plantation (FL); Hybrid; USD 60,000 - 90,000; Full time

Job summary

Vitana Pediatric & Orthodontic Partners is seeking a Data Analyst to join our growing Florida team. This early-career role offers hands-on experience building data infrastructure and reporting for a multi-location healthcare organization.

You will work closely with leadership to organize, validate, and transform data from multiple practice management systems into reliable, actionable information, supporting a centralized data warehouse and data-driven decisions.

Qualifications

• Bachelor's degree in Data Science, Business Analytics, Statistics, Computer Science, Information Systems, or a related field.
• 0–3 years of relevant professional experience; internships or projects welcome.
• Experience with data warehouses such as Google BigQuery, Microsoft Azure, Amazon Redshift, or similar.
• Working knowledge of SQL and/or Python.
• Experience with BI and visualization tools such as Power BI, Looker Studio, Tableau, or similar.
• Strong analytical and problem-solving skills with attention to detail.
• Ability to validate and reconcile data across multiple sources.
• Healthcare or multi-location business experience is a plus.

Responsibilities

• Assist in designing and maintaining normalized data schemas for key metrics.
• Build and maintain data extraction processes from Practice Management Systems across locations.
• Develop validation processes to ensure data completeness and accuracy.
• Reconcile data within the centralized data warehouse against reporting.
• Write and maintain SQL queries and Python scripts for extraction, transformation, validation, and analysis.
• Support the development and maintenance of Vitana's centralized data warehouse.
• Build and maintain dashboards and reporting using BI tools such as Power BI, Looker Studio, or Tableau.
• Collaborate with Finance, Operations, Marketing to translate reporting needs into analysis.
• Identify inconsistencies and trends; communicate findings to stakeholders.
• Document data sources, definitions, processes, and reporting logic.
• Support ongoing improvements to Vitana's data infrastructure as the organization grows.

Skills

Analytical skills

Data validation

SQL

Python

Communication

Education

Bachelor's degree in Data Science or related field

Tools

Power BI

Looker Studio

Tableau

BigQuery

Azure

Redshift

Job description

Vitana Pediatric & Orthodontic Partners is seeking a Data Analyst to join our growing Florida team. This early-career role offers hands-on experience building data infrastructure and reporting for a multi-location healthcare organization.

You will work closely with leadership to organize, validate, and transform data from multiple practice management systems into reliable, actionable information, supporting a centralized data warehouse and data-driven decisions.