7 days ago
Pittsburgh, PA, USASenior
Base Salary
$91k - $186k/yr
Responsibilities
- Design, build, and support data warehouse solutions, including data pipelines, models, transformations, and infrastructure.
- Lead data requirements analysis and data preparation development for targeted solutions.
- Create and maintain source-to-target mappings, DDL documentation, SCD models, naming standards, and metadata documentation.
- Support data governance practices involving data quality, lineage, compliance, and metadata management.
- Oversee scalable, available, and maintainable data solutions for multiple applications.
- Support data migration, transformation, modernization, and legacy rationalization efforts.
- Collaborate with engineers, business systems analysts, quality engineering, and reporting teams.
- Participate in cross-functional initiatives, releases, and code reviews.
- Troubleshoot data issues and perform 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, and naming standards.
- Experience with Oracle and Hadoop.
- Comparable combinations of education, job-specific certifications, and experience may be considered in lieu of a degree.
Benefits
- In-office role based in Pittsburgh, Birmingham, Cleveland, Dallas, or Phoenix.
- Medical and prescription drug coverage, including a Health Savings Account feature, plus dental and vision options.
- Employee and dependent life insurance, short- and long-term disability protection, 401(k) matching, 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, 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 eligibility.
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.