WCCU Credit Union

Financial Analyst

WCCU Credit Union

full-time

Posted on:

Origin:  • 🇺🇸 United States • Wisconsin

Visit company website
AI Apply
Manual Apply

Job Level

Mid-LevelSenior

Tech Stack

JavaScriptOracleSQLTableau

About the role

  • Assist with annual audit and regulatory examination by gathering requested items, preparing schedules, and assisting with questions 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 variance causes, and work with departments to identify variance causes.
  • Reconciles financial data between systems and models to ensure consistent, detailed and summary reporting to management, ALCO, and other end-users.
  • Monitors and measures risk per WCCU 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: Excellent communications skills and professional demeanor.

Requirements

  • Education: Bachelor's degree in Accounting, Finance, Economics, or 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 using databases (Tableau, Power BI, or Oracle) with UI and/or coding languages (e.g., SQL or DAX) to query data.
  • Ability to work in a high production environment and respond quickly under pressure, changing priorities and 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.