7 days ago
Pittsburgh, PA, USASenior
Base Salary
$91k - $186k/yr
Responsibilities
- Design and build data warehouse solutions, including data pipelines, models, and transformations.
- Lead data requirements analysis and development of data preparation processes.
- Design and build data service infrastructure across multiple data platforms.
- Create and maintain source-to-target mappings, DDL documentation, SCD models, and naming standards.
- Support data governance, quality, lineage, compliance, metadata management, and documentation using tools such as Alation.
- Oversee scalable, available, and maintainable data solutions for multiple applications.
- Support data migration, transformation, modernization, and legacy rationalization efforts.
- Troubleshoot data issues and perform root cause analysis.
- Collaborate with engineering, business systems analysis, quality engineering, and reporting teams.
- Participate in cross-functional initiatives, releases, and code reviews.
Requirements
- Bachelor's degree.
- Typically 5+ years of industry-relevant experience.
- Strong experience in data warehousing, data modeling, and SQL.
- Knowledge of source-to-target mapping, DDL, SCD types, naming standards, Oracle, and Hadoop.
- Understanding of data governance principles.
- Experience working across cross-functional teams.
- A comparable combination of education, job-specific certifications, and experience, including military service, may be considered in lieu of a degree.
Benefits
- Medical and prescription drug coverage with a Health Savings Account feature, dental and vision options, life insurance, disability protection, 401(k) match, pension, and stock purchase plans.
- Dependent care reimbursement, back-up child and elder care, adoption, surrogacy, and doula reimbursement.
- Educational assistance, including select fully paid programs, plus a wellness program with financial incentives.
- Paid maternity and/or parental leave, up to 11 paid holidays, 9 occasional absence days, and 15 to 25 vacation days depending on career level and years of service.
- The role is in-office and may be based in Pittsburgh, Birmingham, Cleveland, Dallas, or Phoenix.
- The position is expected to be posted for approximately two business days from November 5, 2026, subject to business discretion.
Tech Stack
Apache HadoopSQL
Categories
Data Engineering
About PNC
PNC is a U.S. bank offering retail, business, and corporate banking, including checking, savings, credit cards, mortgages, auto loans, and wealth management. It earns revenue from interest income and fees across consumer, small-business, and institutional clients, and provides digital and branch services nationwide. Headquartered in Pittsburgh, it is a public company listed on the NYSE.