Operational Controls SQL Developer

Operational Controls SQL Developer

Requirements

• Bachelor’s degree in business, computer science, mathematics, or related field.
• 2-4 years’ experience as a data or reporting analyst in a financial setting or related technical certifications.
• 2-4 years in T-SQL stored procedure programming and optimization.
• 2-4 years in Tableau dashboards & data visualization, or Associate-level Tableau Certification.
• Proficiency of DQL, DML, and DDL T-SQL commands.
• Proficient in Excel reporting & analysis (must know formulas, pivots, lookups, Power Query).

Responsibilities

• Define what the problem is, where it exists, and how it can be fixed.
• Exhibit strong communication and listening skills, focused on interpretation of business requirements, and understanding potential obstacles with rule or control implementation.
• Excel in a team-oriented, collaborative environment while contributing to the creation, design, and implementation of high-visibility value-add, loan exception, and business reporting and controls that ensures adherence to regulatory and investor requirements, operating practices, and company policy.
• Collaborate with servicing departments to identify and understand existing business timelines, rules, and exceptions, ensuring accuracy and integrity throughout the process.
• Create insightful dashboards using Tableau to assist leadership teams with business decision making, employee performance evaluation, KPIs/OKRs, and loan level exception & control reporting.
• Leverage MS SQL Server data warehouse to source required and create trustworthy code logic used to identify loan exceptions and control flag populations.
• Adhere to and recommend improvements to project coding standards, in-line QC, and stored procedure optimization.
• Work in a team environment with shared code; disciplined use of source code control (TFS) and process documentation.
• Assignment of high-visibility reporting projects related to regulatory, investor, compliance, senior leadership, or internal audit.
• Be able to clearly articulate and present ideas and findings to a varied audience including the operational controls staff and senior management.
• Performs related duties as assigned by management including but not limited to ad hoc reporting and cross-training.

Preferred Qualifications

• Mortgage industry experience preferred.
• Experience with Tableau, Power Platform, Visual Studio, SharePoint, Python, R, and Visio a plus.
• Natural entrepreneurial interest is a plus.