Data Architect Data and Automation (Teradata, SQL, Hadoop, Iceberg)
Pittsburgh, PA - USA
Job Summary
-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.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.
- 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.
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 PNCs Enterprise Risk Management Framework.
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.
To learn more about these and other programs including benefits for full time and part-time employees visit.
If an accommodation is required to participate in the application process please contact us via email at . Please include accommodation request in the subject line title and be sure to include your name the job ID and your preferred method of contact in the body of the email. Emails not related to accommodation requests will not receive responses. Applicants may also call and say Workday for accommodation assistance. All information provided will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.
At PNC we foster an inclusive and accessible workplace. We provide reasonable accommodations to employment applicants and qualified individuals with a disability who need an accommodation to perform the essential functions of their positions.
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.
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.
Required Experience:
Staff IC