Sr. Data Analyst - Planning

The Aspen Group (TAG) is one of the largest and most trusted retail healthcare business support organizations in the U.S. and has supported over 20,000 healthcare professionals and team members at more than 1,300 health and wellness offices across 48 states in four distinct categories: dental care, urgent care, medical aesthetics, and animal health. Working in partnership with independent practice owners and clinicians, the team is united by a single purpose: to prove that healthcare can be better and smarter for everyone. TAG provides a comprehensive suite of centralized business support services that power the impact of five consumer-facing businesses: Aspen Dental, ClearChoice Dental Implant Centers, WellNow Urgent Care, Chapter Aesthetic Studio, and AZPetVet. Each brand has access to a deep community of experts, tools and resources to grow their practices, and an unwavering commitment to delivering high-quality consumer healthcare experiences at scale.

As a reflection of our current needs and planned growth we are seeking an individual to join our organization as a Senior Data Analyst - Planning. The Senior Data Analyst - Planning role within the Revenue Management & Planning team is responsible for developing and implementing data, reporting, and analytical solutions to support the commercial planning department. We are looking for a candidate with strong technical skills, a keen eye for detail, excellent organizational and communication skills, and a passion for finding new ways to solve problems.

Essential Responsibilities

• Utilize relational databases to extract and analyze data as well as summarize insights to support ongoing performance evaluation of the business, with a specific focus on performance of CRM campaigns initially
• Integrate data across multiple operating systems such as Salesforce and in-home Patient Management System to provide a comprehensive measurement readout on initiatives
• Drive reconciliation of data discrepancies, if any, across systems in partnership with IT
• Execute analytical diagnostics / deep dives to support ongoing business needs – evaluate and report on performance of every stage of the funnel from leads to appointments to visits to revenue
• Design and build user-friendly Tableau dashboards to enable functional leaders stay updated on performance of ongoing initiatives
• Support the marketing org’s test and learn agenda through optimal test designs and measurement of pilots / tests

Requirements/Qualifications

• High proficiency in SQL (Big Query preferred), Excel, Tableau required. Analytics tools, such as Python and R a plus.
• Working experience with Salesforce
• Ability to meet deadlines, service level commitments, and prioritize multiple tasks independently.
• Detail-oriented, analytical ability and strong oral/written communication skills are also required.
• Must be able to work well with others in a time-sensitive team environment with a flexible attitude focused on delivering outcomes
• 3-5 years in a Business Analytics role required.
• Undergraduate degree required with major in Business, Finance, Economics, Analytics, Computer Science, Statistics, or related field preferred.
• Master’s degree in related field a plus
• Experience in the Heath Care Industry or Customer Relationship Management a plus

Annual Pay Range: $110-125k

A generous benefits package that includes paid time off, health, dental, vision, and 401(k) savings plan with match

If you are an applicant residing in California, please view our privacy policy here: https://careers.aspendental.com/us/en/tag-privacy-policy-for-california-employees

Salary : $110,000 - $125,000