Senior Business Intelligence & Analyst at PCRK Group

Tempe, Arizona, United States -

Full Time

Start Date

Immediate

Expiry Date

06 Aug, 26

Salary

110000.0

Posted On

08 May, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Power BI, SQL, Azure SQL, ETL Processes, Data Modeling, Python, Data Warehousing, Business Intelligence, Dashboard Development, Cohort Analysis, Forecasting Models, Stakeholder Management, AI/LLM Tools, Data Validation, Requirement Gathering, Analytical Thinking

Industry

Wellness and Fitness Services

Description

Description 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. Key Responsibilities: Business Intelligence & Dashboard Development 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 Data & Warehouse Optimization 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 Data Pipeline & Process Ownership 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 Operational Monitoring & Reliability 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 Roadmap & Stakeholder Management 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 AI, Automation & Advanced Tools 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 Requirements Required: 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 Preferred: 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 Success Metrics (MBOs): Deliver accurate, on-time automated reporting across all locations Improve data quality and reliability through strong validation controls Enhance data warehouse performance and scalability Deliver actionable insights that drive revenue, labor optimization, and operational performance Execute and evolve the BI roadmap, including new analytics modules Increase adoption and impact of dashboards across the organization Work Environment: Hybrid role based in Tempe, AZ: 1400 E. Southern Ave, Tempe, AZ, 85252 Work onsite Tuesday - Thursday, remote Monday and Friday Collaborate with offshore teams as needed, with occasional flexibility in working hours Pay Range: $90,000 - $110,000 Annually DOE

Responsibilities

The role focuses on designing and enhancing Power BI dashboards and optimizing the Azure SQL data warehouse to drive operational decision-making. It involves managing automated ETL processes and partnering with offshore engineering teams to scale analytics capabilities.