Business Analytics Lead - Funds Transfer Pricing

PNC Bank•Pittsburgh, PA

12h•Onsite

About The Position

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 on the Funds Transfer Pricing team, you will be part of PNC’s Finance organization within the Control Division. You will have a mix of monthly reporting, project, and analysis responsibilities. This role combines 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.

Requirements

Strong working knowledge of general accounting, accounting systems, financial reporting, data flow and financial analysis.
Proficiency with Microsoft Office (Excel, Word, PowerPoint) is required.
SQL/query experience is required.
Ability to work in a fast-paced environment with rapidly changing needs.
Written and verbal communication skills demonstrating an ability to convey complex subjects in a summary manner for consideration in executive decision making.
High level of insightful curiosity 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.
Bachelors degree.
5+ years of industry-relevant experience.

Nice To Haves

Solid understanding of financial service Industry and bank balance sheets preferred.
Experience with large datasets preferred.
OFSA, Hyperion Essbase experience is a plus.
Familiarity with TOAD software a plus.
MBA preferred.
Familiarity of ETL processes, data consumption patterns, data integration and data flow.
Analytical Thinking, Business Intelligence (BI), Concept Development, Data-Driven Decision Making, Data Integration, Market Research, Performance Metrics, Qualitative Research, Strategic Planning.
Competencies: Analytical Thinking, Business Acumen, Business Analytics, Consulting, Decision Making and Critical Thinking, Effective Communications, Emerging Technologies.

Responsibilities

Supporting Funds Transfer Pricing (FTP) operations within the Control division of Finance.
Understanding key functionality and elements of the OFSA tool to lead monthly reporting and projects.
Coordinate FTP and Oracle Financial Services Application (OFSA) projects and methodology implementations. Current project work includes implementation of new or enhanced funding treatments on banking products and the expansion of OFSA to consume new banking platforms.
Partnering with Asset & Liability Management and Line of Business leadership to ensure the delivery of accurate and timely financial results.
Derive 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 (Senior Managers, Finance Directors, Controllers, etc.). Ability to influence strategic decision making.
Develops, tests, and implements operational changes via the system user interface.
Interprets and creates complex financial models (discounted cash flow, interest rate sensitivity, amortization).
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.
Assists peers with guidance on analytic approaches related to more complex solutions.
Conceptualizing, developing and continuously optimizing analytical solutions for business leadership 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.

Benefits

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
401(k) with PNC match
pension and stock purchase plans
dependent care reimbursement account
back-up child/elder care
adoption, surrogacy, and doula reimbursement
educational assistance, including select programs fully paid
a robust 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
between 15 to 25 vacation days each year, depending on career level; and years of service