Financial Macro Specialist

Tucson, AZ

Full Time

Finance and Accounting

Mid Level

Financial Macro Specialist

Job Summary:

To be responsible for maintaining and supporting, existing and new complex Excel VBA macros utilizing a variety of data sources.

Salary: $76K-$92K/DOE
Location: 971 W. Wetmore Rd Tucson, AZ 85705

About Us:

Hughes Federal Credit Union is dedicated to providing a positive difference in our members’ financial lives. Our commitment to the Tucson community extends beyond our members as we sponsor and support local charities and organizations that promote the financial literacy of future generations. Join our team and see why we have been named a “Best-In-State” credit union, four years in a row!

Daily Responsibilities:

• Develop new macro driven Excel spreadsheets to assist various departments in the automation of their processes.
• Responsible for maintaining and improving the existing macro driven Excel spreadsheets throughout the organization.
• Collaborate with key stakeholders to understand departmental needs. Then develop and execute a solution that brings automation.
• Maintain or develop branch/product profitability analysis reports and results.
• Maintain or develop responsibility/cost center and variance analysis reports.
• Support branch and department requests for profitability analysis, trends, and strategies.
• Review and provide guidance on accounting procedures that will facilitate profitability and reporting.
• Assist with the preparation of monthly financial statements.
• Prepare monthly supporting reports including ratios, graphs, charts, and trends for Board of Directors.
• Prepare Asset/Liability Management Committee packages.
• Assist the Vice President Finance with annual budget preparation, review, and completion.
• Assist the Vice President Finance with financial forecasts, periodic reviews, and other analysis.
• Prepare and submit monthly reports for loan participation pools.
• Prepare monthly budget-to-actual comparisons and variances for the Board of Directors.
• Organize data and research for cost benefit analysis associated with credit union operations.
• Provide data associated with analysis of projected interest rate risk, capital risk, liquidity risk, credit risk and concentration risk.
• Perform modeling and “what-if” scenarios on liquidity and net interest margin.
• Prepare daily cash flow reports and required daily business intelligence reporting as needed.
• Responsible for data collection in support of monthly allowance for credit losses.
• Monitor and analyze credit union investment activity.
• Assist in preparation of all regulatory quarterly reporting.
• Assist the Accounting Department as necessary.

Preferred Skills:

Minimum of three years of similar or related experience.
Associates degree or higher in business, computer science, information systems, or completed formalized vocational training in VBA programming.

Benefits and Perks:

Generous Paid Time Off Policy
- Up to 15 days in 1^st year of service
- Paid Time Off increases with tenure
401(k) plan
- 7% company match
Health, Dental, and Vision Insurance
- Health Savings Account with Employer Contribution Available
- Free Vision Insurance
Life and Disability Insurance
- Provided by the Credit Union with Optional Supplemental Coverage Available
Competitive Wage and Career Growth

Hughes Federal Credit Union is a background screening, credit check and E-Verify workplace.

Apply for this position

Required*

Apply with Indeed

First Name*

Last Name*

Email Address*

Phone*

Address*

Resume*

We've received your resume. Click here to update it.

Attach resume or Paste resume

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Are you 18 years of age or older?

References: Please enter names and contact information:

What is your desired salary?*

Do you have experience in Excel using Macros, Visual Basic for Applications and Pivot Tables

How many years of experience do you have working for the position you have applied for?*

Will you consent to a background credit check and criminal history check?*

Are you legally authorized to work in the US?*

Do you now, or will you in the future, require sponsorship for employment visa status (e.g., H-1B visa status, etc.) to work legally for our Company in the United States?*

I understand that this is an in office position. Work from home or remote work is NOT available.*

How did you hear about this position?*

Have you ever been employed by Hughes Federal Credit Union*

The following questions are entirely optional.

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.

Gender

Race/Ethnicity

Human Check*

Submit Application

Thanks for visiting Hughes Federal Credit Union's career page. Please review our open positions and apply to the positions that match your qualifications.

Financial Macro Specialist

Apply for this position