Software Engineer Lead (ETL/Regulatory Risk & Compliance)

PNC; Pittsburgh (Allegheny County); On-site; USD 120,000 - 170,000; Full time

Benefits offered by this job

Medical and prescription coverage

Dental and vision options

401(k) with company match

Pension and stock purchase plans

Educational assistance

Robust wellness program

Generous paid time off

Job summary

PNC is seeking a Software Engineer Lead in the Finance Accounting Technology organization based in Pittsburgh, PA. You will lead the design, development, and deployment of complex software solutions for regulatory reporting and banking operations.

Responsibilities include guiding architectural decisions, delivering robust code, documenting procedures, and mentoring team members. Strong collaboration with business partners and adherence to development methodologies (waterfall/agile) are essential.

Qualifications

• 5+ years of development experience.

Responsibilities

• Creates and leads the technical design and development of software solutions.
• },
• CoT_job_summary_short
• job_summary_short

Skills

Informatica PowerCenter

Oracle SQL/PLSQL

PL/SQL

UNIX shell scripting

CA7 job scheduler

Teradata

Data modeling

Power BI/Tableau/Oracle BI

Education

Bachelor’s degree or equivalent

Tools

Alteryx

Job description

Position Overview

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are united in delivering the best experience for our customers and fostering an inclusive workplace culture where all employees feel respected, valued, and have the opportunity to contribute to the company’s success. As a Software Engineer Lead within PNC's Finance Accounting Technology organization, you will be based in Pittsburgh, PA.

Responsibilities

• Creates and leads the technical design and development of software solutions.
• Proposes and designs software solutions to address complex business needs.
• Prepares technical and procedural documentation required.
• Facilitates complex problem resolution.
• Provides technical guidance and support to colleagues.
• Reviews coding, testing, and documentation of software.
• Applies modern principles, methodologies, and tools to advance business initiatives and capabilities.

Qualifications

Successful candidates must demonstrate appropriate knowledge, skills, and abilities for this role, including:

• 5+ years of development experience.
• Alignment of business strategy with software solutions.
• Strong communication skills, both written and verbal.
• Active, independent pursuit of broader technology and business knowledge.
• Experience with modern software development principles, methodologies, and tools.
• Formal experience working in projects with a methodology (waterfall, agile).
• Banking and regulatory reporting experience (a plus).

Technical Must Have Skills

• Advanced design and programming skills in Informatica PowerCenter 9.6 & above and Oracle SQL/PLSQL.
• Proficiency in developing and debugging PL/SQL code.
• Experience developing SCD mappings with different source formats using necessary transformations.
• Performance tuning of targets, sources, mappings, sessions, and workflows.
• Design of HTTP transformations.
• Experience handling ETL code deployments using DevOps tools.
• Hands‑on knowledge with UNIX shell scripting and CA7 job scheduler.
• Intermediate level skills in data analysis and data modeling.

Preferred Skills

• Experience with Alteryx.
• BI tools such as Microsoft Power BI, Tableau, or Oracle BI.
• Hands‑on knowledge using Teradata.
• Working knowledge of software design patterns and architecture.
• Leads complex problem solving and provides technical guidance to colleagues and solution development.
• Proposes, designs, and codes software solutions to address complex business needs.
• Oversees technical and procedural documentation as required.

Education & Certifications

• Bachelor’s degree or equivalent combination of education, job‑specific certification(s), and experience (including military service).
• No specific certifications required.
• No licenses required.

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, backup child/elder care.
• Adoption, surrogacy, and doula reimbursement.
• Educational assistance, including select programs fully paid.
• Robust wellness program with financial incentives.
• Paid time off: maternity/parental leave, up to 11 paid holidays, 9 occasional absence days (unless otherwise required by law), 15‑25 vacation days per year depending on career level and years of service.

Equal Employment Opportunity (EEO)

PNC provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law. This position is subject to the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and the Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE Act) and/or FINRA, which prohibit the hiring of individuals with certain criminal history.

Disability Accommodation

If an accommodation is required to participate in the application process, please contact us via email at [e-mail] or call 877-968‑7762 and say "Workday" for accommodation assistance. All information provided will be kept confidential and used only to provide needed reasonable accommodations.