Report Writer III

Report Writer III

Job Category : Customer Service

For a complete understanding of this opportunity, and what will be required to be a successful applicant, read on.

Department : Even MORE Quality

Location : Los Angeles, CA, US, 90017

Position Type : Full Time

Requisition ID : 11490

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, ensuring they receive 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.

The Report Writer III is responsible for data consolidation, data analysis, and management reporting. This position utilizes software to generate metrics and develop actionable recommendations.

This position provides support to teams and / or management by collecting and analyzing data and reporting results, collaborating with various function teams to achieve business results.

Acts as a Subject Matter Expert and serves as a resource and mentor for other staff.

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 system upgrades and implementations.
• Demonstrates outstanding communication skills to translate reporting requests to meet the actual information and deadline needs of users.
• Educates requestors on appropriate and desirable parameters to ensure they get the information they need.
• Applies subject expertise in evaluating business operations and processes.
• Identifies areas where technical solutions would improve business performance.
• Consults across business operations, providing mentorship, and contributing specialized knowledge.
• Ensures that the facts and details are correct so that the project’s / program's deliverable meets the needs of the department, organization, and legislation's policies, standards, and best practices.
• Provides training, recommends process improvements, and mentors junior level staff, department interns, etc. as needed.
• Performs other duties as assigned.

Education Required

Bachelor's Degree in Computer Science or Business Administration. In lieu of a degree, equivalent education and / or experience may be considered.

Experience

Required :

• At least 3 years of 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 proficiency 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 of programming and data analysis experience in a healthcare setting with at least 5 years of 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 of 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 a 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 RequiredLicenses / Certifications PreferredRequired TrainingPhysical Requirements

Light

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 to 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.

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

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

Nearest Major Market : Los Angeles

Job Segment : Call Center, Claims, Customer Service, Insurance

J-18808-Ljbffr