Business Analytics Consultant

PNC•Pittsburgh, PA

6d•Onsite

About The Position

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 Analytics Consultant within PNC's Retail Lending organization, you will be based in Pittsburgh, PA. We are seeking a Business Analytics Consultant to join the Retail Lending Reporting and Analytics organization supporting one of the largest and most active analytics sites at PNC. Our team builds and maintains the end to end data pipeline that powers critical Tableau dashboards, a custom JavaScript/HTML reporting portal, and a broad suite of analytics used across Retail Lending business lines. You will play a key role in supporting our reporting capabilities, while growing your analytics and data visualization skills on one of the best data and dashboarding teams at PNC. Be part of a team maximizing loan sales from digital, branch, and care center sales channels and providing executive and product managers decision making and business influencing products.

Requirements

Tableau Desktop
SQL
Problem Solving
Communication
Collaboration
Adaptability
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.
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.

Nice To Haves

Analytical Thinking
Business Intelligence (BI)
Concept Development
Data-Driven Decision Making
Data Integration
Market Research
Performance Metrics
Qualitative Research
Strategic Planning
Analytical Thinking
Business Acumen
Business Analytics
Consulting
Decision Making and Critical Thinking
Effective Communications

Responsibilities

Develop and enhance Tableau dashboards and reports to support business monitoring and performance tracking.
Perform data analysis, data integrity testing, and regression checks to ensure reporting accuracy and consistency.
Support ad hoc analytical requests and projects by partnering with business stakeholders and cross-functional teams.
Gather, document, and track business requirements to support project implementation and reporting enhancements.
Work with data from multiple lending systems to understand business processes and reporting requirements.
Identify data quality issues and collaborate with teams to resolve discrepancies.
Leverages analytical tools to provide business and technical expertise for the analytics process, tools and applications for a business function or business unit to create data driven solutions.
Recommending appropriate performance measures to be produced including lifts, efficiencies, confidence intervals, and other statistical metrics.
Analyzing and processing data, building and maintaining models and report templates, and developing dynamic, data-driven solutions.
Providing business clients with detailed, actionable reports documenting the findings from, data processing, and data analysis.
Consulting on using business intelligence data for predictive analytics and facilitating implementation of new tools and data marts.

Benefits

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
401(k) with PNC match
pension and stock purchase plans
dependent care reimbursement account
back-up child/elder care
adoption, surrogacy, and doula reimbursement
educational assistance, including select programs fully paid
a robust wellness program with financial incentives
maternity and/or parental leave
up to 11 paid holidays each year
9 occasional absence days each year, unless otherwise required by law
between 15 to 25 vacation days each year, depending on career level; and years of service.