Data Engineer Assoc

PNC Bank•Farmers Branch, TX

2d•Remote

About The Position

As a Data Engineer Associate for PNC's Security Analytics Hub, you will have the opportunity to work fully remote. Our team focuses on producing data driven insights into multiple areas of risk facing the bank, including cybersecurity and physical security. Assists in developing, supporting and implementing data solutions for multiple applications in order to meet business objectives and user requirements. Leverages technical knowledge and industry experience to design, build and maintain technology solutions. Performs data requirement analysis and the data preparation process development for targeted data solutions. Assists in designing and building data service infrastructure on multiple data platforms, according the workflow. Participates the development and implementation of data solutions for multiple applications to ensure its scalability, availability and maintainability. Consults on data migration and transformation to ensure the accuracy and security of data solutions.

Requirements

Experience working in an Agile Team construct.
Extensive knowledge of databases, data warehouses, systems integrations, and data flows are mandatory for this role.
Proficiency in coding languages is essential to this role.
SQL
Python
ETL (extract, transform, and load) systems: Moving data from databases and other sources into a single repository, like a data warehouse.
Data storage knowledge: As solutions are designed, when to use a data lake versus a data warehouse, for example.
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 PNC's Enterprise Risk Management Framework.

Nice To Haves

Analytical Thinking
Competitive Advantages
Data Analytics
Data ETL
Data Mining
Data Science
Machine Learning (ML)
Python (Programming Language)
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

Responsibilities

Acquire/map datasets that align with our business partner needs.
Develop ETL pipelines, Data Ingestion, basic transformations
Build, test, and maintain database pipeline architectures.
Form new data validation methodologies and data analysis tools.
Ensure continued compliance with data security policies and governance.

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