Data Analyst/BSA

Spectraforce Technologies; Westlake (TX); On-site; USD 70,000 - 110,000; Full time

Job summary

Spectraforce Technologies seeks a Data Analyst/BSA to join the Treasury Regulatory Reporting team in Westlake, TX, with Omaha as a backup. The role supports FR 2052a reporting, LCR, and NSFR, delivering daily productions and data quality reviews on a 12-month assignment.

Strong SQL/Excel skills and practical regulatory reporting experience are essential; Bachelor's degree required, with 2–5 years in financial services.

Qualifications

• Bachelor's degree required.
• 2-5 years of experience in a financial institution.
• Strong SQL and Excel skills with large datasets.
• Experience with liquidity regulatory reporting (FR 2052a, LCR, NSFR).
• Familiarity with AxiomSL ControllerView.
• Ability to produce accurate documentation and BRDs.

Responsibilities

• Execute daily FR 2052a production, validation, and submission activities.
• Perform variance analysis, reconciliations and quality reviews.
• Use SQL to analyze large datasets and identify data issues.
• Monitor data feeds and system interfaces; escalate as needed.
• Support LCR and NSFR reporting processes and controls.
• Collaborate with Treasury, Finance, Risk, Data, and Technology teams.
• Maintain reporting procedures and audit materials.
• Identify automation opportunities to improve efficiency.

Skills

Analytical skills

Documentation

Adaptability

Attention to detail

Ownership

Ambiguity tolerance

2-5 years experience

Finance knowledge

SQL skills

Excel skills

Liquidity reporting

AxiomSL ControllerView

Multitasking

Automation thinking

GAAP knowledge

Cross-functional collaboration

Education

Bachelor's degree

Tools

SQL

Excel

AxiomSL ControllerView

Job description

Title: Data Analyst/BSA

Location: Will work in Westlake 4 days per week - Omaha is a backup

Duration: 12 Months

- Team works on a daily report send- Finance reporting and working with Development teams

Manager, Liquidity Regulatory Reporting

The Liquidity Regulatory Reporting team within Treasury manages and monitors key regulatory liquidity metrics and ensures compliance with applicable requirements, including the Liquidity Coverage Ratio (LCR) and related public disclosures, the Net Stable Funding Ratio (NSFR), and the FR 2052a Complex Institution Liquidity Monitoring Report. The team also develops tools to help our business partners analyze the impact of business decisions. In addition, we collaborate with internal and external partners on ongoing examinations and audits of liquidity practices.

The Treasury Regulatory Reporting Analyst will support the daily production, validation, control, and submission processes for U.S. liquidity regulatory reporting, with primary responsibility for FR 2052a reporting and additional support for the Liquidity Coverage Ratio (LCR) and Net Stable Funding Ratio (NSFR) reporting processes. The analyst will execute daily reporting activities, perform data quality reviews, investigate anomalies, coordinate issue resolution, and support regulatory reporting automation initiatives.

The role requires strong analytical skills, attention to detail, and the ability to independently manage daily production activities within strict regulatory deadlines while partnering with Treasury, Finance, Risk, Data, and Technology teams.

What you have:

• Strong analytical and quantitative skills, with experience in data analysis and trend identification
• Excellent documentation skills, with the ability to create comprehensive business requirements, process documentation, and analytical reports
• Ability to thrive in a fast-paced, dynamic environment with changing priorities
• Strong attention to detail and a commitment to accuracy and quality in all deliverables
• Demonstrated ownership, initiative, and accountability for high-quality outcomes
• Ability to navigate ambiguity and make informed decisions
• Bachelor's degree required
• Two to five years of related experience within a financial institution
• Basic knowledge of finance and accounting, particularly within banking and broker-dealer businesses
• Strong SQL and Excel skills, with the ability to work with large datasets and complex queries
• Experience with liquidity regulatory reporting (FR 2052a, LCR, NSFR)
• Experience with AxiomSL ControllerView
• Strong organizational and multitasking skills, with the ability to manage multiple changing priorities
• Adaptability and resilience in uncertain environments with evolving regulatory landscapes
• Hands-on experience implementing automation tools to optimize reporting processes
• Knowledge of U.S. GAAP and accounting policy
• Ability to partner effectively with cross-functional teams across Finance, Data, and Technology

What you'll do:

• Execute daily FR 2052a production, validation, and regulatory submission activities in accordance with established procedures and reporting deadlines.
• Perform detailed variance analysis, reconciliations, and quality reviews to ensure reporting completeness, accuracy, and compliance.
• Utilize SQL to analyze large datasets, investigate reporting anomalies, and identify root causes of data issues.
• Monitor reporting processes, data feeds, and system interfaces; promptly identify, escal…
• Support LCR and NSFR reporting processes, including data validation, reconciliations, and reporting controls.
• Partner with Treasury, Finance, Risk, Data Management, and Technology teams to resolve data discrepancies and implement reporting enhancements.
• Maintain and enhance reporting procedures, control documentation, governance evidence, and audit support materials.
• Participate in testing, implementation, and production validation of regulatory reporting changes, system upgrades, and new initiatives.
• Identify and implement automation opportunities to improve reporting efficiency, reduce manual processes, and strengthen operational controls.
• Develop comprehensive business requirements for functional and nonfunctional enhancements supporting liquidity regulatory reporting processes.
• Create and optimize SQL queries to analyze datasets of varying complexity, and develop analytical models and automation solutions.
• Analyze and interpret data from multiple sources, including databases, spreadsheets, and reporting systems.
• Communicate issues to the appropriate data owners, and monitor and track them to ensure timely and effective resolution.
• Participate in projects supporting new initiatives, process improvements, and technology implementation and development.