Business Analytics Consultant - Power BI
About The Position
At PNC, employees work together to deliver the best experience for customers in an inclusive workplace. This Business Analytics Consultant role is part of PNC's IRM organization and is based in Pittsburgh, Pennsylvania; Brecksville, Ohio; Charlotte, North Carolina; or Houston, Texas. PNC describes itself as an in-office company and encourages applicants 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 develops and maintains reporting, dashboards, models, report templates, and other analytical solutions that support operations, management, and executive decision-making. It involves consulting with business clients on analytics strategies and tools, analyzing data, and communicating actionable findings to business partners and senior management. Strong expertise in SQL, Power BI, and Tableau is emphasized. Experience with ETL processes, PNC source systems, and enterprise data repositories is highly valued. A solid understanding of banking, lending, and credit products is essential. Microsoft Power Apps, Power Automate, Hadoop, Python, and advanced data engineering or data science capabilities are preferred but not required. The role is incentive eligible, with payment based on company, business, and/or individual performance. PNC will not provide employment visa sponsorship or participate in STEM OPT for this position.
Requirements
- Typically, a university or college degree and 2 or more 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 is listed under Education.
- Strong technical expertise in SQL, Power BI, and Tableau.
- Solid understanding of banking, lending, and credit products.
- Demonstrated customer focus, effective written and verbal communication, problem-solving, 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 is highly valued.
- Experience with Microsoft Power Apps, Power Automate, Hadoop, and 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, 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 for managerial and executive leadership to monitor performance, identify opportunities, and make informed decisions.
- Leverage analytical tools and provide business and technical expertise for analytics processes, tools, and applications to create data-driven solutions.
- Consult with clients on tool and strategy implementation and monitoring, statistical scoring, business intelligence, data quality, and analytical product or solution development.
- Determine the optimal analytical approach and support its development, implementation, and enhancement.
- 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 solutions to varied audiences.
- 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 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 technical expertise in SQL, Power BI, and Tableau to develop reporting and analytical solutions.
- Focus on customer needs, communicate effectively, solve problems, and bring innovative solutions to fruition 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 plans
- 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
- Incentive-eligible compensation based on company, business, and/or individual performance
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
