Data Analyst Senior
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 Data Analyst Sr within PNC's Technology - Retail Shop & Buy – Text Banking organization, you will be based in Pittsburgh, PA, Strongsville, OH, or Dallas, TX. Key responsibilities will include but are not limited to: - Partner with Product Owners and technical teams to understand business requirements and translate them into data solutions - Design and develop database objects, including tables, views, and stored procedures - Implement database constraints, indexing strategies, and performance optimization techniques to ensure efficiency - Apply best practices to maintain data accuracy, consistency, and integrity - Deliver insights and recommendations to enhance business processes, products, and performance - Develop dashboards and reports using tools such as Tableau, Excel, and similar platforms - Develop and maintain SQL scripts and stored procedures, ensuring they are tested and deployment-ready - Provide support to the team during monthly release cycles, including troubleshooting and issue resolution Candidates must be proficient in: Oracle Database, Informatica ETL, Tableau, JIRA, Confluence, Visio (to draw flow diagrams), SQL Developer, TOAD, Tableau Preferred proficiency in: MongoDB 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.
Requirements
- Proficient in Oracle Database
- Proficient in Informatica ETL
- Proficient in Tableau
- Proficient in JIRA
- Proficient in Confluence
- Proficient in Visio (to draw flow diagrams)
- Proficient in SQL Developer
- Proficient in TOAD
- Proficient in Tableau
- University / college degree, with 3+ years of relevant / direct industry experience
- 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
- Preferred proficiency in MongoDB
Responsibilities
- Partner with Product Owners and technical teams to understand business requirements and translate them into data solutions
- Design and develop database objects, including tables, views, and stored procedures
- Implement database constraints, indexing strategies, and performance optimization techniques to ensure efficiency
- Apply best practices to maintain data accuracy, consistency, and integrity
- Deliver insights and recommendations to enhance business processes, products, and performance
- Develop dashboards and reports using tools such as Tableau, Excel, and similar platforms
- Develop and maintain SQL scripts and stored procedures, ensuring they are tested and deployment-ready
- Provide support to the team during monthly release cycles, including troubleshooting and issue resolution
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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
