Sr Developer Analyst – Print Communications (On-site)

Description

• Manage, execute, and monitor high-risk print production processes; ensure meticulous accuracy and rigorous testing and quality control measures in all data creation, transmission, and reconciliation.
• Analyze and document product requirements with a focus on understanding the implications of every specification due to the high-visibility and high-risk nature of the operations.
• Create reporting post-production to monitor and identify high risk borrower communications.
• Maintain vendor scorecards related to print functions including monthly volume, SLA’s, and issues management.
• Serve as the subject matter expert and provide expert advice for the Print Communications processes and data for internal business partners and leadership, providing guidance and offering solutions.
• Design and build complex, efficient SQL code to meet business objectives and assist with creating automated controls for our print processes.
• Develop and maintain ETL processes.
• Detect issues in processes or data with the authorization to take appropriate measures independently to address or escalate them, ensuring risks are minimized.
• Engage in special projects centered around letter data, ensuring accurate representation and handling of information within and outside of the organization.
• Research and generate quick turnaround ad-hoc reports, as needed.
• Collaborate with other members of the Print Communications department to ensure department objectives are met.
• Track and maintain data for presentation to internal and external clients and vendors in diverse formats including but not limited to monthly volumes, monthly vendor spend, and letter controls.
• Create and maintain documentation for print data and processes using Excel, Word, and Markdown, emphasizing the importance of rigorous accuracy and attention to detail.
• Proactively respond to business needs with minimal to no supervision.
• Perform quality review of peer code and provide constructive feedback.
• Analyze complex reports with the ability to reconcile discrepancies or anomalies to ensure data accuracy and integrity.
• Mentor and train junior team members.
• Perform other duties as assigned by management.
• Stay up to date with the latest trends and technologies in print communications and loan servicing to continuously improve processes and output.

Qualifications And Education Requirements

• Bachelor's degree in Computer Science, Engineering, Business Information Systems, Information Management, or other quantitative discipline with specialization from an accredited college or university.
• 5+ years’ work experience using advanced SQL required.
• Experience with source control such as Team Foundation Server (TFS) preferred.
• System design experience preferred.
• Mortgage Servicing experience a plus.
• General programming experience a plus.
• Experience with Servicing Director, LMS, OnBase, and other systems used by Shellpoint is a plus.
• Additional experience that would be a plus: Azure, Snowflake, Powershell, Snaplogic, Markdown, Smartsheet, or SharePoint.

Skills, Abilities, And Knowledge

• Knowledge of relational database structures required.
• Knowledge and familiarity of various data file structures (delimited, XML, JSON, fixed width) required.
• Advanced skills in Excel (graphs, pivot tables, formulas).
• Must achieve a score of “proficient” or higher on SQL test.
• Strong attention to detail and an ability to multi-task and manage deadlines.
• Able to work well independently and in a collaborative environment.
• Knowledge of SQL Server Reporting Services (SSRS), PowerBI, Tableau, or other reporting tools required.
• Knowledge of SQL Server Integration Services (SSIS) preferred.