Job Abstract

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.

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.

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.

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.

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.