Data Engineer Senior - Data Modeling
About The Position
PNC is hiring a Senior Data Engineer in its Asset Management Group organization. The role is based in Pittsburgh, PA; Birmingham, AL; Cleveland, OH; Dallas, TX; or Phoenix, AZ, and is part of the AMG Tech Back Office Operations Experience team. PNC describes itself as an in-office company and encourages candidates to discuss workplace expectations with their recruiter and hiring manager. The Senior Data Engineer partners closely with a Lead to design, build, and support scalable data solutions. The hands-on role focuses on data engineering, governance, and modeling. The team supports systems and data for Asset Management Group operations, helping ensure information is accurate, accessible, and reliable for business users, advisors, operations teams, and leadership. Its data foundation supports reporting, analytics, operational efficiency, and strategic decision-making. 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 requirement analysis and data preparation process development; and leads design and construction of data service infrastructure across multiple platforms. The position oversees solutions to ensure scalability, availability, and maintainability and consults on data migration and transformation to support data accuracy and security. PNC expects employees to focus on customers and manage risks in accordance with the company's Enterprise Risk Management Framework. The position does not offer employment visa sponsorship or STEM OPT participation. The role is incentive eligible, with payment based on company, business, and/or individual performance.
Requirements
- Experience working across cross-functional teams.
- Understanding of data governance principles.
- Typically requires a university or college degree and 5+ years of industry-relevant experience; a comparable combination of education, job-specific certifications, and experience, including military service, may be considered in lieu of a degree.
- Bachelor’s degree listed under education; no required certifications or licenses are listed.
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 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 data solution development and implementation to ensure scalability, availability, and maintainability.
- Consult on data migration and transformation to ensure data solutions are accurate and secure.
- Apply customer-focused practices and assess and manage risks 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 and back-up child/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.
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
