Job Description:

Note: this position will start on a remote basis due to COVID, but will eventually require on-site work in Montvale, NJ.  Looking for candidates who are currently commutable to Montvale, NJ.  

Duties

• As part of the Reporting Team, candidate will gather, coordinate and be responsible for providing technical reporting capabilities in support of the global risk applications. Responsible to liaise with functional users and team members to gather business requirements, analyze reports to ensure business goals are achieved and quality is maintained, liaise with other group members and IT teams to evaluate enhancements. Support the Business Process Help Desk teams, Business Leads, Upper Management, & Compliance teams.
• Candidate will also document issues and defects, liaise with the Reporting Project Manager, IT Development teams, and Business Leads to keep all concerned parties informed.
• 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.
• Provide development estimates and participate in project planning. Learn and prototype new technologies, and recommend their use in future reporting solutions
• Maintain detailed commentary in all SQL scripts and diligently report all activity (requirements gathering, development time and implementation) in the Project Activity Application
• Document issues and defects, while liaising with the reporting manager, development teams, and business leads to keep all concerned parties informed
• Ask logical questions to ascertain requirements /needs. Communicate with teams the technical implications, including extractions of data, processing of data, and the delivery of reports.
• Liaise with application end users and team members to define report requirements, participate in group projects and support the business process help desk teams. Collaborate with team business leads and IT development teams to understand application and database structure changes and enhancements. Participate in business design sessions
• Evaluate and propose solutions for business requirements that impact the application
• Participate in the Deployment and Implementation of Projects