ROLE SUMMARY:

 

The Global Production Operations (GPO) Analyst – Excel Automation is an individual who supports GPO and the production network by creating, developing, maintaining, and improving templates used within various mortgage banking, investment sales, and underwriting teams.

 

 

ROLES and RESPONSIBILITES:

  • Build/maintain Automated Excel templates for GPO and Production network
  • Work exclusively within a specific knowledge area (Macro Express and Visual Basic coding)
  • Collaborate with the Excel liaison and business stakeholders to ensure stakeholder requirements are met and exceeded
  • Understand, consolidate and analyze data from spreadsheets
  • Develop macros in VBA (Visual Basic Applications)
  • Prepare test scripts and run the tests prior to template release on the Production Resources website
  • Prepare training documents for launching the templates and conduct trainings
  • Conduct trainings on basics of Excel for new hires
  • Resolve template or excel related queries from analysts
  • Identify process improvement opportunities and develop solutions to remedy inefficiencies within templates
  • Work on special projects as assigned by managers
  • Perform other duties and tasks as assigned by managers

 

 

SKILLS and COMPETENCIES:

  • Bachelor’s degree in any field required
  • Fluency in English – Good communication skills, both written and verbal
  • Comprehend legal language
  • Knowledge of Commercial Real Estate industry preferred
  • Knowledge of building queries in SQL/VB/MS Excel Macros/maintaining Access Database is required
  • Knowledge of MS PowerBI is preferred
  • Ability to understand key performance indicators and measurements impacting work products
  • Display growth mindset with an openness to upskill
  • Willingness and ability to learn technology tools and drive usage and adoption of tools within teams
  • Ability to work in a dynamic work environment
  • Ability to maintain confidentiality and adhere to organizational policies and procedures

 

DETAILS about the ROLE:

  • Title: Analyst – Excel Automation
  • Department: Global Production Operations (GPO)
  • Report to: Team Leader/Assistant Manager
  • Location: Hyderabad
  • Shift timings: Any, including day, split, night, sunrise
  • Overall People span: Not applicable
  • of Direct Reports: Not applicable
  • Travel: Potential for intermittent domestic and international travel
  • Overtime: Occasionally
  • Work Experience: At least 1 year in CRE industry or any other industry with similar skills

 

 

DISCLAIMER:

While this job description is intended to be an accurate reflection of the job requirements, management reserves the right to modify, add, or remove duties from particular job and to assign other duties as necessary.

About Berkadia:

Berkadia, a joint venture of Berkshire Hathaway and Jefferies Financial Group, is an industry leading commercial real estate company providing comprehensive capital solutions and investment sales advisory and research services for multifamily and commercial properties. Berkadia is amongst the largest, highest rated and most respected primary, master and special servicers in the industry.

Berkadia is an equal opportunity employer and affords equal opportunity to all applicants and employees for all positions without regard to race, color, religion, gender, national origin, age, disability or any other status protected under the law.

Our people are our greatest strength and make Berkadia a great place to work, creating an environment of trust, mutual respect, innovation and collaboration. Our culture is driven by our core values: https://www.berkadia.com/about/vision-and-values.

To know more about Berkadia, please visit our website https://www.berkadia.com/aboutus/

Apply for this Job

* Required

resume chosen  
(File types: pdf, doc, docx, txt, rtf)
cover_letter chosen  
(File types: pdf, doc, docx, txt, rtf)