PNC Financial Services Group

Senior Data Engineer - Teradata/Informatica/SQL (R...

Job description

Job Profile

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. This is a remote position and can sit anywhere within the PNC footprint, except for Colorado, Hawaii or Alaska. There is limited expectation for regular in person, in office activities.

This position is part of PNC's C&IB MIS Data Management/Business Intelligence organization. As a Sr. Data Engineer, you will work closely with business partners, developers and other stakeholders to perform activities related to data analysis, data architecture, data modeling and code development. You will also prepare design artifacts enabling developers to build ETL code and/or dashboards and will work with other team members to ensure the overall quality of team deliverables. Additionally, you will lead efforts to migrate code to higher environments and supervise production support activities.

Due to the nature of the position, preferred candidates will have knowledge of/a background with the following:

  • Experience working with large scale/enterprise wide Data Warehouse and Business Intelligence projects
  • In depth knowledge of data mart design and dimensional modeling.
  • Strong data analysis and database development skills (SQL and PL/SQL) on Teradata, Oracle etc.
  • Experience with one or more BI reporting tools like Tableau, OBIEE, etc.
  • Experience working with the Agile methodology
  • Experience with Commercial Banking data, systems or processes will be a plus
  • Experience with designing and developing ETL systems in Informatica, etc. will be a plus
  • Experience with data analysis and preparing Source to Target Mapping (STM) documents
  • Strong analytical and problem solving skills
  • Ability to effectively communicate technical concepts and requirements to technical staff and business partners
  • Ability to multi-task and work in a high-paced development environment
Job Description

Leads 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.
Leads data requirement analysis and the data preparation process development for targeted data solutions.
Leads in designing and building data service infrastructure on multiple data platforms, according the workflow.
Oversees 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.

Consulting – Knowledge of techniques, roles, and responsibilities in providing technical or business guidance to clients, both internal and external; ability to apply this knowledge appropriately to diverse situations.

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.

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 5+ years of industry-relevant experience. Specific certifications are often required. In lieu of a degree, a comparable combination of education and experience (including military service) may be considered.

Education

Bachelors

Additional Job Description

Base salary commensurate with skills and experience.

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.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.