Business Systems Analyst Sr - API, ETL, SQL
Core
Senior Business Systems Analyst translating business needs into technical requirements for API integrations, ETL processes, and data validation within PNC's Retail Technology organization.
Role type
Senior Business Systems Analyst (API, ETL, SQL)
Builds
API-based integrations, ETL data pipelines, and validated data outcomes for retail banking customers.
Domain
Banking / Retail Technology / Data Integration
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Requirements analysis, Agile/Scrum facilitation, API integration design, ETL process definition, SQL data validation, Process modeling, Stakeholder management, Data quality assurance, Functional specification writing, Gap analysis
Preferred skills
RESTful service architecture knowledge, Data lineage and reconciliation techniques, Informatica PowerCenter/PowerExchange usage, Relational database administration (Oracle, SQL Server, Teradata, MongoDB), Impact assessment, Technical documentation
Technologies
Informatica, Oracle, SQL Server, Teradata, MongoDB, RESTful APIs
Responsibilities
Gather integration requirements and translate business needs into Agile stories; Partner with stakeholders to elicit, analyze, and validate data outcomes; Collaborate with engineering teams on API-based integrations; Support data-related initiatives including ETL processes and data transformations; Analyze and validate data using SQL and relational databases; Perform current-state and future-state analysis including process flows and gap analysis.
Seniority
Senior, hands-on IC
