Driving the future of orthopedic medicine.
Senior Data Analyst – RCM
Location
Connecticut
Posted
5 days ago
Salary
$102.9K - $154.3K / year
Seniority
Senior
Job Description
Senior Data Analyst – RCM
Spire Orthopedic Partners
• Design and maintain RCM dashboards and reports in Power BI covering charges, payments, adjustments, denial rates, A/R aging, days in A/R, and payer performance • Write and optimize complex SQL queries in Snowflake to extract and model data from billing systems and practice management platforms • Partner with RCM leadership, billing teams, and finance to define KPIs, understand what's driving variances, and communicate findings clearly • Build out payer-level and procedure-level analyses to identify leakage, underpayments, and denial trends • Monitor data quality across billing feeds and flag anomalies before they become problems downstream • Deliver recurring production reports and ad hoc analysis on time, with context, not just numbers • Present findings to finance, operations, and executive audiences in a way that drives decisions • Document methodology and report logic so the work is repeatable and auditable • Mentor junior team members on RCM data concepts and analytical best practices
Job Requirements
- 5+ years of analytics experience with at least 3 years focused specifically on healthcare revenue cycle
- Deep familiarity with RCM concepts: CPT/ICD coding, ERA/EOB processing, denial management, payer contracting basics, and A/R metrics
- Strong SQL skills. We're on Snowflake, and you should be comfortable writing complex queries from scratch, not just tweaking someone else's
- Power BI proficiency including data modeling, DAX, Power Query, and building reports that finance and billing teams can actually work with
- Ability to work with messy, high-volume billing data and still produce clean, trustworthy outputs
- Strong communication skills. You can explain what the data says, what it doesn't say, and what to do about it
- Comfortable presenting findings to finance, operations, and executive leadership
- Familiarity with practice management or billing platforms such as Athena or Modernizing Medicine (ModMed)
- High attention to detail and a low tolerance for numbers that don't add up
- Healthcare experience required; orthopedic or surgical specialty experience is a strong plus
- Bachelor's degree in a quantitative, finance, or healthcare-related field
- Experience with dbt for managing data transformations in Snowflake preferred
- Python or R for automation and statistical analysis preferred
- Familiarity with Excel at an advanced level including pivot tables, Power Query, and complex formulas
- Exposure to multi-site or physician group RCM environments
Benefits
- Excellent growth and advancement opportunities
- Dynamic environment
- Access to a diverse network of practitioners
- Broad infrastructure of tools and programs to enhance the employee experience
- Competitive Compensation
- Generous PTO
- Benefits package: health, dental, vision, 401(k), etc.
Related Guides
Related Categories
Related Job Pages
More Data Analyst Jobs
Payer Contracting Data Analyst
Scripps HealthHeadquartered in San Diego, California, Scripps Health has provided quality healthcare to the community of La Jolla, California, for more than 80 years. A priva
Role Description This is a full time, benefited, salaried role. This position is work-from-home. Join the Scripps Health team and work alongside passionate caregivers and provide patient-centered healthcare. Receive endless appreciation while you build a rewarding career with one of the most respected healthcare organizations nationwide. Why join this team? - The Payer Relations team plays a critical role in advancing Scripps Health’s financial strategy and long-term growth. - We are looking for a Data Analyst to support our vision to transform payer relationships from transactional to strategic by leveraging data and analytics to predict, model and secure optimal reimbursement terms while achieving sustainable net revenue growth and margin targets. Responsibilities include: - Responsible for transforming complex payer data into actionable insights that drive smarter contract decisions. - Analyze complex data sets, proactively explore insights, and clearly communicate findings to both clinical and operational stakeholders. - Lead cross functional efforts across finance, strategy, and health system performance, to effectively negotiate, monitor, and optimize payer relationships. - Provide the analytical foundation for strategic growth, lead reimbursement modeling, trend analysis, financial proposal development, contract term optimization, risk assessment, and payer performance audits. - Direct business analysis for new and renewing payer contract negotiations, maintain payer contract portfolio reporting, and serve as a key partner to revenue cycle and other internal teams. Qualifications - Bachelor's degree in business, math or health administration. - 3 years broad-base healthcare experience with knowledge of healthcare products and services knowledge. - Expert knowledge of Microsoft Excel, SQL and data manipulation. - Excellent communication skills and exceptional relationship-building skills. - Strong SQL and data manipulation skills, detail-oriented with strong analytical abilities. - Ability to work both independently and as part of a team. - Strategic and critical thinking skills. - Strong problem-solving skills and the ability to adapt. Requirements - Master's degree in business, health administration, math or statistics preferred. - Knowledge and understanding of EPIC, Business Intelligence reporting technologies, and data mart technologies and principles. - Strong understanding of healthcare payer systems, reimbursement models, and insurance policies. - Knowledge of CPT, HCPCS, ICD-10, facility revenue codes and healthcare claims data; experience with billing/payment systems. - Experience maintaining expected reimbursement in contract management systems (e.g., EPIC). - Ability to analyze data and make data-driven decisions. - Knowledge of healthcare regulations and compliance standards. - Proficiency in Strata Axiom contract management software and Epic EHR, including Cogito - Slicer Dicer.
Data Scientist – Predictive Analytics, ML
Enable DataA leading provider of advanced data, application, and cloud engineering services.
• Lead and mentor a team of data scientists and analysts; provide technical guidance and ensure high-quality deliverables. • Design, develop, and optimize machine learning models (classification, regression, clustering, forecasting, etc.). • Build and maintain big data processing pipelines using PySpark, Spark SQL, and distributed computing environments. • Architect and deploy scalable ML solutions on Azure (Azure Databricks, Azure ML, ADLS, ADF). • Oversee feature engineering, model lifecycle management, monitoring, and performance tuning. • Collaborate with cross-functional teams to translate business needs into analytical solutions. • Present insights, model outputs, and recommendations to technical and business stakeholders.
• Lead the development and implementation of Sumer’s firmwide audit data, and innovation strategy. • Identify how standardised audit data can be leveraged to improve audit quality, insight and operational performance. • Support integrated, automated monitoring of KPIs through the design of the integration of existing dashboards and reporting solutions (e.g. audit quality indicators and adoption metrics) to monitor adoption. • Work with the wider audit quality team to ensure training relevant to automation meets the evolving needs of our auditors. • Identify and develop tools and solutions that deliver real value, maintaining and prioritising a back-log in a way that maximises benefits. • Drive continuous improvement through automation, helping teams reduce manual effort, increase consistency and focus on areas of professional judgement. • Lead pilots and rollout of AI and automation solutions, including low-code tools and workflow automation platforms. • Help drive a culture of innovation within Sumer, delivering initiatives that bring our auditors on the transformation journey. • Work closely with IT and audit teams to design and implement integrations across audit systems and tooling that support automation. • Build and harness API-driven solutions to improve data extraction, transformation and analysis. • Set up and test new data connections and workflows, taking innovative solutions through review and implementation. • Support the development of governance frameworks for AI and automation within audit, ensuring alignment with policy, regulation and best practice. • Exercise judgement to ensure solutions put in place manage risk and traceability depending on the output. • Translate innovation concepts into scalable solutions embedded into day-to-day audit workflows. • Engage and influence stakeholders across audit, IT and leadership to drive adoption and successful delivery. • Continuously assess emerging technologies and identify opportunities to enhance audit quality and efficiency.
Senior Analyst, Integrated Media Analytics
AcadiaAcadia Healthcare is a leading provider of behavioral healthcare services across the United States, operating a growing network of 250 plus behavioral healthcare facilities with approximately 11,100 beds in 39 states and Puerto Rico. With more than 23,000 employees serving approximately 75,000 patients daily, Acadia is the largest stand-alone behavioral health company in the U.S. Acadia Healthcare’s purpose is to Lead Care with Light and our mission is to be a world-class organization that sets the standard for excellence in the treatment of mental health and addiction concerns.
• Lead the development of integrated reporting and analytics across paid search, paid social, programmatic, GA4, SEO, and retail media platforms. • Build advanced dashboards and provide data-driven recommendations to optimize media investment and strategy. • Analyze complex datasets to identify media performance trends and optimization opportunities. • Support media planning by providing actionable insights and collaborating with internal teams and external agency partners. • Present findings and recommendations to senior leadership and cross-functional teams. • Ensure data accuracy, process efficiency, and scalability across analytics initiatives. • Stay current on industry trends in media analytics, business intelligence, and emerging media platforms.




