Senior Business Analyst - Healthcare Revenue Cycle - Remote - San Diego, CA

Waterfall Technology Consulting Partners is seeking a Senior System Business Analyst with strong experience in hospital Revenue Cycle operations. This role will serve as a key bridge between business stakeholders and technical teams, driving process improvements, system enhancements, and advanced analytics across revenue cycle functions.

Responsibilities:

• Partner with Revenue Cycle stakeholders to gather, analyze, and document business and technical requirements
• Evaluate current-state workflows and identify opportunities for automation, integration, and process improvement
• Design and implement solutions leveraging Microsoft Power Platform and reporting tools
• Develop dashboards, reports, and data models to support operational and leadership decision-making
• Collaborate with IT and development teams to translate business needs into functional and technical solutions
• Create detailed process documentation, functional design documents, and user stories
• Conduct system and workflow analysis to recommend scalable and sustainable improvements
• Support testing, validation, and implementation of new solutions and enhancements

Requirements:

• Strong knowledge of hospital Revenue Cycle operations, including patient access, billing, claims, and collections workflows
• Experience working with healthcare financial data and reporting
• Minimum 3 years' experience building, training, and deploying AI-powered solutions within Microsoft Power Platform, including tools such as AI Builder and Copilot Studio
• Minimum 3 years' experience and expertise in developing complex Desktop and Cloud flows
• Experience utilizing SQL database connectors
• Experience utilizing Machine runtimes
• Experience utilizing Web scraping techniques
• Minimum 3 years of experience developing interactive dashboards and reports
• Experience with Power Query transformations
• Experience with Custom DAX measures
• Experience with Advanced conditional formatting
• Intermediate proficiency in writing SQL queries
• Intermediate proficiency in joining multiple tables
• Intermediate proficiency in filtering and manipulating data to support reporting and automation
• Minimum 3 years' experience in developing and managing Python scripts
• Advanced proficiency in Microsoft Excel, including writing macros (VBA)
• Advanced proficiency in managing complex data models
• 5+ years of experience gathering technical requirements from stakeholders
• 5+ years of experience creating workflow documentation, including process maps, functional design documents, user stories, preparing high-level requirement documentation (HLD) and software requirement specifications (SRS), creating testing plan and script, conducting User Acceptance Testing (UAT)
• 5+ years of experience analyzing operational workflows and recommending integration and automation solutions
• Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group
• Epic SQL 1 and SQL 2 Self-Study