Financial Analyst

This position is limited remote, requiring three days per week in-branch and two days remote. In order to be considered, you MUST apply on Paylocity at the following link: https://recruiting.paylocity.com/recruiting/jobs/All/b9944418-e383-4000-853f-3d5b60a36394/Westby-Coop-Credit-Union.

Reporting to the SVP -Accounting & Finance, the responsibilities in this role will include a variety of tasks that are daily, monthly, and quarterly with the most demanding being the tasks surrounding month end close and budgeting. There is an emphasis on being able to refine and analyze data from various sources and verify its accuracy through the use of multiple programs. Advanced skills in excel are required for success in this role. The Financial Analyst Supports financial decision-making information by collecting, analyzing, investigating, and reporting financial data. Improves operational efficiencies by recommending process improvements and quality controls.

Principal Duties and Responsibilities:

• Assist with annual audit and regulatory examination by gathering requesting items, preparing schedules, and assisting with questions and requests during the engagement.
• Assist with completing reports for the quarterly NCUA 5300 (call) report.
• Maintain knowledge of finance and accounting functions in the credit union, provide support to all areas of the credit union.
• Prepare monthly yield and variance reports for management, research, and work with departments to identify variance causes.
• 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 WCCU’s policies: Asset-Liability Management; Concentration Risk; Investment; Liquidity Management
• 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, 3rd party ALM Model, Profitability Model, and Loan Analytics Model data is reconciled and uploaded.
• 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.
• Prepare, review, and distribute financial and management reports on a weekly, monthly, and quarterly basis.
• Assist with month-end closing process, including the monthly financial statements.
• Develop and foster internal business partnerships to help departments measure results and maximize value.
• Make recommendations to management based on analyzing results, monitoring variances, and identifying trends.
• Develop and track key performance metrics against the company’s strategic objectives.
• Assists with the analysis and management of data related resources (such as VE Loan Analytics, VISA Analytics Platform, etc.)
• Validate and maintain information between source system and management reporting systems.
• Work collaboratively with other team members to achieve departmental and corporate goals.
• Take ownership for change and identify process improvements where needed.
• Assist with the annual budget process for the organization, document, and update model assumptions, and assist with reporting and meeting preparations.
• Responsible for various internal and external reporting including accurate preparation in accordance with Generally Accepted Accounting Principles (GAAP) and/or regulatory standards.
• Complete financial analysis on products, services, operations. Provide written synopsis of results including opinion and recommending actions to management.
• Creates, organizes, and maintains files using database and spreadsheet programs; retrieves and organizes data into required reporting formats; collects, retrieves, and organizes data to identify financial discrepancies and resolves management inquires; recommends solutions to staff ensuring that corrections or changes are implemented properly.
• Build reporting dashboards from start to finish, including identification of strategic key performance indicators (KPIs), queries to obtain the data, visualizations, and dashboard maintenance.
• Technical expertise regarding data models, data mining and segmentation techniques.
• Expert knowledge of Power BI and databases (SQL and non-SQL).
• Perform intermediate level accounting functions.
• Prepare financial analyses and forecasting reports on monthly, quarterly, and annual basis to senior management and the Board of Directors.
• Prepare ongoing profitability analyses and reporting by partner, product, service, branch, and/or department; monitor cost control activities; and make recommendations on cost control strategies.
• Translate and map data from multiple data sources into Power BI for visualization and reporting. Create automated Power BI dashboards. Develop best Power BI approaches and practices and enhance the skills within the institution.

Other Duties and Responsibilities:

• Excellent communications skills and proven effectiveness when working with members and staff. Also work in a courteous, respectful, and efficient manner. Ability to remain calm and tactful when addressing sensitive situations with employees and members.
• Skillful listening, comprehension, and speaking ability to quickly decipher the needs of others and relate the pertinent information requested.
• Proficient operation of a variety of general office equipment such as PC, software applications, copier, calculator, telephone, copy machine, fax machine and other similar devices or programs related to the position.
• Ability to present ideas, report facts and other information clearly and concisely.
• Always work cooperatively with others.
• Comprehend consequences of various situations and refer them to the appropriate staff for resolution.
• Manage personal workflow, incoming calls, process transactions correctly and meet deadlines by being organized, detailed and task oriented.
• Ability to meet attendance standards and work overtime or early hours as requested and approved.
• Ability to understand and follow safety/security practices.

Work Relationships and Scope: Report directly to the SVP – Accounting & Finance. 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 Will also work with staff members from various other departments of the Credit Union as well as credit union members.

Performance Dimensions:

• Maintains member and employee confidence and protects operations by keeping information confidential and sharing on a business-related as-needed basis only.
• Provides friendly, professional, timely and accurate service and support to all members, employees, and volunteers.
• Engages in problem resolution by clarifying the member’s and/or employee’s complaint; determining the cause of the problem; selecting and explaining the best solution to solve the problem; expediting correction or adjustment; following up to ensure resolution; and keeping the supervisor informed of problems and solutions.
• Complies with WCCU policies and procedures by enforcing and adhering to internal WCCU procedures and board-established policies.
• Complies with federal, state, and local regulations and legal requirements by enforcing and adhering to requirements.
• Maintains professional and technical knowledge by attending staff meetings; identifying opportunities to attend seminars that enhance skills and maintain knowledge of new products that could assist in improving operational effectiveness.
• Contributes to a team effort by accomplishing corporate and individual goals and other related results as needed.

Knowledge, Skills and Abilities Required:

Education/Experience Requirements:

• Bachelor's degree in Accounting, Finance, Economics, or a related field is required.
• A minimum of three years of Accounting/Finance experience in a financial, credit union, or banking industry is required.
• 2 years of experience of effective uses of databases (Tableau, Power BI, or Oracle) using user interface and/or coding languages (e.g., SQL or DAX) to query relevant data.
• Ability to work in high production environment and respond quickly and effectively under pressure, changing priorities and tight timelines/deadlines.
• Ability to lead within a team environment to make rational timely decisions with accountability.
• High degree of accuracy, attention to detail, integrity, work ethic, and willingness to learn.
• Ability to learn new software products and think creatively to find new solutions/efficiencies.

Job Type: Full-time

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Flexible spending account
• Health insurance
• Life insurance
• Paid time off
• Parental leave
• Referral program
• Vision insurance

Schedule:

• Monday to Friday

Work Location: In person