Data Engineer Senior - Data Modeling

PA - Pittsburgh (15222)

Strongsville Technology Center (OH537)

Phoenix - East Camelback Exec Suite (AZ014)

Birmingham - Brock (AL112)

Dallas Innovation Center - Luna Rd (TX270)

Full time

R240257

** 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…