Actively design and develop ETL solutions that transform data for decision-making with Microsoft SSIS. Use expertise in SSIS to create packages that handle complex business workflows and are capable of understanding the existing packages.
independently. Experience with Version Control tools. Troubleshoot problems including system failure, SSIS failure, SQL stored procedures, and use SSIS best practices.
Provide off-hours / weekend on-call rotation with the ETL Team. Monitor performance, index optimization, and process optimization.
Continually survey the current system environment and make recommendations on future system needs.
Essential Duties :
- Design and develop SQL Server stored procedures, functions, views, and triggers to be used during the ETL process.
- Design and develop SSIS / SQL ETL solutions that consume data from numerous upstream systems for data transformation and processing.
- Design, implement, and maintain database objects (tables, views, indexes) and database security.
- Proficient with ETL tools,expert in industry standard best practices on Microsoft SSIS and SSMS (6 or higher)
- Analyze and develop strategies to import and transfer data between source, staging, and Development / Production Warehouse destinations.
- Troubleshoot and correct ETL warnings and errors and resolve critical issues promptly.
- Provides analytical and technical expertise on performance tuning, index optimization, and query optimization.
- Stays informed of new developments and technologies by reading journals and other pertinent publications, maintaining contact with vendors, and participating in professional organizations, meetings, and seminars.
- Work closely with MED IT to assist in patch update reboot, capacity planning, and performance tuning.
- Performs other related duties as assigned or requested.
Required Qualifications :
- Req Bachelor's degree Degree in a related field
- Req 4 years SQL and Microsoft SSIS Development, ETL process, Microsoft SQL Server 9 or above, and related fields
- Req Demonstrate excellent customer service behavior.
- Req Organization / time management skills.
- Req Excellent analytical, problem-solving, planning and evaluation skills.
- Req Demonstrates excellent verbal and written communication skills.
- Req Able to function independently and as a member of a team.
Preferred Qualifications :
- Pref Experience with electronic health record data in a complex healthcare environment
- Pref Understanding of or exposure to healthcare (clinical / financial) operations.
- Pref Prior experience with mandated external reporting requirements for healthcare facilities.
Required Licenses / Certifications :
Req Fire Life Safety Training (LA City) If no card upon hire, one must be obtained within days of hire and maintained by renewal before expiration date.
Required within LA City only)
The annual base salary range for this position is $,. - $,.. When extending an offer of employment, the University of Southern California considers factors such as (but not limited to) the scope and responsibilities of the position, the candidate’s work experience, education / training, key skills, internal peer equity, federal, state, and local laws, contractual stipulations, grant funding, as well as external market and organizational considerations.
Imaging Systems Engineer II - IS Business Apps - Full Time 8 Hour Days (Non-Exempt) (Non-Union)
When extending an offer of employment, the University of Southern California considers factors such as (but not limited to) the scope and responsibilities of the position, the candidate’s work experience, education/training, key skills, internal peer equity, federal, state, and local laws, contractu...
LVN/LPN - Orthopaedic Clinic - Full Time 8 Hour Days (Non-Exempt) (Union)
When extending an offer of employment, the University of Southern California considers factors such as (but not limited to) the scope and responsibilities of the position, the candidate's work experience, education/training, key skills, internal peer equity, federal, state, and local laws, contractu...
Director, Oncology Imaging/Theranostics - Imaging Administration - Full Time 8 Hour Days (Exempt) (Non-Union)
Facilitates the development of the Molecular Imaging/Theranostics Program through coordination, growth, and marketing initiatives with appropriate entities across the inpatient and outpatient system of care. In partnership with Norris Cancer Hospital leadership, assists with execution of site-based ...
Scheduling Coordinator - Glendale OBGYN Clinic - Full Time 8 Hour Days (Non-Exempt) (Non-Union)
When extending an offer of employment, the University of Southern California considers factors such as (but not limited to) the scope and responsibilities of the position, the candidate's work experience, education/training, key skills, internal peer equity, federal, state, and local laws, contractu...
Associate Administrator, Access and Clinical Resource Management - Value Improvement Office - Full Time 8 Hour Days (Exempt) (Non-Union)
Req Demonstrated political savviness – Ability to operate in politically complex situations and remain effective; must have personal influence and credibility to be able to work from behind the scenes in the organization. When extending an offer of employment, the University of Southern California c...
Nurse Manager - 8E Pulmonary Medicine Telemetry - Full Time 8 Hour Days (Exempt) (Non-Union)
Assists in establishing methods for monitoring employee, patient and physician satisfaction with the services provided within the department Communication to each and every staff member their role in maintaining a high performing unit with regard to quality. When extending an offer of employment, th...
RN Clinical - 6N Medical/Surgical Orthopaedics - Full Time 12 Hour Nights (Non-Exempt) (Union)
BONUS POINTS § Preceptor (5) § Professional Certification (5) § More than 8 Non-mandatory CEH (3) § USCUH Nurse Week Recognition (5) § Monthly Hospital or Unit Spirit Award Winner (1) § Public nursing recognition (3). MANAGEMENT OF THE CARE OF PATIENTS IN THE STEPDOWN/TELEMETRY UNITS Demonstrates th...
Nurse Practitioner - Cardiothoracic ICU - Full Time 12 Hour Night Shifts (Non-Exempt) (Union)
If work in Hospital/Acute Care Setting must have Certification from the American Nurses Credentialing Center (ANCC) or American Association of Critical-Care Nurses (AACN) as an Acute Care Nurse Practitioner (ACNP) or Adult Gerontology Acute Care Nurse Practitioner (AGACNP) upon hire. Maintains compl...
Sterile Processing Technician II - Sterile Processing - Full Time 12 Hour Days (Non-Exempt) (Union)
When extending an offer of employment, the University of Southern California considers factors such as (but not limited to) the scope and responsibilities of the position, the candidate's work experience, education/training, key skills, internal peer equity, federal, state, and local laws, contractu...
ORT Supervisor (Spine) - Surgery - Full Time 10 Hour Days (Non-Exempt) (Non-Union)
When extending an offer of employment, the University of Southern California considers factors such as (but not limited to) the scope and responsibilities of the position, the candidate's work experience, education/training, key skills, internal peer equity, federal, state, and local laws, contractu...