BI Developer - New York, United States - ShiftCode Analytics

Description

Visa: USC,GC, GC-EAD, H4, L2
Location: New York/New York City
Mode: Phone & Skype
LinkedIn profile is mandatory
Client: Peoples Bank

JOB 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 packages
• Automate 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 Studio,
• Experienced in Microsoft Office Suite including Excel and Access (preferred). Knowledge of Microsoft SQL Integration

Services preferred.

• Financial Services/ Commercial lending experience (5 years) preferred