- This company is committed to hiring veterans.
University of California - Los Angeles Medical Centers University of California - Los Angeles Medical Centers
Los Angeles, CA
- Job Type
- Job Classification
Entry Level (0 - 2 years)
- Company Ref #
- AJE Ref #
$35.34 / $6150
$69.83 / $12150
Layoff Referral Deadline:
The SQL Developer uses database programming to support analysis of administrative, clinical, financial, and demographic data for use in quality programs within the clinical departments that are coordinated by the Medical Director of Quality, Faculty Practice Group. The developer analyzes Epic Clarity and Cogito Data Warehouse data models, queries data, calculates measures, and generates reports to inform and support the FPG's quality initiatives and priorities. The developer will work with team members, users, and others to define requirements, to develop data management processes, and to meet user needs using the enterprise data warehouse and its business intelligence platform.
- Provide subject matter expertise in quality projects with multidisplinary teams. Contribute to the discovery of requirements necessary for measure development.
- Map the capture of important data elements in Epic applications to the Epic Clarity database, and further map that data into Epic Cogito, Ascender, and other proprietary or custom local data models.
- Perform tasks associated with database programming, specification documentation, report development, and quality assurance.
- Participate in best practices associated with a software development lifecycle. Contribute to the optimization of data management and performance tuning. Assist data management programmers with the packaging and automation of code into standing processes.
SKILLS AND EXPERIENCE:
Strong SQL programming skills, particularly for the Oracle and Microsoft SQL Server platforms.
Understanding of source and target data structures, ETL processes, and products.
Ability to comprehend relationships among field elements in the EpicCare Inpatient and Ambulatory electronic medical records, plus revenue cycle data in encounters, professional and institutional claims and membership.
Understanding of statistical concepts.
Prior experience in reporting for regulatory and contractual healthcare quality programs is preferred.
Baccalaureate degree in health sciences, information systems, or other quantitative field is required.
Graduate degree in public health, health administration, information management, or related field is preferred.
Work experience with health care data is required.