Member Service Representatives

MSR Operations Analyst Coral Gables, FL Job Details Full-time $68,000 - $76,000 a year 1 day ago Benefits Health insurance 401(k) matching Qualifications Performance dashboard reports Dashboard development Master's degree in business administration Microsoft Excel Data Integration (Data management) Financial data reconciliation Microsoft Access Microsoft Outlook Writing skills Process improvement Data reporting Research Mid-level Improving operational efficiency SQL Analysis skills Project management Bachelor's degree Data quality monitoring SQL Server Management Studio Forecasting Data validation 1 year Root cause analysis Cross-functional collaboration Master of Business Administration Communication skills Python Excel data analysis Stakeholder management Full Job Description Overview: This position supports the analytical efforts of the MSR Transaction Management and Collateral teams to improve the MSR operational processes. The MSR Operations Analyst will be responsible for managing operations data from multiple clients and platforms, including supporting initiatives for data integrity and normalization. Supports the collateral team in integrating data required to manage and report on custodial feeds, pool issuance reports, and internal data repositories. Responsible for conducting research and analysis on collateral data and reporting to respective teams and management. Supports the transaction team in reconciling new loan data and performing edit checks to ensure data integrity in the database. Will require the ability to build database tables and create SQL queries to support operational improvement. This is a fully remote position that offers a competitive salary range of $68,000 to $76,000, plus an annual bonus. You'll also receive our excellent benefits package, which includes medical coverage starting on day one and a company-matched 401(k). Compensation may vary based on experience, location, and other job-related factors. Although this is a remote position, candidates are welcome to work out of any office they'd like. Office locations include Coral Gables, FL; Fort Lauderdale, FL; or Horsham, PA. 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. Qualifications: Bachelors or MBA graduates, in any concentration that has exposure and experience in the relevant technical skills, or equivalent work experience, are desired. Previous experience, 1+ years, in an analytical or reporting environment is a plus. Proficiency with Microsoft Office Suite (Outlook, Excel, PowerPoint, Word, Access). Previous experience with operations data preferred. Advanced proficiency in MS Excel and MS Access. Experience working with Microsoft SQL Server Management Studio. Python programming knowledge recommended. Highly organized in nature. Ability to work under pressure, meet deadlines, and maintain focus. Ability to maintain confidentiality. Strong oral and written communication skills. Strong analytical and problem-solving skills. Lakeview Loan Servicing, LLC is an Equal Employment Opportunity employer. All aspects of consideration for employment and employment with the Company are governed on the basis of merit, competence, and qualifications without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, or any other category protected by federal, state, or local law. Apply tot his job Apply To this Job