Lead ETL & Data Integration Architect

PNC Bank; Pittsburgh (Allegheny County); On-site; USD 86,000 - 158,000; Full time

Job summary

PNC Bank in Pittsburgh is seeking a lead for ETL and data integration responsibilities to design and deliver data warehouse solutions. You will build ETL pipelines and APIs, integrate systems (REST/SOAP), and ensure data quality and governance with robust disaster recovery planning.

You will mentor engineers, conduct code reviews, and support reporting and CRM integrations (OBIEE, Salesforce, Siebel) while using deployment tools and CA7 scheduling.

Qualifications

• Lead design and delivery of ETL/data integration and data warehouse solutions.
• Provide governance and disaster recovery planning for data platforms.
• Mentor engineers, perform code reviews, and support reporting and CRM integrations.

Responsibilities

• Lead design and delivery of ETL/data integration solutions.
• Build complex ETL pipelines, APIs, and system integrations (REST/SOAP).
• Ensure data quality, governance, and disaster recovery planning.
• Mentor engineers, perform code reviews, and support reporting and CRM integrations (OBIEE, Salesforce, Siebel).
• Utilize deployment tools and mainframe scheduling (CA7).

Skills

ETL design

Data integration

Data warehouse

REST/SOAP APIs

Mentoring

Code reviews

CRM integrations

Deployment tools

CA7 scheduling

Tools

OBIEE

Salesforce

Siebel

CA7

Job description

PNC Bank in Pittsburgh is seeking a lead for ETL and data integration responsibilities to design and deliver data warehouse solutions. You will build ETL pipelines and APIs, integrate systems (REST/SOAP), and ensure data quality and governance with robust disaster recovery planning.

You will mentor engineers, conduct code reviews, and support reporting and CRM integrations (OBIEE, Salesforce, Siebel) while using deployment tools and CA7 scheduling.