IT Team Lead/ Sr IT BSA/ Database Support Analyst, Anaheim Ca (ONSITE REQUIRED)

CGS Business Solutions is committed to helping you, as an esteemed IT Professional, find the next right step in your career. We match professionals like you to rewarding consulting or full-time opportunities in your area of expertise. We are currently seeking Technical Professionals who are searching for challenging and rewarding jobs for the following opportunity:

Our Financial client close to Anaheim, Ca is looking for a long-term contract-to-hire a technical Team Lead- Business System Analyst/ SQL Database Support Analyst reporting to the CIO to join the IT team in support of the Business and their core retail loan Servicing platform.  As a business savvy Technical Business System Analyst/ SQL Data Integration Analyst, you will be responsible for managing processes and enhancements of the Loan Servicing system and asset management business departments as well as be responsible for the maintenance of the Loan servicing system, borrower portal and supporting custom applications. This position will interact with internal and external stakeholders and serve as a key point of contact between our client and the Servicing System vendors. This is a position where the successful candidate will thrive under minimal supervision and direction.

Where you’re located: ONSITE in Anaheim, Ca WILL BE REQUIRED- relocation from out of state will be considered for the right candidate.

SKILLS and EXPERIENCE:

• 3-5+ years of experience domain knowledge with either support of core Banking application experience, Mortgage Servicing or Loan Originations or personal or auto loans within Finance Industry environment
• Able to interact with the VP or C-level Business Executives and higher to gather requirements and collaborate with IT; working effectively and independently as well as be collaborative team-oriented team player.
• Ideally supported Mortgage servicing systems such as Black Knight’s MSP, Sagent, Finastra’s Fusion Servicing Director, Interlinq Loan Servicing (ILS) or other loan servicing platform OR support of other core banking or originations platform
• Some experience with the following core technologies: T-SQL; SQL Server 2016 or higher; Visual Studio 2017 or higher; SQL Server Data Tools; Team Foundation Server
• Working knowledge of T-SQL programming and scripting, as well as optimization techniques

• 3 years of experience with a strong focus on SQL Relational databases, application and data integration (ETL), Data extractions, cleansing and integration.

• Some Report development experience
• Working knowledge of integrating applications using APIs
• Strong analytical, problem solving, collaboration and technical skills
• Able to work well under deadlines in a changing environment and perform multiple tasks effectively and concurrently.
• Organized and detail-oriented

• Bachelor’s degree or equivalence experience, ideally in Information Systems or Computer Science.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Work closely with executive management and end-users to create and evaluate business requirements to support the delivery of effective data solutions.
• Assist in the design, develop and deploy solutions to support integration with enterprise applications, SaaS applications and other vendor data.
• Manage Mortgage Servicing and Customer Portal: Configure, monitor, maintain and upgrade the system. Execute and monitor End of Day and End of Month processing. Board newly acquired loans into the system. Apply batch updates and data extracts via SQL server.
• Apply system updates from vendor.
• Perform Report & ETL Development: Create, update, and maintain Crystal Reports and SSRS Reports
• Create, update, and maintain SSIS packages.
• Create, update, and maintain ETL packages for system integration. Maintain ETL process jobs and respond to critical data load issues during off hours.
• Create and maintain documentation of processes, databases, applications, and procedures as per department policy.

About CGS Business Solutions:
CGS specializes in IT business solutions, staffing and consulting services. With a strong focus in IT Applications, Network Infrastructure, Information Security, and Engineering. CGS is an INC 5000 company and is honored to be selected as one of the Best IT Recruitment Firms in California. After five consecutive Fastest Growing Company titles, CGS continues to break into new markets across the USA. Companies are counting on CGS to attract and help retain these resource pools in order to gain a competitive advantage the rapidly changing business environments.