Financial Systems Analyst (Accounts Payable and Purchasing)

Financial Systems Analyst (Accounts Payable and Purchasing) The ideal candidate will be an individual who is either an accounting professional with informational technology experience or a person with information technology experience who has specialized in accounting software. The candidate will be responsible for managing and maintaining the following: accounts payable software (Nexus) and a billing system. PRIMARY DUTIES:• Accounts Payable and Purchasing: o Liaison with accountants o On a monthly basis, close the books o Assist Senior Accountants during the month end close process o Understand where the Accounting team can improve and use SQL to automate processes o Manage the SQL database. Create an EOM database every month and create reports from this database o Create Crystal Reports and custom reports using Power Query, Power Pivot, Infor Q&A o Maintain templates for Accounting and Asset Management o Write queries to embed into spreadsheets o Manage day to day ad hoc requests from Accounting and Asset Management for custom reports and queries o Administrator for Accounts Payable and Purchasing system o Liaison between Accounts Payable and Purchasing o Close books o Understand purchase order process o Set up project work flows OTHER DUTIES:• Property Management system:o Administrator for Property Management systemREQUIREMENTS: • SQL is required • Data Base Management • Excel (ie. Macros/VBA/Pivot Tables) • Crystal Reports writing (Crystal) • PowerPivot and PowerQuery • Knowledge of current trends for information technology and accounting systems • Must come from a strong Accounting background or possess solid knowledge of accounting • Strong verbal and written communication