Business Systems Analyst Consultant - Sql/etl jobs at Pnc in United States, Pittsburgh

The position is primarily based in a PNC location. Responsibilities require time in the office or in the field on a regular basis. Some responsibilities may be performed remotely, at the manager’s discretion.
As a Business Analytics Consultant Sr. in the Retail Distribution Analytics Finance team, you will be a strategic finance partner. You will consult and collaborate closely with the business as well finance. Your value-added analytics and observations will drive strategic decisions and change.Key Responsibilities:
· Create dynamic financial modeling for business cases.
· Measure performance relative to business cases and track investment returns.
· Perform proactive, value-based analysis to make recommendations and provide alternate solutions to the business.
· Leverage Tableau to transform data into actionable insights and visualizations.
· Communicate your performance observations, share calls to action, and identify risks/opportunities to leadership.
**A successful candidate should have strong analytical capability, critical thinking, effective communication skills, and the ability to work both independently and within a team.**Job Description

• Leverages complex analytical tools to provide business and technical expertise for the analytics process, tools and useful applications across multiple functions or business units to create data driven solutions.
• Consulting to clients on tool and strategy implementation and monitoring, statistical scoring, business intelligence, data quality, and analytical product / solution development.
• Determining the optimal analytic approach and supporting development, implementation and enhancements.
• Conceptualizing, developing and continuously optimizing analytical solution for operations and executive management to enable data driven decision making.
• Analyze results and make recommendations for key business partners and senior management or communicate conclusions from complex analytical solutions to a wide range of audiences.

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 requiredneeded to be successful in this position.

Roles at this level typically require a university / college degree, with 3+ years of relevant / direct industry experience. Certifications are often desired. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.No Required Certification(s)No Required License(s)

This position is subject to the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and, for any registered role, the Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE Act) and/or the Financial Industry Regulatory Authority (FINRA), which prohibit the hiring of individuals with certain criminal history.

California Residents

Refer to the

Job Description

• Independently performs advanced quantitative analyses and model development to drive decision-making by running quantitative strategies. Makes recommendations based on analyses.
• Analyzes and develops new model frameworks by supporting the line of business. Refines, monitors, and reviews existing models. Conducts on-going communication with model owners and model developers during the course of the review. Works with larger, more complex datasets to create models.
• Performs quantitative analysis and develops complex reports. Performs qualitative and quantitative assessments of all aspects of models including theoretical aspects, model design and implementation as well as data quality and integrity. Analyzes complex data and associated quantitative analysis. Makes recommendations based on findings from data analytics.
• Uses quantitative tools and techniques to measure and analyze model risks and reaches conclusions on strengths and limitations of the model.
• Prepares and analyzes detailed documents for validation and regulatory compliance, using applicable templates.

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 requiredneeded to be successful in this position.

Analytical Thinking, Credit Risks, Data Analytics, Financial Analysis, Model Development, Operational Risks, Quantitative Models, Risk AppetiteBank Quantitative Analysis, Consulting, Data Gathering and Reporting, Effective Communications, Predictive Analytics, Quantitative Techniques, Regulatory Environment - Financial Services, TestingRoles at this level typically require a university / college degree, with 3+ years of relevant / direct industry experience. Certifications are often desired. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.No Required Certification(s)No Required License(s)

This position is subject to the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and, for any registered role, the Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE Act) and/or the Financial Industry Regulatory Authority (FINRA), which prohibit the hiring of individuals with certain criminal history.

California Residents

Refer to the

Responsibilities include, but are not limited to:• Review and interpret lease agreements, amendments, and renewals for all PNC locations within a given portfolio.
• Maintain accurate lease data and critical dates in lease administration systems.
• Process and reconcile rent, CAM, tax payments, and landlord charges in coordination with Finance.
• Track key dates such as lease expirations, renewals, and termination notice periods.
• Collaborate with Legal, Accounting, Finance, and Facilities teams to ensure lease compliance.
• Work closely with landlords and property managers to resolve billing and lease discrepancies.Preferred experience may include:• Bachelor’s degree in Real Estate, Business, Finance, or related field.
• 2+ years of lease administration or lease analyst experience in retail or commercial real estate.
• Proficiency with lease management platforms (e.g., Tririga, MRI, Yardi, CoStar).
• Strong understanding of lease terms, real estate taxes, CAM, and rent escalations.
• Highly organized with strong attention to detail and time management skills.
• Excellent verbal and written communication skills.
• Power BI, Power Platforms, Excel, Tableau experience.
• Experience supporting a national or regional branch network.Job Description

• Manages a large portfolio of properties with primary duties that include auditing, negotiating and resolving rent payment disputes, resolving property use and resolving eminent domain issues. With an understanding of real estate contracts, abstracts complicated legal documents. Manages workflow of legal documents and analyzes portfolio data to facilitate financial and policy decisions.
• Manages projects that include legal and transactional related workflows. Develops and prepares persuasive presentations for approval, execution, receipt of settlements and abstraction into the data base. Investigates property issues, disputes and government action against PNC property. Manages the easement and condemnation processes for realty services.
• Manages the abstraction of data processes for a large portfolio of properties which includes more than 1,500 owned properties, 1,750 leased properties and a rental obligation of $2.2b and 30 million SF. The risk associated with this role and the critical date obligations are managed through the abstraction process.
• Manages the bonding process for construction projects. Works with internal and external legal teams to produce, review and amend critical legal documents for PNC Realty Services including the evaluation of bond release and the resolution of bonding matters with internal and external customers as well as governmental bodies.
• Manages a portfolio of legal documents, rent-related documents and relevant workflow utilizing multiple internal and external systems and reports to ensure that we are monitoring risk and critical dates.

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 requiredneeded to be successful in this position.

Corporate Finance, Decision Making, Economic Policy, Financial Accounting, Financial Management, Investment Strategies, Real Estate, Real Estate Development, Trading StrategiesRoles at this level typically require a university / college degree, with 2+ years of relevant professional experience. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.No Required Certification(s)No Required License(s)

This position is subject to the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and, for any registered role, the Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE Act) and/or the Financial Industry Regulatory Authority (FINRA), which prohibit the hiring of individuals with certain criminal history.

California Residents

Refer to the

Bilingual Spanish PreferredJob Description

• Builds the retail customer base through proactive, outbound quality sales conversations. Creates customer loyalty and grows customer share of wallet through a differentiated customer experience.
• Sells the bank's products and services to existing and prospective clients outside of branch in non-PNC locations, demonstrating how PNC can help them achieve their financial goals. Identifies and independently acts upon sales opportunities to achieve assigned sales goals. Responsible for establishing connections between clients and PNC partners (ie. PNC Investment, PNC Mortgage, and other consumer loan solutions) based on clients' financial needs and goals.
• Grows customer household relationships through onboarding new clients and building a strong pipeline of appointments for branch and PNC partners. Demonstrates value for customers to achieve greater financial well-being by driving deep needs-based conversations.
• Creates an exceptional customer experience at events in a variety of external locations to drive desired acquisition, customer loyalty and increased share of wallet. Stengthens client relationships through planning continued on-site events.
• Understands PNC capabilities, educates and coaches customers on technology options.
• Selling at non-PNC locations requires: Access to a reliable vehicle transportation for travel to multiple work locations on a daily basis; and the ability to lift and carry up to 25 pounds (inclusive of, but not limited to, marketing materials, collateral and/or other promotional items as required).

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 requiredneeded to be successful in this position.

Roles at this level typically require an Associates or equivalent degree as well as related experience or product knowledge to accomplish primary duties. Typically requires 3+ years experience. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.No Required Certification(s)Candidates being considered for this position will be subject to additional background checks as required by Consumer Financial Protection Bureau regulations.

This position is subject to the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and, for any registered role, the Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE Act) and/or the Financial Industry Regulatory Authority (FINRA), which prohibit the hiring of individuals with certain criminal history.

California Residents

Refer to the

Job Description

• Coaches, mentors and leads tellers by example to deliver a unique customer experience aimed at improving customer financial wellbeing and creating loyalty while increasing share of wallet. Processes a variety of customer interactions. Educates customers on alternatives available for their financial interactions. Identifies banking opportunities during the customer interaction and refers as appropriate.
• Coaches, mentors and leads tellers by example in identifying opportunities through meaningful conversations with customers, making appropriate referrals to branch staff.
• Coaches, mentors and leads tellers by example in performing lobby engagement activities to connect with customers and position PNC products to meet their needs. Educates customers on options for managing financial transactions by leveraging technology, tools and resources.
• Coaches, mentors and leads tellers by example with clear communication skills, transaction handling and problem resolution processes. Assists the Branch Manager in performance management and new hire selection processes.
• Coaches, mentors and leads tellers by example in adhering to all policies and procedures, demonstrating sound judgment within established limits. Ensures teller and branch daily operations and maintenance transactions are completed in an efficient and accurate manner.

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.

• To learn more about this and other opportunities on our team.

Qualifications

Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and requiredneeded to be successful in this position.

Roles at this level typically do not require a university / college degree, high school diploma or GED, but do require related experience or product knowledge to accomplish primary duties. Typically requires 1+ years of related experience. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.No DegreeNo Required Certification(s)No Required License(s)

This position is subject to the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and, for any registered role, the Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE Act) and/or the Financial Industry Regulatory Authority (FINRA), which prohibit the hiring of individuals with certain criminal history.

California Residents

Refer to the

Tuesday-Saturday 11:00 PM to 7:00 AM
Needed skills:• Strong leadership qualities and facilitation skills with the ability to lead large groups of technical and operational support through assessment and mitigation activities, facilitating effective incident management process discipline.
• Big picture thinking to correlate events and incident tickets within the organization as an indication of larger issue and the ability to act on and mitigate impact.
• Excellent written and verbal communication skills with an ability to communicate a technology incident to lines of business in a customer-focused business language to all levels of the organization.
• Strong customer focus and ability to act with a “Sense of Urgency” in facilitating and gaining prompt incident resolution.
• The ability to network, influence and manage across all management and organization levels as well as cultural boundaries without having direct management authority.
• Ability to provide analysis on problem trends and identify process improvement opportunities for continuous improvement.
• 8 + years’ experience in Incident Management, Problem Management or other roles where indirect leadership experience was demonstrated, is desired. Previous experience in a site reliability center (SRC) incident and/or operations management
• Banking or Financial Industries experience is a plus.Job Description

• Provides solutions for IT and business management on applying technology to strategic business opportunities, planning and implementation of cross-functional applications.
• Initiates, owns and drives the identification, evaluation and direction of solutions that are cost effective and meet complex business requirements.
• Serves as the central point of contact for business demand management, technology expenditures, client feedback & relationship management and the overall client experience with the technology organization.
• Manages the consulting services and communications to internal business groups on process improvement projects designed to support product strategies and revenue generation/cost reduction.
• Manages the analysis & elicitation of complex client requirements, and the transformation of requirements into functional/non-functional requirements.

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.

PNC also has fundamental expectations of our people managers. As a manager of talent in PNC, you will be expected to:

• Include Intentionally - Cultivates diverse teams and inclusive workplaces to expand thinking.
• Live the Values - Role models our values with transparency and courage.
• Enable Change - Takes action to drive change and innovation that will transform our business.
• Achieve Results - Takes personal ownership to deliver results. Empowers and trusts others in decision making.
• Develop the Best - Raises the bar with every talent decision and guides the achievement of all employees and customers.

Qualifications

Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and requiredneeded to be successful in this position.

Budgeting, Business Acumen, Consulting, Influencing, IT Project Planning and Organization, Product and Vendor Evaluation, Relationship Management, Requirements AnalysisRoles at this level typically require a university / college degree. Higher level education such as a Masters degree, PhD, or certifications is desirable. Industry experience is typically 8+ years. At least 5 years of prior management experience is typically required. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.No Required Certification(s)No Required License(s)
California Residents

Refer to the

As a Portfolio Analytics & Strategy Analyst Senior within the Real Estate Market Analytics (REMA) group you will be responsible for vetting real estate collateral for potential and existing PNC loans prior to ordering a third-party appraisal. Emphasis is placed on prospective asset performance due to a large level of new construction lending. Analyst will cross-check forward-looking developer proformas with existing market performance using industry leading data sources such as CoStar, CBRE-EA, MSCI, Yardi Matrix etc. and forecast future results. Forecasts include absorption (during lease-up), stabilized vacancy, market rent, rent growth, and concessions. Analyst must have a strong understanding of how local submarket performance is impacted by both MSA/regional and national economic trends and how to forecast appropriate market supply and demand trends.Other functions of the REMA group that the analyst may work on include criticized asset valuations, reconciling appraisal findings to internal underwriting, and quarterly sector studies. Appraisal, brokerage, real estate research, urban planning, macroeconomics, real estate property management, lending, or underwriting skills are all relevant. Argus skills are not required but are helpful.Preferred skills and experience:Word, PowerPoint, Excel (Intermediate)
Strong written and verbal skills
Presentations to Senior Leadership
Job Description

• Provides financial and regulatory reporting and analyses to maintain adequate controls over the financial and regulatory reporting processes. Responsible for running complex business performance, risk and operational analytics. May include the development of analytical methods/models to assess market, credit and/or operational risk of new and existing financial products.
• Leverages business / product expertise to rigorously analyze large datasets, improve risk adjusted returns, deliver profitable growth, and communicate conclusions. Synthesizes analytical results and develops, recommends, and implements business strategies that improve lending decisions, assist in managing risk, increase revenues, reduce exposure to losses, meet business goals, and improve performance. Establishes baselines for strategies and tracks actual performance to expectations.
• Applies predictive models, third party data, and other tools to develop and execute appropriate segmentation and targeting for acquisition and portfolio strategies to provide insight into portfolio risk. Manages engagements with internal and external information suppliers ensuring solution is fit for purpose while maintaining appropriate governance and oversight.
• Works with business, credit, data, and model development partners to design, develop, and monitor test designs and analytical reporting to track and enhance strategies. Designs / enhances standard reporting suites for regular product / portfolio reviews.
• Collaborates with the line of business, Finance, and Risk partners to assess and establish credit risk appetite and to understand its implications, as well as to establish policies and procedures governing the identification, monitoring, and management of risk appetite.

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 requiredneeded to be successful in this position.

Analytical Thinking, Credit Risks, Data Analytics, Financial Analysis, Model Development, Operational Risks, Quantitative Models, Risk AppetiteRoles at this level typically require a university / college degree, with 3+ years of relevant / direct industry experience. Certifications are often desired. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.No Required Certification(s)No Required License(s)

This position is subject to the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and, for any registered role, the Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE Act) and/or the Financial Industry Regulatory Authority (FINRA), which prohibit the hiring of individuals with certain criminal history.

California Residents

Refer to the