Vacancy expired!
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 system
REQUIREMENTS:
• 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