We are seeking a Senior Associate - Data Analytics with expertise in Revenue Cycle Management (RCM) within the US Healthcare industry. This role requires strong analytical, technical, and leadership skills to drive data-driven decision-making in areas like denials management, collections, write-offs, A/R (Accounts Receivable), and reimbursement trends. The ideal candidate will be proficient in SQL, Power BI/Tableau/QuickSight, ELT processes, and cloud-based data solutions while also possessing team management, mentoring, and stakeholder engagement skills.
Key Responsibilities
- Analyze denial patterns, payer behavior, reimbursement trends, and collection efficiency to improve financial performance.
- Provide root cause analysis for denials, underpayments, and delays in claims processing.
- Develop dashboards and reports in Power BI, QuickSight focused on denials, collections, A/R aging, write-offs, bad debt, payment posting, and reimbursement rates.
- Identify opportunities to streamline RCM workflows through process automation and predictive analytics.
- Translate business needs into technical requirements, ensuring smooth execution of analytics solutions.
- Understand and analyze business metrics, extract relevant data, and create insightful visualizations in Power BI, Tableau, or QuickSight.
- Convert and enhance existing Excel dashboards into Power BI, Tableau, or QuickSight, ensuring accuracy, efficiency, and improved user experience.
- Work with large, complex datasets from multiple sources (AWS Redshift, Oracle, S3, SageMaker, Excel) to extract actionable insights.
- Develop and optimize SQL queries, stored procedures, and data pipelines to improve data processing.
- Identify, analyze, and correct data anomalies by reviewing reports, extracts, and performance indicators.
- Collaborate with business stakeholders to gather and understand dashboard and reporting requirements.
- Provide recommendations for the design and implementation of data collection systems, analytics solutions, and strategic initiatives to enhance efficiency, improve quality, and align with business objectives.
- Identify opportunities for process improvements by analyzing existing workflows, recognizing Excel/manual reports suitable for automation, and implementing automated solutions.
- Prioritize business needs, translating them into data-driven insights and reports.
- Provide recommendations for optimizing reporting processes and enhancing data visualization techniques.
- Responsible for regularly publishing scheduled reports and handling ad hoc reporting requests from business leaders.
Required Qualifications and Skills
- 8+ years of experience in data analytics, RCM reporting, and business intelligence, with at least 2 years in a leadership role.
- Strong domain expertise in RCM (US Healthcare) with hands-on experience in denials management, collections, A/R aging, write-offs, payment posting, and payer performance analytics.
- Advanced proficiency in SQL and database management.
- Expertise in Power BI, Tableau, or QuickSight for dashboard development and visualization.
- Strong understanding of cloud-based data solutions such as AWS Redshift, Snowflake, and SageMaker.
- Experience in ETL/ELT processes, optimizing data ingestion and transformation workflows.
- Proven ability to lead and mentor a team of data analysts.
- Strong communication skills with experience in stakeholder engagement and cross-functional collaboration.
- Experience in Python or R for advanced analytics is a plus.
