Senior Financial Analyst SQL and Power BI

HCA Healthcare•Reston, VA

1d•Remote

About The Position

The Senior Financial Analyst is responsible for providing operational and financial analysis to SSC operational unit leaders and senior leadership. The Senior Financial Analyst generates and delivers variance analysis, reports key financial statistics and assists business unit leaders in managing information effectively to optimize departmental efficiency and performance. In this role you will: Works closely with operations departments to assess and report performance. Coordinates scheduled and ad hoc data and analysis requests across SSC operational units Develop, test and deliver scheduled and adhoc reports Assists in the development of financial data collection and measurement tools within the SSC. Proactively review and provide data analysis and financial impact assessments to support SSC operations Prepares and analyzes monthly MORs. Prepares uncompensated care projections and variance analysis for accounts receivable and net revenue performance. Monitor defined reports and work with applicable departments to ensure AR is properly stated at month end. Creates and supports exception‐based report generation for all departments. Assist in translating business reporting requirements to development staff. Assist Manager in managing information effectively to improve departmental efficiency and performance. Understands revenue cycle operations and technologies currently in place.

Requirements

Experience of research techniques sufficient to collect and interpret data.
Experience with descriptive statistics to analyze statistical data and prepare projections.
Experienced with interpreting and analyzing data, examining documents and quantitative metrics for correctness and accuracy.
Professional experience applying business intelligence strategies to convert business cases into solutions.
Bachelor's degree with focus in Accounting, Finance, Economics or another Business‐related field, required.
3‐4 years progressive accounting/finance experience required, preferably in healthcare revenue cycle preferred.
Advanced SQL and/or Business Objects query writing experience required.
Experience creating Power BI dashboards
Experience troubleshooting and diagnosis of SQL Server and Database.

Responsibilities

Works closely with operations departments to assess and report performance.
Coordinates scheduled and ad hoc data and analysis requests across SSC operational units
Develop, test and deliver scheduled and adhoc reports
Assists in the development of financial data collection and measurement tools within the SSC.
Proactively review and provide data analysis and financial impact assessments to support SSC operations
Prepares and analyzes monthly MORs.
Prepares uncompensated care projections and variance analysis for accounts receivable and net revenue performance.
Monitor defined reports and work with applicable departments to ensure AR is properly stated at month end.
Creates and supports exception‐based report generation for all departments.
Assist in translating business reporting requirements to development staff.
Assist Manager in managing information effectively to improve departmental efficiency and performance.
Understands revenue cycle operations and technologies currently in place.

Benefits

Comprehensive medical coverage that covers many common services at no cost or for a low copay. Plans include prescription drug and behavioral health coverage as well as free telemedicine services and free AirMed medical transportation.
Additional options for dental and vision benefits, life and disability coverage, flexible spending accounts, supplemental health protection plans (accident, critical illness, hospital indemnity), auto and home insurance, identity theft protection, legal counseling, long-term care coverage, moving assistance, pet insurance and more.
Free counseling services and resources for emotional, physical and financial wellbeing
401(k) Plan with a 100% match on 3% to 9% of pay (based on years of service)
Employee Stock Purchase Plan with 10% off HCA Healthcare stock
Family support through fertility and family building benefits with Progyny and adoption assistance.
Referral services for child, elder and pet care, home and auto repair, event planning and more
Consumer discounts through Abenity and Consumer Discounts
Retirement readiness, rollover assistance services and preferred banking partnerships
Education assistance (tuition, student loan, certification support, dependent scholarships)
Colleague recognition program
Time Away From Work Program (paid time off, paid family leave, long- and short-term disability coverage and leaves of absence)
Employee Health Assistance Fund that offers free employee-only coverage to full-time and part-time colleagues based on income.