Senior Data BI Analyst

U.S. Orthopaedic Partners•Alpharetta, GA

About The Position

The Senior Data BI Analyst reports to the Data & Analytics Manager and supports reporting, business intelligence, and financial analysis across the organization. The role maintains and enhances existing reporting solutions while developing data models, Power BI dashboards, and automated workflows to improve data accessibility, accuracy, and efficiency. In partnership with Finance, the analyst develops automated data loads, validates financial reporting, investigates discrepancies and performance variances, and responds to ad hoc analytical requests. The position combines technical data skills, financial acumen, analytical ability, and the capacity to translate business needs into reliable, actionable reporting for corporate leadership and practice-level stakeholders.

Requirements

Bachelor's degree in Data Analytics, Finance, Accounting, Economics, Information Systems, or a related field.
Approximately 3–5 years of relevant experience in data analytics, business intelligence, reporting, or a related analytical role.
Advanced Excel skills, including lookups, pivot tables, nested functions, and exposure to Power Query.
Ability to understand the general ledger and reconcile it with dashboards and reporting.
Hands-on Power BI or similar experience, including independently developing and modifying dashboards, data models, measures, and report layouts.
Proficiency in SQL, including joins, aggregations, multi-table queries, and investigating data discrepancies.
Ability to manage routine responsibilities independently and collaborate with cross-functional stakeholders on larger initiatives.
Experience communicating analytical findings to technical and nontechnical audiences.

Nice To Haves

Two or more years in FP&A, financial analysis, or data analytics/BI, with at least two years building Power BI or similar reports.
Healthcare services, physician practice management, or ASC experience, including familiarity with revenue cycle data and workflows.
Experience with Mod Med, Great Plains, Jet Reports, UKG, or similar systems.
Python, Microsoft Fabric or data warehouse experience, or experience with AI and automation tools.
Experience in a private equity-backed or multi-entity environment.

Responsibilities

Independently maintain, troubleshoot, and enhance assigned Power BI dashboards and recurring reports, ensuring accuracy, reliability, and alignment with business needs.
Write, maintain, and troubleshoot SQL queries to retrieve, join, aggregate, and analyze data across multiple sources.
Manage assigned reporting solutions throughout their lifecycle, from gathering requirements and developing solutions to validating results, implementing enhancements, and supporting ongoing use.
Create and deliver weekly and monthly operations reporting.
Support the Data & Analytics Manager with data discovery, metric creation, and reporting needs for the platform-wide reporting suite.
Build and maintain Power BI dashboards for financial, operational, and provider performance.
Design data models that join GL, payroll (UKG), revenue cycle, and practice operations data.
Write and tune SQL against the ERP (Great Plains) and other source systems.
Validate every dashboard against the GL and Financial Workbook, and document data sources and tie-outs.
Support executive-level management with metric delivery and reporting validation.
Maintain a broad understanding of the entire data scope to provide next-level analysis.
Create, own, and deliver new reporting requests on the requested cadence.
Automate recurring Excel and Jet Reports processes into repeatable data pipelines.
Find and fix data quality issues at the source, working with Accounting and RCM.
Train finance and operations users on self-serve dashboards.