Data Engineer Senior - Data Modeling
About The Position
The Senior Data Engineer works within PNC’s Asset Management Group and partners closely with a Lead to design, build, and support scalable data solutions. The hands-on role focuses on data engineering, governance, and modeling in a modern data environment. The position is based in Pittsburgh, Birmingham, Cleveland, Dallas, or Phoenix, and PNC describes its workplace as in-office. The role leads development, support, and implementation of data solutions for multiple applications to meet business objectives and user requirements. It includes analyzing data requirements, developing data preparation processes, designing and building data service infrastructure across platforms, and overseeing solution implementation to ensure scalability, availability, and maintainability. The engineer also consults on data migration and transformation to support accuracy and security. The position involves warehouse pipelines, models, and transformations; governance practices such as data quality, lineage, and compliance; source-to-target mappings, DDL documentation, and SCD models; and metadata management and documentation using tools such as Alation. The engineer collaborates with engineering, BSA, QE, and reporting teams, supports migration and modernization initiatives, participates in releases and code reviews, and troubleshoots data issues through root cause analysis. PNC emphasizes customer focus and effective management of business risks. Candidates must demonstrate the knowledge and skills required for the role. A bachelor’s degree and typically five or more years of industry-relevant experience are listed; a comparable combination of education, job-specific certifications, and experience may be considered in lieu of a degree. No certification or license is required.
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; a comparable combination of education, job-specific certifications, and experience may be considered in lieu of a degree.
- Demonstrate appropriate knowledge, skills, and abilities for the role.
Nice To Haves
- Strong experience in data warehousing, data modeling, and SQL.
- Knowledge of source-to-target mapping, DDL, SCD types, and naming standards across Oracle and Hadoop.
- 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 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 solutions.
- Design and build data service infrastructure across multiple data platforms according to workflow.
- Oversee development and implementation of solutions to ensure scalability, availability, and maintainability.
- Consult on data migration and transformation to ensure data accuracy and security.
- Apply customer-focused practices and effectively manage risks associated with business objectives and activities.
Benefits
- Medical and prescription drug coverage, with a Health Savings Account feature.
- 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 programs fully paid.
- Wellness program with financial incentives.
- Maternity and/or parental leave.
- Up to 11 paid holidays each year.
- 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
