The Senior Data Analyst, Bank Operations will provide analytical support and reporting to the Accounting and Bank Operations Department as well as other departments including Business Stacks. This position will work closely with Accounting, Bank Operations, and Business Intelligence Management in providing them with pertinent and actionable information from both financial and operational perspectives.
Perform transaction-level fee analysis using complex SQL queries, business processes monitoring, compliance reporting, and using Microsoft Office tools.
Manage reports necessary for accounting operations and financial reporting.
Perform ad-hoc analysis to provide actionable insights as it relates to customer and financial impact as well as risk exposure and recommending process improvement.
Learn overall bank and company operations to properly analyze processes.
Participate in projects and provide subject matter expertise in group settings.
Interact at all levels of the company, including but not limited to executive, senior, and department management as well as with external clients and vendors.
Consistently deliver projects of high quality with excellent attention to detail within tight deadlines.
Collaborate with the Data Warehouse team as a subject matter expert and help write business requirements for best practices reporting and analytics.
Communication: Superior verbal and written presentation skills are required. Actively listen to others to understand their perspective. Ability to present with confidence complex topics and analysis in easy to comprehend manner. Ability to summarize data into useful information using visual and graphical approaches.
Implementation/Execution: Combine consultative skills with analytical knowledge to critically evaluate objectives and customer requirements. Ability to translate these objectives into meaningful and actionable presentations and reports. Demonstrate skill in data analysis techniques by resolving missing/incomplete information, inconsistencies/anomalies within complex data environment.
Database Skills/Technology: Must have broad comprehension of how data is organized in various database formats and ability to efficiently extract data for analytical use. Advanced skills in SQL querying along with knowledge of BI tools. Forensic data experience and time-series data analysis is preferred.
Work Ethics: Must be able to simultaneously handle multiple projects and meet deadlines with proven ability to succeed in a high activity/pace environment with managing associated stress. Outstanding ability to work independently, within a team, and across various departments.
Problem Solving: Problem solver with the ability to encourage others in collaborative manner and ability to influence with deep subject matter expertise.
Bachelor’s degree in business, economics, or statistics; CIS a plus. Master’s degree preferred.
Minimum of five (5) years of experience in analytics area, preferably in banking or other financial experience.
Outstanding analytical abilities with a steep learning curve.
Must have advanced SQL querying skills to pull data from data warehouses and operational databases.
Experience using major BI software packages (e.g. Micro-Strategy, Tableau).
Microsoft Office products expertise with advanced proficiency in Excel (pivot tables, complex formulas, VLOOKUPs, statistical functions, presentation styles, etc.).
*Must be a US Citizen or Green Card holder*