Senior Business Intelligence & Analyst
hace 19 días
Tempe
Job DescriptionDescription: 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