Data Analyst
Location:
Raleigh , North Carolina
Posted:
November 16, 2016
Reference:
5826236
We are looking for a combination business analyst / data analyst. Person will be working with various platforms including ICRS,CSCC, CCW, Connect dots and EOL too. ICRS is the system of record for all of the data that the various branches of the military have as it relates to gear they have purchased with our clients and associated service contracts. This person will be handling requests to add new products (serial numbers) to the system and put these items on the correct contracts. The branches of the military pay a service contract price based on the number of products they have on their contracts. But the submit requests to change inventory that range from 3000-7000 per week. The person will be working within cisco's systems and will be learning new platforms. Person needs to have expert excel skills. Former, v look up, pivot tables, don't need SQL queries in access. Data processing job but there is also data processing and business mind set. Pivot tables, v look ups, we get ten columns from a customer's go through various tools of Cisco, go to sorting, taking different sets of data and compile it, and it has to be accurate. Errors could cost hundreds and thousands of dollars with one mistake. The work will include adding new gear, update new gear, move gear from one org to another, remove gear from the system. There are requests submitted every day. The team downloads twice a week and has 2 weeks to have each item processed. Have to use cases within another unit, then we remove from contract. This individual does not call customers and is not involved with billing.

The workflow is that a request form comes customer, the person will go into different tools and hunt down things customers have bought. Cleanup, entitling enrollment, submit quote case to gsc team., then convert it onto the contract.
Have to be able to handle large fluctuations and workload, 3000-7000 items can be downloaded twice a week that needs to be addressed. These items will either needed to be added, removed or made changes to the items.

Example: I have this is ICRS can you go into CSCC to see if they match.

No hand holding 2 month ramp up, great problem solving skills. Army (California), Navy, maternity leave supports DISA and other small clients. Possibility of Airforce coming on possibly.

Long term contract.

SLA: from the point it is downloaded there is a 2 week target turn around. Also if you are consistently making data errors. Download it, is in on contract is it valid, once you determine it you fill out a template to open a test case. Send it to MN team you get a file back send it for conversion and take converted file and upload it. Should only be in processing for two week. When it is a new item it is done. When in process that is when they will use the cisco tools. Do all the validation. They will use other tools to ounds out the information about a product. 3 million lines of active inventory.
We have 3 major customers and 7 smaller customers. The work will focus on DISA and Army or Airforce next depending on where the new programs would come from. Each item has a sku value. The sum of sku is what determines the value of the contract.

About TEKsystems:

Join TEKsystems®, a leading IT staffing, IT talent management and IT services firm, and get your career on the fast track. We have more than 100 offices worldwide, and we partner with over 6,000 clients and place over 80,000 consultants per year. At TEKsystems, we seek to understand our consultants' skills, goals and interests, allowing us to present targeted job opportunities on a contract, contract-to-hire or direct placement basis. TEKsystems' leadership in the market stems from our sincere and personal commitment to driving the success of our customers, consultants and each other.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, genetic information or any other characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please call 888 472-3411 or email accommodation@teksystems.com for other accommodation options.

A little about us:
TEKsystems provides corporations with IT staffing, talent management expertise and IT services, enabling them to meet their business objective.

Know someone who would be interested in this job? Share it with your network.