Senior Data Engineer - Data Warehousing & Governance

PNC; United States; On-site; USD 91,000 - 186,000; Full time

Benefits offered by this job

Health benefits

401(k) match

Pension

Stock purchase plans

Paid time off

Job summary

PNC is seeking a Senior Data Engineer in the Asset Management Group, based in Pittsburgh, PA; Birmingham, AL; Cleveland, OH; Dallas, TX; and Phoenix, AZ. You will design, build, and support scalable data solutions, partnering with a Lead to advance governance and modeling in a modern data environment.

You will lead data warehouse design, pipelines, DDL, SCD modeling, and metadata work with Alation, while collaborating across engineers, BSA, QE, and reporting teams to deliver aligned data

Qualifications

• Experience in data warehousing, modeling, and SQL.
• Knowledge of Source-to-Target Mapping, DDL, SCD types, and naming standards, both Oracle and Hadoop.
• Experience working across cross-functional teams.
• Understanding of data governance principles.

Responsibilities

• Design and build data warehouse solutions, including pipelines, models, and transformations.
• Support data governance practices (quality, lineage, compliance).
• Create and maintain source-to-target mappings, DDL documentation, and SCD models.
• Contribute to metadata management and documentation using tools like Alation.
• Collaborate with engineers, BSA’s, QE, and reporting teams to deliver aligned data solutions.
• Support migration and modernization efforts, including legacy rationalization.
• Participate in cross-functional initiatives, releases, and code reviews.
• Troubleshoot data issues and perform root cause analysis.

Skills

Data warehousing

Data modeling

SQL

Source-to-Target Mapping

DDL

SCD types

Oracle

Hadoop

Cross-functional collaboration

Data governance

Education

Bachelor's degree

Tools

Alation

Oracle

Hadoop

Job description

PNC is seeking a Senior Data Engineer in the Asset Management Group, based in Pittsburgh, PA; Birmingham, AL; Cleveland, OH; Dallas, TX; and Phoenix, AZ. You will design, build, and support scalable data solutions, partnering with a Lead to advance governance and modeling in a modern data environment.

You will lead data warehouse design, pipelines, DDL, SCD modeling, and metadata work with Alation, while collaborating across engineers, BSA, QE, and reporting teams to deliver aligned data