Senior Bank Operations Data Analyst

Reports to Vice President, Director of Bank Operations. Provide support for the departmental data owners relating to data quality, and process efficiencies (e.

g. straight-through processing (STP)). Create a discipline within Bank Operations to :

• Support the Bank's Data Management Program by providing support for data owners and stewards relating to data quality,
• Provide meaningful reporting, Key Risk Indicators and Key Performance Indicators for each department supporting data driven decisions and STP.
• Eliminate reliance on other Group's data analysts and enhance existing staff's analytical skills to be data savvy / literacy by providing development opportunities.

Technical skills :

Expert knowledge of multiple data analysis patterns & methods, including but not limited to : canned reporting; visualization;

time series analysis; and dashboards.

• Expertise in multiple tools & technologies for data analysis & reporting.
• Superior aptitude for continually learning & gaining expertise in new methods & technologies.
• Expertise in writing SQL with the ability and desire to train others of varying knowledge.
• Expertise in writing own SQL to ANSI standards.
• Proficiency required in the following PC software : Access, Excel, and Word.
• Working knowledge of the needs of data science / modeling use cases and relevant tools. (e.g. Python, R)
• Expertise in querying data at any level of maturity (i.e. from raw to integrated to curated) in a data warehouse environment.
• Working knowledge of data governance capabilities (e.g. data quality, metadata management, data catalog, lineage) and their interdependencies with an enterprise data warehouse Skilled in drafting "desktop guides relating to reports, KRIs, KPIs and queries, to be used for training and for other staff's benefit to run independently.

Interpersonal skills :

• Autonomy in savvy partner engagement and relationship management.
• Confidence in raising opportunities for improvement to management for action.
• Eagerness and willingness to invest time with stakeholders to elevate their knowledge.
• A patient & adaptable approach to training colleagues of varying experience levels.
• A thought leader who seeks out new ideas & approaches and invites others to collaborate, not only within Bank Operations but also across the Bank.
• Proactively and creatively solves problems and seeks to own the resolution of issues throughout their lifecycle.
• Takes critical feedback in stride and adjusts approaches accordingly.
• Leads by example as a point of help and excellent customer service.
• Excellent written and oral communication skills required.

Experience

Minimum of seven years of experience working as a data analyst for a financial institution. Working with financial data preferred, related experience in mortgage data (residential and income producing), loans, letter of credit, wire transfer, securities, etc. C

Essential Job Function :

• Responsible for user acceptance testing data driven testing and result review.
• Act as liaison to project manager and Data Management Office ("DMO ) for data related efforts in support of projects, work efforts and DMO requirements for data quality / metrics.
• Create analyses, visualizations, and reports to assist management to make data driven decisions to reduce operational risk and to support innovation efforts.
• Provide support for the departmental data owners relating to data quality, and process efficiencies (STP) and lead specific efforts (e.

g. root cause analyses, data remediation)

• Lead efforts across Bank Operations to become more "data driven by being able to leverage data in decision making and to support continuous operational improvements as necessary.
• Ensure Bank Operations alignment / compliance with the Bank's Data Management Program on all fronts.
• Training of existing staff on data analytics on the Bank's chosen data management tools to increase staff's data "literacy across Bank Operations.
• Strong understanding of operational process and controls to be able to provide suggested improvements in data flows, STP, etc.
• Seek to improve Bank Operation's data efforts with use of automation and analytics to achieve high quality results.
• Collaborates with IT on data solutions for Bank Operations.
• Prepares and verifies departmental management and regulatory reports.
• Responsible for preparation of metrics, including board reporting of KRI and KPIs, time series data and analytics relating to operational / transactional data sets (including any ad-hoc data reporting requests).
• Work with DMO to assist with Bank Operations data requirements in support of the data warehousing efforts.
• Analyze data within the BI universe for data quality, identify any issues and work with the business units to ensure the quality expectations are met.
• Train new users how to access reports as well as querying data.
• Define and manage data / reports that access the warehouse used by Bank Operations.
• Collaborate with the DMO and Operational Risk to identify end-user-computing solutions (EUCs) that can be replaced with enterprise data solutions.

Other Duties :

• Successfully execute all other duties and responsibilities as assigned.
• Participate in special teams, project groups and committees as assigned, including System Wide committees and joint efforts.
30+ days ago