Sr SQL Analyst, Revenue Cycle Reporting

Panoramic Health Come Join our team!! The Senior Revenue Cycle Reporting Analyst plays a critical role in optimizing financial performance by leveraging data analysis and reporting to improve revenue cycle efficiency and effectiveness. They work closely with various departments to identify and address issues impacting revenue, ensure compliance with billing regulations, and contribute to data-driven decision-making. Duties and Responsibilities • Analyzes complex revenue cycle data to identify trends, variances, and areas for improvement. • Tracks and monitors key performance indicators (KPIs) such as denial rates, days in accounts receivable (AR), and collection percentages, comparing them against industry benchmarks. • Investigates and analyzes claim denials to determine root causes, develop solutions to reduce future denials, and appeal underpaid claims. • Evaluates and recommends improvements to existing revenue cycle processes, ensuring compliance with regulations and best practices. • Designs, develops, and maintains various reports and dashboards to track performance, identify issues, and provide actionable insights to leadership. • Prepares ad-hoc analysis for claims and KPIs for revenue cycle. • Write customized SQL reports as needed to explore multiple data sources to mine for opportunities to improve revenue cycle. • Works collaboratively with other departments, such as billing, coding, and patient access, to address revenue cycle challenges and implement solutions. • Build strong and trusting relationships with leaders to support problem resolution and ensure overall awareness of medical cost issues and challenges. • Stays informed about healthcare billing regulations and compliance requirements to ensure accurate and compliant billing practices. • Perform other duties and responsibilities as required, assigned, or requested. Education and Experience: • Bachelor’s degree in computer science, accounting, finance, or related field of study or equivalent. • Minimum of five (5) years of data, financial or business analysis experience • Prior experience in revenue management, patient financial services and/or health information systems. • Experience analyzing EMR (Athena) billing data, a plus • Expertise in database queriers; SQL or other reporting languages • Microsoft Office Suite (PowerPoint, Excel, Outlook, Word, Teams) • Strong analytical and research skills. • Excellent understanding of revenue cycle management. • Highly motivated, self-starter. The Company is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations. It is our intent to maintain a work environment which is free of harassment, discrimination, or retaliation because of age, race, color, national origin, ancestry, religion, sex, pregnancy (including childbirth, lactation and related medical conditions), physical or mental disability, genetic information (including testing and characteristics), veteran status, uniformed servicemember status, or any other status protected by federal, state, or local laws. The company is dedicated to the fulfillment of this policy in regard to all aspects of employment, including but not limited to recruiting, hiring, placement, transfer, training, promotion, rates of pay, and other compensation, termination, and all other terms, conditions, and privileges of employment For information about our Privacy Policy, please visit here Apply tot his job