Treasury Analyst I

Mary Kay•Town of Addison, WI

1d•Onsite

About The Position

Initiates electronic payments and transfers between accounts. Administers bank portals and treasury management applications. Works with internal partners on payment requests and adjustments. Records journal entries related to treasury activity. Performs analysis on Treasury metrics and bank account fees. Deposits corporate checks and apply payments in our accounting software.

Requirements

1+ years in Treasury
Bachelor/University Degree in Finance or Accounting
Basic understanding of Generally Accepted Accounting Principles (GAAP) to prepare and review journal entries.
Knowledge of Kyriba Treasury Management System, PeopleSoft and JD Edwards financial modules, including general ledger, query and reporting; Proficiency in Microsoft Excel and SharePoint. This includes the use of macros, pivot tables, and similar advanced Excel functionality.
Ability to quickly learn and effectively use various bank portals and treasury management software.
Able to provide suggestions to automate processes and reduce cost.
Communication skills to interface with personnel at all levels both in the U.S. and internationally, and with external banking and profit sharing record-keeper/trustee contacts to provide support and for issue resolution.
Utilizes digital tools to perform tasks at a high level of productivity.
Builds and maintains trusting relationships by actively listening to stakeholders and backing up opinions with facts, knowledge, and logic.
Good verbal and written communication skills to interface with personnel at all levels both in the U.S. and internationally and with external auditors to provide support and for issue resolution.
Organizes and structures communications in a way that is easily understandable to the audience.
Organizational and time management skills to work on multiple projects.

Nice To Haves

Experience with Tableau, PeopleSoft Financials, HFM, and JD Edwards is highly beneficial.
Proficiency in Microsoft Office suite, especially advanced Excel, is beneficial.

Responsibilities

Independently performs daily cash positioning and liquidity management to ensure company can meet daily cash obligations.
Utilizes treasury management system to obtain prior and intraday bank activity to complete cash positioning and perform short-term cash forecasting.
Provides recommendations for cash movement between operating and investment accounts for daily liquidity needs.
Runs pay cycle process daily in the ERP system and manages supplier bank account information. Works with external business partners and collaborates to ensure outgoing wire, ACH, and check payments are executed on a timely basis and within company internal control standards.
Buys and sells foreign currency as needed, ensuring trade settlements and documentation comply with internal controls.
Performs short-term cash flow forecasting to maximize excess cash for investment.
Makes recommendation on whether to purchase or redeem short-term investment funds.
Has a basic understanding of when business decisions or business strategies have implications on cash processes or cash flow.
Responsible for tracking Treasury KPI metrics & analytics, including bank fees and reviewing results with management.
Uses software solutions, if required, to perform analysis and produce financial reports that are logical and easy to understand.
Identifies trends and variances in an efficient and timely manner.
Tracks and trends interest rates and earnings on investment accounts and presents results to management.
Records journal entries related to treasury activities on a monthly basis.
Has a basic understanding of GAAP principles.
Runs month end reports to validate transaction accuracy and reasonableness.
Works with internal partners to review and correct variances between general ledger and bank account statements.
Analyzes, reviews, and submits Accounts Payable checks for printing.
Provides information to internal departments regarding check status or other payment issues.
Initiates stop payments and researches checks to determine if it is still outstanding. If needed, obtains copy of cleared check to verify signature with the payee.
Responsible for coordination and follow-up of fraud affidavits when applicable.
Reviews and makes pay or return decisions daily on ACH and check positive pay exception items. Conducts research to determine if the payment is valid, fraudulent, being sent to the state for an unclaimed property issue and/or any other transmittal problems.
Serves as a system administrator for the treasury management system and all banking portals.
Assists with user setup of entitlements and inactivation of users.
Leads the annual security review of financial portals to review security on all US bank accounts.
Maintains a SharePoint site for Treasury reports, cash forecasts, and other ad hoc reports shared with management. Researches and provides ad hoc information using the Bloomberg terminal as requested by management.
Responsible for bank relationship support.
Works directly with the FX trade desk, treasury management services and investment managers on daily cash requirements.