During this year-long internship, you will create, maintain and optimize SQL stored procedures and processes to validate, transform and load data into the internal data warehouse.
You will categorize and understand source data, including structured and unstructured data from sources that include MySQL, SQL Server, flat files, and you will regularly conduct database performance tuning and actively look for ways to improve overall performance.
Additionally, you will drive monthly internal allocations of database expenses used in research through usage data analysis, manipulation & reviews.
You'll also support the creation of financial dashboards and ad-hoc reports to showcase performance KPI’s and net position by gathering and analyzing data in a timely manner.
Over time, you'll also have the opportunity learn to design and develop ETL code using scripting language such as Perl and Python.