Job TitleThis individual will serve as a local point-of-contact and project coordinator to assist a consulting firm in managing, collecting, validating, analyzing, and creating reports in order to optimize a supply chain management organization.The activities for this role include:Use project management skills to build the overall project planWork with the client to establish employee roles and task definitionsParticipate in client meetingsPublish weekly status reportsBuild employee survey templates to capture employee data including, salaries, work activities, and other similar elementsEngage the client in the implementation and distribution of employee surveysFrom collected survey data build a comprehensive model using a database/spreadsheetValidate with client that employee survey information is accurate and can be analyzedIdentify and communicate any discrepancies and outliers in the dataIdentify information patterns, gaps, overlap, and report on findingsCreate summary level reports from the dataTranslate, advise, and assist with optimization using the model as the foundationConsult with the client on practices for potential optimizationSupport queries utilizing the model and/or by writing and creating custom reportsContribute input and data to the final client deliverableWork with the team to edit and review other project deliverables and final presentationRequired Skills: Five to seven years of IT, HR or Financial analyst experience. One to two years of project management experience. Expert knowledge of MS Excel, SQL, and PowerPoint, ability to write and edit macros, write SQL queries, and perform limited programming, strong understanding of Human Resource/IT processes and data collection methods, excellent interpersonal skills including written and verbal communication skills, and previous exposure to project-related or consulting activities.Preferred Skills:Bachelor's degree in Human Resources, computer science, financial, or related field or equivalent work experienceProject Management Certifications.Retail/Supply Chain Management KnowledgeConsulting or account management experienceUnderstanding of HRMS database design, structure, functions and processesExperience with data visualization tools