Business Analytics Lead - Finance Specialist

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. We work together each day to foster an inclusive workplace culture where all of our employees feel respected, valued and have an opportunity to contribute to the company's success. As a Business Analytics Lead, you will be part of PNC's Finance organization, supporting the Oracle Financial Services Application (OFSA) management accounting platform, within the Control Division. You will have a mix of monthly reporting, project and analysis responsibilities. This role unites financial concepts with information technology. Ideal candidates will have an interest in both the financial and the operational aspects of the position. This position will be based within the following markets: Pittsburgh, PA, Philadelphia, PA, Cleveland, OH, Chicago, IL, New York City, NY, Gaithersburg, MD, Atlanta, GA, Tampa, FL and Birmingham, AL. Surrounding markets may be considered.

This is a hybrid position which provides flexibility to work both in the office and remotely. Certain job responsibilities may require time in the office on a regular basis.

Primary responsibilities and activities include:• Performing as a key contributor within the management accounting team supporting the Funds Transfer Pricing (FTP) function, both methodology and application within OFSA.
• Understanding key functionality and elements of the OFSA tool in order to support monthly reporting and projects.
• Participate with the FTP and OFSA team on projects and methodology implementations. Current project work includes implementation of new or enhanced funding treatments on banking products, LIBOR transition and the expansion of OFSA to consume new banking platforms.
• Partnering with fellow OFSA team members, MIS Support, Asset & Liability (A&L) Management, and Line of Business consumers to deliver accurate, timely financial results.
• Derives meaning from big data (i.e., datasets that may be large, disparate, unstructured, and/or complex)
• Responding to inquiries, performing analyses and presenting recommendations to senior executive management (the FTP & OFSA Manager, Director of Financial Systems, Controllers, etc.). Ability to influence strategic decision making.
• Develops, tests and implements operational changes via the system user interface.
• Interpret and create complex financial models (discounted cash flow, interest rate sensitivity, amortization)

The successful candidate will have the following qualifications:• Strong working knowledge of general accounting, accounting systems, financial reporting, data flow and financial analysis.
• Solid understanding of financial service Industry and bank balance sheets preferred.
• Proficiency with Microsoft Office (Excel, Word, PowerPoint) is required.
• SQL/query experience is required. Experience with large datasets preferred.
• OFSA, Hyperion Essbase experience is a plus. Familiarity with TOAD software a plus.
• Familiarity with understanding requirements regarding ETL (data consumption ) design flows and data integration. Being able to map data flow to determine best methods in extracting, transforming and loading (ETL) data from source system to generate final reporting.
• Degree in Finance, Accounting, or Data Science preferred.
• Ability to work in a fast paced environment with rapidly changing needs.
• Demonstrated competency in analytical and written and verbal communication skills. An ability to put complex subjects in simple terms to explain to management and end users.
• High level of insightful curiosity in order to constructively challenge presented information to make sure it is accurate and meaningful.
• Detail-oriented with strong problem solving skills. Able to use technology, contacts and deductive reasoning to get to the bottom of reporting requests.
• Business Analyst and/or financial system experience preferred.

CPA, MBA, or CFA is a plus.

This position is a potential management develop opportunity. Interest in having exposure to senior executives, growing into a future leader of group and having direct reports is a plus.

Job Description

• Leads the analytics processes across multiple functions or business units leveraging an array of complex analytical tools to create data driven solutions. Serves as mentor to more junior employees.
• Consults with clients and mentors consultants 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 5+ years of industry-relevant experience. Specific certifications are often required. In lieu of a degree, a comparable combination of education and experience (including military service) may be considered.

Education

Bachelors

Additional Job Description

Base Salary: Commensurate with skills and experience.

Benefits

PNC offers employees a comprehensive range of benefits to help meet your needs now and in the future. Depending on your eligibility, options for full-time employees include medical/prescription drug coverage (with a Health Savings Account feature); dental and vision options; employee and spouse/child life insurance; short- and long-term disability protection; maternity and parental leave; paid holidays, vacation days and occasional absence time; 401(k), pension and stock purchase plans; dependent care reimbursement account; back-up child/elder care; adoption assistance; educational assistance and a robust wellness program with financial incentives. To learn more about these and other programs, including benefits for part-time employees, visit pncbenefits.com > New to PNC.

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 call 877-968-7762 and select Option 4: Recruiting or contact us via email at [email protected].

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.