Data Analyst II

Position: Data Analyst

Duration: 1+ Year

Location: Corning, NY

Direct client: Immediate interview

Required Skills

• Excel data manipulation and charting
• Experience with databases – queries and reporting
• MicroSoft Office Tools
• Explorer Folders

Desired Skills

• Experience with Accounting and Financial Systems
• PeopleSoft
• Actuate/ Jasmine/ Plainview
• SharePoint
• PowerPoint
• Data Analysis

Day-to-Day Duties

• Finance
• Create and manipulate data in reports from the Directorate Forecasting and Planning tools to assist with monthly reporting

-

Resolve questions via use of tools and corporate finance systems

Ensure targets are updated and maintained in tool

• Accounting
• Capital Maintenance
• Maintain Depreciation Model (once implemented by manager) to have on-going tally of depreciation expense projections.
• Ensure items are capitalized into the correct departments and Functions labeled in the “custodian” field
• Maintain folder with information related to ARs/ Capital for staff reference.
• Complete Asset Inventory Control – Annual Audit; Asset transfers & tagging/ location documentation
• Open, change and close projects in PeopleSoft (SSEC) to enable/ prevent charges to be applied. Maintain log to ensure completion of requests. This work is heaviest in December – January.
• Complete journal transfers as required between projects
• Move Directorate towards standardized activity codes to enable data analysis of spending categories (e.g., travel, capital, line time, and other expense)
• Evaluate and address issues on charges related to Travel, Projects and AP Vouchers
• Review Space reports for accuracy and address issues with space/asset owners.
• Review Storage reports for cost savings opportunities and address.
• Review IT reports to ensure accuracy and address issues

Miscellaneous ( based on capability and need)

• IP Stats Report
• NDA Log Maintenance
• SPITS Maintenance
• Purchase Orders

Technology Strategy

Assist with Technology Strategy presentation builds

• Obtain/ manipulate data for charts/ graphics
• Update presentations
• Provide support in the clean-up and re-organization of Directorate folders/ files in support of system optimization

Education

2 year degree is preferred

Experience

2-5 of data manipulation; database queries

Thanks

Nagesh

732-844-8712