New

Master Data Analyst I

Spectraforce Technologies
United States, Illinois, Waukegan
Apr 03, 2025
Title: Master Data Analyst I Duration: 12 months Location: Lake County, IL/ Hybrid- 3 days onsite/week Reason for Request: Support vendor master migration for Integrations and also vendor master cleansing as part of Project Genesis Daily Work Schedule Expectations: Top 3 - 5 Skills Needed for each role: Good analytical skills Expert knowledge on Excel and its functionalities Self-learner and able to work independently and pro-active Flexible to work in multiple time zones including JAPAC time Knowledge of vendor master data preferable General Position Summary/Purpose: The Master Data Analyst will be responsible to ensure the accuracy of RTR and OTC Master Data. He/She will act as a liaison between IT, Accounting, FP&A, Operational Excellence and Business Partners to ensure review and clean-up of master data to be migrated from legacy systems. This role is responsible for coordinating the population of SAP LRF (load ready files), the analysis and review of the data and following up on issues between IT and Business. Will need interpersonal skills to discuss findings through analytical work and drive discussions with teams around what they are seeing and finding. Being able to explain what is needed. Should be able to independently run with what is given to them from the manager and run with it. Internships reflecting use of analytical skills would be fine. Running with tight timelines so must have a solid candidate who can jump in and really get up to speed quickly. Key Accountabilities/Core Job Responsibilities: Collaborate with IT lead to facilitate local data extracts. Map legacy data from ERP AX Microsoft Dynamics to SAP fields. Analyzes data errors, resolves root causes with initiative and proposes problems from end-to-end. Use MS excel to document the results of his/her analysis and present the same to project team for corrective action. Extensively utilize Microsoft Excel functionalities and formulae (e.g. VLOOKUP, PIVOT TABLES etc) to automate various reports and analysis required periodically. Cleanse data in legacy system & work with IT coordinators to enrich missing fields. Follow up on open items related to Master Data. Review Pre-Load Reports and Post Load Reports for Pre-Q and Q. Follow up on issues between IT and Business. Track and report the status of the identified corrective action items. Knowledge/Experience of S4 SAP system with Vendor master and PTP processes required. As a member of the US vendor master data team, collaborate with Procurement, Accounts Payable, Treasury and business users to ensure proper and authenticated vendors are onboarded and maintained. Verify documentation received for onboarding new vendors and updates to existing vendor master data. Should have good analytical skills in analyzing the data. Proficient in MS office tools especially Excel. Prepare documentation and work instructions for any process improvements relating to any of the vendor maintenance systems like Ariba, DSP and SAP. Support additional functions within the Vendor master data team. Address any queries from business requestors in relation to vendor master data. Respond to escalation requests from business users. Provide strict adherence to client's processes and established SLAs for the process. Knowledge/Experience of SAP Ariba and DSP systems is preferred. Excellent teamwork, interpersonal, communication, organization, and decision-making skills. Good time management with the ability to handle multiple tasks simultaneously. Should be flexible to work in multiple time zones as needed. Significant Work Activities -Continuous sitting for prolonged periods (more than 2 consecutive hours in an 8 hour day) Qualifications: BA/BS in Finance or accounting, 1-3 years of work experience in Financial Audit, FP&A, Accounting or Consulting. Strong MS excel skills in data recording, analysis and reporting. Prior SAP experience desirable but not required. Strong analytical skills coupled with thoroughness and attention to detail is desired. Good verbal and written communication skills to effectively gather relevant information from business groups. Ability to work with people across multiple work-streams. Must be able to work independently and proactively to take initiative to solve problems quickly. Extreme attention to detail. Affinity for organizing data and information in ways that are logical and useful. Discretion when dealing with confidential information. Efficient work ethic when working on large projects with aggressive deadlines. Previous experience in this field is an asset, but a keen attention to detail, strong organizational skills, and a great work ethic are must-haves. Experience Level = 1-3 Years