Data Engineer Senior - Data Modeling
About The Position
The Senior Data Engineer within PNC’s Asset Management Group develops, supports, and implements data solutions for multiple applications to meet business objectives and user requirements. The role applies technical knowledge and industry experience to design, build, and maintain technology solutions, including scalable data warehouse models, pipelines, and transformations that support reporting, analytics, and strategic decision-making. The position leads data requirements analysis and development of data preparation processes, and helps design and build data service infrastructure across multiple data platforms. It oversees data solution development and implementation to ensure scalability, availability, and maintainability, and consults on data migration and transformation to support accuracy and security. The role also supports data governance, metadata management, documentation, migration and modernization initiatives, and cross-functional delivery. The position is based in an in-office work environment, with listed locations in Pittsburgh, Birmingham, Cleveland, Dallas, and Phoenix.
Requirements
- Bachelor’s degree; a comparable combination of education, job-specific certifications, and experience may be considered in lieu of a degree.
- 5+ years of industry-relevant experience typically required for roles at this level.
- 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.
- Appropriate knowledge, skills, and abilities for the role.
- No required certifications.
- No required licenses.
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 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 data 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 data requirements analysis and development of data preparation processes for targeted data solutions.
- Lead the design and construction of data service infrastructure across multiple data platforms according to workflow.
- Oversee the development and implementation of data solutions for multiple applications to ensure scalability, availability, and maintainability.
- Consult on data migration and transformation to ensure data solution accuracy and security.
- Focus on customer needs and satisfaction when making business decisions and creating customer solutions.
- Assess and manage risks associated with business objectives and activities in alignment with PNC’s Enterprise Risk Management Framework.
Benefits
- Medical and prescription drug coverage, with a Health Savings Account feature, for eligible full-time 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 programs that are 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.
- Opportunities for career advancement, internal mobility, leadership development, and continuous learning.
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
