Keck Medicine IS team needs to develop and test, implement business intelligence solutions for various Keck Medicine departments, serving as subject matter experts for dashboards and identifying/documenting IT design specifications based on user needs.
Requirements
- Experience with Structured Query Language (MS SQL Server, Oracle)
- QlikView and QlikSense experience.
- Other BI tools experience: Tableau, PowerBI, etc.
- Experience with database systems and experience with system design, capacity planning, and capacity management
- Requires hands-on expertise with database services.
- Proficient in Microsoft Office (Outlook, Word, Excel, Power Point)
- Leverage USC's various technologies including but not limited to QlikView, Cerner Command Language (CCL) and other applications, Hadoop and RDBMS.
Responsibilities
- Develop, test, and deploy enterprise dashboards promptly using SDLC methodology.
- Apply sound user experience design to incorporate visualization in dashboards and reports.
- Generate ad-hoc as well as routine reports and data dump for further consumption.
- Transform disparate data into meaningful analysis, provide information for decision making, and predict outcomes.
- Prepare documentation related to dashboards and reports (e.g., FRD).
- Draft a mock-up data visualization before starting dashboard building.
- Extracting, analyzing and transforming data.
Other
- 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.
- Must work several assignments at one time, manage priorities, deadlines and time.
- The ability to work independently is also required.
- 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.
- Ability to fulfill On-Call requirements and other duties as assigned.
- Good organization skills with ability to prioritize multiple activities in a rapidly changing environment.
- Strong customer service focus
- 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.
- Must be able to communicate the impact and solutions of application/system problems in business language
- Requires a professional approach in all situations
- Ability to work any hours to support 24/7 operations
- Must resolve problems entirely by either completing the work or gathering all of the resources needed for ultimate resolution and continuity of problem management.
- Availability to travel between Keck Medicine of USC, USC, and other facilities.
- Req Bachelor's 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 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.
