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

5+ years of industry-relevant experience
Strong experience in data warehousing, modeling, and SQL
Knowledge of Source-to-Target Mapping, DDL, SCD types, and naming standards, both Oracle and Hadoop
Understanding of data governance principles
Bachelor's degree
Specific certifications are often required.

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
back-up child/elder care
adoption, surrogacy, and doula reimbursement
educational assistance, including select programs fully paid
a robust wellness program with financial incentives
maternity and/or parental leave
up to 11 paid holidays each year
9 occasional absence days each year
between 15 to 25 vacation days each year, depending on career level; and years of service

Senior Data Engineer

Key skills