Portfolio Analytics & Strategy Analyst Senior - Data, Modeling & Analytics
for section headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We must not repeat job title as heading. Must not include Job ID etc. Remove boilerplate. Preserve all substantive info. We need to parse the job posting. Key sections: - Position Overview / At PNC ... (intro) maybe "About the role" heading. - Role Overview: description of tasks. - In This Role, You Will: bullet list. - Preferred Skills And Experience: list. - Job Description: more description. - PNC Employees take pride... (maybe part of responsibilities or values) but could be part of "About the role" or "Responsibilities". - Qualifications: includes Preferred Skills, Competencies, Work Experience, Education, Certifications, Licenses, Language Assessments. - Pay Transparency: base salary range. - Benefits: description. - Disability Accommodations Statement, EEO, etc: boilerplate to remove. - Application Window: maybe not needed? It's metadata; could be omitted or folded into short p? The instruction: do NOT put Job ID / requisition numbers as headings — fold minor metadata into a short
or drop it. Application Window is minor metadata; we could drop or include as a short p. Probably drop. We need to include sections only when posting has real specific content. We have content for: - About the role (intro about PNC, location, role overview). Could be under "About the role". - Responsibilities: we have "In This Role, You Will" bullet list, also Job Description details, also maybe "PNC Employees take pride..." but that's more values. - Requirements: maybe not explicit; but we have Preferred Skills And Experience, Qualifications (Education, Experience). Could be under "Requirements" or "Qualifications". The instruction says we can use headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to decide which to use. We have content for Skills (Preferred Skills And Experience). Also Qualifications (Education, Experience, Certifications). Could combine. We have Pay (base salary range). Benefits (description). No Schedule info. Thus we will output sections: About the role, Responsibilities, Skills, Qualifications, Pay, Benefits. We must not create Schedule section. We must not create Requirements if we don't have explicit; but we could treat Qualifications as covering requirements. However we have both Qualifications and Skills headings allowed. We'll use both. We need to use
- for any list of duties/requirements/benefits. So for bullet lists we need
- .
Prose in
. We must preserve all substantive info; not invent or summarize away detail. Let's extract content. About the role: - At PNC, our people are our greatest differentiator... (first paragraph) - As a Portfolio Analytics & Strategy Analyst Senior within PNC's Data, Modeling & Analytics Credit Card Modeling organization, you will be based in Pittsburgh, PA, Cleveland, OH, Wilmington, DE or Tysons Corner, VA. - Role Overview: This position will support the accurate and timely execution and reporting around PNC’s retail lending models, particularly for CECL and CCAR credit loss forecasting. The candidate will use Python, PySpark, and SQL for model execution and data analytics, as well as for other operational processes supporting CECL/CCAR. We are seeking candidates who are effective communicators and who enjoy tackling complex problems. In this role, you will translate knowledge of PNC’s lending products, data, and models into actionable insights for senior management. We can combine into a few paragraphs. Responsibilities: - In This Role, You Will: - Write code for data stitching, data validation, model output analysis, and similar tasks - Create effective PowerPoint reports and document methodologies - Generate tables and figures for presentations and ad hoc requests - Explain the work and approach to internal and external personnel - Learn and explain domain knowledge from business partners - Job Description (the longer paragraph after "Job Description Provides financial and regulatory reporting..."): we need to keep that as prose. - Also maybe "PNC Employees take pride..." but that's more values; could be part of Responsibilities or About the role. Might be considered part of responsibilities? It's about expected behaviors. Could be included as a paragraph under Responsibilities. We'll include that as a paragraph. Skills: - Preferred Skills And Experience list: - 2 years’ experience with Python (or R/C/C++) as primary programming language - 2 years’ experience with data visualization (e.g., Matplotlib, Tableau, Excel) - Experience with PySpark, Pandas, NumPy, Scikit-learn, Slurm, SQL - Familiarity with IT infrastructure and the command line / bash / os.system() - Experience with automation through readable and reusable code - Experience with managing Python libraries and following basic software development practices - Knowledge of regulatory credit loss (CECL/CCAR) processes and broad knowledge of bank balance sheets - Knowledge of statistical modeling and model lifecycle procedures within the financial services sector We'll put as
- .
Qualifications:
- Includes Preferred Skills (but we already used that). Actually Qualifications section includes: Preferred Skills, Competencies, Work Experience, Education, Certifications, Licenses, Language Assessments.
We need to avoid duplication. Since we already used Preferred Skills under Skills heading, we should not repeat them under Qualifications. Instead Qualifications heading can contain Competencies, Work Experience, Education, Certifications, Licenses, Language Assessments.
Let's extract:
Competencies list: Analytical Approach, Banking Products, Big Data Management and Analytics, Business Analytics, Credit Risk, Mathematics of Financial Instruments, Operational Risk, Performance Measurement, Predictive Analytics, Pricing Models and Analytics, Regulatory Environment - Financial Services, Risk Management Banking
Work Experience: 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.
Education: Bachelors
Certifications: No Required Certification(s)
Licenses: No Required License(s)
Language Assessments: No Required Or Preferred Language Assessments
We need to preserve all substantive info; we can include these as prose or lists.
We'll output as
for prose, maybe
- for competencies list.
Pay:
- Pay Transparency Base Salary: $86,250.00 – $143,750.00 Salaries may vary based on geographic location, market data and on individual skills, experience, and education. This role is incentive eligible with the payment based upon company, business and/or individual performance.
We'll put as
- Write code for data stitching, data validation, model output analysis, and similar tasks
- Create effective PowerPoint reports and document methodologies
- Generate tables and figures for presentations and ad hoc requests
- Explain the work and approach to internal and external personnel
- Learn and explain domain knowledge from business partners
- Analytical Approach
- Banking Products
- Big Data Management and Analytics
- Business Analytics
- Credit Risk
- Mathematics of Financial Instruments
- Operational Risk
- Performance Measurement
- Predictive Analytics
- Pricing Models and Analytics
- Regulatory Environment - Financial Services
- Risk Management Banking
. Benefits: - PNC offers a comprehensive range of benefits... (list). We'll keep as
maybe with
- for list? The benefits description includes many items separated by semicolons. Could be a list but not explicitly bullet. We'll keep as
preserving the text. We must not include boilerplate like Disability Accommodations, EEO, etc. Now construct HTML. We'll start with
About the role
then... maybe multiple paragraphs. We need to ensure we don't repeat content. Let's craft. About the role paragraph(s): Paragraph 1: 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. Paragraph 2: As a Portfolio Analytics & Strategy Analyst Senior within PNC's Data, Modeling & Analytics Credit Card Modeling organization, you will be based in Pittsburgh, PA, Cleveland, OH, Wilmington, DE or Tysons Corner, VA. Paragraph 3: Role Overview: This position will support the accurate and timely execution and reporting around PNC’s retail lending models, particularly for CECL and CCAR credit loss forecasting. The candidate will use Python, PySpark, and SQL for model execution and data analytics, as well as for other operational processes supporting CECL/CCAR. We are seeking candidates who are effective communicators and who enjoy tackling complex problems. In this role, you will translate knowledge of PNC’s lending products, data, and models into actionable insights for senior management. That covers About the role. Responsibilities heading:
Responsibilities
We need to include bullet list from "In This Role, You Will" and the Job Description paragraph and the PNC Employees take pride paragraph. We'll do:for 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." Then a
for PNC Employees take pride: "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." Now Skills heading:
Skills
- list of Preferred Skills And Experience.
We'll copy each bullet.
Now Qualifications heading:
Qualifications
We need to include Competencies list, Work Experience, Education, Certifications, Licenses, Language Assessments. We can do:Competencies:
Work Experience: Roles at this level typically require a
- .
Qualifications:
- Includes Preferred Skills (but we already used that). Actually Qualifications section includes: Preferred Skills, Competencies, Work Experience, Education, Certifications, Licenses, Language Assessments.
We need to avoid duplication. Since we already used Preferred Skills under Skills heading, we should not repeat them under Qualifications. Instead Qualifications heading can contain Competencies, Work Experience, Education, Certifications, Licenses, Language Assessments.
Let's extract:
Competencies list: Analytical Approach, Banking Products, Big Data Management and Analytics, Business Analytics, Credit Risk, Mathematics of Financial Instruments, Operational Risk, Performance Measurement, Predictive Analytics, Pricing Models and Analytics, Regulatory Environment - Financial Services, Risk Management Banking
Work Experience: 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.
Education: Bachelors
Certifications: No Required Certification(s)
Licenses: No Required License(s)
Language Assessments: No Required Or Preferred Language Assessments
We need to preserve all substantive info; we can include these as prose or lists.
We'll output as
- .
Prose in