Senior Data Engineer – Data Modeling

PNC

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

Posted 11/2/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 WarehousingSQLData GovernanceData ModelingOracle

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 Warehouse SolutionsData ModelingSQLSource-to-Target MappingDDL DocumentationSCD ModelsData PipelinesData MigrationData Architecture DevelopmentBig Data

Soft Skills

CollaborationTroubleshootingRoot Cause AnalysisCustomer Focus

Tools & Technologies

AlationHadoop

Industry Keywords

Data Governance PrinciplesMetadata ManagementData EngineeringDatabase ManagementCross-Functional Teams

Tech Stack

Tools & technologies

HadoopOracleSQL

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, 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
Develop, support, and implement data solutions for multiple applications
Lead data requirement analysis and data preparation process development
Design and build data service infrastructure across multiple data platforms
Oversee development and implementation of scalable, available, and maintainable data solutions
Consult on data migration and transformation to ensure data accuracy and security
Manage customer-focused objectives and enterprise risks associated with business activities

Requirements

What you’ll need

University/college degree typically required
5+ years of industry-relevant experience
In lieu of a degree, a comparable combination of education, job-specific certification(s), and experience, including military service, may be considered
Bachelor's degree listed under Education
Strong experience in data warehousing, modeling, and SQL
Knowledge of Source-to-Target Mapping, DDL, SCD types, and naming standards
Experience with both Oracle and Hadoop
Experience working across cross-functional teams
Understanding of data governance principles
Knowledge of Big Data, data architecture development, database management, data engineering, data migrations, data modeling, data pipelines, data warehousing, and Structured Query Language (SQL)
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
Reasonable accommodations for applicants and qualified individuals with disabilities