|
HI, Hope you are doing great! This is Harry from Dynamic Enterprise Solutions. We have urgent requirement with one of our Direct clients (No hidden Layers) , please review below job description and let me know your interest
Position ID: DYESJP00016567 Title: Business Data Analyst (Pivot tables, VLOOKUP') Location: North Chicago, IL Duration: 6 Months
Locals only - Hybrid Remote (3 days Onsite, 2 days Remote) DO NOT SUBMIT CANDIDATES UNWILLING OR UNABLE TO BE ONSITE PART OF THE TIME. FULLY REMOTE IS NOT AVAILABLE FOR THIS ROLE. MUST - Advanced Excel skills: pivot tables, formula writing (VLOOKUP), figure-making PREFERRED - Database access capabilities: Structured Query Language (SQL) for query writing OPTIONAL - Power BI skills: connect to datasets and build interactive reports
Description: BSA Resource requires advanced Microsoft Excel skills. Must be able to create Pivot Tables and use VLOOKUP's to merge / determine variables between sheets, etc. This person will be pulling data from Service Now, using external excel sheets to categorize data (country to region mapping), doing aged calculations using current date versus created date and categorizing incidents using this information. Experience with Power BI is preferred.
Strong knowledge and experience in working with MS-Excel, Pivot Tables and graphs. Experience with ServiceNow (ITSM) in extracting data is desired. Metric Reporting resource skilled using Excel pivot tables and VLOOKUP's. Will pull data from different sources (including ServiceNow, ACD's, etc.) together to produce metric reports for senior management. Ability to organize findings into a PowerPoint or interactive dashboard a plus.
The resource must be capable of needing minimal instruction, able to work independently, good communication skills and ability to capture reporting requirements and create reports.
MUST - Advanced Excel skills: pivot tables, formula writing (VLOOKUP), figure-making PREFERRED - Database access capabilities: Structured Query Language (SQL) for query writing OPTIONAL - Power BI skills: connect to datasets and build interactive reports
Remote is available but must work 8-5 CST
1. Are you open to look at candidates willing to relocate? no What are the top 3-5 skills requirements should this person have? Advanced Excel skills: pivot tables, formula writing (VLOOKUP), figure-making 2. What is a nice to have (but not required) regarding skills, requirements, experience, education, or certification? Database access capabilities: Structured Query Language (SQL) for query writing 3. What type of environment is this person working in? small team, collaborative/iterative, partly remote / partly in-person, quick turnaround, highly-visible products, senior executive customers 4. Work Schedule (Define days,# of hours)/ Is Overtime offered or required? If yes, how many hours, what impact to scheduled working hours? 5 days, 40 hrs per week, overtime possible but shouldnt be required 5. Does this position offer the ability to work remotely on a regular basis or is it an on-site role? If remote opportunity exists, what are the options (i.e. 1 day remote, 4 days on-site)? Remote available 6. Is the worker onshore or offshore? onshore 7. Will there be Domestic and/or International Travel? none
Thanks & Regards jsol...@dynamic-enterprise.net |
This message was sent to you using SWARM™ © 2020.
You received this message because you are subscribed to "rtc-linux".
Membership options at http://groups.google.com/group/rtc-linux .
Please read http://groups.google.com/group/rtc-linux/web/checklist
before submitting a driver.
---
You received this message because you are subscribed to the Google Groups "rtc-linux" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rtc-linux+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rtc-linux/010f017fb200a8a4-08f9d74a-7318-4e69-aa11-704b1ff1f78a-000000%40us-east-2.amazonses.com.
