120 FINANCE - Sr Financl Analyst HealthCare
Alameda, CA

Job Description

At Alameda Alliance for Health (Alliance) we are striving each day to create a healthier community and to improve the quality of life of our members throughout our diverse County. As a part of our mission, we collaborate with our provider partners to address social determinants of health and to deliver high quality, accessible, and affordable health care services.

Sr Financl Analyst HealthCare

PRINCIPAL RESPONSIBILITIES:

Under supervison from the Manager, Financial Planning & Analysis - Planning, the Senior Financial Analyst, Healthcare is responsible for analyzing financial and operational data and performance by maintaining data integrity and providing advanced financial analysis of healthcare expense using various ad hoc reporting tools.

Principal responsibilities include:

* 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.
* Write and execute SQL queries for the purposes of Medical Expense Reporting, DHCS data requests as well as other reporting and analysis functions.
* Consistent review, problem solving, and communication of financial data systems and reports. This includes identifying and providing solutions related to data intergrity issues. and reconciliation between accounting systems, claim systems, reporting systems and the data warehouse.
* Work with operational departments and Information Technology to create and maintain databases to be used predominantly by the Finance Deparrtment which includes data loading and quality control.
* Participate in data gathering, reporting and analysis for data requests from external regulatory entities.
* Participate in implemention of future phases or upgrades next phase of Claims Processing, Planning tools and Budgeting system.
* Represent Finance department requirements for accounting system interfaces and data warehouse design.
* Communicate with InformationTechnolgy and act as a liaison between user business requirements and technical activities.
* Understand and apply project management and system design techniques.
* Develop assumptions and model various financial scenarios.
* Perform reconciliations, variance analyses and trend analyses.
* Document data flows and logic. Engage in department's cross-training efforts to improve knowledge base of the FP&A team.
* Complete other duties as assigned by the Director, Planning and Analysis, Senior Management and FP&A Managers.

ESSENTIAL FUNCTIONS OF THE JOB

* Consult with managers, IT, and other Alliance employees.
* Systematic review, problem solving, design, and implementation of financial data systems and reports.
* Data gathering from diverse systems.
* Data analysis and report preparation.
* Guide integrating findings into financial operations.
* 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.
* Occasionally walking and standing.

MINIMUM QUALIFICATIONS:

EDUCATION OR TRAINING EQUIVALENT TO:

* B.S. in Business Administration, Accounting, Information Technology or related field or equivalent experience.

MINIMUM YEARS OF ADDITIONAL RELATED EXPERIENCE:

* Four years' experience analyzing complex data and creating management information for financial reporting and decision support.
* Two years' experience analyzing healthcare expense in an insurance or health plan setting.

SPECIAL QUALIFICATIONS (SKILLS, ABILITIES, LICENSE):

* Proficient understanding of the software development life cycle.
* Ability to manage projects effectively and efficiently and provide leadership.
* Proficient understanding of healthcare and/or insurance industry. Know the general business processes in healthcare and how they affect an organization. Understand some of the regulatory requirements for HMOs.
* Well organized, detail oriented, and experienced in maintaining a complex, automated financial system required.
* Ability to create documents that describe systems and processes.
* Experience using Business Objects or similar OLAP tool.
* Advanced experience in use of MS Office products including MS Word, MS Excel, MS Access, MS PowerPoint Outlook
* Ability to understand the nuances of data (people using the same name to refer to different things).
* Knowledge and experience of using Microsoft SQL, being able to write adequate SQL code independently.
* Excellent written, verbal and interpersonal communication skills
* Ability to successfully relate to people at all levels.
* Ability to gather, read, analyze, and interpret complex financial/operating data and create accurate meaningful information for financial reporting and decision support.
* Plan and complete tasks to a high standard on time.
* Ability to effectively manage competing priorities and daily ambiguity is essential.

Salary Range: $77,710 -$116,570 / annually

Alameda Alliance for Health is an EQUAL OPPORTUNITY EMPLOYER. Applicants and employees are considered for positions and are evaluated without regard to mental or physical disability, race, color, religion, gender, national origin, age, genetic information, military or veteran status, sexual orientation, marital status or any other protected Federal, State/Province or Local status unrelated to the performance of the work involved.

Other details

* Pay Type Salary
* 1240 S Loop Rd, Alameda, CA 94502, USA