Data Engineer Senior - Data Modeling

PNC Bank • Pittsburgh, PA

7h • Onsite

About The Position

As a Senior Data Engineer within PNC’s Asset Management Group, you will partner closely with a Lead to design, build, and support scalable data solutions. This hands-on role focuses on data engineering, governance, and modeling in a modern data environment. The position is based in Pittsburgh, Pennsylvania; Birmingham, Alabama; Cleveland, Ohio; Dallas, Texas; or Phoenix, Arizona.

The role leads development, support, and implementation of data solutions for multiple applications to meet business objectives and user requirements. It uses technical knowledge and industry experience to design, build, and maintain technology solutions; leads data requirements analysis and data-preparation process development; and leads the design and construction of data-service infrastructure across multiple platforms. It also oversees solutions to ensure scalability, availability, and maintainability, and consults on data migration and transformation to ensure accuracy and security.

PNC describes itself as an in-office company and encourages candidates to discuss workplace expectations with their recruiter and hiring manager. PNC will not provide employment-visa sponsorship or participate in STEM OPT for this position.

Requirements

• Experience working across cross-functional teams.
• Understanding of data governance principles.
• Typically, a university or college degree and 5 or more years of industry-relevant experience are required at this role level; a comparable combination of education, job-specific certifications, and experience, including military service, may be considered instead of a degree.
• Demonstrate appropriate knowledge, skills, and abilities for the role.
• PNC requires employees to be customer focused and to consider customer needs and satisfaction in business decisions.

Nice To Haves

• Strong experience in data warehousing, data modeling, and SQL.
• Knowledge of source-to-target mapping, DDL, SCD types, and naming standards in Oracle and Hadoop environments.
• 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 processes, 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, business systems analysts, quality engineering, 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.
• Develop, support, and implement data solutions for multiple applications to meet business objectives and user requirements.
• Lead data requirements analysis and development of data-preparation processes for targeted solutions.
• Lead the design and construction of data-service infrastructure across multiple data platforms according to workflow needs.
• Oversee data-solution development and implementation to ensure scalability, availability, and maintainability.
• Consult on data migration and transformation to ensure data accuracy and security.
• 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, subject to eligibility.
• 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, subject to eligibility.
• Up to 11 paid holidays each year, subject to 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