SQL Data Analyst – Revenue Cycle

Behavioral Health Group - BHG; Dallas (TX); On-site; USD 85,000 - 95,000; Full time

Benefits offered by this job

Generous paid time off

Flexible schedules

No nights and no Sundays

Tuition reimbursement

401K plan with discretionary match

Health, vision and dental insurance

Employee discounts

Employee Assistance Program (EAP)

Job summary

Behavioral Health Group - BHG is seeking a SQL Data Analyst – Revenue Cycle to liaison with Finance and Revenue Cycle teams, ensuring revenue capture and reporting align with objectives. You will work with large datasets and complex rules to identify gaps and propose improvements in revenue recognition and data governance.

The role emphasizes BI reporting using Power BI, dashboards for executives, and collaboration across departments.

Qualifications

• Bachelor's degree preferred in business, mathematics, information/data sciences, or another analytical discipline.
• 1-3 years of experience, with emphasis in analytics, healthcare RCM experience preferred.
• Knowledge of integrated software packages, SQL, Power BI, and EHR system or similar software.
• Understanding of revenue cycle management processes.

Responsibilities

• Maintain current revenue reporting ensuring data accuracy back to underlying output sources.
• Develop and enhance dashboards per ad hoc requests by executive teams.
• Perform ongoing analysis to determine the root cause of issues in revenue capture and provides recommendations for workflow or systemic changes.
• Maintains the privacy and security of all confidential and protected health information, complying with all applicable regulations (Ex: HIPAA).
• Supports the Finance/Revenue Cycle Team as needed for special projects.
• Develop and design the necessary schedules/outputs/reports in Power BI to produce meaningful monthly business information for Executive Management and Field Operations’ review.
• Utilizes data from multiple sources to bring value and insightful information to the executive team to achieve growth/revenue targets.
• Proactively seek opportunities to improve processes and identify areas of improvement in revenue recognition/capture.

Skills

RCM experience

SQL

Power BI

EHR systems

Education

Bachelor's degree preferred in business, mathematics, information/data sciences, or analytical discipline

Tools

Power BI

SQL

EHR systems

Job description

Compensation: $85,000 - $95,000/Annually + bonus structure

Required: RCM & SQL Experience

Job Summary

Under general supervision, the SQL Data Analyst – Revenue Cycle will act as a liaison to the Finance and Revenue Cycle teams to ensure revenue capture activities and reporting are consistent with approved objectives for revenue generation and process improvement. The Analyst will be working with large data sets and complex business rules to provide insights on gaps, opportunities for improvement, and recommend solutions related to the collection and recognition of revenue for the Company.

Revenue Analysis

• Maintain current revenue reporting ensuring data accuracy back to underlying output sources.
• Develop and enhance dashboards per ad hoc requests by executive teams.
• Perform ongoing analysis to determine the root cause of issues in revenue capture and provides recommendations for workflow or systemic changes.
• Maintains the privacy and security of all confidential and protected health information, complying with all applicable regulations (Ex: HIPAA).
• Supports the Finance/Revenue Cycle Team as needed for special projects.

Business Intelligence and Reporting

• Develop and design the necessary schedules/outputs/reports in Power BI to produce meaningful monthly business information for Executive Management and Field Operations’ review.
• Utilizes data from multiple sources to bring value and insightful information to the executive team to achieve growth/revenue targets.
• Proactively seek opportunities to improve processes and identify areas of improvement in revenue recognition/capture.

Minimum Qualifications

• Bachelor's degree preferred; degree in business, mathematics, information/data sciences, or another analytical discipline.
• 1-3 years of experience, with emphasis in analytics, with healthcare RCM experience preferred.
• Knowledge of integrated software packages, SQL, Power BI, and EHR system or similar software.
• Understanding of revenue cycle management processes.
• Exceptional interpersonal skills, as well as, persuasive written and oral communication.
• Enhanced problem-solving skills.

Physical Requirements And Working Conditions

• Prolonged sitting, some bending, stooping and stretching
• Manual dexterity sufficient to operate standard office equipment
• Variable workload, periodic high stress and activity level
• Willing and able to work unpredictable and sometimes late hours and perform a diverse array of tasks to meet business needs
• Standard office conditions and environments and medical office environments

Why Join BHG?

• Work-Life Balance: Enjoy generous paid time off, holidays, and personal needs. Benefit from flexible schedules with early in/early out hours, no nights, and no Sundays.
• Investment in Your Growth: Prioritize your development with role-based training and advancement opportunities.
• Comprehensive Benefits: Choose from three benefits programs, including health, life, vision, and dental insurance. Enjoy tuition reimbursement and 401K plan with discretionary match.
• Recognition and Rewards: Experience competitive pay, quarterly bonuses, and incentives for certifications or licenses.
• Employee Perks: Access exclusive discounts on various services and entertainment options, and benefit from our Employee Assistance Program and self-care series.

At BHG, we thrive on the greatness of our people. Join us and become part of a community that values excellence, integrity, and making a real difference in the lives of others.

BHG is an equal opportunity, affirmative action employer providing equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, national origin, protected veteran status, disability status, or any other legally protected basis, in accordance with applicable law.