ETL SSIS Developer

This Developer position has design, development and maintenance responsibility for the software applications and processes associated with our Hedge Fund Operations group. Specifically this role will initially focus on the ETL processes needed to support accounting and performance reporting for hedge fund accounts at the firm. The position provides exposure to multiple business units in a dynamic investment management firm. The role requires functioning as a member of an Agile Scrum team and may require some direct interaction with business users.

This is at least a 6 month contract assignment with the possibility of extension.

Responsibilities

• Design, build, and support ETL processes in support of the Hedge Fund Operations group
• Build integration solutions leveraging SSIS for batch integration and .NET (C#) / IBM MQ for real-time based integration
• Maintain, enhance, and develop new stored procedures within MS SQL Server
• Work collaboratively as part of an Agile Scrum project team
• Build reporting solutions leveraging SSRS
• Design and build web based UIs to support business workflows and backend ETL processes
• Partner with various teams to research, resolve, and document production issues

Qualifications

• Experience designing, building and supporting ETL processes
• Strong database engineering skills on the MS SQL Server platform and knowledge of SSIS required
• Experience with ASP.NET, SSRS, C#, and the .NET Framework a plus; Experience with IBM MQ helpful but not required
• Experience delivering software as part of an Agile delivery team and/or experience in a financial services environment a plus
• Solid knowledge of modern software design principles, concepts, and practices
• Outstanding analytical and quantitative skills; Must have the ability to collaborate and communicate effectively in a dynamic work environment

#LI-JW1