Business Analytics Consultant - Regulatory Reporting System Support

PNC • Pittsburgh, PA

22d • Onsite

About The Position

This position is based in Pittsburgh, PA and requires employees to work onsite five days per week. The team thrives in a collaborative, fast-paced environment where in-person partnership, knowledge sharing, and cross-functional teamwork are key to success. As a Business Analytics Consultant - Regulatory Reporting System Support 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 also has 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.

Requirements

• University / college degree, with 2+ years of relevant professional experience. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.
• 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.

Nice To Haves

• Analytical Thinking
• Business Intelligence (BI)
• Concept Development
• Data-Driven Decision Making
• Data Integration
• Market Research
• Performance Metrics
• Qualitative Research
• Strategic Planning
• Analytical Thinking
• Business Acumen
• Business Analytics
• Consulting
• Decision Making and Critical Thinking
• Effective Communications

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, and other data mining solutions to prepare data sets for automation, internal stakeholders and regulatory submission
• Coordinate and prioritize workload
• 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
• Leverages analytical tools to provide business and technical expertise for the analytics process, tools and applications for a business function or business unit to create data driven solutions.
• Recommending appropriate performance measures to be produced including lifts, efficiencies, confidence intervals, and other statistical metrics.
• Analyzing and processing data, building and maintaining models and report templates, and developing dynamic, data-driven solutions.
• Providing business clients with detailed, actionable reports documenting the findings from, data processing, and data analysis.
• Consulting on using business intelligence data for predictive analytics and facilitating implementation of new tools and data marts.

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.

What This Job Offers

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