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
Partner with third-party data engineering teams (India-based) to 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 (memberships, enhancements, retail), 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, 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