BSA SQL Data Modeling - NP

Senior Business Systems Analyst (Online Banking)
Employment Type: Full-Time
Locations: Pittsburgh, PA
Work Model: On-Site 5 Days Per Week Role Overview
In the Business Systems Analyst (BSA) role you will own the translation of high-level retail banking product visions into actionable, technical specifications. You will navigate complex data structures using SQL and lead the integration of Agentic AI to automate customer workflows and internal processes. As a senior member of the team, you will be responsible for ensuring that our offshore development partners have the clarity and requirements needed to deliver high-quality code in an Agile environment. Key Responsibilities

• Product Stewardship:

Deeply understand the retail banking product lifecycle (accounts, transfers, bill pay, etc.) to ensure technical solutions align with business goals.

• Requirement Engineering:

Lead the discovery and documentation of comprehensive Business Requirement Documents (BRD) and Functional Requirement Documents (FRD).

• Agile Delivery:

Author high-quality User Stories with clear acceptance criteria and manage the product backlog in collaboration with Product Owners.

• Data Modeling & SQL:

Perform deep-dive data analysis and mapping. You must be comfortable writing complex SQL queries to validate data integrity and define data models for new banking features.

• AI Innovation (Agentic AI):

Identify opportunities to implement Agentic AI (autonomous AI agents) to enhance self-service capabilities, fraud detection, or automated loan processing.

• Global Collaboration:

Act as the primary point of contact for offshore development and QA teams, facilitating requirements walk- throughs and ensuring clear communication across time zones. Required Qualifications

• Banking Experience 5+ years in Online/Digital Banking, understanding the nuances of PCI compliance, security, and transaction processing.
• Data ProficiencyAdvanced SQL skills and experience with Data Modeling (Relational and NoSQL structures).
• AI AcumenFoundational understanding of LLMs and Agentic AI frameworks (e.g., LangChain, AutoGPT) and how they can be applied to banking "agents."
• Technology SavvyHigh technology acumen; ability to discuss API architecture, cloud infrastructure, and system integrations with engineers.Global DeliveryProven track record of working with offshore/onshore models to drive project velocity.
• Seniority 8+ years of total experience as a BSA or System Analyst in a large-scale enterprise environment.

Skills

• Understand Product
• Technology accument
• SQL data modeling
• Creating User Stories
• Seasoned
• Write requirements
• Agentic AI knowledge
• Work with Offshore workers
• Online Banking Experience

About Techstra Solutions
Techstra Solutions helps leading organizations unlock the value of Digital and Talent Transformation. We combine business strategy, technology, and talent to guide clients through complex transformation journeys—from strategy through execution. We deliver our expertise through consulting, innovative staffing solutions, and software development, always focused on measurable outcomes and long-term impact.

Equal Employment Opportunity Statement

Techstra Solutions is an equal opportunity employer. The Company makes its decisions on merit, and its policy of equal opportunity prohibits discrimination in all phases of the employment process, including, but not limited to, recruitment, hiring, promotion, selection, transfer, demotion, layoff, termination, compensation, benefits, and other terms and conditions of employment. The policy of equal opportunity applies without regard to race, color, creed, religion, gender,, sexual orientation, gender identification, pregnancy, marital status, national origin, ancestry, age, disability that can reasonably be accommodated without undue hardship, military status, veteran status, genetic predisposition or carrier status, alienage or citizenship, domestic partnership status, arrest or conviction record, status as a victim of domestic violence, or any other protected categories under federal, state, or local law. The Company also prohibits discrimination or harassment based upon the perception that a person has, or is associated with a person who has, any of these characteristics.