IT Analyst, Business Intelligence/Data Warehouse - USC Care MSO Business Intelligence - Full Time 8 Hour Days (Exempt)(Non-Union) - University of Southern California

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 (2016 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 2019 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 30 days of hire and maintained by renewal before expiration date. (Required within LA City only) The annual base salary range for this position is $95,680.00 - $158,230.00. 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. USC is a smoke-free environment USC is an equal opportunity, affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, or any other characteristic protected by law or USC policy. USC will consider for employment all qualified applicants with criminal records in a manner consistent with applicable laws and regulations, including the Los Angeles County Fair Chance Ordinance for employers and the Fair Chance Initiative for Hiring Ordinance, and with due consideration for patient and student safety. Please refer to the Background Screening Policy Appendix D for specific employment screen implications for the position for which you are applying. We provide reasonable accommodations to applicants and employees with disabilities. Applicants with questions about access or requiring a reasonable accommodation for any part of the application or hiring process should contact USC Human Resources by phone at (213) 821-8100, or by email at uschr@usc.edu. Inquiries will be treated as confidential to the extent permitted by law. Read USC’s Clery Act Annual Security Report Affirmative Action and Equal Opportunity Plan Pay Transparency Non-Discrimination USC is an E-Verify Employer Digital Accessibility If you are a current USC employee, please apply to this USC job posting in Workday by copying and pasting this link into your browser: https://wd5.myworkday.com/usc/d/inst/1$9925/9925$112981.htmld USC is a leading private research university located in the heart of downtown Los Angeles – a global center for arts, technology and international business. As the largest private employer in the city – responsible for more than $5 billion annually in economic activity in the region – we offer the opportunity to work in a dynamic and diverse environment, in careers that span a broad spectrum of talents and skills. As a USC employee, you will enjoy excellent benefits and perks, and you will be a member of the Trojan Family - the faculty, staff, students and alumni who make USC a great place to work. Application help If you need assistance during the application process, see our application help. (If you already work for USC, see Your USC career.) At any point you may also contact our HR Service Center for help at (213) 821-8100 or uschr@usc.edu.