ETL)

PNC•Strongsville, OH

5d•$91,000 - $202,800•Onsite

About The Position

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 Architect within PNC's DNA Enterprise Warehouse organization, you will be based in Pittsburgh, PA or Strongsville, OH or Dallas, TX. We are seeking an experienced Data Architect to lead the architecture, and control frameworks for D&A technology, on-premises data ecosystem. In this role, you will design robust data movement controls, reconciliation pipelines, and semantic abstraction layers that connect high-throughput relational data warehouses, legacy Hadoop infrastructure, and modern on-premises Lakehouse environments. You will be responsible for defining standards that guarantee high availability, strict enterprise security, and accurate, audited data movement across networks and private storage cluster.

Requirements

Experience in data architecture and enterprise data management within large-scale, on-premises data center environments.
Proven track record designing enterprise-grade data control frameworks, reconciliation patterns, audit mechanisms, and schema evolution strategies for high-throughput environments.
Deep conceptual and architectural understanding of on-premises Hadoop ecosystems (HDFS, YARN, Hive, Spark, Kerberos) and strategies for modernizing legacy workloads.
Experience in architecture and operating mission critical, high volume, low latency services.
Experience in governance, implementation of and or use of Analytic Data and software to do analysis and/or advanced analytics and visualization
Engagement with multiple teams and coordination of multiple requirements that have similar needs, prioritizing based on business value
Implementation & Governance of Business Data Architecture Standards
Collaboration with Enterprise Architecture and Technology partners to generate business requirements in strategic business solution architecture with technology solution architecture
Experienced with architecting high-performance application data services against data stores with very large amounts of data.
Experience with Hadoop, Data Modeling, ETL/ELT, APIs
Experience with distributed computer solutions
Strong written and verbal communicator with the ability to translate complex technical information for senior management and product team.
Experience providing technical thought leadership across an organization.
Roles at this level typically require a university / college degree, with 5+ years of industry-relevant experience. Specific certifications are often required. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.

Nice To Haves

Agentic AI Strategy in Data Management: Exposure to or conceptual understanding of Agentic AI frameworks- specifically how autonomous agents can be leveraged for automated pipeline observability, intelligent metadata tagging, self-healing quality checks, and context-aware schema drift mitigation.
Python (Programming Language)

Responsibilities

On-Premises Data Movement & Control Architecture: Control & Reconciliation frameworks: Architect automated, enterprise-wide data validation mechanisms (source-to-target row count verification, checksum validation, automated threshold alerting and schema evolution tracking) across internal networks. Dual-Orchestration Operations: Define standards bridging enterprise job scheduling (Control-M for batch/legacy workflows) with programmatic DAG orchestration (Apache Airflow deployed on-perm).
Lakehouse, Catalog & Graph Architecture: Rest Catalog Governance (Apache Polaris): Architect and maintain Apache Polaris as the centralized, open-source REST catalog for Apache Iceberg tables. Enforce multi-engine catalog governance, role-based access control (RBAC), and credential scoping across engines. Query Federation (Trino): Implement and tune Trino across local bare-metal or private Kubernetes clusters to federate SQL queries seamlessly across relational databases, Hadoop and Iceberg storage. Graph Databases & Knowledge Graphs: Architect property or RDF graph database integrations (Graph DB) to capture complex entity relationships, data lineage, and semantic ontologies.
Auditability & Lineage: Maintain complete operational metadata, structural tracking, and end-to-end data lineage across all internal data movement paths for strict regulatory compliance.
Provide thought leadership for the control architecture evolution within the DnA Data Ops ecosystem.
Work with Architectural Leadership to drive out the strategic roadmap for all applications and ensure appropriate architectural and technical items are suitably prioritized.
Work with Product Owners to ensure prioritization and delivery of business priorities in a timely manner via the monthly releases.
Participate in business requirements gathering sessions and understand client requirements.
Create, present, and get signoffs for design documents.
Support the enterprise architecture and perform proof of concepts for several new requirements to find innovative ways to enhance current architecture.
Be responsible for compliance to all architecture and technology standards and handle any exceptions and vulnerabilities.
Well-versed in new technologies to keep current architecture moving forward while maintaining the integrity of enterprise architectures.
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.

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; and years of service.