Data Analyst

AMAZING INDIVIDUALS WORKING FOR POSITIVE PEOPLE at AIDS Healthcare Foundation!
 
Does the idea of doing something that really makes a difference in people?s lives while being well-compensated intrigue you?  Are you looking to work for an organization that encourages growth and success from each and every one of its employees?  If so, AIDS Healthcare Foundation is the place for you! 

Founded in 1987, AIDS Healthcare Foundation is the largest specialized provider of HIV/AIDS medical care in the nation.  Our mission is to provide cutting edge medicine and advocacy, regardless of ability to pay.  Through our healthcare centers, pharmacies, health plan, research and other activities, AHF provides access to the latest HIV treatments for all who need them. 

STILL INTERESTED?  Please continue!

AIDS Healthcare Foundation is searching for a Full Time Data Analyst to work in our in Linn House Administrative Office: 1001 N. Martel Ave., in the City of West Hollywood, California.  The hours for this position are Monday-Friday from 8:30 a.m. to 5:30 p.m.

JOB DESCRIPTION

Essential Duties & Responsibilities
Includes the following.  Other duties may be assigned.

- Accesses multiple medical/financial/administrative databases and provide ongoing reporting that supports information-based decision making, measures the execution of strategy, and identifies opportunities for improving existing processes.

- Confers with the persons requesting database services and/or reports to identify needs, requirements or problems in order to produce an accurate data gathering and reporting environment. 

- Assists in the development of reports that determine basic characteristics such as origin and report flow, format, frequency, distribution and purpose or function of report.

- Recommends establishment of new or modified reporting methods and procedures to improve report content and completeness of information.

- Demonstrates experience and skills in Relational Database Management Systems (RDBMS) like SQL Server and writing complex queries in SQL.

- Programs applications in Microsoft Access and Visual Basic.

- Supports business functions of enrollment invoicing, member services database support, claims system (EZ Cap) payment and MAS 90 integration accounts payable support.

- Document data base configuration and update documentation with each change.

- Document policies and procedures required to support system enhancements.

- Prepares various reports required by funding sources, fiscal intermediaries, medical staff, and management on a routine and ad hoc basis.

- Prepares various financial reports required by funding sources, including but not limited to Medi-Cal cost and utilization reports, the Department of Health Services (DHS), managed care filings, and other external financial reports.


- Works regularly with management, physicians, other AHF programmers, and consultants to determine, interpret and program solutions.


- Works continuously  to improve efficiency of programs and process in use.

- Interacts with multiple Foundation (e.g., Finance, Medicine, Nursing, Case Management, etc.) personnel to ensure open lines of communication and compliance with established procedures.

- Supports the enrollment invoicing process by maintaining the appropriate data bases and analyzes the data for accuracy. 

- Collaborates with the Department of Health Services to ensure data transmission systems remain open and efficiently running.

- Prepares and submits the monthly state invoice for Positive Healthcare.

- Develops and assists in the maintenance of Managed Care databases.

- Interacts with the Information Technology Department in order to facilitate information flow and business solutions.

Participation in AHF Meetings/Committees
Attends AHF meetings as assigned.

Supervisory Responsibilities
This job has no supervisory responsibilities.

Qualifications
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.  The requirements listed below are representative of the knowledge, skill, and/or ability required.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education and/or Experience
Bachelor?s degree (B.A.) from four-year college or university;  or one to two years related experience and/or training or equivalent combination of education and experience.

Computer/Software Skills & Abilities
To perform this job successfully, an individual should have knowledge of Contact Management systems; Database software; Internet software; Spreadsheet software, and Word Processing software.

Other Skills & Abilities/Qualifications
- Ability to summarize analytical results graphically and numerically in  Crystal Reports, MS Excel, PowerPoint, etc.
- Proficient and demonstrated use of database reporting tools for data manipulation, data extraction, merging of large, complex data from variety of sources.
- Prior experience with health-related databases/Logician medical database preferred

Physical Demands
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Are you intrigued by this amazing opportunity?  Are you eager to learn more?  If so, please send your resume via e-mail to: Careers@aidshealth.org or fax it to: (323) 417-5030.  To apply in person please come to our Administrative Office:  6255 Sunset Blvd., 21st. Floor, Los Angeles, CA 90028. 

Additional Information
Salary: $44,000 Yr. - $48,000 Yr. Based on Experience
Position Type: Full Time, Employee
Reference Code: 0705 Data Analyst / Managed Care

Contact Information
David Marin / Senior Recruiter
AIDS Healthcare Foundation
6255 W. Sunset Blvd., 21st. Floor
Los Angeles, CA  90028
Fax Number: (323) 417-5030
Email: Careers@aidshealth.org

We look forward to hearing from you!