BSA - Consolidated Audit Trail (CAT)

TEKsystems•Minneapolis, MN

7d•$60 - $75•Hybrid

About The Position

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.

Requirements

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.
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 using AI tools to support business analysis deliverables, including requirements, user stories, and test case creation.
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.

Nice To Haves

Experience with APIs and system integrations is preferred.
Financial services, brokerage, or securities industry experience.
Experience working with vendor-supported regulatory solutions.
Knowledge of securities trade lifecycle and trade reporting processes.

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.