ETL Design

PNC Bank•Pittsburgh, PA

2d•Onsite

About The Position

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 Business Systems Analyst Consultant within PNC's Technology organization, you will be based in Pittsburgh, PA or Cleveland, OH. Provides solutions for IT and business management on applying technology to business opportunities, planning and implementation of cross-functional applications. Participates in identifying, evaluating, and configuring systems that are cost effective and meet business requirements. Monitors client experiences and feedback on the use of business applications; Enhanced system productivity, as needed. Provides senior level consulting services to internal business groups on process improvement projects designed to improve their business results. Analyzes, defines and documents clients requirements, and revises existing systems logic challenges, as necessary.

Requirements

Comfortable communicating with vendors and internal service partners
Experience eliciting functional and technical requirements from internal and external stakeholders
Proficient in the Development and Project Life Cycle
Experience working in an Agile environment and within project management platforms such as JIRA
Knowledge of coding languages and other technologies such as, Python, Informatica ETL, SQL, XSLT, XML, and APIs
Strong leadership, communication, negotiation, and problem-solving skills
Experience using collaboration tools such as Outlook, SharePoint, and Confluence
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 (Customer Focused)
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 (Managing Risk)
Application Development
Business Management
Customer Solutions
Design
Group Problem Solving
Process Improvements
Release Management
Software Solutions
User Experience (UX) Design
Business Assessment
Business Process Modeling
IT Environment
IT Project Management
Requirements Analysis
Technical Writing/Documentation
Workflow Analysis
University / college degree, with 3+ years of relevant / direct industry experience
Bachelors degree

Nice To Haves

ETL design and implementation; data modeling, mapping, and validation
Knowledge of Workday and Workday integrations
Knowledge of Business Process Modeling Notation (BPMN)
Experience working with HR Talent lines of business including Recruiting, Onboarding, and Talent Development
Familiarity with ServiceNow as a demand and incident management platform
CBAP (Certified Business Analysis Professional) certification preferred

Responsibilities

Provides solutions for IT and business management on applying technology to business opportunities, planning and implementation of cross-functional applications.
Participates in identifying, evaluating, and configuring systems that are cost effective and meet business requirements.
Monitors client experiences and feedback on the use of business applications; Enhanced system productivity, as needed.
Provides senior level consulting services to internal business groups on process improvement projects designed to improve their business results.
Analyzes, defines and documents clients requirements, and revises existing systems logic challenges, as necessary.