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 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 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 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 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 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 +1 . 
