Senior Data Engineer: Data Warehousing & Modeling

PNC; Pittsburgh (Allegheny County); On-site; USD 91,000 - 186,000; Full time

Job summary

PNC is seeking a Senior Data Engineer to design, build, and support scalable data solutions in a modern data environment. You will partner with a Lead to deliver data pipelines, models, and transformations across the Asset Management Group.

Based in Pittsburgh, PA or other listed locations, you will contribute to governance, metadata, and migration efforts, participate in code reviews, and help ensure data quality and compliance while advancing large-scale analytics initiatives.

Qualifications

• University degree required or equivalent combination of education and experience.
• 5+ years of industry experience in data engineering or related roles.
• Experience working with cross-functional teams and data governance practices.

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

Big Data

Data Architecture

Database Management

Data Engineering

Data Governance

Data Migrations

Data Modeling

Data Pipelines

Data Warehousing

SQL

Education

Bachelors

Tools

Alation

Job description

PNC is seeking a Senior Data Engineer to design, build, and support scalable data solutions in a modern data environment. You will partner with a Lead to deliver data pipelines, models, and transformations across the Asset Management Group.

Based in Pittsburgh, PA or other listed locations, you will contribute to governance, metadata, and migration efforts, participate in code reviews, and help ensure data quality and compliance while advancing large-scale analytics initiatives.