Weekend Data Analyst Sql Excel Jobs in Ohio (NOW HIRING)

Job Address:

Job Title: Senior Data Analyst

Company: New Vista Behavioral Health (corporate)

Hours:Full Time, M-F

Position Summary:

The Senior Data Analyst plays a critical role in supporting clinical, operational, financial, and revenue cycle performance across New Vista Behavioral Health facilities. This individual partners closely with leadership, facility teams, billing, and accounting to deliver accurate reporting, actionable insights, and data-driven decision support.

The role requires strong independent execution, with a focus on behavioral health metrics including census, length of stay, payer mix, denials, and reimbursement performance. The analyst ensures data integrity across systems and helps drive improvements in patient access, financial outcomes, and operational efficiency.

Key Responsibilities

Reporting & Analytics

• Develop, maintain, and distribute daily, weekly, and monthly reports across facilities (census, admissions, discharges, LOS, payer mix, revenue, and productivity)
• Analyze trends in volume, reimbursement, and operational performance across behavioral health programs
• Reconcile and validate census and patient movement across EHR, billing, and operational systems
• Support mid-month forecasting and assist with month-end close and financial reporting
• Prepare facility-level monthly reporting packages for executive leadership and site operators
• Translate operational and financial needs into data models, dashboards, and reporting solutions

Revenue Cycle & Financial Support

• Track and analyze denials across payers, identifying trends and root causes specific to behavioral health services
• Monitor upfront collections, insurance verification, and authorization performance
• Support payer mix analysis and reimbursement optimization efforts
• Assist accounting with reconciliations, reporting tie-outs, and variance analysis
• Partner with leadership to improve cash flow, reduce denials, and strengthen revenue capture

Operational Support & Collaboration

• Partner with facility leadership (CEOs, Program Directors, and Business Office teams) to identify operational issues and performance gaps
• Serve as a liaison between operations, billing, accounting, and external partners to resolve data discrepancies and reporting issues
• Provide clear, concise insights to both clinical and financial stakeholders to support decision-making
• Support ad hoc analysis tied to growth initiatives, new programs, or facility performance reviews

Data Management & Strategy

• Establish and maintain standardized definitions and reporting structures for behavioral health KPIs (census, LOS, payer mix, denial categories, etc.)
• Support system implementations, integrations, and data migrations (EHR, billing platforms, reporting tools)
• Ensure data integrity and governance across enterprise systems
• Collaborate with internal teams and external vendors to enhance analytics capabilities and reporting automation
• Drive continuous improvement in data quality, accessibility, and reporting efficiency

Qualifications

• Bachelor's degree in business, Finance, Data Analytics, Healthcare Administration, or related field (or equivalent experience)
• 2-5+ years of experience in business intelligence, healthcare analytics, or revenue cycle (behavioral health preferred)
• Strong proficiency in Excel; experience with SQL and BI tools (Power BI, Tableau) preferred
• Knowledge of behavioral health revenue cycle (authorizations, billing, coding, denials, collections)
• Strong analytical, problem-solving, and communication skills
• Ability to work independently in a fast-paced, multi-facility environment

Key Competencies

• High attention to detail and data accuracy
• Strong financial and operational acumen
• Cross-functional collaboration
• Problem-solving and critical thinking
• Ownership and accountability

Work Environment

• Individual contributor role with no direct reports
• High collaboration with facility leadership, billing, accounting, and corporate teams
• Fast-paced, multi-site behavioral health environment requiring adaptability and initiative