DataBusiness Analyst

Data/Business Analyst needs 3 years of experience in System Support or Analytics

Data/Business Analyst requires:

• 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
• 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)

Data/Business Analyst duties:

• Responsible for complex reporting analytics and compliance support activities.
• Ensures the accuracy consistency and timeliness of CRA-related data while also supporting strategic decision-making through advanced analytics and reporting solutions.
• Partners with business units compliance and senior leadership to maintain regulatory alignment and enhance the banks CRA performance monitoring framework.
• 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
• Support preparation of quarterly and annual CRA regulatory submissions ensuring data integrity and readiness for examiner review
• Document business rules data definitions and process flows to ensure consistency and repeatability of reporting