Business Intelligence (BI) Analyst

As a Business Intelligence (BI) Analyst, your role will involve transforming raw healthcare and financial data into actionable insights. You will develop interactive dashboards and reports to empower operational leaders, client services teams, and executive decision-makers in monitoring revenue cycle performance, identifying gaps, and taking corrective actions. Your contribution will be crucial in integrating business logic, visual storytelling, and data-driven strategies into RCM Solutions. **Key Responsibilities:** - Conduct variance analysis between expected vs. actual collections at the CPT, provider, or facility level. - Perform root cause analysis on recurring AR issues and collaborate with the Engineering team to address inefficiencies. - Provide comparative benchmarking analysis across clients, facilities, or billing teams to identify high and low performers. - Analyze operational data to uncover gaps in performance and revenue leakage. - Build and automate monthly and quarterly performance reports for internal review and client delivery. - Support the creation of early warning systems using thresholds and alerts to flag potential revenue risks. - Build optimized data models and star schemas for efficient querying and reporting. - Ensure data integrity, accuracy, and consistency across all reports and dashboards. - Design and maintain semantic layers and calculated measures to standardize KPIs. - Work with data engineering and ETL teams to define data transformation logic and join relationships. - Conduct audits and validations to ensure report outputs match source system data. - Create data dictionaries and metadata documentation to support self-service BI and reporting adoption. - Create client-specific dashboards aligned with contractual SLAs, performance KPIs, and custom reporting formats. - Participate in client calls, review meetings, or QBRs to explain BI findings and gather feedback. - Tailor reports to meet the operational and financial goals of each client based on their specialty. - Support onboarding of new clients by designing initial reporting templates based on contractual agreements. - Collaborate with client-facing teams to identify and implement report automation based on client preferences. - Partner with Data Analysts to integrate deeper insights into business dashboards. - Work closely with Client Services Managers to understand client expectations and customize reporting. - Collaborate with the technology team to align data infrastructure and build Technology for RCM. - Design, develop, and maintain interactive dashboards and reports using BI tools. - Visualize trends across critical RCM KPIs and develop dynamic dashboards. - Incorporate visual indicators and alerts to help users interpret performance issues. - Ensure dashboards are responsive and optimized for various screen sizes and devices. - Perform updates and enhancements to dashboards based on evolving client requirements. **Additional Details:** - Ensure accuracy, consistency, and security of healthcare data in compliance with HIPAA and company standards. - Participate in ETL/data validation and cleansing tasks as required.,