Technical Banking Systems Analyst - Data, SQL & API Focus

CEI; Pittsburgh (Allegheny County); On-site; USD 69,000 - 96,000; Full time

Job summary

CEI is seeking a Technical Business Systems Analyst to support core banking initiatives by partnering with Product and Compliance 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, write detailed user stories with acceptance criteria, and map data across

Qualifications

• Gather and document requirements for core banking features.
• Write user stories with acceptance criteria.
• Incorporate regulatory constraints and financial edge cases into requirements.
• Document non-functional requirements for systems.
• Map data between digital channels and legacy core banking systems.
• Use SQL to validate logic and investigate data discrepancies.
• Analyze API specifications and define integration contracts.
• Create sequence diagrams to document service and data flows.

Responsibilities

• Collaborate with Product and Compliance to define requirements for core banking features.
• Ensure requirements 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 & acceptance criteria

Regulatory constraints

Non-functional requirements

Data mapping

SQL data validation

MySQL / Oracle

API integration contracts

Sequence diagrams

Web/Mobile channel integration

Job description

CEI is seeking a Technical Business Systems Analyst to support core banking initiatives by partnering with Product and Compliance 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, write detailed user stories with acceptance criteria, and map data across