Data Analyst/BSA

Spectraforce Technologies, Inc.

Westlake (TX)

On-site

USD 70,000 - 110,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Liquidity Regulatory Data Analyst – FR2052a & Automation
Liquidity Regulatory Data Analyst – FR2052a & Automation

Spectraforce Technologies, Inc. • Westlake (TX)

On-site
USD 70,000 - 110,000
Regulatory Reporting Consultant
Regulatory Reporting Consultant

Phyton Talent Advisors • New York (NY)

On-site
USD 140,000 - 200,000
Treasury Analyst - Liquidity Regulatory Reporting
Treasury Analyst - Liquidity Regulatory Reporting

Charles Schwab Corporation • Westlake (TX)

On-site
USD 110,000 - 170,000
Senior Manager, Liquidity Platform Modernization
Senior Manager, Liquidity Platform Modernization

Charles Schwab Corporation • Westlake (TX)

On-site
USD 120,000 - 160,000
Senior Treasury Liquidity Data Analyst (Hybrid)
Senior Treasury Liquidity Data Analyst (Hybrid)

Motion Recruitment • Charlotte (NC)

Hybrid
USD 95,000 - 130,000
Business Analyst
Business Analyst

Signature IT World • Charlotte (NC)

On-site
USD 80,000 - 100,000
Senior Liquidity Regulatory Reporting Leader
Senior Liquidity Regulatory Reporting Leader

Phyton Talent Advisors • New York (NY)

Hybrid
USD 125,000 - 225,000
External Regulatory Reporting Analyst
External Regulatory Reporting Analyst

J.P. Morgan Chase & Co. • Newark (DE)

On-site
USD 70,000 - 110,000
Business Systems Analyst (BSA) specialist in Liquidity Technology team
Business Systems Analyst (BSA) specialist in Liquidity Technology team

TechDigital Group • Charlotte (NC)

On-site
USD 90,000 - 120,000
Business Systems Analyst (BSA)
Business Systems Analyst (BSA)

TechDigital Group • Cherry Hill Township (NJ)

On-site
USD 90,000 - 130,000