Pnc
About Pnc
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.
Job Summary
As a Business Analytics Lead for PNC’s Security Analytics Hub, you will be part of a team that focuses on producing data driven insights into multiple areas of risk facing the bank, including cybersecurity and physical security.
Key Responsibilities
- Gather requirements and work with stakeholders to analyze business needs around BI reporting and dashboards.
- Analyze data using tools such as Tableau, SQL and Python to develop and automate reports or analysis that leads to actionable business insights.
- Comprehensive report analysis and design experience with knowledge of data warehouse/database structures and data modelling, PL/SQL.
- Build intuitive interfaces, visualizations, and infographics with storytelling dashboards.
- Identify, analyze, and interpret trends or patterns in complex data sets.
Requirements
- BS/BA degree or equivalent experience.
- Previous leadership experience.
- 5+ years of solid professional work experience.
- Strong knowledge of developing analytical, reporting and data visualization solution using BI tools.
- Expertise with database and data warehouse designs, data modelling, data performance tuning and data integration.
- Hands-on experience with physical and relational data modeling.
- Proven experience with ETL tools and API integration.
- Experience with relational databases (Teradata/Oracle).
- Expert knowledge of writing complex SQL queries to pull and summarize large datasets, report creation and ad-hoc analyses.
- Advanced knowledge of OOP Python and Tableau (certification preferred).
- Strong written and oral communication skills; ability to communicate and present information at varying levels of detail depending on the audience.
- Ability to work effectively in cross-functional teams and influence business partners.
- Strong organizational and prioritization skills.
- Enthusiastic, self-motivated, effective under pressure.
Preferred Qualifications
- Skills in AWS RDS, S3, Lambda, Redshift.
To apply for this job please visit pnc.wd5.myworkdayjobs.com.