Business Analytics Consultant – Power BI

PNC

. Leverage complex analytical tools to provide business and technical expertise across functions or business units .

Posted 10/26/2026full-timeUnited StatesJuniorMid-Level💰 $63,750 - $127,500 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates strong analytical capabilities and technical expertise in SQL, Power BI, and Tableau to develop and optimize reporting and analytical solutions. Effectively communicates complex data insights to diverse audiences while consulting on business intelligence and predictive analytics.

Highest-signal resume keywords

SQL ExpertisePower BI ProficiencyTableau DevelopmentAnalytical ThinkingBusiness Intelligence Consulting

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPower BITableauETL ProcessesData AnalysisStatistical MetricsData IntegrationPredictive AnalyticsData ModelingAdvanced Data Engineering

Soft Skills

Analytical ThinkingBusiness AcumenEffective CommunicationDecision-MakingCritical Thinking

Tools & Technologies

Microsoft Power AppsPower AutomateHadoopData MartsBusiness Intelligence Tools

Industry Keywords

BankingLendingCredit ProductsEnterprise Risk ManagementMarket Research

Tech Stack

Tools & technologies

ETLHadoopPythonSQLTableau

About the role

Key responsibilities & impact

Leverage complex analytical tools to provide business and technical expertise across functions or business units
Design, develop, and maintain complex reporting and dashboard solutions for managerial and executive leadership
Consult with clients on tool and strategy implementation, monitoring, statistical scoring, business intelligence, data quality, and analytical solution development
Determine optimal analytic approaches and support development, implementation, and enhancements
Conceptualize, develop, and continuously optimize analytical solutions for operations and executive management
Analyze results and make recommendations to business partners and senior management
Communicate conclusions from complex analytical solutions to varied audiences
Develop innovative reporting and analytical solutions using SQL, Power BI, and Tableau
Recommend performance measures including lifts, efficiencies, confidence intervals, and other statistical metrics
Analyze and process data, build and maintain models and report templates, and develop dynamic data-driven solutions
Provide business clients with detailed, actionable reports documenting findings from data processing and analysis
Consult on business intelligence data for predictive analytics and facilitate implementation of new tools and data marts
Manage risks associated with business objectives and activities in accordance with PNC's Enterprise Risk Management Framework

Requirements

What you’ll need

University / college degree typically required, or a comparable combination of education, job-specific certification(s), and experience may be considered in lieu of a degree
2+ years of relevant professional experience
Strong technical expertise in SQL, Power BI, and Tableau
Experience with ETL processes, PNC source systems, and enterprise data repositories highly valued
Solid understanding of banking, lending, and credit products
Experience with Microsoft Power Apps, Power Automate, Hadoop, Python, and advanced data engineering or data science capabilities preferred but not required
Analytical thinking, business intelligence, concept development, data-driven decision-making, data integration, market research, performance metrics, qualitative research, and strategic planning
Business acumen, business analytics, consulting, decision-making and critical thinking, and effective communications
No required certifications or licenses
No required or preferred language assessments
Must not require employment visa sponsorship; PNC will not participate in STEM OPT for this position

Benefits

Comp & perks

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 plan
Stock purchase plan
Dependent care reimbursement account
Back-up child/elder care
Adoption, surrogacy, and doula reimbursement
Educational assistance, including select programs fully paid
Wellness program with financial incentives
Maternity and/or parental leave
Up to 11 paid holidays each year
9 occasional absence days each year
15 to 25 vacation days each year, depending on career level