Report Writer III

Job Category: Administrative, HR, Business Professionals

Department: Advanced Analytics Lab

Location:

Los Angeles, CA, US, 90017

Position Type: Full Time

Requisition ID: 11782

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

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. Acts as a Subject Matter Expert, 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 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.

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.

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

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

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)