Data Engineer Senior - Data Modeling

PNC Bank • Pittsburgh, PA

4d • Onsite

About The Position

As a Senior Data Engineer in PNC's Asset Management Group, this role builds the data foundation used for reporting, analytics, and strategic decision-making. It designs, builds, and maintains scalable data warehouse solutions, including pipelines, data models, and transformations, while supporting data governance, metadata management, and documentation. The position contributes to migration and modernization efforts, collaborates across engineering and business teams, and troubleshoots data issues.

The role leads development, support, and implementation of data solutions across multiple applications. It analyzes data requirements and develops data preparation processes, designs data service infrastructure across platforms, and oversees solutions to ensure scalability, availability, and maintainability. It also consults on migration and transformation to support accurate and secure data solutions.

The position is based in Pittsburgh, Birmingham, Cleveland, Dallas, or Phoenix. PNC describes its workplace as in-office and encourages candidates to discuss workplace expectations with their recruiter and hiring manager. Employment visa sponsorship and STEM OPT participation are not provided for this position.

Requirements

• Bachelor's degree; a comparable combination of education, job-specific certifications, and experience may be considered in lieu of a degree.
• Typically, 5 or more years of industry-relevant experience.
• Strong experience in data warehousing, data modeling, and SQL.
• Knowledge of source-to-target mapping, DDL, SCD types, and naming standards, including Oracle and Hadoop.
• Demonstrate appropriate knowledge, skills, and abilities for the role.
• Customer-focused approach, with knowledge of practices that prioritize customer needs and satisfaction.
• Specific certifications are often required, but no certification is required for this position.
• No license is required for this position.

Nice To Haves

• Experience working across cross-functional teams.
• Understanding of data governance principles.
• Skills in big data, data architecture development, database management, data engineering, data governance, data migrations, data modeling, data pipelines, data warehousing, and SQL.
• Competencies in application delivery process, big data management and analytics, business intelligence, consulting, software-based data analysis, data architecture, database structures, problem solving, and the software development life cycle.

Responsibilities

• Design and build data warehouse solutions, including pipelines, models, and transformations.
• Support data governance practices, including data quality, lineage, and compliance.
• Create and maintain source-to-target mappings, DDL documentation, and SCD models.
• Contribute to metadata management and documentation using tools such as Alation.
• Collaborate with engineers, BSA’s, QE, and reporting teams to deliver aligned data solutions.
• Support migration and modernization efforts, including legacy rationalization.
• Participate in cross-functional initiatives, releases, and code reviews.
• Troubleshoot data issues and perform root cause analysis.
• Lead development, support, and implementation of data solutions for multiple applications to meet business objectives and user requirements.
• Lead data requirement analysis and development of data preparation processes for targeted data solutions.
• Lead the design and building of data service infrastructure across multiple data platforms according to workflow.
• Oversee development and implementation of data solutions to ensure scalability, availability, and maintainability.
• Consult on data migration and transformation to ensure data solutions are accurate and secure.
• Assess and manage risks associated with business objectives and activities in support of PNC's Enterprise Risk Management Framework.

Benefits

• Medical and prescription drug coverage, with a Health Savings Account feature, for eligible employees.
• Dental and vision options.
• Employee and spouse/child life insurance.
• Short- and long-term disability protection.
• 401(k) with PNC match.
• Pension and stock purchase plans.
• Dependent care reimbursement account.
• Back-up child and elder care.
• Adoption, surrogacy, and doula reimbursement.
• Educational assistance, including select fully paid programs.
• Wellness program with financial incentives.
• Maternity and/or parental leave, depending on eligibility.
• Up to 11 paid holidays each year, depending on eligibility.
• 9 occasional absence days each year, unless otherwise required by law.
• 15 to 25 vacation days each year, depending on career level and years of service.
• Incentive-eligible compensation based on company, business, and/or individual performance.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior