Senior Servicing Data Warehouse Analyst

The Opportunity

This position will have high visibility with our internal and external clients based on report creation and delivery.  The candidate will act as a report expert in Cognos (internal system), assisting our internal servicing and corporate teams with reporting needs. 

Responsibilities

  • Provide analytical and reporting support and solutions to the Loan Servicing department.
  • Use any combination of tools (BI, SQL, Excel, Access, etc.) needed to meet operational and managerial needs.
  • Troubleshoot and resolve complex report issues.
  • Develop, update, and maintain SQL Server queries.
  • Manage scheduled reports to both external and internal recipients.
  • Manage company branding (Berkadia and Private Label) on appropriate reports and letters as necessary.
  • Other duties as assigned.

What it takes to be successful in this role

  • Bachelor’s degree or equivalent
  • Three to five years prior experience in a similar position.
  • Provide analytical and reporting support and solutions to the Loan Servicing department.
  • Use any combination of tools (BI, SQL, Excel, Access, etc.) needed to meet operational and managerial needs.
  • Troubleshoot and resolve complex report issues as well as database and scheduling issues.
  • Develop, update and maintain SQL Server queries.
  • Manage scheduled reports to both external and internal recipients.
  • Manage company branding (Berkadia and Private Label) on appropriate reports and letters as necessary.
  • Advanced report creation and distribution of recurring monthly Senior Management and Rating Agency reports.
  • Other duties as assigned.
  • Must have professional report development skills including the ability to create list reports, summary reports, cross-tab reports, charts and free form reports such as forms and letters
  • Report Schedule Management
  • Report data modelling a plus
  • Deep understanding of relational databases.
  • SQL experience especially with Microsoft SQL Server and SQL Server Management Studio
  • Excellent communication and time management skills.
  • A working knowledge of Loan Servicing/Financial data and systems a plus. Preferably an understanding of the McCracken’s Strategy Commercial Loan Servicing system.
  • Must be able to work independently with little supervision.
  • Proficiency with Microsoft Products including Excel, Access and Word.
  • Strong user testing and quality assurance skills.
  • Ability to work with our in-house business users as well as our IT department.

#LI-VB1 #LI-Hybrid

Berkadia, a joint venture of Berkshire Hathaway and Jefferies Financial Group, is a leader in the commercial real estate industry, offering a robust suite of services to our multifamily and commercial property clients. Powered by deep relationships and industry-changing technology, our people sell, finance, and service commercial real estate, providing support for the entire life cycle of our clients’ assets. Our unique ownership structure allows us to put the client’s interests first and creates a marketplace that delivers a superior experience.

Berkadia complies with the law regarding reasonable accommodations for disabled applicants.  Applicants who require reasonable accommodations to participate in the interview process should contact Emma.Petersen@berkadia.com to arrange for such accommodations.

Berkadia is an Equal Opportunity employer and complies with all applicable Federal, State and local laws concerning discrimination in employment.  No question in this Application is intended to elicit information in violation of any such law, nor will any information obtained in response to any question be used in violation of any such law.

By applying to this job opportunity you are acknowledging Berkadia’s Privacy Policy. Applicants have rights under Federal Employment Laws. Please click the following links for more information: EEOC, Employee Rights under the FMLA, EPPA.