Financial Analyst II Analytics

Southern California residency required

This position will be responsible for supporting the needs of the department by performing various financial or data analyses, preparing standard and/or ad hoc healthcare financial utilization reports (such as Rate Development Template reports, Prop56 & GEMT analysis, supplemental payment reconciliation, revenue reconciliation, GL mapping of healthcare costs, and pharmacy reports, etc.). In addition, this position will also provide other support for departmental projects such as budget analysis and researching financial healthcare utilization trends and variances. This position requires strong accounting knowledge, working knowledge of extracting data from SQL databases by running and writing queries, and experience with extracting data from large ERP accounting systems. The candidate must have excellent communication skills, proven problem-solving skills, and ability to multi-task.

Minimum of three (3) years of financial or data analysis in a healthcare setting.

Bachelor’s degree in Finance, Business Administration, Accounting, or a related field from an accredited institution required.

Possession of an active, unrestricted, and unencumbered Certified Public Accountant (CPA) License issued by the California Board of Accountancy preferred.

Principles and practices of health care industry and strategies, health care systems, capitated risk contracting, provider network structures and risk sharing arrangements a plus. Strong knowledge and experience utilizing Microsoft Excel, Access, Word, and PowerPoint. Moderate skill level in SQL and Access (or equivalent database) data manipulation. Skilled in thoroughly document database queries, macros, etc. as defined by policy. Must have excellent communication and writing skills. Quickly gain an understanding of data requests (scope and purpose) and to produce accurate and useful reports. Communicate effectively, both verbally and in writing, in order to develop and maintain effective working relationships with all levels of staff and management. Work cooperatively and effectively on group projects. Cross-train and back up other areas of the department.