Business Data Analyst

The Senior Business Analyst supports the analysis, enhancement, testing, and operational support of automated surveillance systems designed to detect potential regulatory violations across multiple asset classes and compliance domains. This role bridges business, regulatory, and technical teams by translating surveillance requirements into scalable analytical solutions and validating that implemented logic produces accurate, defensible results.

The ideal candidate combines strong data analysis and SQL expertise with the ability to interpret complex processing logic, investigate data anomalies, and support surveillance modernization initiatives. This role also requires hands-on experience leveraging Generative AI tools and AI-assisted workflows to improve analysis, documentation, testing, and operational efficiency.

Core Responsibilities

Surveillance Analysis & Requirements Validation

• Analyze and reverse-engineer surveillance pattern logic, workflows, and data pipelines
• Develop and maintain detailed business and technical documentation for surveillance patterns and regulatory workflows
• Perform gap analysis between business requirements and implemented logic to identify inconsistencies, risks, or missing coverage
• Support enhancements and modernization efforts across surveillance and compliance platforms

UAT, Testing & Release Support

• Validate production versus UAT outputs to ensure surveillance accuracy and consistency
• Design and execute complex test scenarios, including edge cases and exception handling
• Build and maintain local testing environments for independent validation of surveillance logic and data processing workflows
• Support release management activities including QC validation, documentation packaging, and deployment readiness

Data Analysis & Investigation Support

• Write complex SQL queries to analyze large-scale datasets and investigate surveillance exceptions or anomalies
• Conduct firm-level trend analysis, operational reporting, and statistical reviews
• Assess downstream impacts of data incidents and dependency changes across surveillance systems
• Maintain and support reference data used in analytical and surveillance workflows

Automation & Tool Development

• Develop scripts, utilities, and automation tools to improve operational workflows, reporting, testing, and documentation processes
• Build comparison and visualization tools to support release validation and data reconciliation activities
• Support workflow optimization initiatives through automation and AI-assisted development practices

Generative AI & AI-Assisted Workflows

• Utilize AI coding assistants and Generative AI tools to accelerate code analysis, documentation generation, testing, and operational tasks
• Design structured AI workflows, prompt frameworks, and reusable project contexts for analytical and documentation activities
• Validate AI-generated outputs for accuracy, regulatory alignment, and operational reliability
• Champion adoption of AI-enabled productivity tools and best practices across the team

Project & Stakeholder Support

• Support project tracking, enhancement requests, defect management, and release coordination activities
• Assist in drafting and maintaining Business Requirements Documents (BRDs) and functional documentation
• Collaborate with engineering, compliance, regulatory, and operational stakeholders throughout the SDLC lifecycle

Required Qualifications

• Bachelor's degree in Business, Finance, Computer Science, Information Systems, or related field
• 5+ years of experience in regulatory technology, surveillance systems, financial services, or large-scale data analysis environments
• Strong SQL expertise with experience analyzing large or distributed datasets
• Experience with scripting or programming languages such as Python or similar technologies
• Ability to interpret complex business logic, data processing pipelines, and technical workflows
• Strong analytical and problem-solving skills with experience investigating data discrepancies and validating system outputs
• Excellent communication and documentation skills with the ability to translate technical concepts into business-friendly documentation
• Advanced proficiency with spreadsheet and reporting tools

Preferred Qualifications

• Knowledge of SEC, Client, or financial regulatory surveillance processes
• Experience with distributed data platforms and big data ecosystems
• Familiarity with source control, release management, and SDLC workflows
• Experience with project tracking and documentation management tools
• Understanding of surveillance architectures including exception generation, aggregation, scoring, and reconciliation processes
• Experience leveraging Generative AI tools, LLMs, or AI-assisted coding platforms within analytical or operational workflows
• Ability to design effective AI prompts and structured workflows in regulated environments

Key Technologies & Skills

• SQL
• Python or scripting languages
• Big Data / Distributed Query Platforms
• Data Analysis & Visualization
• Automation & Workflow Optimization
• UAT / QC Validation
• Business Requirements Documentation
• Generative AI / AI Coding Assistants
• Regulatory Surveillance Systems
• Release & Change Management

Welcome to ConsultNet, a premier national provider of technology talent and solutions. Our expertise spans across project services, contract-to-hire, direct search, and managed services onshore, nearshore, and hybrid. For over 25 years, we have connected thousands of consultants with meaningful roles through a personal, communication-driven approach, partnering with a diverse client base to build high-performing teams and create lasting impact. Our comprehensive service offerings cover a wide range of technology and engineering positions across key markets nationwide. Learn more at www.consultnet.com .