Senior Business Intelligence & Analyst

PCRK Group • Tempe, AZ

1d • Hybrid

About The Position

We operate as a leading multi-unit Massage Envy franchisee, managing over 130 locations within a nationally recognized wellness brand. Our private equity partners have recognized our analytics and management oversight capabilities as among the strongest in their portfolio- and we are continuing to invest to push that advantage even further. We have built a mature, enterprise-grade data warehouse and analytics environment, and we are now focused on expanding, developing new insight modules, scaling performance, and leveraging AI-driven tools to unlock deeper, more actionable intelligence. We are hiring a Senior Business Intelligence & Analyst to play a central role in that evolution. In this role, you will enhance an already strong foundation- building new dashboards, advancing our data model, and driving the next generation of analytics, including customer insights, revenue optimization, and workforce intelligence. You will operate as a high-impact individual contributor, owning BI execution while partnering across the business with external data engineering teams to scale capabilities and deliver meaningful insights.

Requirements

• 5 - 7+ years of experience in Business Intelligence, Analytics, or related roles
• Advanced expertise in Power BI (or comparable BI tools)
• Strong experience working in SQL-based data warehouse environments (Azure preferred)
• Experience managing ETL processes and automated data pipelines
• Ability to translate business needs into scalable technical solutions
• Experience coordinating with cross-functional stakeholders and external vendors
• Strong analytical thinking and problem-solving skills
• Willingness to collaborate with offshore teams, including flexibility in working hours when needed

Nice To Haves

• Experience in multi-unit retail, franchise, or service-based environments
• Familiarity with MEEVO, Paylocity, Sage Intacct, Zoho, or similar systems
• Experience writing Python scripts for automation or data processing
• Experience leveraging AI/LLM tools to improve productivity and output quality

Responsibilities

• Design, build, and enhance Power BI dashboards that drive operational and executive decision-making
• Expand existing analytics by developing new insight modules, including customer engagement, member acquisition, and revenue optimization
• Translate business needs into clear requirements, wireframes, and scalable reporting solutions
• Partner with operations, finance, payroll, and leadership to deliver actionable, data-driven insights
• Drive dashboard usability, adoption, and continuous improvement
• Improve Azure SQL data warehouse scalability, performance, and efficiency
• Optimize table structures and data models to support evolving analytics needs
• Troubleshoot data issues and resolve performance constraints proactively
• Promote continuous improvement of the data environment to support increasing data volume and complexity
• Design and maintain data models (star schema, dimension modeling, fact tables)
• Write efficient SQL queries to ensure Power BI dashboard performance
• Build reusable datasets and views for broader consumption
• Build forecasting models, cohort analyses and trend projections
• Oversee automated ETL processes integrating data from MEEVO, Paylocity, Sage Intacct, Zoho, and Empower
• Support payroll processes by ensuring accurate extraction, validation, and loading of service hours, commissions, and tips
• Implement and maintain data quality controls and validation frameworks
• Ensure automated daily production of ~100K reports across 130 locations runs accurately, reliably, and on schedule
• Identify and resolve data latency, capacity constraints, and system issues
• Manage exceptions and continuously improve automation performance and reliability
• Own and continuously refine the BI and analytics roadmap
• Prioritize and deliver initiatives aligned to business goals, including incremental revenue insights, employee performance, compensation, and productivity analytics, revenue and deferred revenue reporting, inventory analytics, and customer insights and engagement analytics
• Manage stakeholder expectations, communicate progress, and adjust priorities as needed
• Write and leverage SQL and Python to support data transformation and automation
• Use LLM/AI tools to accelerate dashboard development, ETL workflows, and insight generation
• Explore and implement AI-driven enhancements to deliver more predictive and actionable analytics

Benefits

• Health Insurance
• Dental Insurance
• Vision Insurance

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed