Business Analytics Consultant - Power BI

PNC•Washington, DC

1d•$63,750 - $127,500•Onsite

About The Position

At PNC, employees work together to deliver a strong customer experience and foster an inclusive workplace. This Business Analytics Consultant role is within PNC’s IRM organization and is based in Pittsburgh, Pennsylvania; Brecksville, Ohio; Charlotte, North Carolina; Washington, DC; or Houston, Texas. PNC describes itself as an in-office company and encourages candidates to discuss workplace expectations with their recruiter and hiring manager. The consultant applies analytical tools and business and technical expertise to create data-driven solutions for a business function or unit. The role designs, develops, and maintains complex reporting and dashboard solutions for managerial and executive leaders; consults with clients on analytics tools and strategy, business intelligence, data quality, statistical scoring, and analytical products; and recommends analytical approaches and performance measures. It also analyzes and processes data, builds and maintains models and report templates, develops dynamic solutions, and delivers actionable reports and recommendations to business partners and senior management. The position calls for strong technical expertise in SQL, Power BI, and Tableau. Experience with ETL processes, PNC source systems, and enterprise data repositories is valued. A solid understanding of banking, lending, and credit products is essential. Experience with Microsoft Power Apps, Power Automate, Hadoop, Python, or advanced data engineering or data science capabilities is preferred but not required. The successful candidate is a self-starting, adaptable leader with strong communication, customer focus, problem-solving, process improvement, and project management abilities. PNC will not sponsor employment visas or participate in STEM OPT for this position.

Requirements

Typically, a university or college degree and 2+ 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.
Bachelor's degree listed as the education level.
Strong technical expertise in SQL, Power BI, and Tableau.
Solid understanding of banking, lending, and credit products.
Ability to communicate effectively, solve problems, and work in a fast-paced, changing environment.
Customer-focused approach and 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, Python, or 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, and strategic planning.
Competencies in business acumen, business analytics, consulting, decision-making and critical thinking, and effective communications.

Responsibilities

Design, develop, and maintain complex reports and dashboards to help managerial and executive leadership 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 optimal analytical approaches and support their development, implementation, and enhancement.
Conceptualize, develop, and continuously optimize analytical solutions for operations and executive management to support data-driven decision-making.
Analyze results, make recommendations to key business partners and senior management, and communicate conclusions from complex analytical solutions to diverse audiences.
Leverage analytical tools and provide business and technical expertise to create data-driven solutions for a business function or unit.
Recommend appropriate 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 using business intelligence data for predictive analytics and facilitate implementation of new tools and data marts.
Apply customer-focused practices and effectively manage risks in accordance with PNC's Enterprise Risk Management Framework.
Use process improvement, re-engineering, and project management to solve problems and bring innovative solutions to fruition.

Benefits

Medical and prescription drug coverage, with a Health Savings Account feature, subject to eligibility.
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, subject to eligibility.
Up to 11 paid holidays each year, subject to eligibility.
9 occasional absence days each year, subject to eligibility and applicable law.
15 to 25 vacation days each year depending on career level and years of service, subject to eligibility.
Incentive-eligible compensation based on company, business, and/or individual performance.