Business Systems Analyst Consultant – Python, SQL, ETL Design

PNC

Business Systems Analyst Consultant responsible for IT solutions and business management at PNC. Eliciting requirements and enhancing business applications with cross-functional project involvement.

Posted 6/3/2026full-timePittsburgh • Ohio, Pennsylvania • 🇺🇸 United StatesMid-LevelSenior💰 $75,000 - $125,000 per yearWebsite

Tech Stack

Tools & technologies

ETLInformaticaPythonServiceNowSQL

About the role

Key responsibilities & impact

Provides solutions for IT and business management on applying technology to business opportunities, planning and implementation of cross-functional applications.
Participates in identifying, evaluating, and configuring systems that are cost effective and meet business requirements.
Monitors client experiences and feedback on the use of business applications; Enhanced system productivity, as needed.
Provides senior level consulting services to internal business groups on process improvement projects designed to improve their business results.
Analyzes, defines and documents clients requirements, and revises existing systems logic challenges, as necessary.

Requirements

What you’ll need

Comfortable communicating with vendors and internal service partners
Experience eliciting functional and technical requirements from internal and external stakeholders
Proficient in the Development and Project Life Cycle
Experience working in an Agile environment and within project management platforms such as JIRA
Knowledge of coding languages and other technologies such as, Python, Informatica ETL, SQL, XSLT, XML, and APIs
Strong leadership, communication, negotiation, and problem-solving skills
Experience using collaboration tools such as Outlook, SharePoint, and Confluence
ETL design and implementation, data modeling, mapping, and validation preferred
Knowledge of Workday and Workday integrations preferred
Familiarity with ServiceNow as a demand and incident management platform preferred

Benefits

Comp & perks

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
paid time off including maternity, parental leave, and vacation days

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PythonInformatica ETLSQLXSLTXMLAPIsETL designdata modelingmappingvalidation

Soft Skills

leadershipcommunicationnegotiationproblem-solving