Senior Data Analyst

General Description

We are seeking a meticulous Senior Data Analyst to design, implement, and deliver reliable data solutions, automate routine reporting tasks, and generate actionable insights that enhance decision-making and enable effective execution in Retail Banking. This role involves translating complex data into understandable reports, assisting the unit in making data-driven decisions to optimize operations, improving process and regulatory compliance, or identifying trends. In this role, you will extract and integrate data from multiple platforms (deposits, consumer and commercial lending, credit cards, and wealth) and develop KPI definitions and data dictionaries and produce executive dashboards (Power BI preferred). You will resolve data quality issues, standardize reporting logic, and ensure reporting processes and controls are well-documented and audit ready.

Duties & Responsibilities

• Extract, integrate, and validate data across retail product platforms (deposits, lending, cards, wealth) to produce consistent, reconciled datasets for reporting and controls.
• Develop and maintain complex SQL queries and reusable data logic (views/stored procedures, where applicable) to support repeatable, automated data pulls.
• Perform cross-system reconciliations, root-cause analysis, and variance explanations, document assumptions and limitations for auditability.
• Work closely with cross-functional teams, including business analysts, industrial engineers, and decision-makers, to support data-driven decision-making.
• Use Agile methodologies to deliver fast results.
• Design, build, and maintain automated and ad-hoc reports and dashboards that measure key retail and risk/control KPIs.
• Create executive-ready dashboards Power BI (preferred) applying sound data modeling and visualization best practices.
• Implement quality controls (data checks, reconciliation tie-outs, exception tracking) and maintain documentation to support audit, compliance, and regulatory inquiry readiness.
• Lead small-to-medium reporting and data initiatives end-to-end (requirements, data mapping, testing/UAT, deployment, and post-implementation monitoring).
• Own intake, triage, and tracking of data/reporting defects; maintain an issue log with severity, root cause, remediation plan, and target dates.
• Provide clear status updates to stakeholders and senior leaders; proactively escalate risks to delivery timelines, data accuracy, or control effectiveness.
•  Execute data quality routines (completeness, accuracy, timeliness, reconciliation tie-outs) and track exceptions and remediation.
• Support internal audit, compliance monitoring, and regulatory inquiries by providing datasets, methodology, and evidence packages in a timely manner.
• Identify opportunities to improve reporting efficiency and control effectiveness through automation, standardization, and better data definitions.
• Partner with Retail Banking leaders and control partners (Risk, Finance, Compliance, Audit, Technology) to translate business needs into clear reporting requirements
• Translate complex analyses into concise narratives, recommendations, and decision-ready materials for non-technical audiences.
• Present insights to senior management, including trends, drivers, emerging risks/issues, and proposed remediation or performance actions.

Education

•    Bachelor’s degree in Business Administration, Computer Science, Mathematics, Finance, Economics, Statistics, Information Systems, Data Analytics, or a related quantitative field.
•    Master’s degree (MBA, MS in Data Analytics, or similar) is a plus.

Experience

•    At least three (3) to five (5) years of experience in banking/financial services (or comparable regulated environment) with demonstrated work in data analysis, reporting, reconciliation, or analytics delivery.
•    Hands-on experience working with multiple data sources and systems (e.g., deposits, loans, cards, wealth), including data mapping and reconciliation.
•    Experience coordinating across stakeholders to deliver reporting/data changes, including documenting requirements and supporting testing/UAT.

Other Qualifications

• General knowledge of Bank Secrecy Act (BSA), Anti-Money Laundering (AML), and consumer compliance regulations.
• Experience with data governance or risk/control tools (e.g., Archer or similar), ticketing/issue tracking, or SDLC/change management routines.
• Advanced proficiency in SQL (complex queries, joins, stored procedures).
• Advanced Excel skills (Power Query/Power Pivot; complex formulas). VBA is a plus.
• Power BI experience (data modeling, DAX, publishing, refresh/governance in Power BI Service). Tableau is acceptable.
• Python or R (preferred) for automation, data preparation, and analysis.
• Experience with documentation standards (data dictionary, KPI definitions, report logic) and quality controls for reporting.
• Understanding of retail banking products/data flows and reporting used for management, risk, compliance, audit, and regulatory inquiry support.
• Strong analytical and communication skills with the ability to interpret complex data sets and draw practical insights.
• Excellent project coordination and stakeholder management abilities.
• Strong problem-solving skills with the ability to handle complex, cross-system issues.
• Outstanding written and verbal communication skills in both (English/Spanish) – strongly preferred.
• Ability to manage multiple priorities and meet tight deadlines.
• High attention to detail and commitment to data accuracy.
• Experience facilitating meetings and presenting to senior leadership.

Values