Lead Financial Analyst Healthcare / Job Req 688178307

PRINCIPAL RESPONSIBILITIES:

Under the supervision of the Senior Manager, Financial Planning and Analysis (FP&A) - Healthcare, the Lead Financial Analyst, Healthcare Finance is responsible to support the Finance Department in the areas of special projects, financial analysis and reporting as well as review work completed by other analysts. The position requires a high-level of understanding of medical financial data and health plan operations, excellent written and communication skills and project plan development and execution.

Principal responsibilities include:

• Lead the FP&A team in activities related to special financial projects and new programs.
• Responsible for analysis related to the Medicare Product line.
• Lead team efforts in understanding the financial impact of the Long-Term Care and Major Organ Transplants programs.
• Responsible for regulatory reporting.
• Develop processes for new programs and integrate them with existing processes. Improve current processes, increasing efficiency.
• Conduct financial and operational analyses involving a wide range of activities, including but not limited to data extraction, the generation of reports and analyses, and verifying data quality from data sources.This job requires substantial and complex use of the company's information systems.
• Use data to analyze and evaluate financial performance, identify and communicate findings to support decision making.
• Write and execute SQL queries for the purposes of Medical Expense Reporting, Department of Health Care Services and Department of Manage Health Care data requests, as well as other reporting and analysis functions.
• Work within a complex network of data sources and tools, thinking strategically about optimal methods for structuring and presenting data to end users.
• Review analyses for accuracy and consistency including journal entries prior to submission to the Accounting Department.
• Explain actual versus budget variances including changes in estimated incurred projections.
• Model contracts for hospitals, delegated providers, medical groups, and individual providers.
• Support the development of the annual budget and quarterly forecasts.
• Prepare external financial filings and reporting requests.
• Request, review and submit the data provided for external and internal audit requests.
• Understand and apply project management techniques.
• Develop assumptions and model various financial scenarios.
• Document data processes and engage in department's cross-training efforts to improve FP&A team flexibility and knowledge.
• Perform other duties as assigned by the Sr. Manager, Planning and Analysis - Healthcare, FP&A Management, and Executives.

ESSENTIAL FUNCTIONS OF THE JOB

• Consult with finance team and other Alliance employees.
• Provide accurate monthly analysis, reporting, decision, and review support.
• Extract, mine, and gather data from multiple sources.
• Develop and maintain MS SQL tables and MS Excel data analyses and reports.
• Process data through various financial and budgeting models.
• Communicate effectively and efficiently internally and externally.
• Comply with the organization's Code of Conduct, all regulatory and contractual requirements, organizational policies, procedures, and internal controls.

PHYSICAL REQUIREMENTS

• Constant and close visual work at desk or computer.
• Constant sitting and working at desk.
• Constant data entry using keyboard and/or mouse.
• Frequent use of telephone headset.
• Constant verbal and written communication with staff and other business associates by telephone, correspondence, or in person.
• Frequent lifting of folders and other objects weighing between 0 and 30 lbs.
• Frequent walking and standing.

Number of Employees Supervised: 0

MINIMUM QUALIFICATIONS:

EDUCATION OR TRAINING EQUIVALENT TO:

• B.S. in Business Administration, Healthcare Finance, Information Technology or related field or equivalent professional experience.

MINIMUM YEARS OF ADDITIONAL RELATED EXPERIENCE:

• Three years' experience analyzing complex data and creating management information for financial reporting and decision support.
• Three years' experience analyzing healthcare expense in an insurance or health plan setting.
• Previous experience in the health industry required; experience in managed care is preferred.

SPECIAL QUALIFICATIONS (SKILLS, ABILITIES, LICENSE):

• Strong analytic, problem solving and critical thinking skills.
• Ability to manage projects effectively and efficiently.
• Proficient understanding of healthcare and/or insurance preferred experience in government programs.
• Ability to work independently.
• Strong knowledge of MS Excel and SQL.
• Well organized and detail oriented
• Experience planning and managing projects.
• Excellent written, verbal and interpersonal communication skills and have the ability to successfully relate to people at all levels.
• Experience making presentations before groups of management and staff.
• Plan and complete tasks to a high standard on time.
• Ability to effectively manage competing priorities and daily ambiguity is essential.

SALARY RANGE $121,730.28-$185,595.42 Annually

The Alliance is an equal opportunity employer and makes employment decisions on the basis of qualifications and merit. We strive to have the best qualified person in every job. Our policy prohibits unlawful discrimination based on race, color, creed, gender, religion, veteran status, marital status, registered domestic partner status, age, national origin or ancestry, physical or mental disability, medical condition, genetic characteristic, sexual orientation, gender identity or expression, or any other consideration made unlawful by federal, state, or local laws. M/F/Vets/Disabled.