Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

As a Data Architect within PNC's Data and Automation organization, you will administer and support enterprise Teradata database environments, ensuring high availability, performance, security, and reliability for critical business applications and data warehouse solutions. You will also partner with cross-functional teams to identify opportunities for process improvement, automate routine administrative tasks leveraging AI agent, and provide technical guidance to enhance database performance and operational efficiency.

Responsibilities

Administer and support enterprise Teradata database environments, ensuring high availability, performance, security, and reliability for critical business applications and data warehouse solutions.
Monitor database health, troubleshoot production incidents, optimize SQL performance, and resolve data and application issues to meet establish service level agreements (SLA).
Support ETL and batch processing by managing Teradata utilities, analyzing job failures, and collaborating with application development and infrastructure teams to ensure successful data processing.
Implement database changes, manage user access and security, perform performance tuning, and maintain database objects in accordance with change management and operational best practices.
Partner with cross functional teams to identify opportunities for process improvement, automate routine administrative tasks leveraging AI agent, and provide technical guidance to enhance database performance and operational efficiency.
Designs, develops and optimizes data warehouses, with flexible and scalable data and ETL architecture, to support business users and Business Intelligence (BI) applications.
Analyzes business intelligence data and makes recommendations for data warehouse growth and integration an application/business function.
Works with IT and business customers to capture requirements for designing the data warehouse architecture.
Provides support and technical guidance to ensure the solutions are aligned with the architecture and framework.
Leads and consults on the implementation and integration of data warehouses; ensures the solution meets organizational quality and integrity standards.

Requirements

Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role.
PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.
This position is subject to the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and, for any registered role, the Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE Act) and/or the Financial Industry Regulatory Authority (FINRA), which prohibit the hiring of individuals with certain criminal history.

Skills

Apache Hadoop
Competitive Advantages
Customer Solutions
Design
Enterprise Architecture Framework
Machine Learning (ML)
Risk Assessments
Structured Query Language (SQL)
Technical Knowledge
Teradata ETL
Consulting
Data Architecture
Database Structures
Data Warehousing
IT Architecture
Logical Data Modeling
Organizational Leadership
Problem Solving
Requirements Analysis

Location

Pittsburgh-PA
Strongsville-OH
Birmingham-AL
Dallas-TX
Denver-CO
Phoenix-AZ

Work Type

in-office

Experience Level

5+ years of industry-relevant experience

Education Level

Bachelors

Salary/Compensations

$91,000.00 – $202,800.00

Benefits

medical/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/elder care
adoption, surrogacy, and doula reimbursement
educational assistance, including select programs fully paid
a robust 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
between 15 to 25 vacation days each year, depending on career level
years of service

About the Company

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.
PNC is an in-office company that fosters a supportive culture where employees can thrive and achieve balance.
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.

Equal Opportunity

PNC provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law.