Business Analyst

Pasadena, TX - USA

Monthly Salary: Not Disclosed

Posted on: 3 hours ago

Vacancies: 1 Vacancy

Job Summary

Skills Required:

Programming and Software Skills - Tableau Power BI Alteryx SQL Power Point Excel (Required)
Ability to work independently and cross-functionally on a team (Required)
CRA Knowledge (Highly desired)
Communication Skills - Verbal Presentation Written (Highly desired)

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:

Bachelors 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

Skills Required: Programming and Software Skills - Tableau Power BI Alteryx SQL Power Point Excel (Required) Ability to work independently and cross-functionally on a team (Required) CRA Knowledge (Highly desired) Communication Skills - Verbal Presentation Written (Highly desired) Overview The Bus...