BSA - Consolidated Audit Trail (CAT

Position: BSA - Consolidated Audit Trail (CAT)
Description

Position Summary We are seeking an experienced Business Systems Analyst to support a high-visibility regulatory initiative focused on the Consolidated Audit Trail (CAT). This is a critical long-term role supporting the development and enhancement of a CAT Supervisory Tool that helps monitor, identify, and resolve securities trade reporting errors before they are submitted to FINRA. The Consolidated Audit Trail serves as the industry's comprehensive record of securities trading activity, providing regulators with the ability to track the lifecycle of a trade and the ownership of securities as they move through the market.

This project is focused on developing a supervisory database and workflow solution that enables users to identify reporting errors, manage remediation activities, and track issue resolution through completion. The ideal candidate will bring prior CAT experience, strong data analysis capabilities, and the confidence to independently drive discussions, challenge assumptions when appropriate, and own deliverables from inception through implementation.

Key Responsibilities Serve as the lead Business Systems Analyst supporting Phase 2 of the CAT Supervisory Tool initiative. Partner with business stakeholders, technology teams, and third-party vendors to gather, analyze, document, and refine business and technical requirements. Support the enhancement of a supervisory platform designed to identify, track, and resolve CAT trade reporting errors. Define and document workflow requirements that provide visibility into reporting issues, ownership, remediation activities, and resolution tracking.

Analyze large-scale file transfers and data integration processes supporting CAT reporting. Perform data mapping, data lineage analysis, and field-level validation to ensure reporting accuracy and regulatory compliance. Utilize SQL to analyze data, investigate issues, validate reporting outputs, and support testing efforts. Create business requirements, user stories, acceptance criteria, process flows, and test cases. Support end-to-end testing, user acceptance testing (UAT), and defect management activities.

Work closely with stakeholders to investigate data quality issues and identify root causes. Leverage AI tools to accelerate requirements summarization, user story creation, requirements documentation, and test case development. Drive meetings and decision-making discussions while ensuring project objectives and timelines are met. Serve as a long-term subject matter resource for CAT reporting and supervisory processes.

Skills

Business analysis, agile, requirements gathering, business systems analysis, jira

Top Skills Details

Business analysis

Additional Skills & Qualifications

Required Qualifications Experience Prior or current experience working with the Consolidated Audit Trail (CAT). Experience as a Business Systems Analyst on complex regulatory, reporting, or data-centric initiatives. Strong experience gathering requirements and partnering with both business and technology stakeholders. Experience working with file-based processing, data transfers, and data validation activities. Demonstrated experience supporting testing and quality assurance efforts. Technical Skills Strong SQL skills with the ability to query, analyze, and validate complex datasets.

Experience performing data mapping and field-level validation. Understanding of file transmission, file processing, and data integration workflows. Ability to identify and troubleshoot data quality and reporting issues.

Experience with APIs and system integrations is preferred. Experience using AI tools to support business analysis deliverables, including requirements, user stories, and test case creation. Soft Skills Confident, assertive communicator capable of leading discussions and influencing outcomes. Self-starter who takes ownership and proactively drives work forward. Strong investigative mindset with a willingness to dig into complex data and processes. Detail-oriented and highly analytical.

Collaborative partner who can build strong working relationships across teams. Comfortable operating in a challenging environment where independent thinking and accountability are critical.

Preferred Qualifications Financial services, brokerage, or securities industry experience. Experience working with vendor-supported regulatory solutions. Knowledge of securities trade lifecycle and trade reporting processes.

Experience Level

Intermediate Level
Job Type & Location
This is a Contract to Hire position based out of Minneapolis, MN.
Pay and Benefits
The pay range for this position is $60.00 - $75.00/hr.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
Medical, dental & vision Critical Illness, Accident, and…