Business Analysis Advisor

PNC Bank • Pittsburgh, PA

4d • 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 Analysis Advisor within PNC's Finance organization, you will be based in Pittsburgh, PA. The role is primarily responsible for the smooth operation of PNC’s Axiom Regulatory Reporting system and automation of additional regulatory filings. The opportunity lies within PNC’s Regulatory Reporting department which is responsible for statutory filings with various regulatory agencies. This role is an opportunity to navigate the multi-faceted regulatory landscape while partnering with experienced technology partners and diverse line of business contacts within PNC. You will partner closely with various areas within Finance, Operations, Technology, and Treasury. Responsibilities will grow and change over time, but duties and responsibilities will include the following: Work closely with Technology teams to ensure the smooth and stable operation of the Axiom system Identify defects, resolve issues, coordinate releases, and test defects/system changes. Partner with key stakeholders of regulatory reporting on enhancement projects that support regulatory reporting Interpret regulatory guidelines and convert into project specifications for data infrastructure, process automations, and reporting to fulfill regulatory requirements Draft project specifications for data mapping to automate integrations of financial and operational data from multiple data sources into data warehousing solutions Leverage project management platforms to submit project specifications for system enhancements and monitor system development progress as it moves through the software/data engineering lifecycle Participate in testing of reports, automations, and data warehouses, validating system requirements and data integrations meet project specifications, while maintaining high data quality Partner with risk, audit, and governance partners to ensure effective controls development and implementation within reporting processes and data warehouse solutions Leverage SQL, SAS, and Python data warehouse solutions to prepare data sets for automation, internal stakeholders and regulatory submission Develop, maintain, and verify detailed data mapping Oversee the execution of the production process Enhance existing data and processes, implement new data and processes, and validate rules and results SQL skills and understanding of account level loan and deposit data, banking financials and Regulatory Reporting forms will allow you to recommend creative solutions to improving processes, controls, and methodologies PNC is an in-office company that fosters a supportive culture where employees can thrive and achieve balance. We encourage candidates to connect with their recruiter and hiring manager to understand workplace expectations and ensure the role aligns with their goals. PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position. Job Description Directs the research, discovery, collection and interpretation of business requirements. Participates in the development and review of complex processes and procedures, workflow analytics and reporting. May provide senior level consultation and communicates with clients and technology teams on business designs, problem solving and business analysis to support project goals and objectives. Consults and recommends the frameworks, methodologies and processes involved in business requirements traceability for business analysis teams. Independently mentors, leads, and coaches other associates to affect knowledge transfer. Oversees the development and maintenance of all applicable policy and procedure documentation. Translates business needs, processes and/or procedures by partnering with applicable experts and business stakeholders to determine and articulate needs. May communicate with senior level stakeholders and technology teams on complex business requirements. Leads multiple business analysis project management processes through planning, quality assurance and effectiveness assessment. Provides direction for the successful deployment of projects. Drives the development, analysis and distribution of complex reporting. 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.

Requirements

• Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role.
• 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, job specific certification(s), and experience (including military service) may be considered.

Nice To Haves

• Business Needs
• Business Processes
• Data Analytics
• Decision Making
• Management Reporting
• Prioritization
• Waterfall Model
• Analytical Thinking
• Business Assessment
• Business Process Modeling
• Consulting
• Effectiveness Measurement
• Information Capture
• Problem Solving
• Process Management
• Project Management
• Requirements Analysis
• Software Product Business Knowledge

Responsibilities

• Work closely with Technology teams to ensure the smooth and stable operation of the Axiom system
• Identify defects, resolve issues, coordinate releases, and test defects/system changes.
• Partner with key stakeholders of regulatory reporting on enhancement projects that support regulatory reporting
• Interpret regulatory guidelines and convert into project specifications for data infrastructure, process automations, and reporting to fulfill regulatory requirements
• Draft project specifications for data mapping to automate integrations of financial and operational data from multiple data sources into data warehousing solutions
• Leverage project management platforms to submit project specifications for system enhancements and monitor system development progress as it moves through the software/data engineering lifecycle
• Participate in testing of reports, automations, and data warehouses, validating system requirements and data integrations meet project specifications, while maintaining high data quality
• Partner with risk, audit, and governance partners to ensure effective controls development and implementation within reporting processes and data warehouse solutions
• Leverage SQL, SAS, and Python data warehouse solutions to prepare data sets for automation, internal stakeholders and regulatory submission
• Develop, maintain, and verify detailed data mapping
• Oversee the execution of the production process
• Enhance existing data and processes, implement new data and processes, and validate rules and results

Benefits

• PNC offers 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; 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.
• In addition, PNC generally provides the following paid time off, depending on your eligibility: 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.
• To learn more about these and other programs, including benefits for full time and part-time employees, visit pncthrive.com .

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level