Data Engineer Assoc

Position Overview

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 Engineer Associate within PNC's Enterprise Technology, you may be based in a remote location. This is a remote position. Work may be performed from a quiet, confidential space in a home location, approved by PNC. This position may not be available in all geographic locations.

PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.

As an Data Engineer Assocociate 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.

Day to day responsibilities:
• Acquire/map datasets that align with our business partner needs.
• Develop algorithms that shape data into useful and actionable information.
• Build, test, and maintain database pipeline architectures.
• Collaborate with management to understand and meet company objectives.
• Form new data validation methodologies and data analysis tools.
• Ensure continued compliance with data security policies and governance.

Technical Qualifications:
• Education: BS/BA in technical discipline.
• 2+ years of Python development.
• 2+ years of experience with development/decomposition of complex SQL (RDMS Platforms)
• 2+ years of experience with test-driven development. Continuous Integration/ Development (e.g., GIT, Jenkins, Maven).
• 2+ years with CRON/Shell Scripting.
• Experience with utilization of REST API and/or EDPI.
• Hands on experience with project management tools such as JIRA, Confluence
• Ability to work with end users (BI analysts, data scientists, etc.) to solve technical issues.
• Experience working in an Agile Team construct.
• Extensive knowledge of databases, data warehouses, systems integrations, and data flows are mandatory for this role.
• Additionally, candidates should be well-versed in data architecture, data development, with a proven history of providing effective data solutions.
Required skills to be considered for this role:
• Coding: Proficiency in coding languages is essential to this role. Common programming languages used by the team include SQL, Python.
• Relational and non-relational databases: You should be familiar with both relational and non-relational databases, and how they work (Teradata, Oracle, etc.).
• 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.
• Automation and scripting. Candidate should be able to write scripts to automate repetitive tasks (e.g., Cron jobs, Linux, shell scripting).
• Data security: Securely managing and storing data to protect it from loss or theft per PNC guidelines.

This is a remote position. Work may be performed from a quiet, confidential space in a home location, approved by PNC. This position may not be available in all geographic locations.

Job Description

• 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.

PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be:

• 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.

Competencies

Application Delivery Process – Knowledge of major tasks, deliverables, and formal application delivery methodologies; ability to utilize these in order to deliver new or enhanced applications.

Big Data Management and Analytics – Knowledge and ability to plan and execute, big data management and analytics.

Business Intelligence – Knowledge of and ability to utilize business processes and technologies for gathering, storing, analyzing, and providing access to data that helps the organization make better business decisions.

Data Analysis - Software – Knowledge of the investigation, evaluation, interpretation, and classification of data; the ability to identify, collect and analyze data to facilitate the development, implementation and application of software systems.

Data Architecture – Knowledge and ability to create models and standards to govern which data is collected, and how it is stored, arranged, integrated, and put to use in data systems and in organizations.

Database Structures – Knowledge of and the ability to utilize appropriate database structures to organize and store data in a particular manner.

Effective Communications – Understanding of effective communication concepts, tools and techniques; ability to effectively transmit, receive, and accurately interpret ideas, information, and needs through the application of appropriate communication behaviors.

Problem Solving – Knowledge of approaches, tools, techniques for recognizing, anticipating, and resolving organizational, operational or process problems; ability to apply this knowledge appropriately to diverse situations.

Software Development Life Cycle – Knowledge of and experience with using a structured methodology for delivering new or enhanced software products to the marketplace.

Work Experience

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.

Education

Bachelors

Additional Job Description

Base Salary: Commensurate with skills and experience.

Benefits

Disability Accommodations Statement:

If an accommodation is required to participate in the application process, please contact us via email at AccommodationRequest@pnc.com. Please include “accommodation request” in the subject line title and be sure to include your name, the job ID, and your preferred method of contact in the body of the email. Emails not related to accommodation requests will not receive responses.  Applicants may also call 877-968-7762 and say "Workday" for accommodation assistance. All information provided will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.

At PNC we foster an inclusive and accessible workplace.  We provide reasonable accommodations to employment applicants and qualified individuals with a disability who need an accommodation to perform the essential functions of their positions.

Equal Employment Opportunity (EEO):

PNC provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law.

California Residents

Refer to the California Consumer Privacy Act Privacy Notice to gain understanding of how PNC may use or disclose your personal information in our hiring practices.