Title: Business analyst
Location: Remote
Duration: 12months
 
The Business Analyst serves as a mid-level analyst within the CRA Reporting Team, responsible for complex reporting, analytics, and compliance support activities.
 
Overview
The Business Analyst serves as a mid-level analyst within the CRA Reporting Team, responsible for complex reporting, analytics, and compliance support activities. This role ensures the accuracy, consistency, and timeliness of CRA-related data, while also supporting strategic decision-making through advanced analytics and reporting solutions. The BA partners with business units, compliance, and senior leadership to maintain regulatory alignment and enhance the bank’s CRA performance monitoring framework.
 
Responsibilities:
Data Management & Analytics:

• Design, build, and maintain Tableau dashboards that monitor CRA lending, investment, and service activity across multiple business lines.
• Develop and manage Alteryx workflows to automate large-scale data preparation, cleansing, and validation processes.
• Leverage advanced Excel functionality (pivot tables, lookups, Power Query, VBA/macros when applicable) to perform ad hoc analysis and produce reporting templates.
• Ensure all data sources are accurate, reconciled, and compliant with regulatory standards.

 
Regulatory Reporting & Compliance Support:

• Support preparation of quarterly and annual CRA regulatory submissions, ensuring data integrity and readiness for examiner review.
• Respond to ad hoc reporting requests from senior leadership, internal auditors, and regulators.
• Collaborate with Compliance and Data Governance to interpret CRA regulatory guidance and apply it correctly to reporting outputs.

 
Process Improvement & Documentation:

• Identify opportunities to improve reporting efficiency, accuracy, and automation within the CRA reporting lifecycle.
• Document business rules, data definitions, and process flows to ensure consistency and repeatability of reporting.
• Share subject matter expertise with junior analysts and provide peer review to uphold reporting standards.

 
Cross-Functional Collaboration:

• Partner with stakeholders in Compliance, Risk, Community Development, and Business Units to ensure accurate population tracking.
• Translate regulatory requirements and data findings into clear insights for both technical and non-technical audiences.
• Serve as a point of escalation for complex reporting and data interpretation questions within the CRA Reporting Team.

 
Qualifications:

• Bachelor's Degree and 3 years of experience in System Support or Analytics OR High School Diploma or GED and 7 years of experience in System Support or Analytics

 
Preferred Experience: Analytics, or Modeling, or Reporting experience
 
Preferred Skills:

• Advanced Data Analytical, Business Analytics, and Computer Software skills preferred
• Interpersonal communication skills preferred
• Expert-level proficiency in Tableau, Alteryx, Excel, and SharePoint
• Strong knowledge of CRA regulatory framework, lending/investment reporting rules, and related compliance requirements
• Analytical mindset with high attention to detail and ability to manage large, complex datasets
• Skilled in managing ad hoc requests under tight deadlines while maintaining accuracy
• Effective written and verbal communication skills to convey findings to multiple levels of leadership
• Ability to work independently while also contributing to a collaborative team environment

 
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $ 57.68/hr.