Data Engineer Assoc

PNC is a company that values its people as its greatest differentiator and competitive advantage. As a Data Engineer Associate for PNC's Security Analytics Hub, you will work remotely to produce data-driven insights into various risk areas, including cybersecurity and physical security.

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
• Assists in developing, supporting and implementing data solutions for multiple applications in order to meet business objectives and user requirements
• 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
• Common programming languages used by the team include 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
• Assists in developing, supporting and implementing data solutions for multiple applications in order to meet business objectives and user requirements
• 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
• 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
• Roles at this level typically require a university / college degree, with 2+ years of relevant professional experience
• In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered
• Bachelors
• 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