Business Analyst
Software Guidance & Assistance, Inc. (SGA, Inc.) · Rockville, MD · 1 wk ago
HybridOTHRFull-time
Responsibilities
- Surveillance Pattern Analysis & Knowledge Management
- Maintains a knowledge base of surveillance patterns across multiple regulatory domains
- Performs requirements-vs-code gap analysis to identify discrepancies between documented business requirements and implemented logic, flagging risks to surveillance coverage
- Validates new surveillance pattern releases by comparing production vs. UAT outputs, analyzing exception counts, volumes, and firm-level impacts
- Buils local testing environments to execute query scripts against sample data, enabling independent verification of pattern logic before production deployment
- Builds multi-scenario test cases covering edge cases to ensure comprehensive test coverage
- Packages release artifacts (scripts, QC results, requirements documentation) following standardized release structures
- Ad-Hoc Data Analysis & Investigation Support
- Writes complex queries to support analyst investigations into surveillance exceptions
- Performs firm-level statistical analysis and produces reports for management review
- Maintains reference data sets used by downstream surveillance patterns
- Affords data incident impacts by cross-referencing affected data sources against the surveillance pattern dependency map
- Process Automation & Tooling
- Develops automation tools for ticket management, release documentation, and workflow optimization
- Builds local testing frameworks that replicate production environments for rapid pattern testing and iteration
- Creates data visualization and comparison reports with interactive views, summary statistics, and color-coded differentials
- Generative AI Integration & Prompt Engineering
- Leverages AI coding assistants as a force multiplier — directing AI agents to reverse-engineer source code, build knowledge documentation, generate test frameworks, and produce data comparison reports
- Designs structured AI workflows including pattern study pipelines, workflow assistants, and automated documentation generation
- Maintains a curated AI project workspace with standing instructions, conventions, and context files that enable consistent, high-quality AI-assisted output
- Coordinates multi-step analytical tasks through AI — from reading source code and drafting requirements, to generating test harnesses and producing comparison reports — reducing turnaround from days to hours
- Evaluates and validates AI-generated outputs for regulatory accuracy before use in production workflows
- Project Management Support
- Manages work across project tracking boards, tracking enhancement tickets, bug fixes, and new pattern development
- Drafts and updates Business Requirements Documents (BRDs) for surveillance pattern enhancements
- Cooordinates release activities including documentation, QC, and UAT sign-off tracking
Qualifications
- Bachelor's degree and 5+ years of experience in financial regulatory technology, surveillance systems, or capital markets data analysis
- Proficiency in SQL for large-scale data analysis on distributed platforms
- Proficiency in at least one scripting/programming language for data analysis, automation, and tool development
- Strong analytical skills with the ability to independently investigate data discrepancies and validate system outputs
- Advanced proficiency in spreadsheet tools for business and operational analysis