דרושים Business Systems Analyst Consultant - Sql/etl ב-Pnc ב-ארהב

Job Description

• Accountable for the operational soundness of the branch and team, specifically the maintenance of security procedures, ensuring audit controls are followed and the support and adherence to compliance and regulatory guidelines. Manages service and operational aspects of a Branch & Business Center branch. Builds a high performing team through the attraction, on-boarding, coaching and development of branch team members. Leads through influence and impacts a broad range of eco-system partners in an omni channel environment. Drives revenue and loyalty through proactive interactions with clients.
• Influences a range of eco-system partners in an omni channel environment. Manages, coaches and executes a proactive client experience within an omni channel environment. Provides solutions and advice to improve client financial well-being. Leads effective problem resolution.
• Fosters a positive working environment that facilitates exceptional service and expanding profitable customer relationships. Grows branch revenue through acquisition and share-of-wallet growth of consumer and business households. Consistently inspects, supports and coaches the branded sales process to proactively achieve sales targets and customer loyalty.
• Drives the employee engagement experience. Responsible for acquiring and retaining talent through the training, coaching and development of employees with a focus on bank protocol, operational processes, policies and procedures. Coaches employees to achieve performance and activity expectations. Leads the performance management process for direct reports.
• Responsible for the Branch & Business Center risk process through proper oversight and adherence to regulatory, security and audit requirements. Trains and coaches team members with operational/risk activities and monitors adherence to policies and procedures. Exercises sound decision making to identify and mitigate potential risk. Manages operational, human capital, reputational and business risk through adherence to established policies and procedures.

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.

Branch Banking Services, Decision Making and Critical Thinking, Digital Awareness, Effective Communications, Managing Multiple Priorities, Sales Management, Selling.Roles at this level typically do not require a university / college degree, but do require related experience or product knowledge to accomplish primary duties. Typically requires 3+ 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 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

• Responsible for leading all aspects of branch performance. Drives revenue and customer loyalty through consultative interactions with clients, and solutions that help them achieve financial well being. Creates a differentiated customer experience, making banking easy in an omni channel environment. Collaborates with a broad range of eco-system partners. Accountable for risk management and compliance . Builds a high performing team through the attraction, on-boarding, coaching and development of branch team members.
• Utilizes a branded sales process to achieve sales targets and customer loyalty. Grows branch revenue through the acquisition and share-of-wallet growth of consumer and business households and through collaboration with eco-system partners. Drives business banking results primarily through business development and community involvement activities. Coaches to consultative selling to drive results and enable customer financial well-being. Has foundational understanding of balance sheet and income statement.
• Manages and coaches to the delivery of a differentiated client experience. Coaches team to confidently engage with customers in technology enabled interactions, providing solutions and advice oriented consultation that improves client financial well-being. Leads effective problem resolution, making banking easy for customers. Connects all of PNC, delivering a seamless customer experience in an omni channel environment.
• Drives the employee experience. Responsible for acquiring and retaining talent through effective onboarding, coaching and development. Makes talent development a priority for all branch team members . Ensures employees achieve performance and activity expectations through effective and ongoing performance management. Models PNC values by cultivating and supporting an inclusive workplace.
• Manages operational, human capital, reputational and business risk. Exercises leadership, authority and sound decision making to mitigate sales practice risk. Ensures compliance with regulatory guidelines and adherence to established policies and procedures.

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.

• 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.

Branch Banking Services, Digital Awareness, Effective Communications, Managing Multiple Priorities, Sales ManagementRoles at this level typically do not require a university / college degree, but do require related experience or product knowledge to accomplish primary duties. Typically requires 3+ 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)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

• Recommends loan solutions in accordance with lending guidelines and clients' requirements.
• Manages a portfolio of customer relationships. Seeks prospective opportunities to retain and/or develop new clients. Responsible for sales calls.
• Develops and prepares loan solutions and refers products and services; reviews documentation to ensure compliance. Manages customer pipeline for efficiency.
• Collaborates with internal and external stakeholders to complete mortgage transactions.
• Collects and analyzes customer financial information for multifaceted and/or complex borrowers.

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 < 1 year of professional experience and/or successful completion of a formal development program. 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)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

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

This 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 manager’s discretion.Job Description

• Executes complex transactions/processes utilizing standard procedures. May have specific responsibility for one or multiple specialized products or functional areas.
• Processes and/or reconciles complex transactions of varying risk and financial value in accordance with established policies and procedures. Identifies and addresses exceptions and serves as a point of escalation for complex transactions. Partners internally with service partners to route calls, documents or other action items to complete transactions. May interact with external customers to complete transactions.
• Ensures the appropriate materials, documentation and capacity are available to complete transactions. Confirms equipment is operational, if applicable.
• Provides consultation and advice to internal and external customers. Reviews existing processes, recommends improvements and may assist with implementation. Participates in and may serves as a subject matter resource for process improvement projects. May assist in training and onboarding of new hires.
• Reviews transactions and related documents and verifies work processes to ensure completeness, accuracy and conformance to established service levels and applicable policies and procedures. May review reports to identify exceptions, monitor quality and ensure compliance. May participate in risk mitigation activities.

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.

Accuracy and Attention to Detail, Effective Communications, Managing Multiple Priorities, Operational Functions, Problem Management Process, Process Management, Products and Services, Standard Operating ProceduresRoles 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)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

As a Financial Wellness Consultant, you will work within the PNC Retail Out of Branch network, a collaborative business segment that delivers comprehensive financial wellness advice and solutions to clients and consumers. You will identify and develop collaborative relationships with human resources decision-makers, or dedicated benefits managers to design a custom program for a client's organization and provide employees of corporate clients with advice and services including financial education, banking benefits and health-based accounts including, but not limited to, Health Savings Accounts (HSAs) and Flexible Spending Accounts (FSAs), student debt solutions, earned wage access (EWA), and retirement plan services. You will employ a consultativeJob Description

• Handles relationship management activities with new and/or existing clients in a book of business to grow sales, revenue and market share with relevant sales goals. Typically works with clients with basic levels of risk and complexity of needs. Generally works with higher degree of supervision.
• With direction, acquires and/or expands and retains client relationships to generate revenue and deepen share of wallet. Handles the origination, financial analysis, negotiation and documentation of credit and non-credit products and services.
• Manages risk/return and drives quality for new and/or existing clients. Actively identifies and mitigates different types of risk, such as regulatory, reputational, operational and credit risks.
• Focuses on client opportunities by providing ideas and insights based on an understanding of the client's needs and their financial well-being. Focuses on increasing client engagement and loyalty.
• Builds an effective network of internal and external relationships, such as community and industry relationships, to actively acquire new clients and/or expand existing clients and enhance the client experience. Focuses on bringing entire bank to the client by presenting the full range of PNC's products and services. Leverages reporting and sales tools to proactively identify and successfully convert sales opportunities.
• As defined with the business, demonstrates ability to analyze, evaluate and mitigate credit risk by utilizing knowledge of credit fundamentals and internal credit policies.

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.Bachelors (Required)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

• Accountable for the operational soundness of the branch and team, specifically the maintenance of security procedures, ensuring audit controls are followed and the support and adherence to compliance and regulatory guidelines. Manages service and operational aspects of a Branch & Business Center branch. Builds a high performing team through the attraction, on-boarding, coaching and development of branch team members. Leads through influence and impacts a broad range of eco-system partners in an omni channel environment. Drives revenue and loyalty through proactive interactions with clients.
• Influences a range of eco-system partners in an omni channel environment. Manages, coaches and executes a proactive client experience within an omni channel environment. Provides solutions and advice to improve client financial well-being. Leads effective problem resolution.
• Fosters a positive working environment that facilitates exceptional service and expanding profitable customer relationships. Grows branch revenue through acquisition and share-of-wallet growth of consumer and business households. Consistently inspects, supports and coaches the branded sales process to proactively achieve sales targets and customer loyalty.
• Drives the employee engagement experience. Responsible for acquiring and retaining talent through the training, coaching and development of employees with a focus on bank protocol, operational processes, policies and procedures. Coaches employees to achieve performance and activity expectations. Leads the performance management process for direct reports.
• Responsible for the Branch & Business Center risk process through proper oversight and adherence to regulatory, security and audit requirements. Trains and coaches team members with operational/risk activities and monitors adherence to policies and procedures. Exercises sound decision making to identify and mitigate potential risk. Manages operational, human capital, reputational and business risk through adherence to established policies and procedures.

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.

Branch Banking Services, Decision Making and Critical Thinking, Digital Awareness, Effective Communications, Managing Multiple Priorities, Sales Management, Selling.Roles at this level typically do not require a university / college degree, but do require related experience or product knowledge to accomplish primary duties. Typically requires 3+ 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 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