The Business Intelligence Developer Senior will work in Keck Medicine IS team to develop and test, implement business intelligence solutions for various Keck Medicine departments. The position will serve as the subject expert as it relates to dashboards. Also, this position will be responsible for identifying and documenting information technology design specifications based on analysis/assessment of user needs and generate need-gap analyses. Also, this role ensuring data integrity, maintaining system security, extracting, analyzing and transforming data. The IT Business Intelligence Developer Senior also understands the functional workflow and processes of the Departments he/she supports and maintains system functionality leverage USC's various technologies including but not limited to QlikView, Cerner Command Language (CCL) and other applications, Hadoop and RDBMS. Applies learned skills to perform problem resolution across integrated platforms, systems, processes and departments. Supports the mission, vision, values and strategic goals of Keck Medicine of USC.

Essential Duties:

• Dashboard: SDLC methodology to develop, test and deploy enterprise dashboards promptly.
• Data Visualization Design: Apply sound user experience design to incorporate visualization in dashboards and reports.
• Training: Trains new staff members on applicable systems/applications. Responsible for working with customer and/or vendors with training on new systems being implemented and rolled out for use in the departments.
• Priority Management: Must work several assignments at one time, manage priorities, deadlines and time. The work is highly technical, requires collaboration across multiple disciplines and groups. The ability to work independently is also required.
• Customer Service: Addresses customer questions, concerns, enhancement requests, communicates with customers, handles services problems and tickets politely and efficiently, always available for customers, follows procedures, utilizes problem solving skills, maintains pleasant and professional image. Customers may include both internal department users, vendors, and peers within IS.
• Reporting: Generate ad-hoc as well as routine reports and data dump for further consumption.
• Business Intelligence: Transform disparate data into meaningful analysis. Provide information that can be used for decision making. Predict outcomes and prescribe appropriate actions.
• Documentation: Prepare documentation related to dashboards and reports (e.g., FRD). Draft a mock-up data visualization before start building dashboard.
• Other Duties and On-Call: Ability to fulfill On-Call requirements and other duties as assigned.

Required Qualifications:

• Req Bachelor's degree Degree in Computer Science, Information Systems, Computer Engineering, or related field

• Req 6 years 6 to 10 years' relevant experience including dashboards / BI reporting design, documentation, maintenance, implementation, upgrades and troubleshooting .
• Req Experience with Structured Query Language (MS SQL Server, Oracle)
• Req 10 years Experience in relevant business support and/or information technology support. *ONLY If NO Bachelor Science in Computer Science, Information Systems, Computer Engineering, or related field.

• Req Good organization skills with ability to prioritize multiple activities in a rapidly changing environment
• Req Strong customer service focus
• Req Proficient in Microsoft Office (Outlook, Word, Excel, Power Point)
• Req Requires a maturing level of analytical ability to find solutions to increasingly difficult technical or administrative problems, to determine economic feasibility or options available, and to assess time involved in system changes. Thorough documentation skills are also required
• Req Must be able to demonstrate experience with database systems and experience with system design, capacity planning, and capacity management
• Req Requires hands-on expertise with database services.
• Req Must be able to communicate the impact and solutions of application/system problems in business language
• Req Requires a professional approach in all situations
• Req Ability to work any hours to support 24/7 operations
• Req Must resolve problems entirely by either completing the work or gathering all of the resources needed for ultimate resolution and continuity of problem management
• Req Availability to travel between Keck Medicine of USC, USC, and other facilities.

Preferred Qualifications:

• Pref 2 years QlikView and QlikSense experience.
• Pref Other BI tools experience: Tableau, PowerBI, etc.

Required Licenses/Certifications:

• Req Fire Life Safety Training (LA City) If no card upon hire, one must be obtained within 30 days of hire and maintained by renewal before expiration date. (Required within LA City only)

Logo

About University of Southern California (USC)

USC is the leading private research university in Los Angeles—a global center for arts, technology and international business. With more than 47,500 students, we are located primarily in Los Angeles but also in various US and global satellite locations. As the largest private employer in Los Angeles, responsible for $8 billion annually in economic activity in the region, we offer the opportunity to work in a dynamic and diverse environment, in careers that span a broad spectrum of talents and skills across a variety of academic and professional schools and administrative units. As a USC employee and member of the Trojan Family—the faculty, staff, students, and alumni who make USC a great place to work—you will enjoy excellent benefits, including a variety of well-being programs designed to help individuals achieve work-life balance.

Connections working at University of Southern California (USC)