7 days ago
Pittsburgh, PA, USASenior
Base Salary
$91k - $186k/yr
Responsibilities
- Design and build data warehouse solutions, including pipelines, models, and transformations.
- Lead data requirement 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, and SCD models.
- Support data governance, quality, lineage, compliance, metadata management, and documentation.
- Oversee scalable, available, and maintainable data solutions for multiple applications.
- Support data migration, transformation, modernization, and legacy rationalization efforts.
- Collaborate with engineering, business systems analysis, quality engineering, and reporting teams.
- Participate in cross-functional initiatives, releases, code reviews, troubleshooting, and root cause analysis.
Requirements
- Bachelor’s degree.
- Typically 5+ years of industry-relevant experience.
- Experience working across cross-functional teams.
- Understanding of data governance principles.
- Strong experience in data warehousing, data modeling, and SQL.
- Knowledge of source-to-target mapping, DDL, SCD types, naming standards, Oracle, and Hadoop.
- A comparable combination of education, job-specific certifications, and experience, including military service, may substitute for a degree.
Benefits
- In-office work arrangement with locations in Pittsburgh, PA; Birmingham, AL; Cleveland, OH; Dallas, TX; and Phoenix, AZ.
- Medical and prescription drug coverage, including a Health Savings Account feature, plus dental and vision options.
- Employee and spouse/child life insurance and short- and long-term disability protection.
- 401(k) with PNC 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, and 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 service.
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.