Key skills
ETLSDLCServiceNowCRMWorkdayJiraAgileScrumKanbanLeadershipChange ManagementCommunicationCollaboration
About this role
Role Overview
- Business System Analyst Ownership: Review business requirements, perform fit gap analysis, feasibility assessment, build solution design to deliver effective solution with workday integrations, PeopleSoft CRM, Information ETLs. Perform testing and Co-Ordinate UAT testing with LOB, procure UAT approvals, set milestone & communicate dates to LOB and scrum master in absence QE/PM roles in smaller enhancements & production issues.
- Act as Business Systems Analyst: Must demonstrate ownership of requirements gathering, building solution design, testing integration and leading delivery of Workday HR, Payroll and benefits interfaces and ETL processes.
- Data Pipelines & Transmissions: Build design to secure file transmissions (SFTP/HTTPS/AS2), data validations, and reconciliation.
- Access & Security: Partner with PNC Enterprise security and access management teams to ensure data security and privacy controls are considered as part of solution design and obtain approvals.
- SDLC & Agile Delivery: Work in Agile (Scrum/Kanban), manage work in Jira, and coordinate incident/change management in ServiceNow.
- Technical Leadership: Troubleshoot complex production issues, conduct root-cause analysis, mentor peers, and contribute to engineering standards.
- Cross-Team Collaboration: Work closely with technology teams, vendors, and business partners to prioritize, plan, and deliver integrations and enhancements.
Requirements
- 5–8+ years (preferred) in Business Systems Analyst with hands-on defining requirement for workday integration & ETLs, building solution design for workday integration & ETLs, obtaining LOB approvals on solution design & test cases, coordinating with developer & quality engineer.
- Strong experience with Workday integration design, integration output validations (text files, XML), knowledge workday (hr, payroll, benefits) functionality, workday business objects, workday data sources and workday report writing.
- Proficient in SQLs and ETL output data analysis, mapping, validation, and reconciliation.
- Working knowledge of access management, data security, encryption, and secure file transfers.
- Jira, ServiceNow, Agile methodologies; strong documentation and communication skills.
Tech Stack
- ETL
- SDLC
- ServiceNow
Benefits
- 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
- 401(k) with PNC match
- pension and stock purchase plans
- dependent care reimbursement account
- back-up child/elder care
- adoption, surrogacy, and doula reimbursement
- educational assistance, including select programs fully paid
- a robust wellness program with financial incentives