Core Banking Systems Analyst — Regulatory, Data & API Focus

CEI; Pittsburgh (Allegheny County); On-site; USD 63,000 - 89,000; Full time

Job summary

CEI seeks a Technical Business Systems Analyst to support core banking initiatives by partnering with Product and Compliance teams to define clear, testable requirements. This role focuses on regulatory-aware story writing, data mapping between digital channels and legacy core banking platforms, and validation of business logic using SQL and integration specifications.

You will collaborate with Product and Compliance teams, write detailed user stories with acceptance criteria, document

Qualifications

• Experience gathering and documenting requirements for core banking features.
• Experience writing detailed user stories and acceptance criteria.
• Experience incorporating regulatory constraints and financial edge cases into requirements.
• Experience documenting non-functional requirements.
• Experience performing data mapping between digital channels and legacy systems.
• SQL proficiency for data validation and discrepancy investigation.
• Experience with MySQL and/or Oracle databases.
• Experience analyzing API specifications and defining integration contracts.
• Experience creating sequence diagrams to document service and data flows.

Responsibilities

• Collaborate with Product and Compliance teams to define requirements for core banking features.
• Ensure requirements explicitly address regulatory constraints and financial edge cases.
• Identify and document non-functional requirements.
• Write detailed user stories with acceptance criteria to support development and testing.
• Perform detailed data mapping between web/mobile digital channels and legacy core banking systems.
• Use SQL to query MySQL and Oracle databases to validate logic and investigate data discrepancies.
• Analyze API specifications to define integration contracts, including request/response models and sequence flows.

Skills

Requirements gathering

User stories writing

Regulatory constraints

Non-functional requirements

Data mapping

SQL data validation

DB knowledge

API specs analysis

Education

No education requirements

Tools

SQL

MySQL

Oracle

API specs

Job description

CEI seeks a Technical Business Systems Analyst to support core banking initiatives by partnering with Product and Compliance teams to define clear, testable requirements. This role focuses on regulatory-aware story writing, data mapping between digital channels and legacy core banking platforms, and validation of business logic using SQL and integration specifications.

You will collaborate with Product and Compliance teams, write detailed user stories with acceptance criteria, document