Job Description

About the role

You’ll design and deliver our next-generation KPI framework and enterprise dashboards. From metric definitions and data modeling to production builds, QA, documentation, and adoption—you 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 you’ll 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 solutions—without 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 you’ll 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

• Bachelor’s in Analytics, IS, CS, or related field—or equivalent experience.
• 3–5 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

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

Job Tags

Similar Jobs