AI Engineer Intern
Core
Design, code, and maintain complex SQL stored procedures, functions, and SSIS packages for data transformation and database performance tuning.
Role type
Junior IC SQL Database Engineer
Builds
Enterprise database systems and data pipelines
Domain
Financial services / Data Engineering
Required skills
SQL, Stored Procedures, SSIS, Database Performance Tuning, Data Profiling, Unit Testing, Data Validation
Responsibilities
Design, code, and maintain new and existing complex SQL stored procedures and functions; Performance tune existing stored procedures, tables and indexes; Work with other engineers to troubleshoot, repair and performance tune databases; Create SSIS packages for data transformation, cleansing, caching, aggregation, staging, and transfer; Perform data analysis and data profiling tasks to provide support and recommendations for development and design decisions; Support production data loads and ongoing refreshes of the database systems; Define, prepare, execute, and implement data validation and unit testing methods to ensure data quality.