Data Analyst Senior/Business Analyst Senior - Data and Automation (SQL, Python, Data Quality, AI Tools)

Requirements

• Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and required certifications/licensures needed to be successful in this position.
• Preferred Skills
• Analytical Thinking, Competitive Advantages, Data Analytics, Data Mining, Data Science, Machine Learning (ML), Python (Programming Language), Structured Query Language (SQL)
• Competencies
• Application Design, Architecture, Business Intelligence, Data Architecture, Data Mining, Emerging Technologies, Informatics/Information Sciences, Information Management, IT Environment, Modeling: Data, Process, Events, Objects, Requirements Analysis
• Work Experience
• Roles at this level typically require a university / college degree, with 3+ years of rele

Additional Information

Position Overview 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 Senior within PNC's Data and Automation organization, you will be based in Strongsville, OH. - Support regularly occurring data provisioning for Commercial model monitoring, model development, third parties, and other analytics. - Work closely with data scientists, model analytics management, and downstream consumers to understand and fulfill evolving data requirements. - Support onboarding and validation of new data domains (e.g., Marketing) into enterprise analytics environments (e.g., ACZ Bronze), including coverage analysis, reconciliation, and readiness assessment. - Perform hands-on data validation and user acceptance testing (UAT) to ensure datasets are complete, accurate, well-understood, and fit for use by modeling and analytics stakeholders. - Support acquisition-related data efforts (e.g., historical data ingestion, point-in-time and full-history datasets) and contribute to repeatable frameworks that can be applied to future acquisitions. - Streamline and refactor existing code using best practices in SQL and Python to enhance performance, scalability, and maintainability across platforms. - Translate and modernize legacy data processes (e.g., SAS-based workflows) into cloud- and big-data-native solutions (e.g., SQL, PySpark), including effective use of AI-assisted tooling to accelerate and validate code translation. - Develop new scripts and processes to automate repetitive tasks, reduce manual effort, and improve testing and validation efficiency. - Conduct thorough data quality assessments and clearly articulate data anomalies, risks, and constraints to management and data consumers using root-cause analysis and trend reporting. - Partner with stakeholders to resolve data quality issues and implement preventative controls to reduce recurrence. - Adhere to change management practices to ensure that all code and process changes are reviewed, tested, documented, and approved prior to implementation. - Track and document changes to data processes, validation results, and decisions to support auditability, transparency, and knowledge transfer. - Occasionally participate in scrum or agile development teams, supporting Enterprise Data Management and analytics initiatives through planning, development, testing, and delivery activities. 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. Job Description Manages and develops information systems for clients; conducts data information analysis for a variety of studies under the direction of organizational standards. Advises end-users on data manipulation, end-user support systems and statistical analysis. Selects new information sources and acquires stock. Catalogs and indexes new materials. Implements and supports technologies for managing and effectively utilizing multiple information sources, formats and uses. Researches customers needs, conducts awareness and promotional sessions for potential customers. PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be: 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.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at PNC? Share your experience