Senior Data Engineer - Data Warehousing & Governance

PNC Financial Services Group; Strongsville (OH); On-site; USD 91,000 - 186,000; Full time

Job summary

PNC Financial Services Group is seeking a Senior Data Engineer for the Asset Management Group. Based across multiple offices, you will design, build and support scalable data solutions, focusing on governance, modeling and ETL pipelines to enable reliable analytics.

You will collaborate with cross-functional teams, create source-to-target mappings, and contribute to metadata and documentation using tools like Alation, while participating in migration and modernization initiatives.

Qualifications

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

Responsibilities

• Design 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

Governance

Education

Bachelor's degree

Tools

Alation

Job description

PNC Financial Services Group is seeking a Senior Data Engineer for the Asset Management Group. Based across multiple offices, you will design, build and support scalable data solutions, focusing on governance, modeling and ETL pipelines to enable reliable analytics.

You will collaborate with cross-functional teams, create source-to-target mappings, and contribute to metadata and documentation using tools like Alation, while participating in migration and modernization initiatives.