Business Analyst II

About the role

The role is located in Nashville, TN. This is an exciting opportunity to join HCA Healthcare, a leading provider of healthcare services.

Responsibilities

• Synthesizes financial and other data from multiple applications and data sources in response to ad hoc requests by department/hospital/division/enterprise leaders
• Manages a suite of recurring reports (daily/weekly/monthly/etc.) and reporting tools (i.e. dashboards) to ensure stakeholders have robust, timely, and accurate data to drive strategic decision making and monitor departmental performance
• Systematically/independently identifies critical trends and communicates them proactively to leadership, developing additional reports/tools to support further analysis as needed
• Maintains a working knowledge of departmental/division/enterprise/industry strategic priorities to inform and focus their analysis
• Serves as the primary liaison between other analytics departments to ensure accurate use of Patient Logistics Center data and develop cross-departmental reporting tools as appropriate
• Edicates/trains stakeholders on all reports, data tools and business intelligence resources as needed
• Pairs with department leaders to analyze productivity and performance data for key trends and opportunity areas
• Works closely with corporate team to ensure all departmental reporting and analysis meets enterprise standards
• Creates and maintains a suite of reports to monitor staff compliance with process and data standards
• Provides ongoing education and training to Patient Logistics Center staff on documentation standards
• Serves as the primary admin for departmental workflow/documentation applications as it related to reporting function (e.g. manages access, troubleshooting, settings, and data dictionaries)
• Participates actively in the Patient Logistics Center Analyst community by sharing best practices with their peers and providing cross coverage/mentoring new team members when requested

Requirements

• Bachelor’s degree in information management, Healthcare Information, Computing, Accounting, Mathematics, Statistics, or related field required
• Minimum 2 or more years of experience in data & reporting or analytics centric position; 2+ years of analytics experience in Patient Logistics Center or related setting preferred
• Demonstrated ability to use a combination of applications and tools to complete analysis, including but not limited to database tools (SQL, Teradata), data visualization tools (PowerBI, Qlikview, Tableau), and Office applications
• Excellent analytical and data management skills, with experience combining related data from different types of databases/systems (including SQL queries, application data exports and Excel) into a single report/analysis effort
• Advanced skill with Microsoft Office applications including Excel, PowerPoint, and Word
• Expert skill in Microsoft Excel with significant extensive experience using complex formulas, pivot tables, charts, macros/VBA, data connections/queries
• Interest in/working knowledge of healthcare services’ volumes, financial metrics, utilization, and market demographics
• Strong understanding of Patient Logistics Center terminology
• Strong interpersonal skills with proven ability to effectively work with others, experience leading or participating in cross functional/departmental analysis efforts
• Excelling time management skills, extensive experience working independently to manage an analysis portfolio of both recurring and ad-hoc reporting across diverse recipients
• Proven ability to manage competing deadlines and priorities with professionalism, extensive experience in managing customer expectations and balancing requests from diverse stakeholders
• Clear customer-service orientation, experience working directly with executive level stakeholders to provide timelines, clarify analysis objectives, and follow up to ensure all needs were met

Benefits

HCA Healthcare offers a comprehensive benefits package that includes:

• Comprehensive benefits for medical, prescription drug, dental, vision, behavioral health and telemedicine services
• Wellbeing support, including free counseling and referral services
• Time away from work programs for paid time off, paid family leave, long- and short-term disability coverage and leaves of absence
• Savings and retirement resources, including a 401(k) Plan with a 100% match on 3% to 9% of pay (based on years of service), Employee Stock Purchase Plan, flexible spending accounts, preferred banking partnerships, retirement readiness tools, rollover support and financial wellbeing counseling
• Education support through tuition assistance, student loan assistance, certification support, dependent scholarships and a partnership with Galen College of Nursing