HCA, Hospital Corporation of America Senior Reporting Analyst in Nashville, Tennessee

WHY HCA?

HCA, a Fortune 100 company with more than 200,000 employees, is one of the nation's leading providers of healthcare services, operating over 170 locally managed hospitals and over 100 freestanding surgery centers in 20 states and the United Kingdom. With its founding in 1968, HCA created a new model for hospital care in the United States, using combined resources to strengthen hospitals, deliver patient-focused care and improve the practice of medicine. HCA is a learning healthcare system that uses more than 27 million annual patient encounters to advance science, improve patient care and save lives. HCA has been named one of the world's most ethical companies for eight years in a row.

/At HCA, we are driven by a single goal: the care and improvement of human life./

//

JOB SUMMARY

The Portfolio Senior Reporting Analyst will be responsible for all aspects of portfolio reporting. This includes, but not limited to, creation and maintenance of all custom reporting datasets, interpreting financial and non-financial aspects of the various project portfolio (including SPC) and being the team SME for understanding data integrations and logic between the various departmental reporting and data platforms.

This position is critical in developing, building and conveying the overall portfolio story through relevant, easy to understand reporting. The reporting analyst supports the IT&S organization and reports directly to the Director of Portfolio and Project Financial Management within F&A.

MAJOR RESPONSIBILITIES

Reporting and Power BI Development: • Develop, refine, maintain and produce monthly/quarterly/annual reports and dashboards for both internal (F&A) and external customers (outside F&A) • Create custom reporting datasets to enable monthly, quarterly, annual reporting/planning activities as well as ad-hoc requests based on changing business demands and requirements o This involves working independently, but also working in conjunction with the DART and Planview business/product analyst(s) • Assist in the creation and design of the new Mircosoft PowerBI Datasets/Cubes for the Project Portfolio • Create and design PowerBI Project Portfolio dashboard reports for internal and external customers • Serve as the PowerBI publishing gatekeeper for the Project Portfolio team • Assist in the continued evolution of the monthly Executive Financial MOR and ensure Project Portfolio information is updated appropriately

Project System Coordination: • Perform work as the SME of all Project data for the project team and F&A as a whole o Specifically this involves a significant understanding of project data across these systems:  Planview (PPM Tool)  DART (internally developed SQL Server Reporting Database)  Lawson (GL System) - Activities module specifically  Axiom (Financial Budgeting Tool)  Microsoft PowerBI (Business Intelligence Tool) • Work with the business/product analysts as well as external vendors to coordinate changes to the Planview to DART or Planview to Lawson interfaces or web API based on changing business requirements o Responsible for the data validation of any changes that are executed • Coordinate, validate, and execute the loading of project costing GL actuals into the Planview system from DART • Set and monitor the monthly Project MOR Report list within DART to ensure the appropriate SSRS (SQL Server Reporting Services) reports are produced through the monthly automated process • Work with various business areas to ensure the systemic reporting calendar within DART and Planview aligns to the demands of the Project Governance Schedule as well as the needs/timelines of Project Management.

Analysis and Planning: • Perform historical and current year actuals trend analysis to help execute quarterly projection and annual budget activities. Execute processes in a way that allow for scenario driven estimates that can be changed as underlying assumptions change • Work with various business areas to coordinate and compile necessary data to calculate the annual blended rate for the IT&S budget. Use statistical analysis as part of the rate calculation process. • Assist in the Annual Planning process by gathering relevant measures/results/projections and assist in creating slides for the Executive PowerPoint presentation

Qualified candidates will have at least 5 years of relevant work experience Bachelor's degree required

SPECIAL QUALIFICATIONS • Highly analytical • Ability to handle multiple priorities • Ability to tell a story through data • Flexibility and ingenuity • Team player and works well in community • Outside the box thinker

Job: *Finance Acctg Billing Claims & Revenue

Title: Senior Reporting Analyst

Location: Tennessee-Nashville-Corporate Main Campus

Requisition ID: 10207-24993