Onelife Fitness
About the role
Youll design and deliver our next-generation KPI framework and enterprise dashboards. From metric definitions and data modeling to production builds, QA, documentation, and adoptionyou own the lifecycle. Your work will standardize KPIs, establish a clean semantic layer, and deliver executive-ready views that guide decisions across Operations, Finance, and Marketing.
What youll do
Define KPIs & metrics:
Partner with business owners to lock calculation logic, lineage, ownership, and refresh cadence. Model data for reuse:
Build star/snowflake models powering reusable
Power BI
datasets; write robust
DAX
and
Power Query M . Build & evolve dashboards:
Ship high-performing, consistent Power BI reports; monitor adoption and iterate with a product mindset. Modernize legacy reporting:
Rationalize
SSRS
inventory and replace with curated Power BI solutionswithout losing accuracy. Source & validate data:
Pull from
MS SQL Server ,
Cognos ,
Centage , and APIs; investigate anomalies with targeted SQL. Document & govern:
Maintain a living KPI dictionary; support governance (naming, security/RLS, refresh, versioning/release). Prioritize transparently:
Manage a clear analytics backlog and roadmap with leaders; balance quick wins and strategic builds. Communicate insights:
Deliver clear, actionable findings to senior leadership. What youll bring Advanced
Power BI
(data modeling, DAX, Power Query M) with best practices for scale and performance. Strong
SQL
(joins, window functions, tuning) across large relational datasets. Experience with
SSRS
(assessment/migration); familiarity with
Cognos
outputs (e.g., UKG). Advanced
Excel
(pivots, complex formulas;
VBA
a plus). Analytical rigor; ability to convert ambiguity into precise metric specs. Excellent communication and documentation; cross-functional collaborator in a fast-moving environment. Education & experience Bachelors in Analytics, IS, CS, or related fieldor equivalent experience. 35 years
as a Business/Data Analyst (data-driven environment). 2+ years
hands-on with
Power BI ,
SQL , and
Excel
(required). Cognos BI or SSRS preferred;
Python
for automation/API a plus. Multi-unit services/fitness/hospitality/retail experience helpful. Location & Work Model Hybrid/Remote with periodic in-office collaboration and cross-functional meetings at our corporate office in McLean, VA. ONELIFE FITNESS IS AN EQUAL OPPORTUNITY EMPLOYER Know Your Rights Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
Partner with business owners to lock calculation logic, lineage, ownership, and refresh cadence. Model data for reuse:
Build star/snowflake models powering reusable
Power BI
datasets; write robust
DAX
and
Power Query M . Build & evolve dashboards:
Ship high-performing, consistent Power BI reports; monitor adoption and iterate with a product mindset. Modernize legacy reporting:
Rationalize
SSRS
inventory and replace with curated Power BI solutionswithout losing accuracy. Source & validate data:
Pull from
MS SQL Server ,
Cognos ,
Centage , and APIs; investigate anomalies with targeted SQL. Document & govern:
Maintain a living KPI dictionary; support governance (naming, security/RLS, refresh, versioning/release). Prioritize transparently:
Manage a clear analytics backlog and roadmap with leaders; balance quick wins and strategic builds. Communicate insights:
Deliver clear, actionable findings to senior leadership. What youll bring Advanced
Power BI
(data modeling, DAX, Power Query M) with best practices for scale and performance. Strong
SQL
(joins, window functions, tuning) across large relational datasets. Experience with
SSRS
(assessment/migration); familiarity with
Cognos
outputs (e.g., UKG). Advanced
Excel
(pivots, complex formulas;
VBA
a plus). Analytical rigor; ability to convert ambiguity into precise metric specs. Excellent communication and documentation; cross-functional collaborator in a fast-moving environment. Education & experience Bachelors in Analytics, IS, CS, or related fieldor equivalent experience. 35 years
as a Business/Data Analyst (data-driven environment). 2+ years
hands-on with
Power BI ,
SQL , and
Excel
(required). Cognos BI or SSRS preferred;
Python
for automation/API a plus. Multi-unit services/fitness/hospitality/retail experience helpful. Location & Work Model Hybrid/Remote with periodic in-office collaboration and cross-functional meetings at our corporate office in McLean, VA. ONELIFE FITNESS IS AN EQUAL OPPORTUNITY EMPLOYER Know Your Rights Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities