Data Migration Analyst III

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

OUR PEOPLE AND OUR COMMUNITY

We support our people and our community through our dedicated committees:

• Diversity & Inclusion Council
• Women's Leadership Council
• Community Outreach
• Sustainability Team
• Continuing Education Committee

Position Title: Data Migration Analyst III

Position Summary:

Monument Consulting is seeking a skilled and detail-oriented Data Migration Analyst III (DMA) to join our Data Migration Team. The DMA will play a crucial role in the implementation and enhancement of Vendor Management Systems (VMS) for our clients. As a Managed Service Provider (MSP), we design and implement managed procurement solutions for contingent labor programs. New client implementations typically span 3-6 months, with DMAs managing 2-4 projects simultaneously. Additionally, DMAs will contribute to strategic departmental initiatives.

Responsibilities

Project Responsibilities

• Executing VMS data uploads (SAP Fieldglass, Beeline, VNDLY, etc.)

• 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

Mentorships Responsibilities

• Developing and leading trainings on data best practice and VMS upload topics

• Building improved data collection / validation / import process design and documentation

• Mentoring Data Migration Team DMAs

Qualifications

Experience

• Bachelor's degree (Computer Science, Information Services, or related study preferred)

• 5+ year(s) of experience in data analysis, data migration, data transformation, or data import

• Strong familiarity with navigating and loading data into SAP Fieldglass, Beeline, VNDLY, Coupa Contingent Workforce, 3Story Software, Vector, Wand, or equivalent

• 5+ year(s) of experience in a corporate setting

Desired Skills

• Advanced Microsoft Excel skills - Mastery of Lookup formulas (XLOOKUP, VLOOKUP), formatting formulas (CONCAT, LEFT, RIGHT, TEXT), summary formulas (COUNTIF, SUMIF, Pivot Tables)

• Strong knowledge of relational database concepts

• Strong detail-oriented organizational skills

• Experience with VMS imports (preferred)

• 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

Pay Range

USD $70,000.00 - USD $77,000.00 /Yr.