Job Information
Sharp HealthCare Health Services Data Analyst / Managed Care Finance / Full Time / San Diego in San Diego, California
Facility: Corporate Offices
City San Diego
Department
Job Status
Regular
Shift
Day
FTE
1
Shift Start Time
Shift End Time
Bachelor's Degree; Master's Degree
Hours
Shift Start Time:
8 AM
Shift End Time:
5 PM
Additional Shift Information:
Weekend Requirements:
No Weekends
On-Call Required:
No
Hourly Pay Range (Minimum - Midpoint - Maximum):
$39.435 - $50.884 - $62.333
The stated pay scale reflects the range that Sharp reasonably expects to pay for this position. The actual pay rate and pay grade for this position will be dependent on a variety of factors, including an applicant’s years of experience, unique skills and abilities, education, alignment with similar internal candidates, marketplace factors, other requirements for the position, and employer business practices.
This is a full time position located in Kearny Mesa (San Diego County). It is recommended that you please submit a cover letter that speaks to your experience in developing and maintaining spreadsheets and databases.
What You Will Do
Under the direction of the Director of Managed Care Finance and Supervisor of Managed Care Finance provides the medical group with database development and technical support, reporting and analysis that enables data driven decision making. Maintains the integrity of extensive spreadsheets, links data from different sources and databases to include functionality of formulas, queries, importing and exporting of data to other programs, and monitors internal and external data needs on an ongoing basis.
Required Qualifications
Bachelor's Degree or equivalent work experience.
Previous experience in a managed care setting.
Working knowledge of hospital, physician and health care operations.
Experience in medical management systems (e.g., IDX), operating systems (e.g., Microsoft Windows), and a variety of PC-based software programs (e.g., Access, Excel, Word, SQL, and Monarch).
Experience in development and maintenance of spreadsheets and databases.
It is recommended that you please submit a cover letter that speaks to your experience in developing and maintaining spreadsheets and databases.
Preferred Qualifications
- Master's Degree preferred.
Essential Functions
CommunicationKeeps supervisor informed of project status.Communicates with supervisor any issues or concerns before they turn into crisis.Asks pertinent questions if unclear about a project assigned.Maintains open communication with coworkers especially if a project he or she is working on will impact others.
ConfidentialityMaintains confidentiality of information of various entities.
Data integrityConsults with Supervisor with regards to data integrity issues.Identifies barriers in data abstraction methods to aid in determining the impact of missing data.Performs analysis of data related to quality management (i.e. capitation revenue, reductions, adjustments, and membership movements).
Data reportingDevelops ad hoc and standard reports.Extracts and compiles data information from a variety of internal and external sources (I.P. using Monarch for data extraction).Summarization of reports from various canned system reports.Designs and builds spreadsheets and databases to be accessed by other team members or by customers served.Compiles core data sets and develops appropriate queries with appropriate documentation.
General supportPerform other duties as assigned to contribute to the overall success of the organization.
Medical group reports and analysisAutomates and standardizes routine but complex projects.Develops tools for use within the department to facilitate the data retrieval process.Designs, builds interface, and maintains complex databases and spreadsheets for clients to use (I.E. revenue summaries, capitation datamart, and capitation deducts).Performs financial and clinical analyses using data from various sources.
Other duties as assignedCompletes assignments accurately, meets frequent and tight timelines, and prioritizes workload effectively.
Record maintenanceDemonstrate organizational ability and initiative in establishing (electronic and hard copy) filing system.Ensures that all documentation (to include electronic and hard copy) files will be maintained in a well-organized manner to enable ease in access and data review.Ensures adequate data and file storage and retrieval processes.
Report preparationCross train with various applications and acts as department back-up resource.
Special projectsAssists with the development of new data management systems, new reports, and reporting capabilities, special projects, and additional assignments as needed.
Knowledge, Skills, and Abilities
Working knowledge of hospital, physician and health care operations.
Demonstrates knowledge of on-line data entry and the ability to organize work flow to maximize efficiency.
Ability to deal with the IDX main frame database, personal computer database (Access), spreadsheets (Excel), statistical programs and extraction of data through Monarch in a windows environment.
Ability to effectively participate in various activities and to interact with other departments and staff effectively.
Demonstrate organizational, analytical and problem solving skills; ability to meet rapidly changing deadlines.
Working knowledge of procedure, diagnostic, and revenue coding (e.g., CPT-4, HCPCS, CRVS, RBRVS, RVS, ICD-9, etc.) and medical terminology.
Detail oriented, able to follow directions quickly and efficiently.
Excellent written and verbal communication skills.
Ability to meet frequent deadlines and tight schedules.
Sharp HealthCare is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender, gender identity, sexual orientation, age, status as a protected veteran, among other things, or status as a qualified individual with disability or any other protected class