Business Intelligence ETL Solutions Developer (USC Care) - Business Intelligence - Full Time 8 Hour Days (Exempt) (Non-Union)

Job description

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, stagi...