Generate reports, large data extractions, and analysis based on a SQL back-end data store.
Design new reports/data transformation/flows and maintain existing report portfolio.
Utilize SQL scripting, SSIS and VB.Net; develop code that presents information to Risk Management and engagement teams in support of the member firm's ongoing operations and usage of the Global Risk systems.
Understand, interpret and challenge requirement specifications Develop reports and ETL with little, incomplete or no written specifications.
Upgrade existing ETL framework and packages from SQL Server 2008 to SQL Server 2016 Upgrade SSIS Script Tasks (written in VB.Net) from SQL Server 2008 to SQL Server 2016 Address complex issues by thoroughly understanding the business and its functions
Design and maintain multifaceted SSIS and T-SQL based ETL processes Support, maintain and create new reports in one of three VB.NET reporting applications Troubleshoot complex issues as well as provide ongoing support to production: Create, manage and troubleshoot SQL Server Agent Jobs. Manage Logins and Security in SQL Server Automate existing ongoing reports via SQL server, SSIS and VB.NET while continuously looking for efficiencies. Automate/schedule ETL processes via the SQL Server Agent.