Data Analyst

Socket.dev; Plantation (FL); On-site; USD 55,000 - 85,000; Full time

Job summary

Vitana Pediatric & Orthodontic Partners is seeking a Data Analyst to help organize, validate, and transform data from multiple practice management systems into reliable, actionable information. You will contribute to building Vitana's centralized data warehouse and enable accurate data for decision making across locations.

The role involves designing data schemas, extracting data from practice systems, validating data quality, and developing dashboards with Power BI, Looker Studio, or Tableau to

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; strong recent graduates with internships, projects, or technical experience are encouraged to apply.
• Experience with data warehouses such as Google BigQuery, Microsoft Azure, Amazon Redshift, or similar platforms.
• Working knowledge of SQL and/or Python.
• Experience with BI and visualization tools such as Power BI, Looker Studio, Tableau, or similar platforms.

Responsibilities

• Assist in designing and maintaining normalized data schemas for key business and operational metrics, including production, collections, appointments, treatment starts, and other practice-level KPIs.
• Build and maintain data extraction processes to pull information from multiple Practice Management Systems across Vitana's locations.
• Develop validation processes to ensure data is complete, accurate, and consistent across systems.
• Reconcile data within the centralized data warehouse against existing practice and corporate reporting.
• Write and maintain SQL queries and Python scripts used for data 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.
• Partner with Finance, Operations, Marketing, and other departments to understand reporting needs and translate business questions into meaningful analysis.
• Identify inconsistencies, trends, and opportunities within large datasets and communicate findings clearly to business stakeholders.
• Assist with documentation of data sources, definitions, processes, and reporting logic.
• Support ongoing improvements to Vitana's data infrastructure as the organization continues to grow and add practices.

Skills

SQL

Python

Data Warehousing

BI Tools

Education

Bachelor's degree in Data Science

Bachelor's degree in Business Analytics

Tools

Google BigQuery

Microsoft Azure

Amazon Redshift

SQL

Python

Power BI

Looker Studio

Tableau

Job description

As a rapidly growing organization, Vitana Pediatric & Orthodontic Partners is looking for a Data Analyst to join our team. This is a great opportunity for an early-career data professional who wants hands‑on experience building the data infrastructure and reporting capabilities that support a growing, multi-location healthcare organization.

The Data Analyst will work closely with leadership to help organize, validate, and transform data from multiple practice management systems into reliable, actionable information. This individual will play an important role in developing Vitana's centralized data warehouse and ensuring our teams have accurate data to make better business decisions.

Key Responsibilities

• Assist in designing and maintaining normalized data schemas for key business and operational metrics, including production, collections, appointments, treatment starts, and other practice-level KPIs.
• Build and maintain data extraction processes to pull information from multiple Practice Management Systems across Vitana's locations.
• Develop validation processes to ensure data is complete, accurate, and consistent across systems.
• Reconcile data within the centralized data warehouse against existing practice and corporate reporting.
• Write and maintain SQL queries and Python scripts used for data 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.
• Partner with Finance, Operations, Marketing, and other departments to understand reporting needs and translate business questions into meaningful analysis.
• Identify inconsistencies, trends, and opportunities within large datasets and communicate findings clearly to business stakeholders.
• Assist with documentation of data sources, definitions, processes, and reporting logic.
• Support ongoing improvements to Vitana's data infrastructure as the organization continues to grow and add practices.

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; strong recent graduates with applicable internships, projects, or technical experience are encouraged to apply.
• Experience working with or building data warehouses such as Google BigQuery, Microsoft Azure, Amazon Redshift, or similar platforms.
• Working knowledge of SQL and/or Python.
• Experience with business intelligence and visualization tools such as Power BI, Google Looker Studio, Tableau, or similar platforms.
• Strong analytical and problem‑solving skills with excellent attention to detail.
• Ability to validate and reconcile data across multiple sources.
• Comfortable working in a fast‑paced, growing environment where priorities may evolve.
• Strong communication skills and the ability to work collaboratively with both technical and non‑technical team members.
• Healthcare, dental, or multi‑location business experience is a plus, but not required.

What We're Looking For

We are looking for someone who is naturally curious, analytical, and excited about solving problems with data. The ideal candidate doesn't just pull numbers, they want to understand where the data comes from, whether it is accurate, and how it can be used to help the business operate more effectively.

This is an opportunity to join Vitana at an exciting stage of growth and have a meaningful role in building the data foundation that will support the organization as we continue to scale.