BI Developer

BI DeveloperVisa: USC,GC, GC-EAD, H4, L2 Location: New York/New York City Mode: Phone & Skype LinkedIn profile is mandatory Client: Peoples BankJob Description: BI Developer with Crystal reports.Does not need nCino or Salesforce. Should come from a Bank. In office 2-3 days per week. Can work in NYC or Melville LI.Front end system migration to nCino platform will require wholesale changes to all existing data reporting. Focus on the build, support and maintenance of current and new SF management and bank data reporting (Crystal Reports and MS SSRS and SQL Data Extracts). Work with VP- Data and Systems Manager to scale a data architecture which will support the ongoing growth of Financial's nine business channels.Create, update and support MS SQL Reporting Services and Crystal Report packagesAutomate current reporting processes and author SQL queries used for reporting and downstream data processes.Manage the data integration and data migration process between nCino and other application platforms. Coordinates and collaborates with IT to ensure end to end processes are aligned.Designs and codes database objects (tables, views, stored procedures and functions/triggers). Creates table indices to improve performance and troubleshoots/optimizes queries.Extensive experience with Microsoft SQL Server, T-SQL, Visual Studio, and Microsoft SQL Reporting Services required. Knowledge of commercial lending and banking practices. Knowledge of cloud applications and change control.Microsoft SQL Server Reporting Services, Crystal Reports, Microsoft Visual StudioExperienced in Microsoft Office Suite including Excel and Access (preferred). Knowledge of Microsoft SQL Integration Services preferred.Financial Services/ Commercial lending experience (5 years) preferred