Financial Analyst

*This position is limited remote -- 3 days in-branch required per week, 2 days per week remote.
In order to be considered for this position, 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.
* The Financial Analyst is primarily responsible for performing product, organizational, and member profitability analysis.
The Financial Analyst will provide executive level and cross-functional support of all financial analysis and reporting needs of the credit union, forecasting processes, and help to instill financial disciplines throughout the organization.
*Principal Duties and Responsibilities:* * Adopt and meet all assigned performance management goals and objectives.
* Assist other departments with general ledger balancing.
* Assist staff in analyzing and improving job processes.
* Assist the CFO/Controller in special projects as assigned.
* 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.
* Complete cross-training of additional duties within the Accounting Department to allow effective backup support for Accounting activities.
* Daily review of various Symitar morning reports, general ledger accounts, clearing accounts and exception reports for prior day posting errors.
* Implement improvements in workflow efficiency.
* Maintain knowledge of finance and accounting functions in the credit union, provide support to all areas of the credit union.
* Openly communicate with managers to ensure productive interactions.
* Perform miscellaneous accounting, finance, or strategic ad hoc report requests.
* Prepare appropriate general ledger entries, balance general ledger accounts and follow up on outstanding items when necessary.
* Processing of new credit union employee checklists to include setup/removal of cash user general ledgers as needed.
* Provide backup to the Staff Accountant for the daily credit card settlement postings.
* Reconciles and reviews the Credit Union’s daily cash letters.
Promptly researches and resolves discrepancies.
* Remain abreast on all accounting software features and functionality.
* Responsible for various internal and external reporting including accurate preparation in accordance with Generally Accepted Accounting Principles (GAAP) and/or regulatory standards.
* Assist in implementing Current Expected Credit Loss (CECL) methodologies.
* Assist the Controller with Troubled Debt Restructuring calculations, and ALLL (Allowance for Loan and Lease Loss) reporting.
* Assist the Controller with maintaining general ledger chart of accounts to include adding, deleting, or revising existing general ledger accounts as deemed appropriate.
* 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.
* Increase productivity by developing automated reporting/forecasting tools utilizing SQL.
* Manage yield and variance reporting, working with departments to ensure adequate, accurate, and timely reporting to senior management.
* Use visualization software to design and create dashboards and custom reports with interactive views, analysis, and drill downs.
* 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.
* Responsible for backing up the Controller in ALM software data input, data analyzation and reporting and prepare the quarterly ALM packet for management.
* 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 * Responsible for completing peer analysis to analyze profitability, trends, and key ratios.
* Responsible for cost benefit analysis for key corporate projects.
* Other job-related duties as may be necessary to carry out the responsibilities of this position.
*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 Controller.
Will have regular contact with members and employees of the accounting department and back office staff.
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 mathematics, statistics, finance, accounting or related field preferred.
* Equivalent work experience in lieu of a degree will be considered.
* Credit Union or Financial Institution financial analysis experience a plus * 2+ years of experience in data analytics or statistical modeling * 2+ year(s) of experience with SQL, Power BI, Dundas, or Tableau or similar software * Experience in data/statistical languages: Excel, VBA, M, SQL, R, and Python * 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 * Disability insurance * Employee assistance program * Flexible spending account * Health insurance * Life insurance * Paid time off * Parental leave * Referral program * Vision insurance Physical setting: * Office Schedule: * Day shift Work Location: Hybrid remote in Westby, WI 54667