Healthcare Financial Analyst (SQL, Crystal, Tableau, Oracle)
Job Description BASIC FUNCTIONS This position provides financial analyses, management consulting, analytical decision support services and technical expertise for a broad array of financial and operational projects and initiatives for the Mid-Atlantic Permanente Medical Group (MAPMG). The incumbent designs and builds sophisticated financial models based on diverse data sets in order to inform strategic decision making and the evaluation of alternative options. The incumbent is responsible for technically complex, multi-faceted data consolidation and analyses across multiple information systems and functional areas, assists in developing performance monitoring reports and process, interprets and presents reports and analyses to senior leadership, and participates in the planning and development of regional, departmental targets and strategic plans. RESPONSIBILITIES Undertake financial analyses independently. Develops feasibility studies and business plans to support new lines of services. Participate in the strategic planning process. Develop business cases in line with strategic vision of the organization. Conduct ongoing user education and provide management consulting services on the use and interpretation of analyses, reports, methodologies and source data to managers/leaders. Deliver formal presentations of analytic findings and recommendations to senior managers and leadership. Extract data from multiple systems using tools such as SQL, SAS, MS Access and Crystal Reports. Compile and generate reports from KPHC, Clarity, and workforce management data systems. Compile and distribute financial data provided by regional operations and finance staff. Participate in the planning and development of regional services budgets. Participate in lead projects of moderate to complex scope as assigned. May develop spreadsheet and database analyses for presentation and analysis of financial reports. Monitor compliance with policies and procedures related to financial management and budget systems and related automated systems. Travel within the service area and region as required. Support compliance and the Principles of Responsibility (Kaiser Permanente's code of conduct) by maintaining confidentiality, protecting the assets of the organization, acting with ethics and integrity, reporting non-compliance, and adhering to applicable Federal and State laws and regulations, accreditation and licensure requirements, and Kaiser Permanente policies and procedures. QUALIFICATIONS Bachelor's degree in a finance, accounting, or related field, Master's Degree preferred. Three plus years related experience in financial analysis and budgeting. Experience with developing financial models. Proficient in data retrieval and manipulation from various applications including MS Excel, Access, VBA, SQL, SAS and KP Health Connect. Able to formulate operational study designs and prepare and conduct professional presentations. Advanced proficiency in PC based spreadsheet applications, including advanced functions such as graphics, pivot tables, macros and database management. Demonstrated experience in translating business user needs into accurate management reports. Experience working with departments to develop resource needs within the operational plan and budgeting framework. Strong verbal, written and presentation communication skills. Strong facilitation skills. Works under limited guidance; accountable to complete work assignments. Travel to the various medical office buildings may be required. Company Description SETTING STANDARDS FROM THE START In 1948, seven physicians got together to create a new kind of medical group, one that focused on collaboration, put the patient at its core and provided a truly integrated health care delivery system. The result was a practice and approach that grew to become a gold standard in healthcare. More than 30 years later and over 1,200 physicians strong, MAPMG and its integrated health care delivery model continue to forge new territory in medicine. As the quality leader in our industry, we help over 600,000 members throughout DC, MD, and VA live healthier, happier lives. And we do the same for our physicians. BALANCED LIVING IN PRACTICE As part of our team, you enjoy comprehensive administrative support, cross-specialty collaboration, easy access to resources and more. You also enjoy a balanced schedule, so you can make the most of your time here and at home. Most importantly, you will have the professional autonomy you need to do what you do best: provide truly exceptional care for your patients. OUR FACILITIES, PROGRAMS & AFFILIATIONS MAPMG boasts 30 medical office buildings throughout DC/Suburban Maryland, Baltimore, and Northern Virginia, and affiliations with several top hospitals in the region including Greater Baltimore Medical Center and Holy Cross Hospital.