23 hours ago
Pittsburgh, PA, USASenior
Base Salary
$91k - $186k/yr
Responsibilities
- Design and build data warehouse solutions, including pipelines, models, and transformations.
- Develop and support scalable data solutions and data service infrastructure across multiple applications and platforms.
- Create and maintain source-to-target mappings, DDL documentation, and slowly changing dimension models.
- Support data governance, data quality, lineage, compliance, metadata management, and documentation using tools such as Alation.
- Lead data requirement analysis and data preparation process development.
- Support data migration, transformation, modernization, and legacy rationalization efforts.
- Collaborate with engineers, business systems analysts, quality engineers, and reporting teams.
- Participate in cross-functional initiatives, releases, and code reviews.
- Troubleshoot data issues and perform root cause analysis.
- Help ensure the scalability, availability, maintainability, accuracy, and security of data solutions.
Requirements
- Bachelor’s degree required.
- Typically 5+ years of industry-relevant experience.
- Strong experience in data warehousing, data modeling, and Structured Query Language (SQL).
- Knowledge of source-to-target mapping, DDL, slowly changing dimension types, and naming standards.
- Experience with Oracle and Hadoop data environments.
- Understanding of data governance principles.
- Knowledge of data architecture, database management, data pipelines, data migrations, big data, and business intelligence.
- Comparable combinations of education, job-specific certifications, and experience may be considered in lieu of a degree.
Benefits
- In-office position based in Pittsburgh, Birmingham, Cleveland, Dallas, or Phoenix.
- Medical and prescription drug coverage with a Health Savings Account feature, dental and vision options, life insurance, short- and long-term disability protection, 401(k) match, pension, and stock purchase plans.
- Dependent care reimbursement, backup 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.
- Full-time employees may be eligible for the listed benefits; the role is incentive eligible.
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.
