Business Analytics Consultant Sr. - Data Analysis/SQL

Company: PNC Financial Services Group
Location: Pittsburgh
Posted on: November 23, 2020

Job Description:

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 PNCaposs Asset Management (AMG) Data Analytics and Solutions Team, you will be based Pittsburgh, Pennsylvania, Cleveland, Ohio, Columbus, Ohio or Philadelphia, Pennsylvania and or you may work within PNCaposs Footprint. As a Business Analytics Consultant Sr. you will work on various strategic analytics initiatives. A qualified candidate will leverage emerging technologies to create innovative and streamlined solutions to drive PNC and the AMG business forward. The successful candidate will bull Identify and assist in orchestrating optimal data driven solutions based on business needs and strategic goals. bull Analyzes results for multiple functions and communicates conclusions from complex models to a wide range of audiences. bull Actively engage in strategic initiatives with the business and supporting leaders through data, analytics, report design and implementation. bull Work within an agile crew to support the AMG Data Strategy initiative bull Lead the technical research and identification of data elements needed to support business objectives and enhanced analytics bull Support the design of custom tables by researching processes, identifying possible solutions including advantages disadvantages of suggested design, organize and present information for sign off by management bull Work closely with multiple teams across PNC - AMG executives, MIS, agile crew, data analytics team and other lines of business bull Utilize advanced tools to gather and analyze data in support of leadership's needs bull Consults with clients on tool and strategy implementation and monitoring, statistical scoring, business intelligence, data quality, and analytical product solution development. Requirements bull BSBA in a related field plus 3 years of related experience. bull Knowledge of SQL and basic understanding of database designs bull Practical experience with data analysis data wrangling (Alteryx andor Python preferred) bull Knowledge of visualization tools (Tableau, Qlik, etc.), human-centered design andor web application development bull Excellent written and oral communication skills bull Intellectually curious bull Proven project management and leadership skills bull Knowledge of banking industry bull Experience and knowledge of Asset Management, systems, and processes required bull Ability to define, support implement data driven strategies initiatives that support AMG business segments bull Experience in requirements gathering and data analysis related to large multi-faceted projects across multiple business lines with various sources and complexity of data elements bull Demonstrated project management capabilities bull Experience leading business planning, analytics and process design bull Proven ability to work creatively and analytically in a problem-solving environment bull Must be able to develop strong internal partnerships across line of businesses and departments Please note, PNC will not sponsor candidates for 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 PNCaposs 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 companyaposs 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 900 AM to 500 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 httpscontent.pncmc.comlivepncaboutHROnboardingPNCCCPAPrivacyDisclosureEmployee.pdf to gain understanding of how PNC may use or disclose your personal information in our hiring practices.

Keywords: PNC Financial Services Group, Pittsburgh , Business Analytics Consultant Sr. - Data Analysis/SQL, Other , Pittsburgh, Pennsylvania