Senior Data Engineer – Data Modeling

PNC

. Design and build data warehouse solutions, including pipelines, models, and transformations .

Posted 11/5/2026full-timeUnited StatesSenior💰 $91,000 - $185,900 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and building data warehouse solutions, including data modeling, SQL, and data governance practices. Proficient in collaborating with cross-functional teams to deliver scalable and maintainable data solutions while ensuring data accuracy and compliance.

Highest-signal resume keywords

Data WarehousingSQLSource-To-Target MappingData GovernanceData Migration

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ModelingData PipelinesData ArchitectureDatabase ManagementData Engineering

Soft Skills

Problem SolvingCollaboration

Tools & Technologies

OracleHadoopAlation

Industry Keywords

Data Governance PrinciplesBusiness IntelligenceData Analysis SoftwareSoftware Development Life CycleBig Data Management

Tech Stack

Tools & technologies

HadoopOracleSDLCSQL

About the role

Key responsibilities & impact

Design and build data warehouse solutions, including pipelines, models, and transformations
Support data governance practices, including 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, BSAs, QE, and reporting teams to deliver aligned data solutions
Support data migration and modernization efforts, including legacy rationalization
Participate in cross-functional initiatives, releases, and code reviews
Troubleshoot data issues and perform root cause analysis
Develop, support, and implement data solutions for multiple applications
Lead data requirements analysis and data preparation process development
Design and build data service infrastructure across multiple data platforms according to workflow
Oversee development and implementation of scalable, available, and maintainable data solutions
Consult on data migration and transformation to ensure data accuracy and security
Manage risks associated with business objectives and activities in support of PNC's Enterprise Risk Management Framework

Requirements

What you’ll need

University / college degree, with 5+ years of industry-relevant experience
Bachelor's degree
Comparable combination of education, job-specific certification(s), and experience, including military service, may be considered in lieu of a degree
Strong experience in data warehousing, modeling, and SQL
Knowledge of Source-to-Target Mapping, DDL, SCD types, and naming standards
Experience with Oracle and Hadoop
Understanding of data governance principles
Experience working across cross-functional teams
Knowledge of Big Data, data architecture development, database management, data engineering, data migrations, data modeling, data pipelines, and data warehousing
Knowledge of application delivery process, Big Data management and analytics, business intelligence, consulting, data analysis software, data architecture, database structures, problem solving, and software development life cycle
No required certifications
No required licenses
PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position

Benefits

Comp & perks

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 plan
Stock purchase plan
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 and years of service
Incentive-eligible compensation based on company, business and/or individual performance
Internal mobility, leadership development, and continuous learning opportunities
Reasonable accommodations for applicants and qualified individuals with disabilities