Multi-Location Data & Business Analyst

Multi-Location Data & Business AnalystOverview

Smyle Dental Implant Centers is seeking a highly organized, detail-oriented, and experienced Multi-Location Data & Business Analyst to manage, record, organize, and analyze business data across our multiple locations.

We are looking for someone who is highly skilled with data and understands how to take information from multiple sources, accurately record it, verify it, organize it, and turn it into clear reports and dashboards for leadership.

This person will be responsible for making sure our numbers are accurate, consistent, organized, and up to date across every location.

The ideal candidate should not simply enter numbers. They should understand what the data means, recognize when something does not look correct, investigate discrepancies, identify trends, and provide leadership with clear information that can be used to make business decisions.

Key ResponsibilitiesMulti-Location Data Management

• Collect and maintain data for multiple Smyle Dental Implant Centers locations
• Accurately record daily, weekly, and monthly business information
• Maintain organized spreadsheets, databases, dashboards, and reporting systems
• Ensure each location is reporting information consistently
• Review data submitted by individual locations for accuracy and completeness
• Follow up with managers and team members when information is missing or unclear
• Identify duplicate, incorrect, or inconsistent data
• Reconcile information between different systems and reports
• Maintain historical data so leadership can compare performance over time

Patient & Appointment Data

Track and analyze key patient metrics, including:

• New patient leads
• Appointments booked
• Patients scheduled
• Patients confirmed
• Patients who showed
• No-shows
• Cancellations
• Rescheduled patients
• Pending patients
• Retargeted patients
• Lead-to-appointment conversion
• Appointment-to-show conversion

Treatment & Financial Data

• Track treatment presented
• Track treatment accepted versus not accepted
• Calculate treatment acceptance percentages
• Track pending treatment
• Track collections and production
• Monitor financing activity when applicable
• Compare presented treatment against accepted treatment
• Identify discrepancies between reported and actual numbers
• Compare performance by provider and location

Marketing Data & Performance

• Track leads by marketing source and campaign
• Monitor advertising spend
• Track cost per lead
• Track cost per booked appointment
• Track cost per showed patient
• Analyze lead-to-patient conversion
• Monitor marketing ROI and ROAS
• Compare marketing vendors and campaigns
• Identify which campaigns are generating quality patients
• Work with marketing and operations teams to verify reported results

Reporting & Dashboards

• Create and maintain daily, weekly, monthly, quarterly, and annual reports
• Build easy-to-understand dashboards for leadership
• Compare performance across different locations
• Compare current results with previous months and established goals
• Create location-specific reports as well as consolidated company reports
• Present findings clearly to leadership
• Highlight significant increases, decreases, trends, or concerns
• Provide accurate data for leadership meetings and business reviews

Data Accuracy & Quality Control

Accuracy is extremely important in this position.

The analyst will be expected to:

• Review numbers before reports are submitted
• Catch missing or inaccurate information
• Question numbers that do not appear consistent
• Investigate why reports or systems do not match
• Verify information with the appropriate location or department
• Establish consistent reporting methods across locations
• Maintain organized records so information can easily be reviewed later
• Ensure leadership is making decisions based on reliable data

Required Skills & Experience

• Previous professional experience in data analysis, business analysis, reporting, finance, operations analytics, or a related field preferred
• Strong experience recording, organizing, validating, and analyzing business data
• Advanced Microsoft Excel and/or Google Sheets skills
• Strong understanding of formulas, pivot tables, data validation, filtering, lookups, and reporting
• Experience creating dashboards and KPI reports
• Strong attention to detail and accuracy
• Experience working with data from multiple locations, departments, or business units preferred
• Ability to reconcile information from multiple systems
• Ability to identify trends and discrepancies within large amounts of data
• Strong analytical and problem-solving skills
• Ability to explain data clearly to managers and leadership
• Experience with CRM, dashboard, reporting, or business intelligence platforms preferred
• Power BI, Tableau, or similar reporting experience is a plus
• Dental, healthcare, medical, multi-location, or marketing analytics experience is a plus

Who We Are Looking For

We are looking for someone who is very comfortable working with numbers and large amounts of information.

The right candidate must be extremely organized and detail-oriented. They should be able to receive information from several locations, organize it correctly, identify what is missing, and follow up until the data is complete.

We need someone who does more than data entry. This person should be able to understand the numbers, find inconsistencies, recognize trends, and explain what the data is telling us.

They should also be comfortable working independently and taking ownership of the company's reporting systems.

Position Details

Job Title: Multi-Location Data & Business Analyst
Company: Smyle Dental Implant Centers
Employment Type: Full-Time
Experience: Relevant data, business, financial, or operations analysis experience preferred
Industry Experience: Dental, healthcare, medical, marketing, or multi-location business experience is a plus
Compensation: Pay will be determined based on experience, qualifications, and skill level.

If you are highly skilled in data organization, reporting, analytics, and identifying trends and enjoy turning large amounts of information into accurate and useful business insights, we would like to hear from you.

Pay: $30.00 - $38.00 per hour

Benefits:

• 401(k)
• Paid time off

Work Location: In person