Business Analytics Consultant - Power BI

PNC Bank•Pittsburgh, PA

1d•Onsite

About The Position

PNC is hiring a Business Analytics Consultant in its IRM organization. The role is based in Pittsburgh, Pennsylvania; Brecksville, Ohio; Charlotte, North Carolina; or Houston, Texas. The consultant applies complex analytical tools and business and technical expertise to create data-driven solutions for business functions and units. The position develops and optimizes reporting, dashboards, models, and other analytical solutions that support operational, managerial, and executive decision-making. It also advises clients on analytics tools and strategy, business intelligence, data quality, statistical scoring, and solution development and implementation. Strong expertise in SQL, Power BI, and Tableau is sought, along with experience working with ETL processes, PNC source systems, and enterprise data repositories. Banking, lending, and credit product knowledge is essential. The position is in-office; candidates are encouraged to discuss workplace expectations with their recruiter and hiring manager. PNC does not provide employment visa sponsorship or participate in STEM OPT for this position. Successful candidates typically have a university or college degree and at least two years of relevant professional experience. A comparable combination of education, job-specific certifications, and experience, including military service, may be considered in lieu of a degree. A bachelor’s degree is listed, and no certifications or licenses are required. The base salary range is $63,750–$116,875, varying by location and individual qualifications. The position is incentive eligible, with payment based on company, business, and/or individual performance.

Requirements

Typically, a university or college degree and 2 or more years of relevant professional experience; a comparable combination of education, job-specific certification(s), and experience, including military service, may be considered in lieu of a degree.
Strong technical expertise in SQL, Power BI, and Tableau.
Solid understanding of banking, lending, and credit products.
Demonstrated customer focus and ability to understand and meet customer needs.
Effective written and verbal communication skills, problem-solving ability, and ability to work in a fast-paced, changing environment.
Ability to assess and manage risks in support of PNC’s Enterprise Risk Management Framework.

Nice To Haves

Experience with ETL processes, PNC source systems, and enterprise data repositories.
Experience with Microsoft Power Apps, Power Automate, Hadoop, or Python.
Advanced data engineering or data science capabilities.
Skills in analytical thinking, business intelligence, concept development, data-driven decision-making, data integration, market research, performance metrics, qualitative research, or strategic planning.
Competencies in business acumen, business analytics, consulting, decision-making, critical thinking, and effective communication.

Responsibilities

Design, develop, and maintain complex reports and dashboards that help managerial and executive leaders monitor performance, identify opportunities, and make informed decisions.
Consult with clients on analytics tool and strategy implementation and monitoring, statistical scoring, business intelligence, data quality, and analytical product or solution development.
Determine appropriate analytical approaches and support solution 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, communicating conclusions from complex analytical work to diverse audiences.
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 data processing and analysis findings.
Consult on the use of business intelligence data for predictive analytics and facilitate implementation of new tools and data marts.
Apply SQL, Power BI, and Tableau expertise to develop reporting and analytical solutions.
Focus on customer needs, communicate effectively, solve problems, and bring forward innovative solutions through process improvement, re-engineering, and project management.
Assess and manage risks associated with business objectives and activities in accordance with PNC’s Enterprise Risk Management Framework.

Benefits

Medical and prescription drug coverage, including 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 and elder care
Adoption, surrogacy, and doula reimbursement
Educational assistance, including select fully paid programs
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
15 to 25 vacation days each year, depending on career level and years of service