Data Analyst II
At a glance
Mid-level Data Analysis & BI role at Integrated Resources INC. Corning · no salary stated · we estimate $86,500–$135,038 across the United States.
Integrated Resources INC has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Build monthly finance reports from Directorate forecasting and planning data, and keep targets current in the tools
- Track depreciation projections, verify capital assignments, and maintain reference records for accounts receivable and capital
- Handle asset audits, transfers, tagging records, and project changes in PeopleSoft, especially during December and January
- Review travel, project, accounts payable, space, storage, and IT reports, then resolve errors or pursue cost savings
- Prepare charts and presentation updates, and help reorganize Directorate files and folders
What you bring
- You have two to five years of experience manipulating data and querying databases
- You can use Excel to reshape data and create charts, and work with database queries and reports
- You can use Microsoft Office tools and Explorer folders
Who this fits
This mid-level, onsite role in Corning is suited to someone comfortable with data work and recurring finance and accounting tasks. The assignment is expected to last at least a year. A two-year degree is preferred.
From the employer
Integrated Resources, Inc is a premier staffing firm recognized as one of the tri-states most well-respected professional specialty firms. IRI has built its reputation on excellent service and integrity since its inception in 1996. Our mission centers on delivering only the best quality talent, the first time and every time. We provide quality resources in four specialty areas: Information Technology (IT), Clinical Research, Rehabilitation Therapy and Nursing.
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