Report Writer III (ALD)

Job Category: Claims

Department: Claims Integrity

Location:

Los Angeles, CA, US, 90017

Position Type: Full Time

Requisition ID: 9465

Salary Range: $77,265.00 (Min.) - $100,445.00 (Mid.) - $123,625.00 (Max.)

Established in 1997, L.A. Care Health Plan is an independent public agency created by the state of California to provide health coverage to low-income Los Angeles County residents. We are the nation’s largest publicly operated health plan. Serving more than 2 million members in five health plans, we make sure our members get the right care at the right place at the right time.

Mission: L.A. Care’s mission is to provide access to quality health care for Los Angeles County's vulnerable and low-income communities and residents and to support the safety net required to achieve that purpose.

As a condition of employment, L.A. Care requires a COVID-19 vaccine. This requirement includes our remote workforce. If you would like to request an exemption, L.A. Care has implemented a process to consider exemptions for documented medical conditions and sincerely held religious beliefs. L.A. Care will review all exemption requests prior to proceeding with the recruitment process.

Job Summary

The Report Writer III is responsible for data consolidation, data analysis and management reporting. This position utilizes software to generate metrics and develops actionable recommendations. This position provides support to teams and/or management by collecting and analyzing data and reporting results. Collaborates with various function teams to achieve business results.

Duties

Responsible for database administration, data consolidation, data analysis and management reporting. Collaborates with end users to gather report requirements and ensure proper testing and validation. Provides support to end users on standardized and ad hoc reports. Acts as liaison with the I.T. department.

Performs technical and analytical work to support the functional and reporting requirements of the department. Analyzes tables in the information system to establish knowledge of data for accurate retrieval and use in report writing. Plays an active role in identifying requirements and workflow associated with the systems upgrades and implementations.

Presents report data in a way that is most meaningful and readily accessible to staff and faculty using a combination of system reports. Demonstrates outstanding communication skills to translate reporting requests in order to accurately meet the actual information and deadline needs of users.

Educates requestors as to appropriate and desirable parameters to ensure they get the information they need.

Performs other duties as assigned.

Duties Continued

Education Required

Bachelor's Degree in Computer Science or Business Administration

In lieu of degree, equivalent education and/or experience may be considered.

Education Preferred

Experience

Required:
At least 3-5 years experience working with healthcare data in a reports development role, direct experience developing reports derived from an Access, SQL or Oracle database in a healthcare setting, working with healthcare data and be proficient in claims and/or encounter data.

Prior healthcare experience, working on the core system (QNXT), with at least 5 years’ experience performing system integration testing (SIT) and/or user acceptance testing (UAT).

Preferred:
At least 3 years programming and data analysis experience in a healthcare setting with at least 5 years experience working with Medi-Cal managed care and/or commercial healthcare data.

Prior experience working with Core membership systems implementations, with at least 5 years experience managing system implementations and performing system integration testing (SIT) and user acceptance testing (UAT).

Prior experience working within a project management structure.

Skills

Required:
Must have solid understanding of report development methodologies and be able to assess appropriate methodologies for the work assigned to the unit.

Must have excellent communication skills, strong analytical and coaching/mentoring skills, team building skills and the ability to work effectively with diverse team members.

Must have the ability to perform extensive root cause analysis of problem areas and recommend alternative solutions.

Must be able to work in an environment where critical time constraints exist.

Preferred:
Knowledge of 837 and NCPDP file formats.

Licenses/Certifications Required

Licenses/Certifications Preferred

Required Training

Additional Information

Additional Essential Duties and Responsibilities to Dept. Specific (Enrollment Services):
Responsible for database administration, data consolidation, data analysis, management reporting and operational reporting specific but not limited for Customer Solutions Center, which includes Enrollment Services, Even MORE, Call Center and Appeals & Grievances. Collaborates with end users to gather report requirements and ensure proper testing and validation. Provides support to end users on standardized and ad hoc reports. Acts as liaison with the I.T. department.

Salary Range Disclaimer: The expected pay range is based on many factors such as geography, experience, education, and the market. The range is subject to change.

This position is a limited duration position. The term of this position is a minimum one year and maximum of two years from the start date unless terminated earlier by either party. Limited duration positions are full-time positions and are eligible to receive full benefits.

L.A. Care offers a wide range of benefits including

Paid Time Off (PTO)
Tuition Reimbursement
Retirement Plans
Medical, Dental and Vision
Wellness Program
Volunteer Time Off (VTO)

At L.A. Care, we value our team members’ safety. In order to keep our work locations safe, each employee is required to self-screen for symptoms prior to entering any L.A. Care location each day. L.A. Care and all of its staff are required to comply with all state and local masking orders. Therefore, when on-site at any L.A. Care location, it's expected that all employees wear a mask in areas where physical distancing cannot be managed.