Position Overview The Credit Portfolio Reporting Analyst develops and improves portfolio credit portfolio reporting to support the Credit Department with some guidance from Credit reporting manager and other subject matter experts. Intermediate knowledge of underlying data, data sources, SQL, and data visualization tools. Resource on credit data questions for customers, credit department staff, and bank staff. As a key member of the Credit Wholesale Lending team, you will be part of AgriBank's mission to support the people who feed the world. Job Functions Asset Pool Sale Due Diligence Complete due diligence on proposed asset pool sales Recommends & implements enhancements to the due diligence process & reporting. Able to identify & resolve intermediately complex issues Resource to field customer questions applicable to our responsibilities within the due diligence process Recurring Reports - Credit Department Produce recurring reports for the Credit Department & Board meetings Produce standardized reports as needed to support the Wholesale loan renewal/review process Recommends & implements enhancements to queries & processes. Able to identify & resolve intermediately complex issues Develop new intermediately complex reports Report high level changes in portfolio trends to Credit leaders External Reporting / Bank Projects Assists the Credit Department's Subject Matter Expert representative for Bank Projects, as needed Complete responsibilities for reporting including but not limited to Loans2, Attribution, benchmark updates, annual collateral exposure analysis Recommends & implements enhancements to queries & processes following department procedures. Able to identify & resolve intermediately complex issues Ad Hoc Analysis & Reports Create queries & reports for intermediately complex requests with minimal assistance from manager Resource to answer questions on credit data within the Credit Department This job description is subject to change without notice. Education and Experience Bachelor's degree in business administration, economics, or agricultural related field 3 years' experience in credit analysis, credit operations, application development, portfolio analysis and/or report generation Or an equivalent combination of education and experience sufficient to perform the essential functions of the job Knowledge Intermediate knowledge of portfolio risk assessment and risk management concepts Intermediate knowledge of Generally Accepted Accounting Principles (GAAP), loan accounting systems as well as accounting and general ledger practices Intermediate knowledge of agricultural lending Intermediate knowledge of Farm Credit System and District operations, Farm Credit Act regulations, cooperative principles, and federal lending laws Skills Intermediate proficiency in office software Microsoft Office Suite Intermediate proficiency with SQL Intermediate proficiency in PowerBI Intermediate knowledge of data sources & underling data Intermediate proficiency in OneStream Physical Requirements Prolonged periods sitting at a desk and working on a computer Must be able to lift up to 15 pounds at times The AgriBank Advantage You are the key differentiator in the marketplace and ultimately the most important factor in helping us fulfill our mission to support those who feed the world. We are committed to providing you with a competitive compensation and benefits package - your total rewards for making significant contributions to our business and making a difference on behalf of those we serve. The typical base range for this role is between $68,000-$104,000. Compensation may vary based on individual job-related knowledge, skills, expertise, and experience. The position is eligible for a discretionary annual incentive program driven by organization and individual performance. Benefits AgriBank benefits provide safety, security, and peace of mind for you and your family. Through comprehensive Total Rewards, access to financial tools and support, and personal services, our benefits demonstrate that employees' health and financial well-being are of primary importance. Wherever you are on life's continuum or what life transition you experience, our benefits support your health care needs and guide you along the path to retirement. Collaboration and Staying Connected Beautiful office overlooking many of St. Paul's landmarks, with exceptional space to collaborate with your colleagues and friends Monthly employee activities to keep groups connected and have fun! Annual Employee Appreciation activities Multiple recognition programs to celebrate each other's success Work and Life Paid time off Company holidays Floating holidays Sick time Right Work/Right Place hybrid work program Dress for Your Day flexible wardrobe policy Generous company match on employee donations Growth and Development Employee and leader career development toolkits Tuition reimbursement Internal and external resources and opportunities to grow personally and professionally Health, Wellness and Investment/Retirement Health care plan alternatives to fit your lifestyle, including: Health Savings Account (HSA) and Flexible Spending Account (FSA) Dental Vision Wellness reimbursement Investment and retirement planning Saving today for tomorrow is one of the smartest moves you can make. That's why AgriBank offers you a generous, competitive and flexible 401(k) plan for your financial well-being: Fixed Employer Contribution = 3 percent PLUS, Employer Matching Contribution = $1 for $1 match (vested fully after 4 years) on the first 6 percent of eligible compensation you save Life and disability insurance plans for eligible team members and their families Free exercise facility onsite for all employees Parking and transportation discounts Generous employee referral incentive Join the dedicated professionals at AgriBank and put your skills to work ensuring farmers and rural communities have the innovative financial solutions they need to feed our neighbors and the world. AgriBank will not sponsor a work visa (e.g., H1B, etc.) to fill this position. Applicants requiring a reasonable accommodation for any part of the application process may contact us through the following methods: Phone: 651-282-8578 or Mail: AgriBank, Attn: Talent Recruiting, 30 E 7th Street, Suite 1600, St. Paul, MN 55101. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire. AgriBank FCB is an Equal Opportunity Employer (M/W/D/V) dedicated to diversity in the workplace and offers a great work environment. All qualified applicants will receive consideration for employment without regard to race, color, gender, age, religion, national origin, handicapped status, veteran status, public assistance status or other condition or status prohibited by law. Apply here: https://www.aplitrak.com/?adid=YmJnZW5lcmljLjA4OTM5LjEwNTA2QGFncmliYW5rZmNiY29tcC5hcGxpdHJhay5jb20
