Business Analytics Lead

PNC • Pittsburgh, PA

1d

About The Position

The PNC Financial Services Group, Inc. seeks a Business Analytics Lead in Pittsburgh, PA. Specific duties include: (1) lead analytics across retail lending to deliver data-driven solutions; (2) consult with stakeholders and mentor team members on tools, strategies, and best practices; (3) define analytics, oversee development and enhancements; (4) optimize analytical solutions to support executive decision-making; (5) interpret complex results and communicate actionable insights to stakeholders; (6) source, analyze, and visualize data for clear, impactful reporting; (7) partner with business leaders to implement KPIs and KDEs; (8) ensure a single source of truth across the organization; (9) manage end-to-end deliverable lifecycles within agile teams; and (10) provide technical, analytical, and problem-solving expertise throughout projects. Position requires a Bachelor’s degree in Computer Science, Software Engineering, Computer Engineering, Information Technology, or CIS, plus 5 years of experience designing, building, and maintaining data, reporting, and analytical systems and building advanced end to end decisioning control framework in or for the financial services industry. Must have experience with: (1) developing, maintaining, and optimizing Elastic and Tableau dashboards, including management of Elastic clusters and Tableau Server user groups; (2) developing complex SQL (including stored procedures, functions, materialized views, common table expressions, analytical functions, performance tuning, and partitioning) and ETL processes (aggregations, complicated joins, rank, union, lookup, and custom user defined functions) with advanced features and functionality of multiple data sources (Oracle, SQL, Teradata, MS SQL Server and Hadoop); (3) automating (incremental processing, dependency and schedule management, and error checking) and maintaining complex data transformation pipelines (Kafka topic, Java streaming, Elastic, Tableau Prep, Python and SAS); and (4) experience, in or for the financial services industry, performing the following: (a) utilizing Retail Lending systems, application and loan decisioning and servicing data models (FICO DM, Empower, OLNACS, EDS, MSP, ACLS, or FDR), and support of analytics and reporting; (b) interviewing business users; (c) identifying functional and technical requirements; and (d) converting use cases into technical designs (LLD and User Case Diagrams) and solutions (prototypes and mock-ups) as part of an agile software development process (Jira and Confluence). Benefits PNC offers employees a comprehensive range of benefits to help meet your needs now and in the future. Depending on your eligibility, options for full-time employees include medical/prescription drug coverage (with a Health Savings Account feature); dental and vision options; employee and spouse/child life insurance; short- and long-term disability protection; maternity and parental leave; paid holidays, vacation days and occasional absence time; 401(k), pension and stock purchase plans; dependent care reimbursement account; back-up child/elder care; adoption assistance; educational assistance and a robust wellness program with financial incentives. To learn more about these and other programs, including benefits for part-time employees, visit pncthrive.com. Disability Accommodations Statement If an accommodation is required to participate in the application process, please contact us via email at [e-mail]. Please include “accommodation request” in the subject line title and be sure to include your name, the job ID, and your preferred method of contact in the body of the email. Emails not related to accommodation requests will not receive responses. Applicants may also call 877-968-7762 and say "Workday" for accommodation assistance. All information provided will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. At PNC we foster an inclusive and accessible workplace. We provide reasonable accommodations to employment applicants and qualified individuals with a disability who need an accommodation to perform the essential functions of their positions. Equal Employment Opportunity (EEO) PNC provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law. 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 California Consumer Privacy Act Privacy Notice to gain understanding of how PNC may use or disclose your personal information in our hiring practices. For nearly 160 years, PNC has strived to make a meaningful impact for our employees, customers, communities, and shareholders. We believe our success and positive reputation are built on open and honest dialogue, an unwavering focus on smart risk management, relationship-based customer service and community investments. Our inclusive workplace allows our employees to be heard, valued, and developed to do their best work. Being a great place to work means we are making a lasting difference for everyone we serve. Check out the top reasons to join PNC. PNC’s total rewards package includes things like time off, benefits, learning and career development, wellness programs, recognition and much more. The benefits and programs highlighted below are just a sampling of what PNC offers its employees. To learn more, visit our Total Rewards page. If you're not ready to apply yet, or you'd like to learn more about PNC, join the Talent Community to receive regular updates on what's happening at PNC and available career opportunities. Click to join!

Requirements

• Bachelor’s degree in Computer Science, Software Engineering, Computer Engineering, Information Technology, or CIS
• 5 years of experience designing, building, and maintaining data, reporting, and analytical systems and building advanced end to end decisioning control framework in or for the financial services industry
• developing, maintaining, and optimizing Elastic and Tableau dashboards, including management of Elastic clusters and Tableau Server user groups
• developing complex SQL (including stored procedures, functions, materialized views, common table expressions, analytical functions, performance tuning, and partitioning) and ETL processes (aggregations, complicated joins, rank, union, lookup, and custom user defined functions) with advanced features and functionality of multiple data sources (Oracle, SQL, Teradata, MS SQL Server and Hadoop)
• automating (incremental processing, dependency and schedule management, and error checking) and maintaining complex data transformation pipelines (Kafka topic, Java streaming, Elastic, Tableau Prep, Python and SAS)
• experience, in or for the financial services industry, performing the following: (a) utilizing Retail Lending systems, application and loan decisioning and servicing data models (FICO DM, Empower, OLNACS, EDS, MSP, ACLS, or FDR), and support of analytics and reporting; (b) interviewing business users; (c) identifying functional and technical requirements; and (d) converting use cases into technical designs (LLD and User Case Diagrams) and solutions (prototypes and mock-ups) as part of an agile software development process (Jira and Confluence)

Responsibilities

• lead analytics across retail lending to deliver data-driven solutions
• consult with stakeholders and mentor team members on tools, strategies, and best practices
• define analytics, oversee development and enhancements
• optimize analytical solutions to support executive decision-making
• interpret complex results and communicate actionable insights to stakeholders
• source, analyze, and visualize data for clear, impactful reporting
• partner with business leaders to implement KPIs and KDEs
• ensure a single source of truth across the organization
• manage end-to-end deliverable lifecycles within agile teams
• provide technical, analytical, and problem-solving expertise throughout projects

Benefits

• PNC offers employees a comprehensive range of benefits to help meet your needs now and in the future.
• Depending on your eligibility, options for full-time employees include medical/prescription drug coverage (with a Health Savings Account feature); dental and vision options; employee and spouse/child life insurance; short- and long-term disability protection; maternity and parental leave; paid holidays, vacation days and occasional absence time; 401(k), pension and stock purchase plans; dependent care reimbursement account; back-up child/elder care; adoption assistance; educational assistance and a robust wellness program with financial incentives.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level