Temporary Excel Spreadsheet Jobs in Indiana (NOW HIRING)

Role: Administrative Assistant
Location: Indianapolis, IN 46204-Onsite
Long Term Contract
Payrate:- $17.45/hr
DCS Rate Setting keeps files on all active providers. These files need to be created, updated, and maintained. This is a year-round duty that should be done in preparation of cost report season, Administrative Review, and spatially throughout the year.
OverviewThis position would also create both hard and soft folders for the cost reports.
1. Hard/physical folders are our tangible paper documents that consist of the following:
a. Cost Report, Cost per Day, Personnel, and the Desk Audit Analysis
b. Financial documents
c. Licenses.
d. Vendor Cost per Day and Personnel Analysis, if applicable.
e. Any email correspondent that's of pertinent information from the provider, director, licensing department, etc.
2. Soft/ digital folders that should be stored on the Rate Setting server should consist of the same information as the hard folders, plus other info pertaining directly to the cost report (which will be mentioned in far job descriptions.)
Gather cost report Info for AuditorThis position would be the first point of contact when a cost report is submitted to DCS. They will oversee the following:
1. During the process of making the folders, they will make sure the original copy of the cost report, the licenses, and financial documents are attached in the Attachment Tab on iRate.
2. Check Rate Adjustment with guidance from supervisor (in regard to which adjustment should be appropriate for that year.
3. Research if cost report should be a Budgeted Report. (This information will be given to the Auditor on written documentation or checklist that will be created for the Auditor.)
4. If financial information is available, make sure the cost report has the correct Tier listed.
Update Primary Contact Person
Once the cost report has been started by the Auditor, issues have been created, and the provider has responded and sent the issues back to DCS, one of the Standard Questions that the provider must answer is regarding the primary contact person. This is a small task, but extremely important! This information collected will determine who the Deputy Director will send the Rate Letter to in November. We must verify the name, work email, address, and phone number so that when the letters are sent via email, they are NOT undeliverable. Once this information is verified by the Auditor, it needs to be logged into KidTraks.
Purgatory cost reportsThis process is when a vendor starts a cost report, doesn't assign a program, and the program becomes caught in purgatory, meaning the vendor cannot go back and access the cost report. This is extremely helpful when these reports are deleted when trying to run Public Queries. At the end of the year, there's anywhere between 300-600 cost reports and purgatory.
Copying budgeted reportAs directed by the auditor, this position will need to roll over "copy" prior year budgeted report to the current year report.
ResearchDuring the desk audit process, the auditor might have a few items the temp person could research to assist. This will be on an as needed basis. Below are a few examples:
• Grant Research - looking into certain revenue the provider has stated on the cost report.
• RMS Roster List - assist with finding which positions are participating in the RMS and should be allocated to Time Study
• Completing or updating the Time Study FTE Analysis only if directed by auditor. (This spreadsheet wasn't available last year but highly recommended for next year.)
• Assist and reviewing job descriptions. (This would only come after more experience with the Rate Setting Unit.)
• Research small things like, IARCA membership, maximum Social Security Tax Earnings, Travel reimbursement rate, unallowable vs. allowable cost, etc.
• (Might) send provider follow-up email 3 days after auditor has submitted issues. Keep track of response in Events Tab in iRate and keep auditor in loop.
• Rate Research - sometimes when the rate increase or decrease drastically, it's helpful to research what is happening with the cost and utilization for the program. This information can be done on Excel (easily).
Profit Margin
This has to be updated yearly before the Bulletin is sent to providers. There will be an updated spreadsheet on the Rate Setting server where this information can be updated whenever Private of Profit vendors submit their financial information.
Start Q&A Process
The Rate Setting Unit will create a checklist of items to verify on the cost report, before the director, manager, or auditor starts a Q&A after a cost report is completed. These items will be redundant to a lot of the duties in prior job descriptions however, it's tremendously important this process is reported with additional checklist items like:
• Checking Social Security and Medicare FICA tax rate
• Making sure the LCPA's Caseload Ratio Limit was updated
• The provider has listed in §3.1a CCW, CCWM, and CM in conjunction to what's entered on the T/S FTE Analysis.
• LCPA number of locations is updated
• Salary Tier, revenue, and §2.1 salary limit amounts all match
• All Other line entries, Small Equipment Purchases, and Leased and Rented Equipment have a description
Required/Desired Skills
Skill
Required /Desired
Amount
Candidate Experience
High School Diploma.
| Required
| 0
|
Prior experience as admin. in a financial or auditor setting.
| Required
| 1 Years
|
Experience with Excel for rate research and analysis.
| Required
| 1 Years
|
Strong organizational skills.
| Required
| 0
|
Strong communication skills, both written and oral.
| Required
| 0
|
Prior experience researching grant information and other financial and rate related data.
| Highly desired
| 0
|
Prior experience working with iRate and KidTracks for file management and updates.
| Desired
| 0
|
Rate Setting Using a Cost Reporting Method
| Desired
| 0
|
Compensation: $17.00 per hour
About Us
We're more than Software Company with a creative side. We're a full-service creative studio with a serious technology background. We take a holistic view of sales and marketing, building digital brands that deliver real value to our client.
As a marketing agency, our innovative digital strategies grab and hold people's attention, and produce the communication and organizing tools needed for success. With a mix optimized to the specific goals of each client and the character of their target customer demographics, we provide true integration across media platforms and channels.
Our Vision
Inteletech Global, Inc provides consulting services to assist clients with their ongoing demand for changing IT environments. The early 2000s were an exciting time for IT. Digital technology was transforming our lives, and with each innovation, it became clear that digital was the future.
We use our Global Delivery Model for the success of every engagement. Improve effectiveness and efficiency of IT application environments by adopting re-usable software platforms. Our onsite teams work directly with our clients to understand and analyze the current-state of problems and design specifically tailored conceptual solutions.