Data Engineer Senior - Data Modeling

Position Overview At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. We work together each day to foster an inclusive workplace culture where all of our employees feel respected, valued and have an opportunity to contribute to the company’s success. As a Data Engineer Senior within PNC's Asset Management Group organization, you will be based in Pittsburgh, PA; Birmingham, AL; Cleveland, OH; Dallas, TX, and Phoenix, AZ. Why This Job Matters This role is responsible for building the data foundation that powers reporting, analytics, and strategic decision-making across the organization. By designing scalable and reliable data models, the Senior Data Engineer ensures that business leaders and teams can trust the data they use to drive growth, improve customer experience, and support innovation. What You’ll Do -Design and build data warehouse solutions, including pipelines, models, and transformations. -Support data governance practices (quality, lineage, compliance). -Create and maintain source-to-target mappings, DDL documentation, and SCD models. -Contribute to metadata management and documentation using tools like 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. Preferred Experience -Experience working across cross-functional teams. -Understanding of data governance principles. Technical Skills -Strong experience in data warehousing, modeling, and SQL. -Knowledge of Source-to-Target Mapping, DDL, SCD types, and naming standards, both Oracle and Hadoop. Why PNC PNC is an attractive employer because it offers the stability and resources of one of the nation's leading financial institutions while continuing to invest in innovation, technology, and employee growth. Employees can work on meaningful initiatives that impact millions of customers and businesses across the country, while also benefiting from a culture that values collaboration, inclusion, and professional development. PNC provides opportunities for career advancement through internal mobility, leadership development, and continuous learning, allowing employees to build long-term careers across a variety of disciplines. For technology and data professionals in particular, PNC offers the chance to work on large-scale, enterprise-wide projects involving data, analytics, cloud technologies, and digital transformation. Employees can make a tangible impact by helping improve customer experiences, support business decision-making, strengthen risk management practices, and drive innovation across the organization, all while contributing to PNC's purpose of helping clients, communities, and employees move forward financially. PNC is an in-office company that fosters a supportive culture where employees can thrive and achieve balance. We encourage candidates to connect with their recruiter and hiring manager to understand workplace expectations and ensure the role aligns with their goals.   PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position. Job Description Leads in developing, supporting and implementing data solutions for multiple applications in order to meet business objectives and user requirements. Leverages technical knowledge and industry experience to design, build and maintain technology solutions. Leads data requirement analysis and the data preparation process development for targeted data solutions. Leads in designing and building data service infrastructure on multiple data platforms, according the workflow. Oversees the development and implementation of data solutions for multiple applications to ensure its scalability, availability and maintainability. Consults on data migration and transformation to ensure the accuracy and security of data solutions. PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be: Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions. Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC's Enterprise Risk Management Framework. Qualifications Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and required certifications/licensures needed to be successful in this position. Preferred Skills Big Data, Data Architecture Development, Database Management, Data Engineering, Data Governance, Data Migrations, Data Modeling, Data Pipelines, Data Warehousing (DW), Structured Query Language (SQL) Competencies Application Delivery Process, Big Data Management and Analytics, Business Intelligence, Consulting, Data Analysis - Software, Data Architecture, Database Structures, Problem Solving, Software Development Life Cycle Work Experience Roles at this level typically require a university / college degree, with 5+ years of industry-relevant experience. Specific certifications are often required. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered. Education Bachelors Certifications No Required Certification(s) Licenses No Required License(s) Language Assessments   No Required or Preferred Language Assessments   Pay Transparency Base Salary: $91,000.00 – $185,900.00 Salaries may v