Data Engineer

PNC Bank•Pittsburgh, PA

8d•Onsite

About The Position

Develops, supports and implements data services for multiple applications to meet business objectives and user requirements. Uses technical knowledge and industry experience to design, build and maintain technology solutions. Works closely with users, developers, operations and business partners to define data service requirements and the data preparation process development. Designs and builds data service infrastructure on multiple data platforms, according to key business processes and the overall workflow. Develops and implements data solutions for multiple applications to ensure its scalability, availability and maintainability. Implements data migration and transformation activities/processes to ensure the accuracy and security of data solutions.

Requirements

Strong functional expertise in Oracle SQL, PL/SQL, and query tuning.
Working knowledge of MongoDB data models, indexing, and query performance.
Clear understanding of RDBMS vs NoSQL tradeoffs and use cases.
Ability to translate business and application requirements into efficient database designs.
Experience supporting enterprise-scale, data-intensive applications.
Analytical Thinking
Application Delivery Process
Big Data Management and Analytics
Business Intelligence
Data Analysis - Software
Data Architecture
Database Structures
Effective Communications
Problem Solving
Software Development Life Cycle
Bachelors degree
3+ years of relevant / direct industry experience

Nice To Haves

Analytical Thinking
Competitive Advantages
Data Analytics
Data Mining
Data Science
Machine Learning (ML)

Responsibilities

Serve as the functional DBA for Oracle and MongoDB across production and non‑production environments.
Partner with application teams on schema design, data modeling, and query optimization.
Analyze and resolve database-related functional issues, performance bottlenecks, and data anomalies.
Support release activities by validating database changes, scripts, and backward compatibility.
Provide guidance on transaction management, indexing strategy, and data access patterns.
Ensure data consistency, integrity, and correctness across applications and integrations.
Review and approve database changes for functional risk and impact.
Assist incident response by diagnosing database behavior and data-related failures.
Maintain functional documentation, standards, and runbooks for database usage.

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