Security Analyst: Tableau, Power BI, SQL

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 within PNC's ENTERPRISE DIGITAL IDENTITY organization, you will be based in Pittsburgh, PA, Dallas, TX, Strongsville, OH, Birmingham, AL, Phoenix, AZ. PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.

Responsibilities

• Provides technical evaluation and analysis. Supports activities, process, and tools needed to improve overall security posture of the organization.
• Applies security concepts, reviews information, executes defined tasks, analyzes requirements, reviews logs, and creates documentation.
• Performs investigation and data loss prevention, data manipulation, and coordination of activities.
• Performs actions to address or mitigate risks and vulnerabilities. Reviews and defines controls.
• Advises on more complex security procedures and products for clients, security administrators and network operations.
• Participates in enforcement of control security risks and threats; potential of one more controls subject to manager discretion.
• Shares knowledge with staff.
• Conducts security assessments and other information security routines consistently.
• Investigates and recommends corrective actions for data security related to established guidelines.

Requirements

• Strong proficiency in SQL for querying and data manipulation.
• Experience in data visualization tools (e.g: Tableau, Power BI, Looker).
• Hands on experience in fraud detection models, including third party vendor models.
• Experience developing, and maintaining model documentation, including model development reports, validation reports and monitoring frameworks.
• Proficiency in Excel, including pivot tables, VLOOKUP and data modeling.
• Ability to analyze large datasets and extract meaningful insights.
• Strong problem-solving skills & attention to detail.
• Ability to translate business needs into data insights and recommendations.
• Experience working with stakeholders to define business requirements.
• Strong written & verbal communication skills.
• Ability to present insights to both technical and non-technical audiences.

Nice-to-haves

• Experience with Python or R for data/model analysis.
• Familiarity with cloud platforms (AWS, GCP or Azure) and data lakes.
• Experience in security and real time fraud detection systems.
• Extract data from Splunk.
• Extract data from LogScale.
• Knowledge of A/B testing, forecasting or machine learning models.
• Exposure to ETL processes and data warehousing concepts.
• Familiarity with business intelligence platforms like snowflake or google BIG Query.

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.
• 8 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.