Data-Driven Operations Analyst | SQL & Dashboards

Lakeview Loan Servicing, LLC.; Coral Gables (FL); On-site; USD 70,000 - 80,000; Full time

Job summary

Lakeview Loan Servicing, LLC. in Florida seeks an MSR Operations Analyst to support data-driven improvements across MSR Transaction Management and Collateral teams.

You will build SQL queries, develop centralized data repositories, and design dashboards to enhance reporting, governance, and operational efficiency. The role emphasizes data integrity, cross-functional collaboration, and the ability to translate complex data into actionable insights for leadership.

Qualifications

• Bachelor’s or MBA with exposure to technical skills or equivalent work experience
• 1+ years in an analytical or reporting environment preferred
• Proficiency with Microsoft Office Suite (Outlook, Excel, PowerPoint, Word, Access)
• Experience with operations data preferred
• Advanced proficiency in MS Excel and MS Access
• Experience with Microsoft SQL Server Management Studio
• Python programming knowledge recommended
• Highly organized and able to work under pressure and meet deadlines
• Strong oral and written communication skills
• Strong analytical and problem-solving skills

Responsibilities

• Develop and maintain a centralized sql-based data repository supporting collateral management and pool certification activities, ensuring data integrity, governance, and audit readiness
• Lead data quality, reconciliation, and consolidation efforts for loan-level datasets to ensure reporting accuracy and operational reliability
• Analyze databases and operational workflows to identify inefficiencies, conduct root-cause analysis, and implement data-driven process improvements
• Design, automate, and optimize management reporting and dashboards to provide actionable insights for operational and strategic decision-making
• Perform detailed loan-level reconciliations across servicing systems, custodial records, and investor reporting platforms, resolving variances and mitigating risk
• Develop complex sql queries to extract, transform, and analyze data in support of reporting, modeling, forecasting, and departmental initiatives
• Establish standardized analytical frameworks and reporting methodologies to improve operational consistency and scalability
• Manage cross-functional projects and support departmental initiatives, ensuring timely execution and stakeholder alignment
• Provide analytical support for audits, compliance reviews, and leadership requests, along with other duties as assigned

Skills

MS Excel

MS Access

SQL

Python

Analytical skills

Data analysis

Education

Bachelor's degree or MBA

Tools

Excel

PowerPoint

Word

Outlook

Access

Job description

Lakeview Loan Servicing, LLC. in Florida seeks an MSR Operations Analyst to support data-driven improvements across MSR Transaction Management and Collateral teams.

You will build SQL queries, develop centralized data repositories, and design dashboards to enhance reporting, governance, and operational efficiency. The role emphasizes data integrity, cross-functional collaboration, and the ability to translate complex data into actionable insights for leadership.