Financial Analyst

Travis Credit Union•Vacaville, CA

1d•Hybrid

About The Position

Candidates must reside within a commutable distance to the communities that Travis Credit Union serves: Alameda, Colusa, Contra Costa, Merced, Napa, Placer, Sacramento, San Joaquin, Solano, Sonoma, Stanislaus and Yolo counties. This position is considered hybrid and will be required to be on-site 2-3 days per week. Summary : The Travis Credit Union (TCU) Financial Analyst is responsible for developing and implementing analytics and reporting solutions for the Accounting & Finance division of the organization. The Financial Analyst creates value for the organization by synthesizing data from multiple sources and liaising with other departments to share insights with respect to growth trends, profitability, potential efficiencies, and other knowledge which will help run the business more effectively. Profile: Provides reporting and analytics focused on but not limited to budgeting; asset-liability management modeling (ALM); interest rate risk; liquidity management; balance sheet allocation; profitability; product pricing methodologies; cost-benefit analysis; static pool tracking; dividend verification and deposit analytics; financial trends; and ad-hoc analysis. Maintains and runs various financial analytical software systems and models, both in-house and 3 rd party, including but not limited to: Prologue General Ledger; Vantage Budgeting; 3 rd party Asset/Liability Management (ALM) Model; DNA Profit Vision; Visible Equity Loan Analytics; DNA Core; Callahan Peer-to-Peer; Travis Intelligence Database. Reconciles financial data between systems and models to ensure consistent, detailed and summary reporting to be provided to management, ALCO, and other end-users. Monitors and measures risk in accordance with the metrics outlined in TCU’s policies: Asset-Liability Management; Concentration Risk; Investment; Liquidity Management. Coordinates data gathering from each department for annual budget. Performs quarterly re-forecasts. Evaluates budget and what-if scenarios versus historical data, performs other budgeting duties as assigned. Performs profitability analyses and develops pricing models to ensure product offerings are appropriately priced. Ensures Budget, 3 rd party ALM Model, Profitability Model, and Loan Analytics Model data is reconciled and uploaded. Develops and maintains financial analytics and reporting using modeling output. Responsible for: daily share and loan balancing; deposit analytics; quarterly peer analysis; monthly dividend verification; establishing benchmarks for financial performance. Accurately prepares reports for monthly ALCO and Board meetings. Serves as a Finance Liaison to other departments as it relates to other functions and projects. Serves as TCU Liaison to: third-party software providers; entities that report on our financial data (Callahan, Raddon Financial Group, etc.). Determines methods and procedures on new assignments and may coordinate activities of other personnel for projects.

Requirements

Basic understanding of accounting, balance sheets, income statements, depository institutions, and Asset Liability Management.
Strong analytical skills, highly organized, ability to prioritize workload and manage multiple assignments and deadlines simultaneously.
Reasoning ability - capable of logical, critical thinking.
Ability to use logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusion or approaches to complex problems.
Ability to define problems, collect data, establish facts and draw valid conclusions.
Detail-oriented and able to perform functions with accuracy and on rigid schedules.
Accuracy and attention to detail are paramount as errors in reporting can lead to material misstatements in both regulatory and public arenas, potentially resulting in financial penalties.
Effective, professional verbal and written communication skills.
Ability to work with all levels of the credit union staff.
Proficient in Microsoft Office suite of products.
Advanced Excel skills to include macro experience.
Budgeting software, General Ledger package, and reporting software experience is helpful.
Bachelor's degree in Finance, Accounting, Statistics, Data Analytics Economics, Business, or related field; or an advanced degree without experience; or equivalent related professional experience.
Minimum 2 years finance related work experience, preferably in the financial services and/or banking industry.
Thorough understanding of financial statements, budgeting, forecasting, and ALM.
Effective use of databases (Tableau, Power BI, or Oracle) using user interface and/or coding languages (e.g., SQL or DAX) to query relevant data.

Responsibilities

Provides reporting and analytics focused on but not limited to budgeting; asset-liability management modeling (ALM); interest rate risk; liquidity management; balance sheet allocation; profitability; product pricing methodologies; cost-benefit analysis; static pool tracking; dividend verification and deposit analytics; financial trends; and ad-hoc analysis.
Maintains and runs various financial analytical software systems and models, both in-house and 3 rd party, including but not limited to: Prologue General Ledger; Vantage Budgeting; 3 rd party Asset/Liability Management (ALM) Model; DNA Profit Vision; Visible Equity Loan Analytics; DNA Core; Callahan Peer-to-Peer; Travis Intelligence Database.
Reconciles financial data between systems and models to ensure consistent, detailed and summary reporting to be provided to management, ALCO, and other end-users.
Monitors and measures risk in accordance with the metrics outlined in TCU’s policies: Asset-Liability Management; Concentration Risk; Investment; Liquidity Management.
Coordinates data gathering from each department for annual budget.
Performs quarterly re-forecasts.
Evaluates budget and what-if scenarios versus historical data, performs other budgeting duties as assigned.
Performs profitability analyses and develops pricing models to ensure product offerings are appropriately priced.
Ensures Budget, 3 rd party ALM Model, Profitability Model, and Loan Analytics Model data is reconciled and uploaded.
Develops and maintains financial analytics and reporting using modeling output.
Responsible for: daily share and loan balancing; deposit analytics; quarterly peer analysis; monthly dividend verification; establishing benchmarks for financial performance.
Accurately prepares reports for monthly ALCO and Board meetings.
Serves as a Finance Liaison to other departments as it relates to other functions and projects.
Serves as TCU Liaison to: third-party software providers; entities that report on our financial data (Callahan, Raddon Financial Group, etc.).
Determines methods and procedures on new assignments and may coordinate activities of other personnel for projects.