Senior Data Analyst

KMM Technologies, Inc.; Tysons (VA); On-site; USD 90,000 - 130,000; Full time

Job summary

KMM Technologies, Inc. in Tysons Corner, VA is seeking a Business Analyst III with senior data analysis experience and strong SQL to analyze complex surveillance patterns across multiple markets.

The role bridges regulatory requirements with technical implementation and leverages AI tools to accelerate analysis and automation. The analyst will validate releases, build testing environments, and develop automated tooling and reports, while coordinating BRDs and release activities.

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 language for data analysis, automation, and tool development.
• Experience reading and interpreting complex data processing pipelines and business logic in source code.
• Strong analytic skills with the ability to investigate data discrepancies and validate outputs.
• Excellent documentation and spreadsheet skills.

Responsibilities

• Reverse-engineer surveillance pattern source code and document data pipelines, rules, and output schemas.
• Maintain knowledge base of surveillance patterns across regulatory domains.
• Perform requirements-vs-code gap analysis and flag risks to coverage.

Skills

SQL

Scripting language

Analytical skills

Documentation

Spreadsheet tools

Education

Bachelor's degree

Tools

Distributed query engines

Big data platforms

Job description

Position: Business Analyst III (Senior Data Analyst, strong SQL needed)

Location: Tysons Corner, VA (3 days onsite)

Duration: 12+ Months

Description

PURPOSE

The Business Analyst conducts moderate-to-high complexity analysis of automated surveillance systems that 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 the technical implementation of surveillance logic, ensuring patterns produce accurate, complete, and defensible results. The analyst is expected to actively leverage generative AI tools to accelerate analysis, documentation, and automation — serving as the domain expert who directs AI capabilities while ensuring regulatory accuracy and completeness of all outputs.

CORE FUNCTIONS

• Reverse-engineers surveillance pattern source code to build comprehensive knowledge documentation covering data pipelines, business rules, exception logic, and output schemas
• 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

UAT & Release Validation

• Validates new surveillance pattern releases by comparing production vs. UAT outputs, analyzing exception counts, volumes, and firm-level impacts
• Builds local testing environments to execute query scripts against sample data, enabling independent verification of pattern logic before production deployment
• Designs 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
• Assesses 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
• Coordinates release activities including documentation, QC, and UAT sign-off tracking

OTHER RESPONSIBILITIES

Participates on special projects as assigned. Serves as a mentor for less experienced analysts. Keeps management updated on notable trends in industry practices, regulatory changes, and emerging technology capabilities (including AI tooling). Champions 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/programming language for data analysis, automation, and tool development
• Experience reading and interpreting complex data processing pipelines and business logic in source code
• Strong analytic skills with the ability to independently investigate data discrepancies and validate system outputs
• Excellent documentation skills — 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/FINRA 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 (exception generation, scoring, aggregation, reconciliation)
• Experience with source code management and release branch workflows
• Experience leveraging generative AI tools (LLMs, 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