Are you looking for an opportunity to bring your unique skills and experiences to a leading commercial loan servicer?

Join Berkadia's loan servicing platform and learn from the best of the best at the largest U.S. non-bank commercial mortgage servicer in the industry. We provide the personal and professional development opportunities you need to impact the commercial real estate industry, build a career that takes the long view, and reach your full potential. Be Your Best Self. Be Berkadia.

This position involves high visibility with internal and external clients through report creation and delivery.  The candidate will serve as a report expert utilizing IBM Cognos  Power BI, and other applications to support internal servicing and corporate teams with both routine and complex reporting needs. 

We are committed to growing your career, so in this role you will:

• Provide analytical and reporting support and solutions to the Loan Servicing department.
• Design, implement, and maintain relational database systems ensuring efficient data-joins to support multi-source data integration.
• Utilize tools like BI, SQL, Advanced Excel, and Python to meet operational needs.
• Develop and automate advanced analytics, Power BI dashboards, and reporting solutions.
• Create and manage complex Cognos dashboards and data models.
• Troubleshoot and resolve report, database and scheduling issues.
• Develop and optimize advanced SQL Server queries.
• Experience with ETL processes, data warehousing and multi-source data consolidation.
• Manage scheduled reports for external and internal recipients.
• Ensure company branding (Berkadia and Private Label) on reports and letters.
• Create and distribute recurring monthly Senior Management and Rating Agency reports.
• Perform other duties and project as assigned.

We are passionate about your growth, so to achieve success in this role you should have: 

• Professional report development skills, including creating various report types.
• Experience in report schedule management and data modeling a plus.
• Strong understanding of relational databases and SQL, particularly with Microsoft SQL Server and SQL Server Management Studio.
• Excellent communication and time management skills.
• Knowledge of Loan Servicing/Financial data and systems a plus, especially McCracken’s Strategy Commercial Loan Servicing system.
• Ability to work independently with minimal supervision.
• Proficiency in Microsoft products, advanced SQL queries and joins (inner/outer, cross/Cartesian), Python, Advanced Excel, Power BI, Cognos Analytics, dashboard development, and reporting framework.
• Experience with JavaScript, TypeScript, and integrating machine learning models is beneficial, along with building data solutions using React, Python, and SQL.
• Strong user testing and quality assurance skills.
• Ability to collaborate with business users and the IT department.
• Bachelor’s degree or equivalent
• Three to five years prior experience in a similar position. 

We believe People Matter, so we offer benefits that go beyond:

• Monthly paid volunteer hours and donation matching to benefit our communities 
• Employee Resource Groups that help you grow with us
• Fertility and family planning services  
• Up to 12-weeks of fully paid parental leave   
• Mental health care, including free counseling sessions:  
• We'll help you fund your learning journey with generous tuition reimbursement 
• Pet insurance discounts 
• And more! 

Be Your Best Self. Be Berkadia. 

#LI-EP1 #LI-HYBRID