SQL/Oracle Report Writer III

Job Category:  Customer Service
Department:  Enrollment Services
Location: 

Los Angeles, CA, US, 90017

Position Type:  Full Time
Requisition ID:  4864
Job Summary


The Customer Solution Center 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. 

 

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

 

Perform other duties as assigned.

 

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. 

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. 

 

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


Nearest Major Market: Los Angeles

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