Security Analyst - Data Analytics & Optimization

PNC•Pittsburgh, PA

2d•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 Security Analyst - Data Analytics & Optimization within PNC's Cyber Defense organization, you can be based in Pittsburgh, PA; Birmingham, AL; or Cleveland, OH. The Global Security Fusion Center’s (GSFC) Data Analytics & Optimization team provides information- and data-related work products which support department leaders and executives in decision making to reduce risk and to improve the overall security posture of the organization. Information takes a number of forms including presentations, Tableau dashboards, analytical summaries, metric data, and data-backed insights which require interactions and coordination across many partner organizations across GSFC and the enterprise. 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. Information developed by the team inform leaders in making key decisions including, but not limited to, operational performance and operational risk of teams, utilization and performance of security tools, understanding current staffing (gearing ratios), changing threat landscape, and briefings to senior leadership. The position is primarily based in a PNC location. Responsibilities require time in the office or in the field on a regular basis. Some responsibilities may be performed remotely, at the manager’s discretion.

Requirements

Demonstrated experience in data analytics, reporting, and metric development, preferably within a Cybersecurity, Technology, or Risk Management environment.
Proficiency with data visualization tools, particularly Tableau; experience with or strong aptitude for Power BI.
Experience writing and validating SQL queries and working with structured datasets, with an understanding of data access controls and governance principles.
Strong analytical, critical thinking, and problem-solving skills, with exceptional attention to detail and accuracy.
Ability to synthesize data and articulate insights clearly through dashboards, presentations, and analytical summaries.
Working knowledge of information security concepts, controls, and operational metrics.
Strong collaboration and communication skills, with the ability to effectively partner with technical subject matter experts and non-technical stakeholders.
Ability to manage multiple reporting deliverables in a highly visible, fast-paced security environment.
Advance experience with Microsoft Office Tools: PowerPoint, Word, Outlook
Familiar with Python
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.
Roles at this level typically require a university / college degree, with 3+ years of relevant / direct industry experience.
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

Access Control (AC)
Building Architecture
Customer Solutions
Cybersecurity
Disaster Recovery Planning
Information Security
Microsoft Power Business Intelligence (BI)
Network Security
Physical Security
Risk Assessments
Security Analytics
Security Technologies
Tableau (Software)

Responsibilities

Produce, analyze, and deliver recurring and ad hoc security metrics and reports to support GSFC leadership, executive committees, and Board-level reporting.
Develop, maintain, and enhance dashboards and visualizations using Tableau, with a transition to Power BI, to communicate security trends, risks, and operational performance.
Analyze security operations, threat activity, staffing models (gearing ratios), and tool utilization data to generate clear analytical summaries and actionable insights.
Collaborate closely with subject matter experts across cyber defense functions, including threat intelligence, perimeter defense, security operations, and incident management, to ensure accuracy and relevance of reporting.
Translate complex technical and security data into presentations and written materials suitable for senior leadership and cross-functional stakeholders.
Ensure consistency, accuracy, and integrity of data through validation, documentation, and adherence to established data governance and access control requirements.
Support internal audits, regulatory examinations, and risk assessments by providing timely, accurate, and well-documented metrics and analyses.
Perform independent analytical work while maintaining regular engagement with stakeholders to understand evolving reporting needs and security priorities.
Apply foundational security concepts to interpret data, assess trends, and identify opportunities to improve operational effectiveness and risk management.

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