Hybrid Business Systems Analyst Consultant – SQL, Data Mapping, Oracle

Posted 4 hours ago

Apply now

About the role

  • Business Systems Analyst Consultant focusing on SQL and Data Mapping at PNC. Collaborating with teams to define requirements and validate business logic for banking features.

Responsibilities

  • 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

Job title

Business Systems Analyst Consultant – SQL, Data Mapping, Oracle

Job type

Experience level

Mid levelSenior

Salary

$55,000 - $120,750 per year

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job