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 governance practices, data modeling, and SQL. Proficient in collaborating with cross-functional teams to deliver scalable data solutions and support data migration and transformation efforts.

Highest-signal resume keywords

Data WarehousingSQLData Governance PrinciplesOracleHadoop

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 PipelinesSource-to-Target MappingDDL DocumentationSCD TypesData Architecture DevelopmentDatabase ManagementData EngineeringData MigrationBig Data Management

Soft Skills

Problem SolvingCollaboration

Tools & Technologies

Alation

Industry Keywords

Data GovernanceBusiness IntelligenceData Analysis SoftwareSoftware Development Life CycleOperational Efficiency

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, 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
Partner with a Lead to design, build, and support scalable data solutions
Lead data requirement analysis and data preparation process development
Lead the design and construction of 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
Build data foundations supporting reporting, analytics, operational efficiency, and strategic decision-making across PNC’s Asset Management Group

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
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
Experience with Oracle and Hadoop
Knowledge of Big Data, data architecture development, database management, data engineering, data migrations, data modeling, data pipelines, and data warehousing
Knowledge of application delivery processes, Big Data management and analytics, business intelligence, consulting, data analysis software, data architecture, database structures, problem solving, and software development life cycle
Must not require employment visa sponsorship; PNC will not provide sponsorship or participate in STEM OPT
No required certifications or licenses
No required or preferred language assessments

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 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
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, with payment based upon company, business and/or individual performance
Reasonable accommodations for applicants and qualified individuals with disabilities