Data Architect Senior - Retail Architecture

PNC; Pittsburgh (Allegheny County); On-site; USD 80,000 - 194,350; Full time

Benefits offered by this job

Medical/prescription drug coverage

Dental and vision options

401(k) with PNC match

Educational assistance

Vacation days (15 to 25 annually)

Job summary

PNC is seeking a Data Architect Sr to design, develop, and optimize complex data warehouses in Pittsburgh, PA or other locations. This role focuses on ensuring data architecture meets business needs and includes responsibilities such as analyzing BI data and providing technical guidance.

The ideal candidate will have 8+ years of relevant experience, proficiency with Apache Kafka and Avro, and a Bachelor's degree. The position offers a competitive salary and extensive benefits.

PNC values a diverse workplace culture committed to equal opportunity for all employees.

Qualifications

• 8+ years of industry-relevant experience.
• Advanced degrees or certifications are preferred.
• Able to predict the impact of data changes on business processes.

Responsibilities

• Design, develop, and optimize complex data warehouses.
• Analyze BI data and recommend data warehouse growth.
• Collaborate with IT and business customers to develop requirements.

Skills

Apache Avro

Apache Kafka

Design

Enterprise Architecture Framework

Machine Learning (ML)

Risk Assessments

Technical Knowledge

Consulting

Data Architecture

Database Structures

Data Warehousing

IT Architecture

Logical Data Modeling

Organizational Leadership

Problem Solving

Requirements Analysis

Education

Bachelor’s degree

Job description

Position Overview

Data Architect Sr within PNC's Retail Architecture organization, based in Pittsburgh, PA, Cleveland, OH, Dallas, TX, or Birmingham, AL.

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are united in delivering the best experience for our customers. We foster an inclusive workplace culture where employees feel respected, valued, and have the opportunity to contribute to the company’s success.

Job Description

• Design, develop and optimize highly complex, specialized data warehouses with flexible and scalable data and ETL architecture to support business users and BI applications.
• Analyze BI data and make recommendations for data warehouse growth and enterprise integration.
• Collaborate with IT and business customers to develop requirements for overall data warehouse architecture.
• Provide technical guidance to ensure architecture and framework align with BI application needs.
• Lead and consult on the implementation and integration of data warehouses, ensuring data is current and meets organizational quality and integrity standards.
• Work with an extensive data streaming platform that supports making data available from many systems of record to all channel applications.
• Have experience with data streaming and Kafka, and design data streaming pipelines.
• Strong communication skills, able to communicate at multiple levels – technology partners, business partners and leadership.
• Understand business processes and predict the impact of data changes on those processes and systems.

Qualifications

• Apache Avro
• Apache Kafka
• Design
• Enterprise Architecture Framework
• Machine Learning (ML)
• Risk Assessments
• Technical Knowledge
• Consulting
• Data Architecture
• Database Structures
• Data Warehousing
• IT Architecture
• Logical Data Modeling
• Organizational Leadership
• Problem Solving
• Requirements Analysis

Work Experience

Roles at this level typically require a university/college degree. Higher level education such as a master’s degree, Ph.D., or certifications is desirable. Industry relevant experience is typically 8+ years. A comparable combination of education, job‑specific certification(s), and experience (including military service) may be considered in lieu of a degree.

Education

Bachelor’s degree

Pay Transparency

Base Salary: $80,000.00 – $194,350.00. Salaries may vary based on geographic location, market data and individual experience, education and performance. This role is incentive eligible with payment based on company, business and/or individual performance.

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; backup child/elder care
• Adoption, surrogacy and doula reimbursement
• Educational assistance, including select fully paid programs
• 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; additional days per years of service

Disability Accommodations Statement

If an accommodation is required to participate in the application process, please contact [e-mail] with 'accommodation request' in the subject line and include your name, the job ID, and your preferred method of contact in the body. Applicants may also call 877-968-7762 and say 'Workday' for accommodation assistance. All information will be kept confidential and used only to provide needed reasonable accommodations.

Equal Employment Opportunity (EEO)

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 protected categories. This position is subject to federal and state hiring laws.

California Residents

Refer to the California Consumer Privacy Act Privacy Notice to understand how PNC may use or disclose your personal information in our hiring practices.