Data Engineer Senior - Data Modeling
Job Description
PNC Financial Services Group is hiring a Senior Data Engineer to support the Asset Management Group (AMG) with scalable data engineering in a modern data environment. This onsite role focuses on data modeling and the end-to-end delivery of data solutions, with responsibilities spanning governance, metadata, migration, and troubleshooting across multiple applications.
You will work from one of the following locations: Pittsburgh, PA; Birmingham, AL; Cleveland, OH; Dallas, TX; or Phoenix, AZ. The position is available with a base salary range of USD 91,000 - 185,900 per year and is incentive eligible based on company, business, and/or individual performance.
What you will do
- Design and build data warehouse solutions, including pipelines, models, and transformations.
- Support data governance practices covering quality, lineage, and compliance.
- Create and maintain source-to-target mappings, DDL documentation, and SCD models.
- Contribute to metadata management and documentation using 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.
- Lead the development, support, and implementation of data solutions for multiple applications to meet business objectives and user requirements.
- Lead data requirement analysis and the development of data preparation processes for targeted data solutions.
- Lead designing and building data service infrastructure on multiple data platforms according to the workflow.
- Oversee development and implementation of data solutions for multiple applications to ensure scalability, availability, and maintainability.
- Consult on data migration and transformation to help ensure accuracy and security.
Required qualifications
- 5+ years of industry-relevant experience.
- Bachelor’s degree (university/college degree).
- Experience working across cross-functional teams.
- Understanding of data governance principles.
- Strong experience in data warehousing, modeling, and SQL.
- Knowledge of Source-to-Target Mapping, DDL, SCD types, and naming standards, including both Oracle and Hadoop.
Technologies
- Alation
- SQL
- Oracle
- Hadoop
Even better if you have
- Strong experience in data warehousing, modeling, and SQL.
- Knowledge of Source-to-Target Mapping, DDL, SCD types, and naming standards for both Oracle and Hadoop.
Benefits
- 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.
- Stock purchase plans.
- Dependent care reimbursement account.
- Back-up child/elder care.
- Adoption, surrogacy, and doula reimbursement.
- Educational assistance, including select programs fully paid.
- Robust wellness program with financial incentives.
- Maternity and/or parental leave.
- Up to 11 paid holidays each year.
- 9 occasional absence days each year, unless otherwise required by law.
- 15 to 25 vacation days each year, depending on career level.
Additional information
- APPLICATION WINDOW: Expected to be posted for two business days from 11/05/2026, though it may be longer with business discretion.
- Visa sponsorship: PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.