Data Engineer Senior at PNC Financial Services Group in Raleigh, North Carolina

Job Description:

Job Profile

Job Description

The PNC Financial Services Group, Inc. has an opening for a Data Engineer Senior in Raleigh, NC.  Within the Enterprise Data Management department, the position will be responsible for performing analytical tasks on vast amounts of structured and unstructured data to extract actionable business insights.  Specific duties include: (i) ingesting large volumes of data from various external sources into Hadoop, and able to build data pipelines (ii) developing IT based Hadoop strategies for business data implementation, date acquisition, execution, reporting, and archive recovery; (iii) advising IT, business, applications, and operations counterparts to ensure data integrity and availability; (iv) developing the PoCs for business problems leveraging Hadoop eco system; and (v) educating business community users with Hadoop best practices and latest techniques to optimize the code.

Master’s degree in Technology, Analytics, Engineering, Mathematics, Information Technology, or Information Systems Management plus 3 years of experience conducting data engineering and analytics on large volumes (Petabytes) of data is required.  Experience must include: (i) handling, manipulation and analysis of large datasets (multiple terabytes of data); (ii) leveraging Trifacta or Informatica for data preparation and wrangling activities; (iii) utilizing data query tools including HQL, SQL, R, and Python to manipulate, analyze and interpret data; (iv) writing and implementing code/software to clean and transform multiple terabytes of unstructured data sets with numerical and textual data; (v) building data pipelines using pySpark, to prepare the consumable datasets  for data analytics and reporting; (vi) integrating with external data sources to identify interesting and relevant trends; (vii) programmatically extracting data from a Hadoop database and transforming the data into presentable form such as an ROC curve, map, or Tableau visualization; (viii) ingesting real time data from Kafka streaming platform into Hadoop and preparing consumable datasets; (ix) converting existing complex SQL code from Teradata/SAS/Oracle into Hive Query language/pySpark; (x) optimizing and troubleshooting the Yarn/Impala applications; (xi) providing training to hundreds of business users and technology partners about Hadoop best practices and latest Hadoop tools & techniques; and (xii) understanding business problems and designing the architecture solutions for data consumption using Hadoop ecosystem.

Benefits

PNC offers employees a comprehensive range of benefits to help meet your needs now and in the future. Depending on your eligibility, options for full-time employees include 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; maternity and parental leave; paid holidays, vacation days and occasional absence time; 401(k), pension and stock purchase plans; dependent care reimbursement account; back-up child/elder care; adoption assistance; educational assistance and a robust wellness program with financial incentives. To learn more about these and other programs, including benefits for part-time employees, visit pncbenefits.com > New to PNC.

Disability Accommodations Statement:

The PNC workplace is inclusive and supportive of individual needs. If you have a physical or other impairment that might require an accommodation, including technical assistance with the PNC Careers website or submission process, please call 877-968-7762 and select Option 4: Recruiting or contact us via email at pathfinder@pnc.com. 

The Human Resources Service Center hours of operation are Monday - Friday 9:00 AM to 5:00 PM ET.

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.