The Data Analyst serves as a core contributor within the bank’s Data Analytics group, strengthening enterprise analytics by producing consistent, governed, and trusted reporting used across all business units.
This role goes beyond report development and focuses on deep analytical work - understanding and blending data sources, ensuring accuracy and consistency, and delivering meaningful insights that drive business decisions across the enterprise.
The analyst will clean, prepare, validate, and analyze data from multiple banking systems, develop trusted enterprise reporting, and communicate key metrics and insights to business units and executive leadership.
Role and Responsibilities
Enterprise Analytics & Insight Generation
- Support enterprise-wide analytics including loan portfolio and deposit trends, pipeline dynamics, production drivers, efficiency metrics, and growth analysis.
- Move beyond surface-level reporting to interpret results and provide actionable insights.
Data Preparation, Quality & Validation
- Extract, clean, transform, and validate data from multiple source systems to ensure accuracy, consistency, and reliability.
- Identify data quality issues, investigate root causes, and partner with data owners to resolve discrepancies.
- Develop reconciled datasets that serve as a single source of truth for enterprise reporting.
Enterprise Reporting & Metric Standardization
- Design and maintain consistent, repeatable, enterprise-aligned reporting across all business units.
- Create clear, concise, and visually engaging dashboards and reports using data visualization tools (e.g., Tableau).
- Establish and document standardized metric definitions, calculation logic, and assumptions to eliminate conflicting or duplicated reports.
Reporting Modernization & Automation
- Contribute to a multi-year initiative to migrate legacy reports (e.g., IBM Cognos and manual Excel processes) into scalable datasets and Tableau dashboards.
- Reverse-engineer and validate legacy reporting logic to ensure accuracy prior to migration.
Business Partnership & Enterprise Collaboration
- Work cross-functionally with leaders and staff across business lines and members of the data warehouse team.
- Develop a strong understanding of how different areas of the bank operate and how their activities impact enterprise performance.
Executive & Leadership Support
- Deliver accurate, well-documented reporting and analysis to support weekly, monthly, and quarterly lea