SAP ERP Implementation Intern — Data Migration

MiTek; Chesterfield (MO); Presencial; USD 25.000 - 39.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Paid Time Off and holidays

Medical/Dental/Vision plans

Parental Leave and Adoption Reimburse.

Bonuses and incentives

Tuition reimbursement

401(k) Matching and Profit Sharing

Disability/Life Insurance

Flexible pay access

Descripción de la vacante

MiTek is hiring a Data Migration Intern to join a live ERP implementation project. You will profile, map, cleanse, and validate legacy data for SAP migration, working directly with data owners and key partners to ensure clean data at cutover.

You will own defined slices of the data effort, gain experience in ERP consulting, data analytics, or IT program management, and have potential for a full-time offer based on performance.

Formación

• Pursuing or recently completed degree in IS/Analytics/SC/Accounting/Finance/CS.
• Strong Excel skills and ability to handle large datasets.
• Demonstrated analytical rigor and attention to detail.
• Clear written and verbal communication; asks precise questions with documentation.
• Ability to manage several tasks and raise blockers early.

Responsabilidades

• Profile legacy data and document findings for resolution.
• Map source to SAP target objects and maintain mapping docs.
• Execute cleansing routines and track remediation progress by object/data owner.
• Prepare load files, participate in mock loads, and reconcile counts.
• Build data readiness reports for program leadership.
• Coordinate with finance/procurement/supply chain/sales to confirm cleansed values.
• Maintain data dictionaries and validation procedures for repeatable processes.

Conocimientos

Data analysis

Attention to detail

Written & verbal communication

Multitasking

Team collaboration

Educación

Bachelor's degree in Information Systems / Business Analytics / related field

Herramientas

SQL

Python (pandas)

Power BI

Tableau

Alteryx

Power Query

SAP Migration Cockpit / LSMW

Descripción del empleo

POSITION OVERVIEW

Our 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 RESPONSIBILITIES

• Data 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 elevate 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 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 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 QUALIFICATIONS

• Prior 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 GAIN

• Direct 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 Demands

This 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 off
• Day One Medical/Rx, Dental and Vision Plans
• Family friendly benefits including Paid Caregiver Leave, Paid Parental Leave and Adoption Reimbursement
• Performance/Incentive bonuses
• Career advancement, training opportunities, Employee Resource Groups, and tuition reimbursement
• Retirement programs including Matching 401(k) Contributions and Profit Sharing
• Employer paid Short-Term Disability, Long-Term Disability and Life Insurance
• myFlexPay partner – allows you to track, manage and access your pay anytime

MiTek 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