Job Profile

Position Overview

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. As a Business Analytics Consultant Sr. within PNC's Asset Management Group, you will be based in Pittsburgh, Pennsylvania.

The Business Analytics Consultant Sr. will work closely with internal clients to turn data into critical information and knowledge that can be used to make sound business decisions. Leads the collection and interpretation of business requirements. Sources appropriate data, applies analytical method(s), interprets the resulting information and then constructs an understandable visual representation in the analysis.

Serves as a subject matter expert of AMG (Asset Management Group) investment product data. Understands complex business rules and is able to combine investment officers, managers, geographies & hierarchies, and investment product usage to provide insights for business leaders in a repeatable and highly available reporting environment.

Responsible for designing, developing and implementing various information related deliverables including Tableau dashboards and self-service analytical tools.

Owns the production and maintenance of metrics reporting and dashboards for stakeholders.
Owns end-to-end life-cycle for deliverables including requirements gathering, technical development, refinement, adoption and maintenance.
Adds value from outset through technical, analytical, and problem solving skills.
Self-motivated and eager to continually improve skill set and learn new technologies.
Informs and influences future priorities and initiatives.

Requirements:
• BA/BS in a STEM or Business related degree plus 3 years of related experience.
•Analytical aptitude, curiosity, and critical thinking.
• Experience using multiple data sources and programming language (Oracle, SQL, Java, Excel/VBA, CSV, Hadoop, SQLite, Microsoft Azure, MS Access) a plus.
• Ability to automate and maintain data transformation pipelines (Tableau Prep, Python, Windows Scheduler, Oozie) a plus.
• Experience developing, maintaining, and optimizing Tableau dashboards.
• Demonstrated understanding of advanced tableau features for use in embedded analytic tools and custom portal.
• Interest in investment products; including design, application, and usage.
• Knowledge of AMG systems, including AmTrust, Vestmark, and Managed Account Workflow is a plus.

*Please note, PNC will not sponsor work visas for this position.

Job Description

• Leverages complex analytical tools to provide business and technical expertise for the analytics process, tools and useful applications across multiple functions or business units to create data driven solutions.
• Consulting to clients on tool and strategy implementation and monitoring, statistical scoring, business intelligence, data quality, and analytical product / solution development.
• Determining the optimal analytic approach and supporting development, implementation and enhancements.
• Conceptualizing, developing and continuously optimizing analytical solution for operations and executive management to enable data driven decision making.
• Analyze results and make recommendations for key business partners and senior management or communicate conclusions from complex analytical solutions to a wide range of audiences.

PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be:

• Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions.
• Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC's Enterprise Risk Management Framework.

Competencies

Analytical Thinking - Knowledge of techniques and tools that promote effective analysis and the ability to determine the root cause of organizational problems and create alternative solutions that resolve the problems in the best interest of the business.

Business Acumen - Knowledge, insight, and understanding of business concepts, tools, and processes that are needed for making sound decisions in the context of the company's business; ability to apply this knowledge appropriately to diverse situations.

Business Analytics - Knowledge of technologies, techniques and practices for the evaluation of business performance data; ability to analyze business performance using advanced statistical methods to justify and drive future business planning decisions.

Consulting - Knowledge of techniques, roles, and responsibilities in providing technical or business guidance to clients, both internal and external; ability to apply this knowledge appropriately to diverse situations.

Decision Making and Critical Thinking - Understanding of the issues related to the decision-making process; ability to analyze situations fully and accurately, and reach productive decisions.

Effective Communications - Understanding of effective communication concepts, tools and techniques; ability to effectively transmit, receive, and accurately interpret ideas, information, and needs through the application of appropriate communication behaviors.

Emerging Technologies - Knowledge of and ability to design, apply and evaluate new information technologies for business environments in order to improve work productivity and accuracy.

Work Experience

Roles at this level typically require a university / college degree, with 3+ years of relevant / direct industry experience. Certifications are often desired. In lieu of a degree, a comparable combination of education and experience (including military service) may be considered.

Education

Bachelors

Disability Accommodations Statement:

The PNC workplace is inclusive and supportive of individual needs. If you have a physical or other impairment that might require an accommodation, including technical assistance with the PNC Careers website or submission process, please calland select Option 4: Recruiting or contact us via email at

The Human Resources Service Center hours of operation are Monday - Friday 9:00 AM to 5:00 PM ET.

Equal Employment Opportunity (EEO):

PNC provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law.

California Residents

Refer to the California Consumer Privacy Act Privacy Notice to gain understanding of how PNC may use or disclose your personal information in our hiring practices.