Sr. Business Analyst

Description:

FIELDGLASS COMMENTS SECTION - Required Information (DO NOT Include in Resume):
When submitting a candidate, please ensure the following details are provided:
• Candidate's Location: Specify city and state (mandatory).
• Skillset Alignment: Briefly summarize how the candidate's experience and skills align with the role's requirements.
• Requested Time Off: Include any pre-planned time off (e.g., vacations).
• Work Authorization Status: Clearly state if the candidate is authorized to work in the U.S.
Note: The IS Department cannot consider candidates requiring sponsorship.
• Pacific Time Zone Availability: Confirm if the candidate is comfortable working Pacific Time Zone hours, regardless of location.


USC Medical Enterprise IS Department - Resume Expectations:
• Resumes must be professional and error-free-submissions with grammar, spelling, font inconsistencies, or misaligned bullet points will not be considered.
• Verb tense consistency is crucial (use past tense for completed work, present tense for ongoing responsibilities).
• Do not include the company logo or name in the resume title or document.


Work History:
The IS department places strong emphasis on the continuity of a candidate's work history, particularly the number of positions held at various companies over a two-year period. Specifically, having four or more job changes within this span or any extended unemployment exceeding three months may be a concern.


Remote Work and Onsite Expectations for This Role:
• Remote work is acceptable, LOCAL CANDIATES ONLY
• Occasional onsite requirements may include HR orientation, equipment pickup, pre-employment health appointments, annual team events, go-lives, or other manager-assigned instances.
• Typically requiring onsite presence 2-4 days per year for most remote team members.
• Other Duties and On-Call: Ability to fulfill On-Call requirements and other duties as assigned.


Communication:
We require strong candidates capable of effective communication in meetings and with stakeholders. Please ensure candidates are vetted for their communication skills.
• Working Job Title: BI Developer, Sr.
• Number of needs: 1
• Duration of Assignment: Direct Hire
• Salary Rate: #####20k - #####43K (Exempt)
• Work hours: 8-5
• 2 -3 steps Video/ Teams interview process
• Dress code: Business Casual


Summary
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.


Minimum Education
• Bachelor's degree in Computer Science, Information Systems, Computer Engineering, or related field required.
• In lieu of bachelor's degree will consider 10 years' experience in relevant business support and/or IT support.


Minimum Experience/Accountabilities
• Minimum 6 years' relevant experience including dashboards /BI reporting design, documentation, maintenance, implementation, upgrades, and troubleshooting. If no bachelor's degree, must have 10+ years of experience.
• Must have experience with Structured Query Language (MS SQL Server, Oracle)
• 2 years' experience QlikView and QlikSense preferred.
• Must have other BI tools experience, such as Tableau, PowerBI, etc.
• Must be able to demonstrate experience with database systems and experience with system design, capacity planning, and capacity management.
• Requires hands-on expertise with database services.
• 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.


USC will be responsible for working with the candidate to complete all onboarding background requirements listed below if a Direct Hire offer is extended.


Medical Enterprise - Non-Clinical Onboarding - Must complete all onboarding requirements prior to the start date, with no exceptions.


Medical Enterprise - Non-Clinical Onboarding Requirements:
Background, Education, and Employment
Background Check:
• Social Security Trace: 7 years worked and lived found by SSN Trace
• County Criminal F&M: 7 years
• Federal Criminal: 7 years
• Widescreen Plus National Criminal Search
• National Sex Offender Registry
• Healthcare Sanctions - State
• OIG/SAM
Education:
• SEE JD
Employment:
• Verification of 3 Employers, with 2 out of 3 verified
Other Requirements:
• HIPAA Training
• Application
• Temporary Worker Agreement
• Harassment & Discrimination Pamphlet
Medical Requirements:
Immunizations:
• MMR (Measles, Mumps, Rubella): Proof of immunity or series of 2 shots
• Varicella (Chickenpox): Proof of immunity or series of 2 shots
• Hepatitis B: Proof of immunity or series of 3 shots; worker can decline with a declination form on file
TB Test:
• Annual test required; results must be read within 24 to 48 hours
• Positive TB history requires chest x-ray results
Drug Screen:
• Must be taken within 72 hours or the offer is rescinded.
• 10-panel drug test including:
• Amphetamines
• Barbiturates
• Benzodiazepines
• Cocaine metabolite
• Opiates (Codeine, Morphine)
• Hydrocodone
• Hydromorphone
• Oxycodone
• Phencyclidine
• Methadone
• Propoxyphene
Influenza Vaccination:
• Required for the current flu season (11/1 through 5/30)
• Workers starting after May 1st should wait until after September 1st for the next flu shot season
• Accepts signed personal/medical exemption
COVID Vaccinations:
• Fully vaccinated with Covid-2024-25 Vaccine
• Accepts signed religious/medical exemption


Note: All items are billable except for the drug screen.


Qualified Applicants with arrest or Conviction records will be considered for Employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act
Working Job Title
Additional Details

• Manager's Requested ### : (No Value)
• Does the position allow for the worker to be virtual/remote? : Yes
• Shore Options Available for this Position : Onshore Only
• Critical Position? : No
• Kelly Job Code : TBD
• Operations Group : USC Medical Enterprise IS Department
• Working Job Title : Business Intelligence Developer, Sr
• Markup Category : Professional
• Shift Details/Expected Working Days and Hours : SEE JD
• Dress Code/Special Attire : SEE JD
• Does this position require driving? : No
• Will resource have direct patient contact? : No
• HIPAA training required? : Yes
• Nearest Parking Location : SEE JD
• Will job responsibilities include working directly with minors? : No