PNC

Senior Data Engineer

PNC
Apply
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
PNC

About PNC

10,000+ employees

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.

Contact me