Senior Business Intelligence Analyst

PCRK Group•Tempe, AZ

28d•$90,000 - $110,000•Hybrid

About The Position

We are a leading multi-unit Massage Envy franchisee seeking a Senior Business Intelligence Analyst to play a central role in evolving our analytics capabilities. We have a mature data warehouse and analytics environment and are focused on expanding it, developing new insight modules, scaling performance, and leveraging AI-driven tools. In this role, you will enhance our existing foundation by 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 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 in partnership with third-party data engineering teams.
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 analytics, revenue and deferred revenue reporting, inventory analytics, and customer insights.
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.