Mortgage Servicing Data & Reporting Analyst

BOK Financial Corporation; Dallas (TX); On-site; USD 75,000 - 110,000; Full time

Benefits offered by this job

Discretionary bonus

Job summary

BOK Financial Corporation is seeking a Loan Servicing Reporting Specialist to develop and maintain low to medium-complexity reporting for Mortgage Loan Servicing. The role partners with the servicing line of business to ensure requirements are understood, reports accurate, and solutions meet business needs.

A moderate level of knowledge in SQL, Power BI, SSRS, and Excel is expected with familiarity of BlackKnight MSP data sources.

Qualifications

• Bachelor’s degree with 1-3 years related experience or 5-7 years mortgage banking work experience.
• Strong people-skills with ability to maintain relationships between the Line of Business and Ops Support Group
• Intermediate analytical and problem-solving skills
• Detail-oriented and precise
• Able to begin to identify best practices and proliferate knowledge across the team
• Growing interpersonal skills including verbal and written communication skills; as well as organizational skills
• Familiar with mortgage banking and investor guidelines; FHA, VA, FHLMC, FNMA, GNMA
• In depth knowledge of BOKF servicing policies and procedures
• Intermediate PC and software skills including spreadsheets, statistical tools, word processing and report writers
• Proficient skills for medium-complexity data analysis and reporting in: SQL, Power BI, Excel, VBA Macros and the BlackKnight (MSP) system

Responsibilities

• Stay up-to-date on Power BI, SQL, Excel and related reporting tools.
• Own monthly KPI deck content with senior peers and coordinate data/reports.
• Contribute to monthly Loan Servicing reporting and ad-hoc requests.
• Ensure timely and accurate reporting to leadership and compliance requirements.
• Coordinate with servicing lines of business to translate requirements into reports.

Skills

SQL

Power BI

SSRS

Excel

Data analysis

Education

Bachelor’s degree

Mortgage banking experience

Tools

BlackKnight MSP

VBA Macros

Job description

BOK Financial Corporation is seeking a Loan Servicing Reporting Specialist to develop and maintain low to medium-complexity reporting for Mortgage Loan Servicing. The role partners with the servicing line of business to ensure requirements are understood, reports accurate, and solutions meet business needs.

A moderate level of knowledge in SQL, Power BI, SSRS, and Excel is expected with familiarity of BlackKnight MSP data sources.