Lead Software Engineer, ETL/Regulatory Risk & Compliance

PNC

Confirmed live yesterday High trust

Quick summary

Work type: On-site
Location: Pittsburgh, PA
Posted: 94 days ago
Freshness: Confirmed live yesterday
Nearby: 99+ roles within 25 mi

Market check

Salary context

How this pay compares to similar roles

Similar $205k

$187k most similar roles pay here $230k

This listing doesn't post a salary. Most similar roles pay $192,050–$218,325.

Based on 240 similar postings.

Employer

About PNC

PNC is one of the largest diversified financial services institutions in the U.S., based in Pittsburgh, PA, it provides retail banking, corporate banking, and asset management.

PNC currently has 118 open roles on FindRole.

Listed pay typically runs $86,250–$172,500 across 62 roles with salary data.

Most-posted roles

View all roles at PNC

At a glance

TL;DR · Lead Software Engineer, ETL/Regulatory Risk & Compliance

Role Posting Log in to save

Software Engineer Lead (ETL/Regulatory Risk & Compliance) serves within the Finance Accounting Technology organization, specifically supporting the Regulatory Risk and Compliance Reporting team. This role involves leading the technical design, development, and documentation of software solutions for data-intensive applications that satisfy critical business and regulatory requirements. The successful candidate will manage data changes from consumption to reporting while providing technical guidance to colleagues and solving complex problems. Key technical requirements include advanced proficiency in Informatica PowerCenter, Oracle SQL/PLSQL, and UNIX shell scripting, alongside experience with CA7 job schedulers and DevOps tools for ETL code deployments. Additional preferred skills include Alteryx, Teradata, and BI tools like Power BI or Tableau. The role addresses the specific challenge of developing innovative technology to support mandatory regulatory submissions within a banking environment through robust data modeling and performance tuning.

Skills

Informatica power center Oracle SQL PL/SQL ETL Unix Shell Scripting CA7 Teradata Alteryx Power BI Tableau Oracle BI DevOps Agile Waterfall Data Modeling

What you'll do

Lead the technical design and development of software solutions for regulatory risk and compliance reporting.
Design and program data transformations using Informatica PowerCenter and Oracle SQL/PLSQL.
Perform performance tuning for targets, sources, mappings, sessions, and workflows.
Develop SCD mappings from various source formats using necessary transformations.
Manage ETL code deployments utilizing DevOps tools and UNIX shell scripting.
Provide technical guidance, support, and complex problem resolution to colleagues.
Create and maintain technical and procedural documentation for software projects.
Review coding, testing, and documentation to ensure alignment with business requirements.

What we're looking for

Must have 5+ years of development experience.
Must possess advanced design and programming skills in Informatica PowerCenter 9.6 and above.
Must be proficient in developing, debugging, and performance tuning Oracle SQL/PLSQL code.
Must have hands-on knowledge of UNIX shell scripting and CA7 job scheduler.
Experience with ETL code deployments using DevOps tools is required.
Bachelor's degree or a comparable combination of education, certifications, and experience is required.
Preferred skills include Alteryx, Teradata, and BI tools like Power BI or Tableau.
Experience in banking and regulatory reporting is preferred.

Similar roles

Software Engineer Lead

PNC

Pittsburgh, PA +2 73 days ago $86,250–$158,125

Java Spring Boot GraphQL Angular SQL NoSQL Oracle MySQL PostgreSQL MongoDB Kafka Dynatrace ELK OpenShift Kubernetes CI/CD JUnit Karate Cypress Bitbucket Jenkins Domain-Driven Design OAuth 2.0 OIDC

3+ yrs exp

Save

Software Engineer Lead

PNC

Pittsburgh, PA +3 93 days ago $86,250–$158,125

Python Django JavaScript Kubernetes OpenShift CI/CD SonarQube PostgreSQL Oracle Microservices APIs GenAI Document AI PyCharm

3+ yrs exp

Save

Lead Software Engineer, Site Reliability Engineering

PNC

Pittsburgh, PA +7 49 days ago $86,250–$158,125

Java Spring Boot J2EE Kubernetes Microservices Mongo DB Dynatrace Elastic search Postman MQ Kafka ETL SAFe Mainframe Oracle SQL Ansible Site Reliability Engineering

3+ yrs exp

Save