Experience:
No experience
Employment Type:
Full time
Posted:
8/8/2015
Job Category:
Software Development
Industry:
Health Care & Medicine
SQL Developer
(This job is no longer available)
UCLA Health | Los Angeles, CA
loading
loading
School
Major
Grad Date
 
 

Not sure what types of jobs you are interested in?


Explore Jobs
Based on Your Education

Follow This Company
Share

Job Description

Job Duties

DUTIES TO BE PERFORMED ON THE JOB:

The SQL Developer uses database programming to support analysis of administrative, clinical, financial, and demographic data. The SQL Developer will report to the team lead of the Data Integration team in OHIA (the Office of Health Informatics & Analytics), the centralized analytics group supporting UCLA Health"s three hospitals, physicians, the School of Medicine, and research, and other entities across the UCLA Health enterprise. The developer supplies data to researchers to support cutting-edge projects working in an interactive team environment. The developer also analyzes Epic Clarity and Cogito Data Warehouse data models, integrating data from numerous sources of clinical, financial, operational, and demographic data. 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.

KEY RESPONSIBILITIES:

Provide subject matter expertise in quality projects with multidisciplinary 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.

Job Qualifications

SKILLS AND EXPERIENCE:
Strong SQL programming skills:
Strong experience on OLTP system
Sound knowledge around ETL using SSIS development.
Experience of relational data modeling, designing, developing, maintaining, and enhancing OLTP databases used by end-user applications is a must. Microsoft SQL Server 2008R2 or higher (2012/2014 preferred)
Microsoft SQL Server Integration Services (SSIS) 2008R2 or higher (2012/2013 preferred)
Previous data warehousing/data integration experience required
Previous experience working in Healthcare
Oracle Experience is a plus.
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 healthcare is preferred.
BA/BS degree or higher OR equivalent experience required

Keywords
data experience sql developer or h team epic development job database programming integration health management processes higher duties on support clinical financial demographic will report analytics ucla enterprise projects working clarity cogito warehouse models requirements using quality contribute map elements applications associated skills oltp etl ssis microsoft server r previous required healthcare plus understanding performed uses analysis administrative lead ohia office informatics amp centralized group supporting three hospitals physicians school medicine research entities supplies researchers cutting-edge interactive environment analyzes integrating numerous sources operational work members users others define develop meet user needs business intelligence platform key subject matter expertise multidisciplinary teams discovery necessary measure capture important ascender proprietary custom local perform tasks specification documentation assurance participate practices software lifecycle optimization performance tuning assist programmers packaging automation code standing qualifications system sound knowledge around relational modeling designing developing maintaining enhancing databases used end-user must services warehousing oracle source target structures products ability comprehend relationships among field epiccare inpatient ambulatory electronic medical records revenue cycle encounters professional institutional claims membership statistical concepts prior reporting ba bs degree equivalent

About UCLA Health

For more than half a century, UCLA Health  has provided the best in healthcare and the latest in medical technology to thepeople of Los Angeles and throughout the world. Today we are one of the most comprehensive and advanced healthcare systems in existence. We are comprised of Ronald Reagan UCLA Medical Center, UCLA Medical Center, Santa Monica, Resnick Neuropsychiatric Hospital at UCLA, Mattel Children’s Hospital UCLA, and the UCLA Medical Group, with offices throughout the region.

Ronald Reagan UCLA Medical Center is consistently ranked by U.S.News & World Report as one of the top five hospitals in the nation and the best medical center in the western United States. The doctors, scientists and caregivers of UCLA are leaders in their fields. Every day, they perform pioneering work across an astounding range of disciplines, from organ transplantation and cardiac surgery to neurosurgery and cancer treatment. Year after year, our people have achieved medical breakthroughs and earned the highest industry honors. And we’re just getting started.

The dedicated professionals of UCLA Health are committed to healing humankind, one patient at a time, by improving health, alleviating suffering, and delivering acts of kindness on a daily basis.

Job posted via
JWT EasyPost