Health Equity BI Developer

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, with a preference for local candidates or those within Pacific or Central Time Zones. NO EST
• Occasional onsite requirements may include HR orientation, equipment pickup, pre-employment health appointments, annual team events, go-lives, or other manager-assigned instances.
• Flexible travel expectations, typically requiring onsite presence 2-4 days per year for most remote team members.
• Equipment shipping available for candidates located 2+ hours driving distance from the office.


Communication:
We require strong candidates capable of effective communication in meetings and with stakeholders. Please ensure candidates are vetted for their communication skills.


Work location: 2011 N. Soto St Los Angeles, CA 90032
• Campus or Medical Enterprise: Medical Enterprise
• Working Job Title: BI Developer, Sr. (Health Equity)
• Number of needs: 1
• Duration of Assignment: Direct Hire
• Salary Rate: Salary Range: #####20k - #####43K (exempt)
• Work hours: 8-5
• 2 -3 steps Video/ Teams interview process
• Dress code: Business Casual


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)
• Healthcare experience preferred.
• HealthEquity experience required.
*****Working experience with HealthEquity: Building visualizations and KPI's for Patient satisfaction, Readmission rates, Treatment success, Health outcomes, Compliance rates with safety protocols, Wait times.
• Understanding of the Healthcare protocols.
• KPI's and visualizations.
*** Experience using HealthEquity software/services
• 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.
• Familiarity and experience with data modeling and query logic leveraging MS-SQL or other programming logic.
• Effective communicator to both clinical and technical audiences, using appropriate language, terminology, and formats, including but not limited to being able to present and explain data analysis results, findings, and recommendations in a way that is relevant, accurate, and actionable.
• Competence with healthcare data sets (clinical, administrative, financial, operational etc) and concepts including standards (ICD, CPT, HCPCS, LOINC, SNOWMED)
• Ability to extract, integrate, and analyze data from AllScripts SCM, Infinity databases.
• Experience leveraging Oracle Health Cerner HealthAnalytics/Population Health platforms. to access, analyze, and report on healthcare data from various sources, such as electronic health records, claims, registries, surveys.


Job Accountabilities:
• 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.


Additional REQUIRED qualifications:
• Extensive experience with data modeling.
• Must have Tableau proficiency (experience with other BI and visualization tools a plus).
• Deep knowledge of joins and visualizations.
• SQL programming skills and clinical knowledge to formulate the models for the complex metrics required for this role.
• Ability to present developed analytics and show health equity knowledge.


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:
o Amphetamines
o Barbiturates
o Benzodiazepines
o Cocaine metabolite
o Opiates (Codeine, Morphine)
o Hydrocodone
o Hydromorphone
o Oxycodone
o Phencyclidine
o Methadone
o 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 : IT55
• Operations Group : USC Medical Enterprise IS Department
• Working Job Title : Health Equity BI Developer
• Markup Category : Information Technology
• 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