PNC

Business Systems Analyst Consultant – SQL, Data Mapping, Oracle

PNC

full-time

Posted on:

Location Type: Hybrid

Location: Dallas • Arizona, Florida, Ohio, Pennsylvania, Texas • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Salary

💰 $55,000 - $120,750 per year

Job Level

Mid-LevelSenior

Tech Stack

MicroservicesMySQLOracleSQL

About the role

  • Collaborate with Product and Compliance teams to define requirements for core banking features
  • Ensure all requirements explicitly address regulatory constraints
  • Identify and document non-functional requirements
  • Write detailed User Stories with acceptance criteria that account for financial edge cases
  • Perform detailed Data Mapping between modern digital channels (Web/Mobile) and legacy Core Banking Systems
  • Use SQL to query MySQL/Oracle databases to validate business logic and investigate production data discrepancies
  • Analyze API specs to define integration contracts (Request/Response models)
  • Create sequence diagrams to visualize the flow of funds and data across microservices

Requirements

  • 3+ years of relevant / direct industry experience
  • Bachelor's degree
  • CBAP (Certified Business Analysis Professional) certification preferred
  • Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions
  • 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.
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
  • maternity and/or parental leave
  • up to 11 paid holidays each year
  • 8 occasional absence days each year
  • between 15 to 25 vacation days each year, depending on career level; and years of service

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLMySQLOracleData MappingUser StoriesAPI specificationssequence diagramsmicroservices
Soft skills
collaborationcommunicationrisk managementcustomer focus
Certifications
CBAP