BI Developer

For more than half a century, UCLA Health has provided the best in healthcare and the latest in medical technology to the people of Los Angeles and throughout the world.

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 its wide-reaching system of primary-care and specialty-care offices throughout the region.

• Use health system clinical and financial data repositories and databases to program, analyze, document, compile, interpret and create reports from utilization, quality, clinical, and financial data.
• Effectively communicate with various departments to gather and understand the information necessary to successfully complete programming requests and projects with the ability to document those requests and the final products both orally and in written format in a way a non-programmer can understand the logic and business rules.
• Prepare detailed documentation of programming code in a format that a non-programmer can understand following standard documentation templates and industry standards.
• Documentation is prepared and maintained at all stages of program development.
• Conduct research and development in the use of the Epic Clarity Database and Cogito Data Warehouse as data sources for reporting.
• Develop the enterprise data warehouse and data marts using a both Epic and non-Epic sources.
• Use business intelligence (e.g. SAP Business Objects, Tableau, Microsoft Power BI) and database (Oracle, MS SQL Server) software to integrate data, calculate measures, and visualize information.
• Implement data visualization through R and other statistical packages to produce heat maps, run charts, Shewhart statistical control charts, etc.
• Transform data into various stages of usability via SAP Data Services and MS SQL Server Integration Services.
• Maintain a strong knowledge of internal and external data sources.

• At least 2-4 years of experience in a healthcare organization.
• Equivalent experience in a programming / analytic / information systems role, with an emphasis on SQL programming.
• One or more Epic Clarity Data Model certifications.
• Superior analytical and problem-solving skills and the ability to work in a fast-paced and challenging environment.
• Excellent interpersonal skills and exceptional judgment and discretion in interacting with physicians and senior management on sensitive political and confidential issues.
• Knowledge of current issues in data management and SQL particularly in a healthcare environment including quality measurement, outcomes studies, healthcare finance, and patient safety.
• Proficiency in spreadsheet and database applications including Access, Excel, PowerPoint, and other database management and business intelligence software.