Sr Business Analyst - Production Operations

Are you looking for an opportunity to define your future in the commercial real estate industry based on your own unique skills and experience

Whether your talents lie in marketing operations finance human resources management or something different altogether youll find flexibility and a sense of belonging at Berkadia. Were committed to a culture that strives for excellence a place where your contributions are valued you are empowered to create positive impact and you can grow your career. Be Your Best Self. Be Berkadia.

The Senior Analyst Production Operations Analytics plays a crucial role in supporting the strategic decisionmaking of the Production Leadership team and network by leveraging data analytics to generate strategic insights and enhance operational performance. Responsibilities include extracting and analyzing key metrics from Salesforce Power BI and Excel managing and tracking Production budgets developing and maintaining a catalog of business reports and dashboards in Power BI and Salesforce and running projects from inception to completion. This position will work closely with crossfunctional teams to implement process improvement improve efficiency and ensure the ongoing advancement of Berkadias Production function.

We Innovate to shape the future of CRE so in this role you will:

• Extract and analyze data related to key production metrics using Power BI dashboards Salesforce reports and Accounting MRS Excel pivot tables to drive strategic insights and decisionmaking;
• Develop and customize Salesforce reports and Power BI dashboards to meet the specific needs of Production Leadership and the Production network ensuring timely and accurate data delivery;
• Monitor and maintain key performance indicators (KPIs) to assess the performance and efficiency of the Production network supporting Monthly Production CheckIns and Quarterly Business Reviews;
• Manage Mortgage Banking and Investment Sales marketing budgets including the development of annual budgets review of yearend penalties and ongoing management of expense dashboards in Power BI;
• Address adhoc Marketing requests for external publications and provide biyearly production metric summaries at office specialty and lender levels;
• Conduct analysis of Berkadias market presence to identify strategic opportunities for recruitment and expansion in key markets and teams;
• Facilitate the onboarding process for new producers by vetting client lists and assisting with the creation of new accounts to ensure seamless integration into the organization;
• Research and evaluate direct competitors market share using RCA and analyze overall industry trends to inform strategic positioning and competitive advantage;
• Perform monthly maintenance of Power BI dashboards including updating support files and managing security groups to ensure data integrity and accessibility;
• Provide information to management via written oral and PowerPoint presentations by assembling and summarizing data presenting findings performing detailed analysis and delivering possible recommendations or strategies for change;
• Identify and implement opportunities for process improvement providing actionable insights and executing recommendations to enhance operational efficiency;
• Collaborate with crossfunctional teams to deliver solutions and support to the Production network;
• Assist in driving initiatives for process improvement and policy development within the Production function;
• Undertake adhoc projects analyses and reports as assigned by Production Leadership.Other duties as assigned.

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

• Proficiency in Microsoft Office suite including Outlook Word PowerPoint and Teams with a demonstrated ability to leverage these tools for efficient communication and collaboration;
• Advanced expertise in Microsoft Excel;
• Formula creation (e.g. SUM AVERAGE COUNTIF VLOOKUP IF INDEXMATCH etc. data analysis tools (e.g. PivotTables charts graphs filters) data management (e.g. data validation sorting conditional formatting) and Power Query (e.g. create edit manage external connections);
• Strongproficiency in Power BI;
• Data sourcing (e.g. SQL Excel SharePoint) data transformation (e.g. Query Editor clean transform M formula language group pivot data modeling e.g. DAX calculated columns calculated measures) data visualization (e.g. matrixes tables cards) and analytical thinking to drive actionable insights;
• Basic SQL proficiency including ability to write simple SQL queries for data retrieval and manipulation including SELECT statements basic aggregations JOIN operations for combining data from multiple tables and data updates with a foundational understanding of relational database concepts and a willingness to further develop SQL skills;
• Experience with Salesforce CRM or other CRM highly preferred demonstrating familiarity with customer relationship management and exhibiting proficiency in modifying existing reports building new reports and dashboards logic filtering and custom calculated columns
• Experience with RCA preferred exhibiting understanding of industrystandard tools for market analysis;
• Demonstrated ability to manage multiple simultaneous projects including maintaining project tasks coordinating work efforts across teams and consistently meeting deadlines;
• Proven capability to work independently with minimal oversight and without frequent guidance;
• Exceptional organizational skills and ability to multitask effectively in a fastpaced environment with competing priorities;
• Strong critical thinking skills and ability to interpret requirementsevidenced by examples of analyzing information solving problems and making sound judgments based on experience and data;
• Meticulous attention to detail and ability to conduct quality control checks ensuring accuracy and precision in alldeliverable;
• Ability to manage both longterm strategic projects and adhoc urgent requestsmaintaining clear communication with stakeholders regarding potential delays due to conflicting priorities;
• Proactive cando attitude characterized by making suggestions and providing options rather than waiting for direction fostering a culture of innovation and continuous improvement;
• Excellent verbal and written communication skills capable of engaging effectively with all levels of an organization to convey information clearly and persuasively.
• Bachelors degree or equivalent.
• 35 years of 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 12weeks of fully paid parental leave
• Mental health care including free counseling sessions:
• Well help you fund your learning journey with generous tuition reimbursement
• Pet insurance discounts
• And more!

Be Your Best Self. Be Berkadia.

#LIHF1 #LIHYBRID

Berkadia as an equal opportunity employer celebrates our employees unique differences which we believe drives personal and companywide innovation and creates a peoplefirst culture where your career can take the long view. To achieve these goals we are committed to the full inclusion of all qualified individuals without regard to race religion age color national origin gender sexual orientation gender identity or expression marital status domestic partner status military and veteran status disability pregnancy parental status genetic information political affiliation or any other status protected by federal state and local laws.

In keeping with our commitment Berkadia takes the necessarysteps to provide a workplace free from harassment and discrimination as well as access and reasonable accommodations for individuals with you require reasonable accommodation to take part in the interview process please contact

You have rights under Federal and State employment laws. 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. If you apply for this role you are acknowledgingBerkadias Application PolicyandBerkadias Privacy Policy. Please click the following links for more information about:EEOCEmployee Rights under the FMLAEPPA.