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 ensuring data integrity, system security, and efficient data extraction, analysis, and transformation.
Requirements
- at least 6 months of QlikView and QlikSense experience
- Experience with Structured Query Language (MS SQL Server, Oracle)
- Hands-on expertise with database services
- Must be able to demonstrate experience with database systems and experience with system design, capacity planning, and capacity management
- Must be able to communicate the impact and solutions of application/system problems in business language
- Other BI tools experience: Tableau, PowerBI, etc.
Responsibilities
- develop and test, implement business intelligence solutions for various Keck Medicine departments
- identifying and documenting information technology design specifications based on analysis/assessment of user needs and generate need-gap analyses
- ensuring data integrity, maintaining system security, extracting, analyzing and transforming data
- 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
- SDLC methodology to develop, test and deploy enterprise dashboards promptly
- Generate ad-hoc as well as routine reports and data dump for further consumption
Other
- Under the supervision and guidance of the department leader and/or seasoned developers
- 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
- Req High school or equivalent
- Req Bachelor's degree Degree in Computer Science, Information Systems, Computer Engineering, or related field. Combined work experience and education as equivalent.
- Good organization skills with ability to prioritize multiple activities in a rapidly changing environment
- Strong customer service focus
- Proficient in Microsoft Office (Outlook, Word, Excel, Power Point)
- Must have 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
- Must have 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 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).
