Data/Financial Analyst

First Financial Credit Union; Albuquerque (NM); On-site; USD 85,000 - 110,000; Full time

Job summary

First Financial Credit Union in Albuquerque, NM seeks a Finance Analyst to gather and analyze financial data, evaluate profitability across products, and prepare monthly BOD/Committee reports. The role includes creating what-if analyses for loan yields, assisting in investment and cost-efficiency reviews, and supporting 5300 reporting.

The ideal candidate has a Bachelor’s in accounting/finance or 4+ years of relevant experience, 7+ years preferred, with proficiency in Power BI and SQL preferred.

Qualifications

• Education: Bachelor's degree in accounting, finance or 4+ years relevant/equivalent experience in lieu of degree.
• Experience: 7 years relevant/equivalent experience, plus must be bondable.
• Preferred: Power BI and/or SQL.
• Knowledge, Skills, Abilities: Effective communication, detailed loan/product analysis, proficient with complex spreadsheets, accuracy and teamwork.

Responsibilities

• Research factors affecting loan yields and provide what-if analyses on products; generate reports from internal data warehouses and external sources.
• Evaluate profit and cost efficiencies across credit union areas using spreadsheets; collaborate with external vendors on activity-based costing models.
• Regularly review investments portfolio to meet policy targets; prepare Asset/Liability models with external vendors to maintain guidelines.
• Research other credit unions to report industry trends, growth opportunities and earnings potential.
• Review and assist 5300 reporting as needed.
• Other duties as assigned by the VP of Finance.

Job description

Summary

Gathers financial information to analyze the profitability of various products offered by the credit union. Studies the industry to assess trends in products and practices. Provides recommendations and reporting based on the analysis of the financial information and industry trends. Analyzes efficiency and financial information before and after project or software implementation to assess the potential & actual return on the investment. Will assist in the monthly preparation of BOD and various Committee reports.

Essential Functions

35% 1. Research and evaluate factors that affect loan yields and provide recommendations and what-if analysis on products offered to members. Generating reports using internal data warehouses and external databases, and reviewing environmental and economic reports and FFCU data to the provide recommendations. Assist in the preparation of BOD and various Committee reports.

20% 2. Evaluate profit and cost efficiencies in various areas of the credit union to assess effectiveness and return on investments by utilizing spreadsheets, data bases and other internal FFCU reports. Works with external vendors and consultants regarding activity-based costing models.

20% 3. Regularly review and monitor investments portfolio to maintain policy targets. Suggest new investment options and assist in purchasing new investments to hit policy targets. Prepare Asset/Liability spreadsheets and models, working with external vendors and consultants to maintain policy guidelines.

10% 4. Research other credit unions within the industry to reports industry-wide trends, growth opportunities, additional member services and earnings potential.

5% 5. Review and assist 5300 reporting as needed.

Non-essential Functions

10% 1. Other duties as assigned by the VP of Finance.

Expectations

1. Accuracy and attention to detail when compiling financial information for analysis. Thorough review of the information before presentation to ensure sound decisions are made based on accurate data.


2. Work well with all levels of management and personality types. Performing an assist and support role within the credit union.


3. Required reports and analysis are completed on time and accurately.


4. Gain a strong understanding of financial models and planning as it relates to the credit union industry.


5. Develop strong analytical and organizational skills while managing multiple projects

Requirements

Qualifications

Education: Bachelor's degree in accounting, finance or 4 plus years relevant/equivalent experience in lieu of degree.

Experience: 7 years relevant/equivalent experience, plus must be bondable.

Preferred: Experience with Power BI and/or SQL.

Knowledge, Skills, Abilities: Must communicate effectively with other peers and management. Perform detailed analysis of loan products and project efficiencies. Be proficient with various complex spreadsheets. Demonstrate accuracy, attention to detail and a cooperative team spirit. Ability to work in a changing environment and demonstrate knowledge of the industry through experience and research.