Position Overview

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. We work together each day to foster an inclusive workplace culture where all of our employees feel respected, valued and have an opportunity to contribute to the company's success. As a Business Analysis Advisor within PNC's Multifamily Capital organization, you can sit in Kansas City, Louisville, Atlanta, Pittsburgh, Portland or Dallas. Other locations within the PNC footprint will be considered.

As a member of the Business Technology Support team, the person assuming the Business Analysis Advisor role will be focused on providing custom solutions and support for the Enterprise! (SM) Loan Management System. Working closely with our internal business partners, responsibilities will include the development and maintenance of database objects such as reports, stored procedures, and data scripts. The ideal candidate will demonstrate knowledge of commercial real estate as well as an understanding of relational databases.

Preferred Skills & Experience
SQL, T-SQL, or similar programming language
SQL Server Management Studio (SSMS)
SQL Server Reporting Services (SSRS)
Visual Studio
Commercial real estate and/or loan servicing experience
Proficient in Microsoft M365 suite of productivity tools and applications

Job Description

• Directs the research, discovery, collection and interpretation of business requirements. Participates in the development and review of complex processes and procedures, workflow analytics and reporting. May provide senior level consultation and communicates with clients and technology teams on business designs, problem solving and business analysis to support project goals and objectives.
• Consults and recommends the frameworks, methodologies and processes involved in business requirements traceability for business analysis teams. Independently mentors, leads, and coaches other associates to affect knowledge transfer. Oversees the development and maintenance of all applicable policy and procedure documentation.
• Translates business needs, processes and/or procedures by partnering with applicable experts and business stakeholders to determine and articulate needs. May communicate with senior level stakeholders and technology teams on  complex business requirements.
• Leads multiple business analysis project management processes through planning, quality assurance and effectiveness assessment. Provides direction for the successful deployment of projects. Drives the development, analysis and distribution of complex reporting.

PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be:

• Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions.
• Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC's Enterprise Risk Management Framework.

Qualifications

Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and required certifications/licensures