SAP ERP Implementation Intern — Data Migration

MiTek Industries; Chesterfield (MO); On-site; USD 25,000 - 34,000; Part time

Benefits offered by this job

Paid Time Off

13 holidays annually

Volunteer time off

Medical/Dental/Vision plans

Parental Leave

Job summary

MiTek is seeking a Data Migration Intern to join our SAP ERP migration efforts in Chesterfield, MO. You will profile, cleanse, and map legacy data, work with business data owners, and contribute to the cutover validation in a live enterprise program.

You'll own defined slices of the data work, run load prep and validation, and help build readiness reporting for program leadership, gaining direct exposure to ERP consulting and IT program management.

Qualifications

• Rising junior, rising senior, or recent graduate pursuing a degree in Information Systems, Business Analytics, Supply Chain, Accounting, Finance, Computer Science, or a related field.
• Strong Excel skills, including lookups, pivot tables, text functions, and comfort working with large data sets.
• Demonstrated analytical rigor — you question data and investigate discrepancies rather than returning uncertain results.
• Clear written and verbal communication; you must ask precise questions and document answers.

Responsibilities

• Profile legacy data across source systems to identify duplicates, invalid records, and formatting inconsistencies.
• Support field-level mapping between legacy structures and SAP objects; maintain mapping docs.
• Execute cleansing routines and track remediation progress by object and data owner.
• Prepare load files, participate in mock loads, and reconcile pre- and post-load counts and errors.
• Build and maintain readiness reports showing data readiness by object and workstream.

Skills

Excel

Attention to detail

Analytical thinking

Communication

Education

Information Systems or related field

Tools

SQL

Python (pandas)

Alteryx

Power Query

Power BI

Tableau

Job description

Job Responsibilities & RequirementsPOSITION OVERVIEWOur organization is undertaking a company-wide SAP ERP implementation, and data migration is the workstream that determines whether we go live on time. We are hiring a Data Migration Intern to work alongside our functional leads, technical team, and system integrator partners to extract, cleanse, map, and validate legacy data as it moves into SAP.This is a hands-on role on a live enterprise program. You will not be shadowing from the sidelines — you will own defined slices of the data effort, work directly with business data owners, and see your work reflected in the production system at cutover. It is an unusually direct path into ERP consulting, data analytics, or IT program management.KEY RESPONSIBILITIESData profiling and analysis — Profile legacy data across source systems to identify duplicates, incomplete records, formatting inconsistencies, and orphaned entries; document findings for the business owners who must resolve them.Source-to-target mapping — Support field-level mapping between legacy structures and SAP target objects (material master, customer/vendor master, chart of accounts, open items, BOMs), and maintain mapping documentation as decisions change.Cleansing and remediation tracking — Execute cleansing routines in Excel, SQL, or the project's data quality tooling; track remediation progress by object and by data owner, and escalate records that stall.Load preparation and validation — Prepare load files, participate in mock load cycles, and reconcile pre- and post-load record counts and control totals. Investigate load errors, categorize root causes, and log defects for resolution.Readiness reporting — Build and maintain reporting that shows data readiness by object and workstream, giving the program leadership a reliable view of where the risk sits.Business stakeholder coordination — Partner with business data owners across finance, procurement, supply chain, and sales to chase down decisions and confirm cleansed values are correct.Documentation — Keep data dictionaries, cleansing rules, and validation procedures current so the work is repeatable for later waves and post-go-live governance.REQUIRED QUALIFICATIONSRising junior, rising senior, or recent graduate pursuing a degree in Information Systems, Business Analytics, Supply Chain, Accounting, Finance, Computer Science, or a related field.Strong Excel skills, including lookups, pivot tables, text functions, and comfort working with files of tens of thousands of rows.Demonstrated analytical rigor — you notice when a number looks wrong and you dig into why rather than passing it along.Clear written and verbal communication; much of this role is asking busy people precise questions and documenting their answers.High attention to detail and the discipline to follow a repeatable process, since data errors compound quietly and surface late.Ability to manage several parallel tasks and flag blockers early rather than absorbing them.PREFERRED QUALIFICATIONSPrior coursework or exposure to ERP systems (SAP, Oracle, Microsoft Dynamics), even at an academic level.Working knowledge of SQL, or experience with Python (pandas), Alteryx, or Power Query for data transformation.Familiarity with SAP master data objects or with SAP Migration Cockpit / LSMW concepts.Experience with Power BI, Tableau, or similar tools for building status reporting.Coursework in accounting, supply chain, or operations that provides context for what the data represents.WHAT YOU WILL GAINDirect experience on a full-scale ERP implementation — the kind of exposure most professionals wait years to get.Practical fluency in enterprise data governance, master data management, and cutover planning.Mentorship from functional consultants and program leadership, plus a defined mentor for the duration of the internship.A capstone presentation to program stakeholders at the end of the summer.Consideration for a full-time offer or return internship based on performance.Physical DemandsThis role is performed in an office environment where a computer, telephone and other office equipment are used as needed to perform the duties of the role.MiTek Perks:Generous time off including Paid Time Off, 13 annual holidays, and volunteer time offDay One Medical/Rx, Dental and Vision PlansFamily friendly benefits including Paid Caregiver Leave, Paid Parental Leave and Adoption ReimbursementPerformance/Incentive bonusesCareer advancement, training opportunities, Employee Resource Groups, and tuition reimbursementRetirement programs including Matching 401(k) Contributions and Profit SharingEmployer paid Short-Term Disability, Long-Term Disability and Life InsurancemyFlexPay partner – allows you to track, manage and access your pay anytimeMiTek is a platform innovator and enabler that exists to transform the building industry with better building solutions. In 1955, MiTek transformed residential construction with the invention of the Gang-Nail plate and a digital platform that provided an affordable and scalable way to manufacture wood trusses. Today, MiTek delivers software, services, engineered products, and automated solutions that enable the building industry to improve efficiencies by optimizing the balance between off-site and on-site. With nearly 5,600 team members worldwide, MiTek collaborates across the building industry to enable and accelerate transformational breakthroughs in design and construction to transform the way the industry designs, makes, and builds. As a Berkshire Hathaway (NYSE: BRK-A, NYSE: BRK-B) company since 2001, MiTek has a record of continuous growth and innovation.MiTek is an E-Verify and Drug and Tobacco-Free Workplace.We are an equal opportunity employer; and all qualified applicants will receive consideration for employment without regard to race, color, creed, religion, national origin, ethnicity, physical or mental disability, sex (including pregnancy, sexual orientation, gender identity or expression, or transgender status), age (40 and over), genetic information (including family medical history), veteran status, or any other protected characteristic.For accommodation to assist with completing this application, please contact Human Resources at [phone].www.mii.com