Data Migration Analyst II

Data Migration Analyst II: (Intermediate) Position Summary

Monument Consulting is currently seeking a Data Migration Analyst II (DMA) to join our Configuration Team and facilitate the implementation and enhancement of Vendor Management Systems (VMS) for our clients. As a Managed Service Provide (MSP), our clients seek our services to consult on, design, and implement managed procurement solutions for their contingent labor programs. New client implementations typically last 3 - 6 months and a DMA may work on 2 - 4 projects at a time. All DMAs will complete strategic departmental initiatives related to their workstreams.

The DMA will work as part of a project team owning the collection and review of foundational data and incumbent worker data. The DMA will be responsible for manipulating large datasets in Microsoft Excel and learning VMS uploads across multiple software including SAP Fieldglass, Beeline, and VNDLY. The DMA will sanitize client source system HRIS and financial data and create early estimates for key project metrics. The DMA will create a Data Validation Template (DVT) and coordinate distribution to key external stakeholders. The DMA will answer stakeholder questions, collect returned data, and combine into a Worker Data Master (WDM) file. The DMA will then identify and call out any discrepancies or gaps and coordinate the closure of gaps. After building and testing uploads in a test environment, the DMA will upload client data into the VMS and audit results for accuracy and completeness. The DMA will also own change request and/or expansion work for existing clients.

ResponsibilitiesProject Responsibilities

• Learning new VMS data uploads (SAP Fieldglass, Beeline, VNDLY, etc.)
• Learning and employing data management best practices
• Reviewing, sanitizing, and combining client source data to establish a Data Validation Template (DVT)
• Auditing, cleaning, and standardizing large Excel datasets including formatting, file combination, field mapping, and gap analysis
• Coordinating the data validation project plan with our internal project management team
• Coordinating data validation with client, vendor, and internal stakeholders
• Conducting data validation call outlining the process for client, vendor, and internal stakeholders
• Validating and uploading foundational datasets into VMS
• Building and maintaining a Worker Data Master (WDM) Excel dataset of collected data
• Maintaining through backups and audit trails for master data files
• Validating returned data, communicating data gaps, and coordinating gap closure
• Reporting on data collection progress and key spend metrics
• Executing rigorous VMS upload testing and troubleshooting errors
• Executing production uploads
• Ensuring error-free imports of client data from master files to VMS
• Exceeding key performance metrics related to data import completeness and accuracy
• Performing systematic audits of production data

Desired Skills & ExperienceExperience

• Bachelor's degree (Computer Science, Information Services, or related study preferred)
• 3+ year(s) of experience in data analysis, data entry, or related data study
• Familiarity with navigating and loading data into SAP Fieldglass, Beeline, VNDLY, Coupa Contingent Workforce, 3Story Software, Vector, Wand, or equivalent
• 3+ year(s) of experience in a corporate setting

Desired Skills

• Strong Microsoft Excel skills (familiarity with XLOOKUP, VLOOKUP, Pivot Tables)
• Working knowledge of relational database concepts (preferred)
• Strong detail-oriented organizational skills
• Working knowledge of Microsoft Office (Word and PowerPoint)
• Working knowledge of internet browsers (Google Chrome, Microsoft Edge)
• Clear verbal and written communication skills
• Ability to set and manage expectations around deliverables and timelines
• Willingness to speak up, ask for help, and receive coaching
• Ability to break technical concepts into component parts and problem solve
• Demonstrated ability to speak on technical issues to audiences of various sizes and technical abilities
• Ability to learn complex concepts through formal training, on the job coaching, and self-study
• Ability to travel up to 4 times a year for annual conference and on-site client visits

Our Shared Values

• Everyone matters
• We take care of each other
• Leadership is here to serve
• High character and hard work above all else
• Always know where you stand
• Excellence isn’t the expectation, it’s the Monument standard

*This is a hybrid role located in Richmond, VA