Business Data Analyst

The Business Data Analyst conducts moderate to high complexity analysis of automated surveillance systems designed to detect potential violations of regulatory rules. This role is responsible for understanding, validating, enhancing, and supporting surveillance patterns across multiple asset classes and regulatory domains. The analyst serves as the bridge between regulatory requirements and technical implementation, ensuring surveillance logic produces accurate, complete, and defensible results. This role is also expected to actively leverage generative AI tools to accelerate analysis, documentation, and automation—acting as the domain expert who directs AI capabilities while ensuring regulatory accuracy and completeness of all outputs. Core Functions Surveillance Pattern Analysis & Knowledge Management • Reverse-engineer surveillance pattern source code to build comprehensive knowledge documentation, including data pipelines, business rules, exception logic, and output schemas • Maintain a centralized knowledge base of surveillance patterns across multiple regulatory domains • Perform requirements vs code gap analysis to identify discrepancies between documented business requirements and implemented logic, flagging risks to surveillance coverage UAT & Release Validation • Validate new surveillance pattern releases by comparing production vs. UAT outputs, analyzing exception counts, volumes, and firm-level impacts • Build local testing environments to execute query scripts against sample data for independent verification of pattern logic prior to production deployment • Design multi-scenario test cases, including edge cases, to ensure comprehensive test coverage • Package release artifacts (scripts, QC results, requirements documentation) following standardized release structures Ad-Hoc Data Analysis & Investigation Support • Write complex queries to support analyst investigations into surveillance exceptions • Perform firm-level statistical analysis and produce reports for management review • Maintain reference datasets used by downstream surveillance patterns • Assess data incident impacts by cross-referencing affected data sources against surveillance pattern dependency mappings Process Automation & Tooling • Develop automation tools for ticket management, release documentation, and workflow optimization • Build local testing frameworks that replicate production environments to enable rapid testing and iteration • Create data visualization and comparison reports featuring interactive views, summary statistics, and color-coded differentials Generative AI Integration & Prompt Engineering • Leverage AI coding assistants as a force multiplier to reverse-engineer source code, build documentation, generate test frameworks, and produce data comparison reports • Design structured AI workflows, including pattern study pipelines, workflow assistants, and automated documentation generation • Maintain a curated AI project workspace with standing instructions, conventions, and context files to ensure consistent, high quality AI-assisted output • Coordinate multi-step analytical tasks through AI—from ingesting source code and drafting requirements to generating test harnesses and comparison reports—reducing turnaround times from days to hours • Evaluate and validate AI-generated outputs for regulatory accuracy prior to use in production workflows Project Management Support • Manage work across project tracking boards, including enhancement tickets, bug fixes, and new pattern development • Draft and update Business Requirements Documents (BRDs) for surveillance pattern enhancements • Coordinate release activities, including documentation, QC, and UAT signoff tracking Other Responsibilities • Participate in special projects as assigned • Serve as a mentor for less experienced analysts • Keep management informed of trends in industry practices, regulatory changes, and emerging technology capabilities (including AI tooling) • Champion adoption of AI-assisted workflows within the team Qualifications Required • 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 or programming language for data analysis, automation, and tool development • Experience reading and interpreting complex data processing pipelines and business logic in source code • Strong analytical skills with the ability to independently investigate data discrepancies and validate system outputs • Excellent documentation skills, with the ability to translate complex technical implementations into clear, business facing knowledge documents • Advanced proficiency in spreadsheet tools for business and operational analysis Preferred • Major in Business Administration, Finance, Computer Science, or related field; advanced degree preferred • Knowledge of SEC and other regulatory rules and reporting requirements • Experience with distributed query engines and big data platforms • Experience with project management and documentation tools and their APIs • Familiarity with surveillance pattern architectures, including exception generation, scoring, aggregation, and reconciliation • Experience with source code management and release branch workflows • Experience leveraging generative AI tools (LLMs and AI coding assistants) to accelerate data analysis, code comprehension, documentation, and automation workflows • Ability to design effective AI prompts and structured project contexts that produce reliable, domain accurate outputs in a regulated environment