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

About the role

The Data Analyst Senior within PNC's Data and Automation organization is based in Strongsville, OH. They support data provisioning, model development, and data onboarding, while also streamlining and modernizing data processes.

Responsibilities

• 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 into enterprise analytics environments, including coverage analysis, reconciliation, and readiness assessment.
• Perform hands-on data validation and user acceptance testing to ensure datasets are complete, accurate, well-understood, and fit for use by modeling and analytics stakeholders.
• Contribute to repeatable frameworks for future acquisitions, including historical data ingestion and point-in-time/full-history datasets.
• 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 into cloud and big-data-native solutions, including effective use of AI-assisted tooling.
• 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.

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 include Analytical Thinking, Competitive Advantages, Data Analytics, Data Mining, Data Science, Machine Learning (ML), Python (Programming Language), Structured Query Language (SQL).

Qualifications

Roles at this level typically require a university/college degree, with 3+ years of relevant/direct industry experience. Certifications are often desired. In lieu of a degree, a comparable combination of education, job-specific certification(s), and experience (including military service) may be considered. Education includes a Bachelor's degree. Certifications are not required.

Skills

• Analytical Thinking
• Competitive Advantages
• Data Analytics
• Data Mining
• Data Science
• Machine Learning (ML)
• Python (Programming Language)
• Structured Query Language (SQL)

Benefits

PNC offers a comprehensive range of benefits to meet your needs now and in the future. Depending on your eligibility, options include medical/prescription drug coverage, 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, and a robust wellness program with financial incentives. In addition, PNC provides paid time off such as maternity and/or parental leave, up to 11 paid holidays, 9 occasional absence days, between 15 to 25 vacation days, and years of service.

Pay

Base Salary: $75,000.00 – $125,000.00. Salaries may vary based on geographic location, market data, and on individual skills, experience, and education. This role is incentive eligible with the payment based upon company, business, and/or individual performance.

Schedule

This role is full-time.