Data Engineer Senior - Data Modeling

PNC Financial Services Group is seeking a Senior Data Engineer focused on data modeling within the Asset Management Group (AMG). This onsite role supports the design, build, and ongoing operation of scalable data solutions in a modern data environment, with strong emphasis on governance and metadata practices.

Role Location

This position is based in one of the following locations: Pittsburgh, PA; Birmingham, AL; Cleveland, OH; Dallas, TX; or Phoenix, AZ. The role is onsite.

Compensation

Base salary: USD 91,000 to 185,900 per year. Incentive eligibility: This role is incentive eligible, with payment based on company, business, and/or individual performance.

Application Window

Generally, this opening is expected to be posted for two business days from 11/05/2026, though it may be longer at the discretion of the business.

Responsibilities

• Design and build data warehouse solutions, including pipelines, models, and transformations.
• Support data governance practices across quality, lineage, and compliance.
• Create and maintain source-to-target mappings, DDL documentation, and SCD models.
• Contribute to metadata management and documentation using tools such as 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 develop the data preparation process for targeted data solutions.
• Lead the design and build of data service infrastructure on multiple data platforms, aligned to the workflow.
• Oversee development and implementation of data solutions for multiple applications to support scalability, availability, and maintainability.
• Consult on data migration and transformation to help ensure accuracy and security of data solutions.

Required Qualifications

• 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 Oracle and Hadoop.
• Bachelor’s degree.
• 5+ years of industry-relevant experience.

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 across Oracle and Hadoop.

Skills and Competencies

• Big Data Management and Analytics
• Business Intelligence
• Consulting
• Data Analysis - Software
• Data Architecture
• Database Structures
• Problem Solving
• Software Development Life Cycle
• Application Delivery Process

Benefits

• Medical and 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

Visa Sponsorship

PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.