Business Intelligence Analyst

National Fitness Partners; Springfield Township (Delaware County); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Growth opportunities

PTO for all employees

401K with employer match up to 4%

Health insurance options

Life insurance & short-term disability

Employee assistance program

Free Black Card membership

Job summary

National Fitness Partners in Philadelphia, PA is seeking a Business Intelligence Analyst to transform data into meaningful insights, supporting strategic decisions and financial discipline across the organization.

You will design scalable BI solutions, build dashboards in Sigma, Power BI, and other platforms, develop ETL pipelines and data models, and partner with Finance, Operations, HR, Marketing, IT, and leadership.

Qualifications

• Bachelor’s degree in Data Science, CS, or related field.
• 3–7+ years in BI, data analytics, or data engineering.
• Strong SQL skills for data extraction and querying.
• Proficiency with Python for data prep and automation.

Responsibilities

• Design, build, and maintain interactive dashboards and reports.
• Translate data from finance, operations, HR, marketing into actionable outputs.
• Develop recurring and ad hoc KPI reports and analyses.
• Build and maintain ETL/ELT pipelines and data models.
• Partner with business stakeholders to define KPIs and forecasting.

Skills

SQL

Python

Data visualization

Data modeling

ETL/ELT

Education

Bachelor’s degree in Data Science or related field

Tools

Sigma

Power BI

Tableau

Databricks

Snowflake

Job description

Full-time, salaried position based in Phliadelphia, PA (on-site only).

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

At National Fitness Partners, we don’t just work in fitness— we TRANSFORM LIVES through affordable fitness. As the largest Planet Fitness franchise, we serve over one million members across 200+ clubs nationwide, creating a Judgement Free fitness experience.

• We Are Accountable – Self-starters who pursue excellence.
• We Are Driven – Problem solvers who deliver results.
• We Are Passionate – Positive energy with a real desire to help others.
• We Are Ambitious – Always learning and growing toward success.

We believe in the power of our people to make a difference. If you’re looking for a career where your passion meets purpose, we want YOU on our team!

Benefits

• Growth Opportunities over 90% of our management team started as an entry level team member!
• PTO for all employees
• 401K Retirement Fund (Employer match up to 4%!)
• Health Insurance Options including Health, Dental, Vision, family life insurance, and more
• Basic Life Insurance & Short-Term Disability I00% Company Paid!
• Employee Assistance Program
• Free employee Black Card Membership

Job Summary

The Business Intelligence Analyst plays a critical role in transforming data into meaningful, accurate, and actionable insights that support strategic decision-making, operational performance, and financial discipline across the organization. This role is responsible for designing and delivering scalable business intelligence solutions, including interactive dashboards, reporting tools, data models, and analytical frameworks that help leaders better understand trends, measure performance, identify opportunities, and make informed decisions.

This position serves as both a technical analytics resource and a cross-functional business partner, working closely with Finance, Operations, HR, Marketing, IT, and senior leadership to translate complex business questions into reliable data solutions. The BI Analyst will gather requirements, define and standardize key performance indicators, build and maintain data pipelines and reporting structures, validate data accuracy, and present insights in a clear, practical, and business-oriented manner. Success in this role requires strong technical capability in SQL, Python, BI tools, and cloud-based data platforms, combined with curiosity, sound business judgment, and the ability to communicate effectively with both technical and non-technical audiences.

Essential Job Functions

Business Intelligence, Reporting & Dashboard Development

• Design, build, and maintain interactive dashboards, visualizations, and self-service reporting tools using Sigma, Power BI, , or similar platforms.
• Translate raw data from accounting, financial systems, operations, HR, marketing, and other business areas into clear, accurate, and actionable reporting outputs.
• Develop recurring and ad hoc reports that communicate KPIs, trends, variance analysis, performance drivers, and business implications.

Data Engineering, Modeling & Integration

• Design, build, and maintain scalable ETL/ELT data pipelines using SQL, Python, PySpark, cloud-based orchestration tools, APIs, databases, flat files, and third-party platforms.
• Build and maintain data models, schemas, semantic layers, and warehouse structures, including dimensional models, to support consistent and scalable reporting and analytics.
• Write and optimize complex SQL queries, tune data workflows, and improve data storage, retrieval, processing performance, and reliability across reporting environments.

Advanced Analytics & Emerging Technology Support

• Support forecasting, segmentation, optimization, experimentation, and data science initiatives by preparing reliable datasets, curated inputs, and scalable data assets.
• Evaluate and apply AI-enabled analytics tools, including generative AI and large language models, to improve reporting automation, data exploration, insight generation, and business productivity.
• Use AI and LLM-enabled tools responsibly by following appropriate data privacy, security, governance, validation, and documentation standards.

Business Partnership & Performance Insights

• Partner with leaders and stakeholders across Finance, Operations, HR, Marketing, IT, analytics, and senior leadership to understand business needs, define reporting requirements, and align data initiatives with organizational priorities.
• Define and standardize key performance indicators, support budgeting, forecasting, and financial performance analysis, and identify opportunities for cost optimization, revenue growth, and operational efficiency.

Data Governance, Quality & Process Improvement

• Ensure data integrity, consistency, security, and compliance by implementing validation checks, access controls, monitoring, documentation, and governance standards.
• Perform data validation, cleansing, reconciliation, and root-cause analysis to resolve data discrepancies, reporting issues, and process gaps.
• Automate manual reporting processes, improve data workflows, document business logic and reporting standards, and stay current with BI, analytics, AI, and data engineering technologies.

Qualifications

• Bachelor’s degree in Data Science, Computer Science, Information Systems, Statistics, Engineering, Finance, Business Analytics, or a related field; equivalent relevant experience may be considered.
• 3–7+ years of experience in business intelligence, data analytics, data engineering, or a related role supporting both technical data solutions and business decision-making.
• Strong SQL skills, including data extraction, transformation, query optimization, and work within relational database or data warehouse environments.
• Proficiency with Python for data preparation, automation, analysis, and pipeline support; experience with PySpark or distributed data processing is a plus.
• Hands-on experience building or supporting ETL/ELT pipelines, data models, semantic layers, and scalable reporting datasets using cloud-based or modern data platforms, specifically Databricks & Snowflake.
• Experience with business intelligence and visualization tools such as Sigma, Power BI, Tableau, or similar platforms, including dashboard development and KPI reporting.
• Experience with Azure Synapse Analytics or related Azure data services, including pipelines, notebooks, linked services, and integration components, is a plus.
• Relevant certification in data engineering, cloud platforms, business intelligence, analytics, or AI-enabled analytics is a plus.
• Demonstrated experience using AI/LLM tools to materially improve analytics workflows, automation, or efficiencies — with specific examples of what you built, used, or automated. Experience in a multi-site or operations-driven environment such as retail, fitness, healthcare, hospitality, or QSR is a plus.
• Ability to translate business questions into analytical requirements and communicate insights clearly to both technical and non-technical stakeholders.

Key Competencies

• Analytical problem-solving, critical thinking, and intellectual curiosity.
• Strong attention to detail, data accuracy, documentation, and quality control.
• Clear communication and storytelling skills with the ability to influence technical and non-technical stakeholders.
• Ability to manage multiple priorities, work independently, and adapt in a fast-paced, evolving environment.