ClearanceJobs
Master Data Analyst
This is a hybrid position and will need to be onsite three days a week. Local candidates only. 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. Reason for Request: Support vendor master migration for Integrations and also vendor master cleansing as part of Project Genesis. 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. 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 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 The benefits that you are eligible for with Collins Consulting, Inc: 401(k) Medical, Dental and Vision Insurance Term Life Insurance Accidental Death and Dismemberment Long Term Disability
This is a hybrid position and will need to be onsite three days a week. Local candidates only. 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. Reason for Request: Support vendor master migration for Integrations and also vendor master cleansing as part of Project Genesis. 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. 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 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 The benefits that you are eligible for with Collins Consulting, Inc: 401(k) Medical, Dental and Vision Insurance Term Life Insurance Accidental Death and Dismemberment Long Term Disability