Senior Financial Analyst I - IT

TITLE: SENIOR FINANCIAL ANALYST I – IT DEPARTMENT: PLANNING AND GOVERNANCE ADMIN REPORTS TO: MGR – IT STRATEGIC SOURCING AND FINANCIAL PLANNING ANALYSIS STATUS: EXEMPT JOB CODE: 11140 PAY RANGE: $97,600.00 - $105,000.00 ANNUALLY   GENERAL DESCRIPTION    Performs various finance and analytical functions for Golden 1 Credit Union, including but not limited to financial reporting, financial analyses, and maintaining financial systems/models. Act as lead for other analysts in the Finance & Business Intelligence team.  Employees in this area are cross-trained in several aspects of finance, treasury, and other relevant analytical functions and will assist the Finance & Business Intelligence team in special projects.   TASKS, DUTIES, FUNCTIONS Perform the following job duties and responsibilities in accordance with corporate policy and procedures, within established timeframes: 1. Support strategic financial initiatives to aid in the achievement of multi-year ongoing financial objectives to support the financial position, growth, and profitability of the Credit Union, through effective long-term capital management. 2. Assist in the routine preparation of financial reports for the Credit Union including, but not limited to, information for management reports analyzing financial performance by channels, markets, and peers. 3. Analyze the monthly financial statements and reports, and communicate variances and relevant findings in support of the financial plan. 4. Maintain a thorough understanding of the general ledger accounts, components of the balance sheet, income statement, key ratios, products, and other pertinent financial data.  5. Using PowerBI and/or Excel, aggregate multiple data sources into a single story to summarize the results of a review into actionable points for Senior Management to support business decision-making. 6. Assist with requirement gathering using interviews, document analysis, use cases, scenarios, and workflow analysis. 7. Learn and gain an understanding of lending/deposit rates, policies and procedures impacting responsibilities. 8. Update procedures in response to changes in operational activities or technological upgrades. 9. Perform reviews or validations of other Financial Analyst work prior to, or in lieu of, review by Team Leadership. 10. Ensure compliance with applicable standards, rules, regulations, and systems of internal control. 11. Conduct ad hoc market research, special studies, reviews, analyses, and all other duties as assigned. 12. Update and maintain financial models including, but not limited to profitability and pricing models through scenario and breakeven point analyses. 13. Analyze financial results and synthesize through written reports or dashboards, with clean and concise visual charting. 14. Prepare or create ad hoc financial models, analyses, spreadsheets, visualizations, and presentations that effectively present data and analytical findings for management as reference for strategic decisions, committee review, and other information requests. 15. Continue to expand on an understanding of lending/deposit rates, policies and procedures impacting responsibilities. 16. Perform reviews or validations of Financial Analyst I work prior to, or in lieu of, review by Team Leadership. 17. Develop and maintain financial performance-related expertise in assigned business lines to provide deep-dive analyses into metrics, trends, and anomalies while providing insights to drive improvements and support ongoing business line initiatives and projects.   18. Develop and maintain financial models, metrics, graphs, reports and any other means to measure and monitor Golden 1’s financial position.  This includes researching, querying, analyzing, interpreting, and communicating qualitative and quantitative data associated with the credit union’s financial strength and stability. 19. Use statistical concepts and tools to find causation, patterns, and trends to develop or better inform existing financial models. 20. Actively supports the Asset/Liability Management (ALM) function through data preparation and validation 21. Proactively collaborate with management, other Financial Analysts, and assigned lines of business in the Credit Union to define, analyze, and study financial performance-related issues and data.   22. Coordinate the assessment of internal and/or external industry trends, market, product, member, and channel performance to identify gaps and additional value areas to maximize financial performance and operational efficiency. 23. Work with Leadership and with other Financial Analysts on complex analyses, using data to add value to our business partners. 24. Develop reports for executive management and credit union committees, ensuring that the reports are accurate and thorough. 25. Develop and Recommend Internal Controls and other relevant improvements.  26. Monitor and document progress toward significant strategic goals and policy adherence. 27. Routinely maintains a pulse on the financial position and financial trajectory of the Credit Union through dedicated monitoring of the balance sheet, income statement, key financial ratios, and other supplementary reports.  28. Is ever vigilant of developing financial trends and proactively shares findings and recommendations with senior leadership.  29. Actively supports the Asset/Liability Management (ALM) function through working closely with consultants to select, process, and validate data for ALM models.  30. Provide analytical support to the Asset Liability Committee (ALCO) through quarterly analysis and written presentation of the ALM model results. 31. Contribute to and lead the creation of deliverables including preparing various and wide-ranging reports pertaining to corporate strategic focus areas. 32. Lead the research and development efforts undertaken to improve the Credit Union’s products, services, and operations. 33. Increase productivity by developing automated applications, eliminating duplicating effort, and coordinating information requirements. 34. Lead complex analysis projects, coordinating and delegating work to Jr Analysts and business partners to ensure success. 35. Proactively ask questions and use data to answer theses questions, creating new value-add knowledge for the Credit Union. 36. Gather and integrate data and contextual information to design rigorous analyses to support carefully crafted projections. 37. Utilize advanced data analytics tools and techniques to build periodic trend analysis reports, and present insights and findings that are relevant, actionable and visually appealing to management.  38. Review and maintain an understanding of current and future economic landscape and internal and external influences.   39. Develop and provide written and verbal recommendations and alternative solutions based on the results of analyses, taking into consideration internal and external factors, and the Credit Union’s strategic goals and initiatives. 40. Assist with workflow, monitoring the ticketing queue for new work and ensuring it is assigned to the right teammate for success. 41. Assist with the technical skill growth and business knowledge growth of junior Financial Analysts. 42. Maintain a thorough understanding of state and federal laws and regulations related to credit union compliance including bank secrecy and anti-money laundering laws appropriate to the position. 43. Perform other duties as assigned.   Specializations in this position may include one or more of the following: • General Ledger Accounting  • Financial Reporting • Lending (Real Estate Secured/Personal Loan/Vehicle Secured/Credit Cards) • Marketing  • Business Banking • Treasury functions • Pricing (Loans and Deposits) • Compliance Reporting • Loan Portfolio Analysis • Membership Analysis • Asset/Liability Management (ALM) • Workflow monitoring for the team     PHYSICAL SKILLS, ABILITIES, AND EXERTION UTILIZED IN THE PERFORMANCE OF THESE TASKS 1. Effective oral and written communication skills required to prepare reports and perform other related tasks. 2. Must possess sufficient manual dexterity to skillfully operate an on-line computer terminal and other standard office equipment, such as financial calculators, personal computer, facsimile machine and telephone. 3. Hand-eye coordination required to read, post, and handle complex computer programs and report.   ORGANIZATIONAL CONTACTS & RELATIONSHIPS 1. INTERNAL:  All levels of staff and management. 2. EXTERNAL: Vendors, external auditors and other financial institutions or business sources.   QUALIFICATIONS 1. EDUCATION: Requires a bachelor's degree in area of specialty (Accounting, Mathematics, Business Administration, Information Technology or similarly quantitative/analytical degrees). Equivalent work experience with required knowledge/skills may be substituted for other degree types.   2. EXPERIENCE: 5 - 12 years or more of progressive finance experience. 5 - 12 years of Analytical Experience. Knowledge of commonly-used concepts, practices, and procedures within credit union/banking operations. 3. KNOWLEDGE/SKILLS:  Functional: - Functional Knowledge in the following: Federal Rules and Regulations as applied to credit unions; Golden 1 Products; Golden 1 Employee Handbook. - Expert knowledge in the following areas: Relevant Corporate Finance concepts; U.S. GAAP and General Ledger Accounting concepts; Golden 1 Policies and Procedures; Lending concepts; Retail Branch Banking; Compliance Reporting; Financial modeling.   Technical: - Expert knowledge in the following systems/applications (required): Microsoft Excel- Formulas, functions, and pivot tables, dashboard creation, Power Query, data connections, and automation with macros; Microsoft Power Point; Microsoft Word; Microsoft Outlook- Email, Calendar, Task; Microsoft Teams; PDF Creation/Editing (Nitro Pro); VBA Coding to support automation of tasks. - Expert knowledge in the following systems/applications (preferred): Microsoft Power BI - Building Visuals using existing Datasets, and Power BI Desktop to build datasets and complex reporting through DAX Programming; SQL Programming - Select Statements, Joins, Aggregating Data, temp tables, and complex querying; DataSafe;; VBA Coding to support automation of tasks. - Intermediate knowledge in the following systems/applications (preferred): SAS Enterprise Guide – Data Manipulation and transformation, data aggregation using the GUI tool basic SAS programming; Bloomberg Terminal; Syntellis Axiom EPM; R/Python Programming; Bloomberg Terminal; Syntellis Axiom EPM.   Behaviors: - Self-Motivated, can stay focused with minimal oversight. - Models Golden 1's Core Values of Service Excellence, Respect, Integrity and Reliability; Embraces Golden 1's mission and vision. - Acts ethically in all matters. - Plans and organizes work in order to support department goals. - Productively works to improve the standard way of doing things, anticipating issues to prevent problems before they occur. - Utilizes skill and training to make recommendations to improve a process, support our Core Values and/or save costs. - Can be counted on to meet obligations and accepts accountability for delivering results. - Demonstrates reliable and on-time attendance. - Demonstrates functional, technical and job specific knowledge required for position. - Takes ownership of their own professional and personal development to ensure their skills remain current and relevant. - Is open and willing to try new approaches and ideas. - Learns about and embraces changes in Golden 1’s strategy or direction. - Attention to detail; ensures accuracy in work product. - Ability to independently prioritize tasks. - Leverages available tools and resources to stay organized and proactive. - Demonstrates desire and ambition to achieve. - Knows when work product requires additional attention to presentation and acts accordingly to ensure deliverables match the need. - Is available and sought after as a resource of relevant skill and knowledge. - Able to work through roadblocks and find solutions. - Takes initiative to identify, investigate and resolve stakeholder issues, including operational and support situations. - Ability to structure workload, adding or delegating tasks as time allows. - Establishes, monitors and reports key performance indicators. - Takes the lead on projects to see them to completion. - Helps manage the team workload and delegates work appropriately.   Communication & Interaction: - Steward of the Golden 1 Brand and maintains quality standards of service excellence in all interactions. - Respects and works well with people with diverse skills, styles, perspectives, and backgrounds.  - Contributes to an inclusive environment, where everyone is treated with courtesy, dignity and respect, regardless of perceived differences. - Provides exceptional member/colleague service by showing caring, friendly, member centric support, and seeking opportunities to provide Golden Service. - Fully participates in meetings, proactively bringing forward relevant information, ideas and potential solutions. - Communicates clearly and concisely, both in written and oral form. - Shares knowledge freely to help others succeed. - Shares important information at appropriate time; Ability to escalate issues requiring additional action. - Works well within team and across departments, effectively collaborating and interacting with coworkers, leaders, and members. - Acknowledges and celebrates the success of others. - Gives and receives honest and candid feedback in a constructive way; Leverage feedback to further personal and professional development. - Positively adapts to changes in Golden 1 and/or changes in own role, and helps others to do the same. - Effective listener. - Presumes positive intent in all communications. - Able to speak in technical and business language based on the audience. - Ability to ask relevant probing questions of external stakeholders to ensure appropriate accounting treatment. - Confident communicating with mid-level management outside of the team. - Solid presentation skills; Speaks clearly and confidently. - Makes complicated information understandable to the audience. - Confident communicating with all levels of management outside the team, including executive leadership. - Takes time to understand co-workers work goals and supports them in their effort to do their best work. - Ability to speak on behalf of the Finance Leadership Team. - Adept in resolving conflicts in a professional manner.   Leadership: - Guides external stakeholders to proper resources for inquiries. - Supports team and department leadership with projects. - Supports teammates. - Provide guidance and training to Junior Financial Analysts. - Ability to effectively lead efficient meetings. - Mentor and develop employees throughout the department to assist with skills growth. - Effective delegation skills; knows when to delegate and when to lead. - Supports and demonstrates cohesive leadership within the department. - Demonstrates and coaches behaviors that are expected of the team (leadership by example). - Develops coaching and leadership skills by observation and training courses. - Assist with workflow, delegating work to Jr Analysts using the ticketing system.   PHYSICAL REQUIREMENTS 1. Prolonged sitting throughout the workday with occasional mobility required. 2. Corrected vision within the normal range. 3. Hearing within normal range.  A device to enhance hearing will be provided if needed. 4. Ability to lift 15 lbs. as may be required.   5. Occasional movements throughout the department daily to interact with staff, accomplish tasks, etc.   LICENSES/CERTIFICATIONS Not required, but desired: Chartered Financial Analyst (CFA); Certified Corporate FP&A Analyst (FPAC); Certified Treasury Professional (CTP); or other relevant advanced degree.   THIS JOB DESCRIPTION IN NO WAY STATES OR IMPLIES THAT THESE ARE THE ONLY DUTIES TO BE PERFORMED BY THIS EMPLOYEE.   HE OR SHE WILL BE REQUIRED TO FOLLOW OTHER INSTRUCTIONS AND TO PERFORM OTHER DUTIES REQUESTED BY HIS OR HER SUPERVISOR THAT ARE WITHIN HIS / HER KNOWLEDGE, SKILL AND ABILITY AS WELL AS HIS / HER MENTAL AND PHYSICAL ABILITIES. REV. 4/11/2024