Data Analyst: Build Central Data Warehouse & Dashboards

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

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