Revenue Analytics Specialist — AR, Denials & Cash Flow

Progyny, Inc; New York (NY); On-site; USD 70,000 - 85,000; Full time

Benefits offered by this job

Family friendly benefits

Health insurance

401(k) plan with company match

Bonus program

Equity

Job summary

Progyny, Inc. seeks a Revenue Analyst to support the Carrier and Member Revenue Operations team. The role focuses on delivering actionable insights across the indirect book of business and driving improvements in denial resolution and cash performance.

You’ll use Excel, SQL and PowerBI to analyze AR/DSO, build dashboards, automate workflows with RPA, and align carrier reporting with internal data. Collaboration with carriers and internal stakeholders is key.

Qualifications

• 3+ years of experience in analytics, revenue operations, healthcare analytics, or similar data-heavy role.
• Strong proficiency in Excel, including complex modeling and data manipulation.
• Working knowledge of SQL for data querying, validation, and transformation.
• Experience building dashboards or visualizations in PowerBI.
• Ability to manage and evolve analytic tools and automation processes (e.g., RPA, macros, workflows).

Responsibilities

• Analyze trends in outstanding AR, denial/adjudication rates, and carrier-specific behaviors.
• Own and maintain monthly AR and DSO reporting models for the broader Finance organization.
• Re-build and maintain end-to-end monitoring for Member AR.
• Develop and refine dashboards and reporting in PowerBI to track denial trends, 90-day adjudication trends, and cash collections outcomes.
• Conduct contextualized tracking of denial balances by carrier, surfacing volume shifts and opportunities.
• Own and manage the relationship with external vendors supporting Member AR.
• Track and analyze member account pending/unlocking trends to inform process improvements.
• Align external carrier reporting with internal adjudication data to identify discrepancies and insights.
• Manage and enhance an RPA tool to detect and group denial categories with high financial impact.
• Collaborate with internal stakeholders and external carrier contacts to design effective denial workflows that drive resolution and improve cash.
• Lead monthly “scorecarding” for the Carrier & Member Revenue Operations team, tracking key performance metrics and process health.
• Support continuous improvement initiatives with data-backed recommendations and process automation.

Skills

Excel proficiency

SQL

PowerBI

AR/DSO modeling

Data analysis

Communication

Tools

SQL

Power BI

Job description

Progyny, Inc. seeks a Revenue Analyst to support the Carrier and Member Revenue Operations team. The role focuses on delivering actionable insights across the indirect book of business and driving improvements in denial resolution and cash performance.

You’ll use Excel, SQL and PowerBI to analyze AR/DSO, build dashboards, automate workflows with RPA, and align carrier reporting with internal data. Collaboration with carriers and internal stakeholders is key.