Banking Operations Senior Analyst

Federal Home Loan Bank•Irving, TX

About The Position

FHLB Dallas actively pursues dedicated and hardworking individuals to be a part of our professional team. Positions are offered on an as-needed basis for all departments. View our current opportunities by clicking the View Open Positions tab above. To deliver best practices standards within the department and assist in meeting overall department policies, procedures, and regulatory requirements. Executes production activities, operational analysis, data maintenance, and system support related to the Bank’s Wire Transfer, Demand Deposit, Securities Custodial Services, Letters of Credit, Membership, and ACH functions and services provided to Members. Reinforces and represents the FHLB value proposition by presenting the Bank’s products and services in a manner that increases the inherent business value of its members. Ensures customer needs, transactions, and requests for information are fully met and that all service requirements are delivered to the highest standards of excellence, accuracy, and integrity. Deliver high-quality reporting and drive continuous improvement and efficiency. Lead and represent the department in projects and scrum activities. Develop and execute QA/UAT test scripts for systems impacting operational workflows.

Requirements

Bachelor’s degree in finance, Accounting or other business-related degrees
3 or more years of work experience related to a broad understanding of operational and performance standards as well as experience in back-office operations with an emphasis in Safekeeping, user acceptance testing, or process optimization using Microsoft Power Applications, AI, SQL or other like tools to automate processes and analyze transactional data.
Analytical skills include the ability to solve problems and resolve conflicts, and to help others do so.
Intermediate Excel Skills, including the ability to work with multiple worksheets, filter data, use integrated functions, and manipulate databases.
Understands SQL code and ability to write and troubleshoot new and existing SQL queries working with a star-schema data warehouse, familiar with database navigating, reading tables and views.
Experience with Agile project management methodology, writing test plans, test scenarios and test scripts. Testing integrated financial systems.
Ability to manage workload, set priorities, and exercise sound judgement while meeting goals and deadlines.
Excellent interpersonal, communication, and organizational skills combined with ability to plan, organize, and carry out multiple project assignments.
A structured and organized team player with the ability to work collaboratively with those in various positions, multitask, cross-train co-workers.
The ability to be flexible while working in a high-energy environment on complex tasks under deadline pressure.

Responsibilities

Be a subject matter expert on all aspects of the Banking Operations department and be able to assist Members and internal partners in all areas of the department (Safekeeping, Letters of Credit, DDA, Member Maintenance and Wires). This includes understanding of all operational areas that is needed to successfully cover the tasks due to vacations or other absences.
Responsible for compliance with department internal controls, policies, procedures, FHFA and other regulations. Suggest updates to procedures and assist with the annual review to ensure procedures and policies reflect the current operating environment.
Lead projects that impact internal and external applications and processes. Be able to articulate the needs of the department and be the voice of the Member in scrum meetings and other settings that determine project roadmap and timelines.
Responsible for documenting and executing test scenarios and test scripts for quality assurance and user acceptance testing.
Responsible for writing and troubleshooting new and existing SQL queries and SSRS reports, as well as utilizing Microsoft Power Applications, AI and other available tools to automate processes within the department.
Represent FHLB and cover for Director, Manager and/or supervisor on Member and internal calls.
Review Member initiated transactions (Safekeeping, Letters of Credit, Wires, DDA and Maintenance) to ensure transactions have been appropriately initiated and are not in violation of current policies or procedures. Exercise sound judgment in processing and release of any non-Member-initiated transactions.
Review and update department internal controls, policies, procedures, FHFA and other regulations to ensure compliance and that they reflect the current operating environment.
Provide assistance to Treasury Department or Accounting on internal wires and Members on external wires, by ensuring all wires are released in accordance with policies and procedures.
Identify out of ordinary processing, potential fraud or other areas that may result in potential exposure and recommend corrective action to protect the Bank and its members. Be able to identify and resolve problems in Bank and escalate or resolve as appropriate.
Provide prompt, courteous service to all internal and external customers. Assist in departmental and group cross-training to enhance staff skill building in other areas of the department and group.
Ensure all required reporting (daily, weekly, and monthly) is delivered as requested by Members and other third parties. Provide consistent review of processes for opportunities for increased efficiency and automation.
Provide recommendations to management and participate in the development and testing of department dashboards, internal/external reports, and process automation.
Assume additional responsibilities as assigned.