Finance - Sr Financial Analyst I - Treasury and Investments

Sacramento, CA, United States

Finance - Sr Financial Analyst I - Treasury and Investments Sacramento, CA, USA Req #5103

Thursday, April 4, 2024

TITLE: SR FINANCIAL ANALYST I – TREASURY AND INVESTMENTS

STATUS: EXEMPT

DEPARTMENT: TREASURY

REPORTS TO: VP – TREASURY & INVESTMENTS OFFICER

CODE: 11265

PAY SCALE: $98,600.00 - $105,000.00 ANNUALLY

GENERAL DESCRIPTION:

As Senior Financial Analyst I – Treasury & Investments, you will help lead the team on product pricing (loans & deposits) while supporting the team in the oversight of liquidity, business & investment services, interest rate risk, investments, and capital market activities. This position performs various finance, accounting, analytical, and treasury-related functions for Golden 1 Credit Union, including but not limited to financial reporting, financial analyses, trade operations, market research, and maintaining financial systems/models directly related to the Credit Union’s treasury & investment functions. Act as lead for other analysts in the Treasury & Investments team. Employees in this area are cross trained in several aspects of finance, treasury, and other relevant analytical functions and will assist the Finance & Business Intelligence team in special projects.

TASK, DUTIES, FUNCTIONS:

Perform the following job duties and responsibilities in accordance with corporate policy and procedures, within established timeframes:

Leads product pricing (loan & deposit) reports and the construction of new dashboards for loans and deposits to support rate change proposals, including but not limited to improving existing treasury-related reports throughout the Credit Union.

Provide analytical support to the Asset Liability Committee (ALCO) through analysis and written presentation of loan and deposit products.

Actively leads team members in product pricing (loan & deposit) through Funds transfer pricing (FTP) analysis, liquidity analysis, Asset liability Management (ALM) analysis, yield analysis, portfolio performance, market research, competitor rate research.

Leads team members with providing in-depth market research and risk/reward analysis on product pricing and investments.

Supports team in investment-related reporting, capital markets activities (loan participations purchase or sales), trade operations (security transaction report packages, collateral management, rate change emails, invoices, trade blotter, closed mortgage pipeline hedged emails, settlements, wire payments, trade reconciliations, safekeeping, pledging, etc.) including any other administrative tasks relating to these functions.

Supports team in liquidity reporting and analysis

Actively participates in ALM meetings and discussions. Leverages ALM for product pricing proposals and investment analysis.

Supports team in any funding/borrowing or leverage reporting and activity.

Leads team members in ALCO, Board, and other ad hoc management reporting, as well as internal regulatory reporting.

Supports team in business and investment services reporting.

Using PowerBI, R, and/or Excel, aggregate multiple data sources into a single story to summarize the results of a review into actionable points for Senior Management to support business decision-making.

Supports team members with the quarterly call reports related to investments.

Continually seek to improve processes, reports, and tools to increase business value and improve efficiency; offers recommendations for improvement as business evolves. Participates in continuous improvement activities that may cross functions through routine collaboration with other analysts.

Prepare data, support spreadsheets, provide analytics, and develop reports to help evaluate product pricing and investment performance. Contribute to the research and development efforts undertaken to improve the Credit Union’s oversight of product pricing, liquidity, ALM, and the investment portfolio.

Lead in developing and maintaining metrics, graphs, reports, analytical tools, and any other means to measure and monitor the Credit Union’s product pricing. Lead team members in utilizing advanced data analytics tools and techniques to build periodic trend analysis reports, and presents insights and findings that are relevant, actionable, and visually appealing to management.

Is committed to fostering a “data-driven culture” by continually seeking to harvest data-driven insights and developing technical skills (ex. PowerBI and/or Excel (VBA), R programming etc.)

Ensure data for all reports is accurate and reports are prepared in a timely and thorough manner.

Lead team members in coordinating the assessment of internal and/or external industry trends, market, product, member, and channel performance to identify gaps and additional value areas to maximize financial performance and operational efficiency

Lead team members in updating and maintaining financial models such as Net Present Value (NPV) models, FTP models, scenario and breakeven point analyses, scenario based total return models, cash flow models, cost benefit analysis models, etc.

Leads team members in analysis and synthesis of financial results into meaningful recommendations to management through written reports or dashboards, with clean and concise visual charting.

Utilize various business intelligence tools and financial information systems including but not limited to current organization-wide and/or department specific software in the preparation of analyses, evaluation, and reports.

Develop and maintain a thorough understanding of the general ledger accounts, components of the balance sheet, income statement, key ratios, products, and other financial data, and analyzes and communicates variances in support of the financial plan that relates to product pricing, ALM, liquidity, and the investment portfolio.

Develop and maintain a thorough understanding of state and federal laws and regulations related to credit union compliance including bank secrecy and anti-money laundering laws appropriate to the position.

Develop and maintain financial performance-related knowledge in assigned business lines to provide deep-dive analyses into metrics, trends, and anomalies while providing insights to drive improvements and support ongoing business line initiatives and projects.

Maintain current procedure and process manuals for position functions of recurring tasks.

Monitor progress toward significant strategic goals and policies.

Support strategic financial initiatives to aid in the achievement of multi-year ongoing financial objectives to support the financial position, growth, and profitability of the Credit Union, through effective long-term capital management.

Assist in the routine preparation of financial reports for the Credit Union including, but not limited to, information for management reports analyzing financial performance by channels, markets, and peers.

Analyze the monthly financial statements and reports and communicate variances and relevant findings in support of the financial plan.

Learn and gain an understanding of lending/deposit rates, policies and procedures impacting responsibilities.

Update procedures in response to changes in operational activities or technological upgrades.

Perform reviews or validations of other Financial Analyst work prior to, or in lieu of, review by Team Leadership.

Prepare or create ad hoc financial models, analyses, spreadsheets, visualizations, and presentations that effectively present data and analytical findings for management as reference for strategic decisions, committee review, and other information requests.

Use statistical concepts and tools to find causation, patterns, and trends to develop or better inform existing financial models.

Work with Leadership and with other Financial Analysts on complex analyses, using data to add value to our business partners.

Develop reports for executive management and credit union committees, ensuring that the reports are accurate and thorough.

Develop and Recommend Internal Controls and other relevant improvements.

Contribute to and lead the creation of deliverables including preparing various and wide- ranging reports pertaining to corporate strategic focus areas.

Lead the research and development efforts undertaken to improve the Credit Union’s products, services, and operations.

Increase productivity by developing automated applications, eliminating duplicating effort, and coordinating information requirements.

Lead complex analysis projects, coordinating and delegating work to Junior Analysts and business partners to ensure success.

Utilize advanced data analytics tools and techniques to build periodic trend analysis reports, and present insights and findings that are relevant, actionable, and visually appealing to management.

Assist with the technical skill growth and business knowledge growth of Junior Financial Analysts.

Specializations in this position may include one or more of the following:

Product Pricing (Loans and Deposits)

Business Banking & Investment Services

Treasury functions (Trade Operations & Collateral Management)

Asset/Liability Management (ALM)

Investments

Market Research

Capital Markets

Secondary Marketing

Wholesale Funding/Borrowing

Membership Analysis

PHYSICAL, SKILLS, ABILITIES, AND EXERTION UTILIZED IN THE PERFORMANCE OF THESE TASK:

Effective oral and written communication skills required to prepare reports and perform other related tasks.

Must possess sufficient manual dexterity to skillfully operate an on-line computer terminal and other standard office equipment, such as financial calculators, personal computer, facsimile machine, and telephone.

Hand-eye coordination required to read, post, and handle complex computer programs and report.

ORGANIZATIONAL CONTACTS & RELATIONSHIPS:

IN TE R NA L : All levels of staff and management.

E X TE RNAL: Vendors, external auditors, and other financial institutions or business sources.

QUALIFICATIONS:

EDUCATION: Requires a bachelor's degree in area of specialty (Accounting, Mathematics,

Economic, Business Administration, Information Technology, or similarly

quantitative/analytical degrees). Other degree types will be considered with relevant

experience combined with strong technical experience. Equivalent work experience with

required knowledge/skills may be substituted for other degree types.

E X PERIENCE: 5 - 12 years or more of progressive finance experience. 5 - 12 years of

Analytical Experience. Knowledge of commonly used concepts, practices, and procedures

within credit union/banking operations.

KNOWLEDGE/SKILLS: Power Excel user; experience building advanced dashboards with business intelligence tools; ability to use statistical programs and data wrangling tools to assemble complex datasets and perform advanced analyses; strong research, quantitative and qualitative data collection, and report building; self-starter with strong time management, organizational skills; ability to multi- task effectively; make sound decisions in the absence of detailed instructions and work on own initiative; strong independent work methods; excellent verbal and written communication skills with the ability to present complex data in a comprehensive yet succinct manner; detail oriented, critical thinking problem solver who continually seeks to learn new concepts and acquire new skills, specifically technical skills. Advanced technical skills and/or experience in one or more of the following: Bloomberg API, S&P Global API, R, Power BI, VBA, SQL, Fixed Income Security Analysis, Bond Accounting, Security Settlement & Wire Confirmation, Asset/Liability Management, and/or Cash & Liquidity Management. The following further details additional knowledge and skills that are necessary to perform the position successfully.

Functional:

Functional Knowledge in the following: Federal Rules and Regulations as applied to credit unions; Golden 1 Products; Golden 1 Employee Handbook.

Expert knowledge in the following areas: Relevant Corporate Finance concepts; U.S. GAAP and General Ledger Accounting concepts; Golden 1 Policies and

Technical:

- Expert knowledge in the following systems/applications (required): Microsoft

Excel- Formulas, functions, and pivot tables, dashboard creation, Power Query, data connections, and automation with macros; Microsoft Power Point; Microsoft Word; Microsoft Outlook- Email, Calendar, Task; Microsoft Teams; PDF Creation/Editing (Nitro Pro); VBA Coding to support automation of tasks.

- Expert knowledge in the following systems/applications (preferred): Microsoft

Power BI - Building Visuals using existing Datasets, and Power BI Desktop

to build datasets and complex reporting through DAX Programming; SQL Programming - Select Statements, Joins, Aggregating Data, temp tables, and complex querying; DataSafe; VBA Coding to support automation of tasks; R/Python Programming.

Behaviors:

- Self-Motivated, can stay focused with minimal oversight.

- Models Golden 1's Core Values of Service Excellence, Respect, Integrity and R e liability; Embraces Golden 1's mission and vision.

- Acts ethically in all matters.

- Plans and organizes work in order to support department goals.

- Productively works to improve the standard way of doing things, anticipating issues to prevent problems before they occur.

- Utilizes skill and training to make recommendations to improve a process, support our Core Values and/or save costs.

- Can be counted on to meet obligations and accepts accountability for delivering results.

- Demonstrates reliable and on-time attendance.

- Demonstrates functional, technical and job specific knowledge required for position.

- Takes ownership of their own professional and personal development to ensure their skills remain current and relevant.

- Is open and willing to try new approaches and ideas.

- Learns about and embraces changes in Golden 1’s strategy or direction.

- Attention to detail; ensures accuracy in work product.

- Ability to independently prioritize tasks.

- Leverages available tools and resources to stay organized and proactive.

- Demonstrates desire and ambition to achieve.

- Knows when work product requires additional attention to presentation and acts accordingly to ensure deliverables match the need.

- Is available and sought after as a resource of relevant skill and knowledge.

- Able to work through roadblocks and find solutions.

- Takes initiative to identify, investigate and resolve stakeholder issues, including operational and support situations.

- Ability to structure workload, adding or delegating tasks as time allows.

- Establishes, monitors, and reports key performance indicators.

- Takes the lead on projects to see them to completion.

- Helps manage the team workload and delegates work appropriately.

Communication & Interaction:

- Steward of the Golden 1 Brand and maintains quality standards of service excellence in all interactions.

- Respects and works well with people with diverse skills, styles, perspectives, and backgrounds.

- Contributes to an inclusive environment, where everyone is treated with courtesy, dignity, and respect, regardless of perceived differences.

- Provides exceptional member/colleague service by showing caring, friendly, member centric support, and seeking opportunities to provide Golden Service.

- Fully participates in meetings, proactively bringing forward relevant information, ideas, and potential solutions.

- Communicates clearly and concisely, both in written and oral form.

- Shares knowledge freely to help others succeed.

- Shares important information at appropriate time; Ability to escalate issues requiring additional action.

- Works well within team and across departments, effectively collaborating and interacting with coworkers, leaders, and members.

- Acknowledges and celebrates the success of others.

- Gives and receives honest and candid feedback in a constructive way; Leverage feedback to further personal and professional development.

- Positively adapts to changes in Golden 1 and/or changes in own role and helps others to do the same.

- Effective listener.

- Presumes positive intent in all communications.

- Able to speak in technical and business language based on the audience.

- Ability to ask relevant probing questions of external stakeholders to ensure appropriate accounting treatment.

- Confident communicating with mid-level management outside of the team.

- Solid presentation skills; Speaks clearly and confidently.

- Makes complicated information understandable to the audience.

- Confident communicating with all levels of management outside the team, including executive leadership.

- Takes time to understand co-workers work goals and supports them in their effort to do their best work.

- Ability to speak on behalf of the Finance Leadership Team.

- Adept in resolving conflicts in a professional manner.

Leadership:

- Guides external stakeholders to proper resources for inquiries.

- Supports team and department leadership with projects.

- Supports teammates.

- Provide guidance and training to Junior Financial Analysts.

- Ability to effectively lead efficient meetings.

- Mentor and develop employees throughout the department to assist with skills growth.

- Effective delegation skills; knows when to delegate and when to lead.

- Supports and demonstrates cohesive leadership within the department.

- Demonstrates and coaches behaviors that are expected of the team (leadership by example).

- Develops coaching and leadership skills by observation and training courses.

- Assist with workflow, delegating work to Junior Analysts.

PHYSICAL REQUIREMENTS:

Prolonged sitting throughout the workday with occasional mobility required.

Corrected vision within the normal range

Hearing within normal range. A device to enhance hearing will be provided if needed.

Ability to lift 15 lbs. as may be required.

Occasional movements throughout the department daily to interact with staff, accomplish tasks, etc.

Minimal travel to attend meetings by car and/or public conveyance for conferences or training session held at out-of-area locations or across the United States (1 – 2 times per year).

L IC E N SES /C ER T I F ICA T I O N S :

Not required, but desired: Chartered Financial Analyst (CFA); Certified Corporate FP&A Analyst (CFP&A); Certified Treasury Professional (CTP); Chartered Alternative Investment Analyst (CAIA)

TH I S JOB DESCRIPTION IN NO WAY STATES OR IMPLIES THAT THESE ARE THE ONLY DUTIES TO BE PERFORMED BY THIS EMPLOYEE. HE OR SHE WILL BE REQUIRED TO FOLLOW OTHER INSTRUCTIONS AND TO PERFORM OTHER DUTIES REQUESTED BY HIS OR HER SUPERVISOR THAT ARE WITHIN HIS / HER KNOWLEDGE, SKILL AND ABILITY AS WELL AS HIS / HER MENTAL AND PHYSICAL ABILITIES.

#J-18808-Ljbffr