Description

You will provide technical reporting capabilities in support of global risk applications by designing data transformations and maintaining the existing report portfolio.

Responsibilities

• Design, build, and maintain multifaceted T-SQL and SSIS-based ETL processes and data flows.
• Develop and support reports within VB.NET reporting applications.
• Upgrade existing ETL frameworks and SSIS Script Tasks from SQL Server 2008 to SQL Server 2016.
• Liaise with functional users and ITS teams to gather requirements, evaluate enhancements, and interpret specifications.
• Manage SQL Server Agent jobs, logins, and security, while automating existing reporting processes.
• Troubleshoot complex production issues and document defects for project managers and business leads.

Required Skills

• 5-7 years of overall business experience, including at least 4 years in reporting and SQL development.
• 3+ years of experience working with SSIS, preferably within a professional services firm.
• Advanced expertise in Microsoft SQL Server and RDBMS management.
• Strong T-SQL development skills, including complex data structures, indexes, stored procedures, cursors, and dynamic SQL.
• Experience with performance tuning and database management.
• Proficiency in VB.NET and Visual Basic for application support and ETL script tasks.
• Ability to reverse engineer existing ETL processes and VB.NET applications.
• Proven experience designing, building, installing, and configuring Microsoft SQL Server.
• Bachelor's degree.

Key Skills

Education

Bachelor's degree