Business Analytics Consultant - Data Reporting

Pittsburgh, PA

Full-time

Onsite

Entry, Mid Level

PNC is a company that values its people as its greatest asset, fostering an inclusive workplace culture. The Business Analytics Consultant will support the Credit and Cash Management Analytics & Reporting team by focusing on data analysis, reporting, and dashboarding to enhance production goals and support business decision-making.

Apply Now

Responsibilities

Support banking production goals through data analysis, reporting, and dashboarding
Build and maintain relationships with line of business partners
Analyze and document business requirements and production specifications related to changes in the data warehouse supporting AMG reporting
Participate in data discovery by identifying, analyzing, and validating additional data sources to meet business needs
Partner with technical teams to define database table structures and data designs
Identify and document system constraints, impacts, and implications of proposed system changes
Develop and maintain dashboards and data visualizations using Tableau or Power BI
Use SQL to analyze datasets, read workbooks, and interpret dashboards
Support automated data refreshes and automated email reporting workflows
Understand how data is stored, structured, and accessed across systems
Collaborate within Agile environments, supporting intake processes and cross team communication

Qualification

Required

Bachelor's degree in business, Analytics, Information Systems, Finance, or related field
1–2 years of professional experience as a Business Analyst, Data Analyst, or similar role
Strong analytical skills with experience working with structured datasets
Proficiency in SQL
Experience with: Python, PySpark, Tableau or Power BI (dashboards and data visualization)
Familiarity with database administration tools (MS SQL Server, Toad, etc.)
Understanding of data storage concepts and how to work with enterprise data
Experience supporting automated refreshes and reporting processes
Ability to read, interpret, and explain dashboards and reporting outputs

Preferred

Strong communication and presentation skills
Proficiency with Microsoft Office (Excel, PowerPoint, Word)
Gen AI knowledge or exposure
Experience using GitHub and Copilot
Working knowledge of Agile methodologies and tools such as Jira
Experience interacting with cross functional teams in an Agile intake process
Familiarity with AMG business and processes
Wealth management or asset management business knowledge
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

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

PNC is a financial service company providing bank deposits products and services to its community.

Glassdoor