Financial Analyst II - Finance Analytics - Inland Empire Health Plan : Job Details

What you can expect!Find joy in serving others with IEHP! We welcome you to join us in healing and inspiring the human spirit and to pivot from a job opportunity to an authentic experience!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, in addition to collaborating with inter-departments to ensure member needs are met while simultaneously building strong peer relationships.Key Responsibilities1. Assist in the preparation and completion of the Rate Development Template (RDT) reports.2. Create standard and ad-hoc healthcare utilization reports to support the Contracting Department and Leadership for strategic decision-making purposes.3. Prepare, analyze, and reconcile financial healthcare data from organization's operations.4. Use SQL Server tables to develop analytical reports, including conducting analysis, summarizing and interpretation of results.5. Act as primary liaison with Information Technology and Healthcare Informatics departments to define and translate requirements into technical applications.6. Perform quality assurance and peer review on financial data analysis reports and other output.Commitment to Quality: The IEHP Team is committed to incorporate IEHP's Quality Program goals including, but not limited to, HEDIS, CAHPS, and NCQA Accreditation.PerksIEHP is not only committed to healing and inspiring the human spirit of our Members; we also aim to match our Team Members with the same energy by providing prime benefits and more.CalPERS retirementRemote work. California Residency Required457(b) option with a contribution matchGenerous paid time off- vacation, holidays, sickState of the art fitness center on-siteMedical Insurance with Dental and VisionPaid life insurance for employees with additional optionsShort-term, and long-term disability optionsPet care insuranceFlexible Spending Account - Health Care/ChildcareWellness programs that promote a healthy work-life balanceCareer advancement opportunities and professional developmentCompetitive salary with annual merit increaseTeam bonus opportunitiesEducation & ExperienceMinimum of three (3) years of financial or data analysis in a healthcare settingBachelor's degree in Finance, Business Administration, Accounting, or a related field from an accredited institution requiredKey QualificationsModerate skill level in SQL and Access (or equivalent database) data manipulationStrong knowledge and experience utilizing Microsoft Excel, Access, Word, and PowerPoint. Skilled in thoroughly documenting database queries, macros, etc. as defined by policyCross-train and back up other areas of the departmentStart your journey towards a thriving future with IEHP and apply TODAY!