Data Integration Analyst

The Data Integration Analyst is responsible for the accurate extraction, cleansing, matching, transformation, and loading of master data (primarily items, customers, and suppliers) during ERP system rollouts. This role plays a pivotal part in post-acquisition integration by ensuring master data consistency, deduplication, and alignment with the corporate ERP template to support seamless Day 1 operations in finance, procurement, sales, inventory, and supply chain processes. Additionally, this position will contribute to our reporting systems by assisting in migrating data from our main ERP to cloud-based analytical systems (such as PowerBI), designing semantic models, and troubleshooting SQL statements (this skill is not necessary to start as long as the candidate is willing to learn).

The ideal candidate has strong analytical skills, attention to detail, and experience in data mapping/matching for ERP migrations in M&A scenarios.

DAY TO DAY RESPONSIBLITIES
Lead or support master data conversion for ERP implementations, including items, customers, and supplier/vendor data across acquired companies.
Profile and analyze legacy systems to identify data quality issues, duplicates, inconsistencies, and gaps.
Develop and execute data matching, mapping, and harmonization rules aligned with corporate ERP standards.
Perform data cleansing, duplication, enrichment, and standardization using SQL, scripts, ETL tools, or MDM platforms.
Create and maintain mapping documents, transformation logic, cross‑reference tables, and conversion specifications.
Collaborate with Finance, Procurement, Sales, Supply Chain, IT, and acquired entities to validate rules, resolve conflicts, and confirm mappings.
Work closely with the ERP team to validate and ingest converted data into the target system
Design and execute mock conversions, validation cycles, reconciliation, and error resolution to ensure high data accuracy.
Support ETL processes by writing/reviewing SQL and building pipelines in Matillion and Snowflake for data extraction, transformation, and loading.
Participate in cutover planning, dry runs, go‑live execution, and post‑go‑live stabilization and troubleshooting.
Document processes, issues, decisions, and lessons learned to support repeatable migration of playbooks for future acquisitions.
Contribute to master data governance by improving data standards and preventing recurring quality issues.
Support SIT/UAT testing cycles and ensure successful migration readiness.

Compensation:

$90,000 to $100,000 per year annual salary.

Exact compensation may vary based on several factors, including skills, experience, and education.

Benefit packages for this role includes healthcare insurance offerings and paid leave as provided by applicable law.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Bachelor’s degree in Information Systems, Business, Computer Science, Finance, Supply Chain, or related field (or equivalent experience).
3–7+ years of hands‑on experience in ERP data conversion, data migration, ETL development, or master data management.
Strong SQL skills (Oracle or Microsoft).
Proven experience mapping and matching item master, customer master, and supplier/vendor master data.
Strong understanding of ERP master data structures and dependencies (SAP, Oracle Cloud ERP, D365, Infor, NetSuite, etc.).
Familiarity with ERP data domains: items, inventory, customers, vendors, chart of accounts, transactions.
Proficiency with Excel/CSV data handling (VLOOKUPs, pivot tables, Power Query, VBA).
Experience with data quality, cleansing, duplication, and matching techniques (e.g., fuzzy matching, duplicate detection).
Experience with ETL tools (Informatica, Talend, SSIS, or ERP‑specific loaders).
Excellent analytical, problem‑solving, and reconciliation skills with strong attention to detail.
Ability to work independently in a remote environment.
Strong communication and collaboration skills across cross‑functional teams.
Ability to manage multiple priorities in a fast‑paced environment.
Detail‑oriented with a commitment to data accuracy and integrity.
Proactive problem‑solver who can identify risks early and propose solutions.

Experience with ERP implementations (NetSuite, D365, SAP, Epicor, P21).
Experience with Snowflake.
Experience with Matillion.
Background in distribution or manufacturing.
Knowledge of data governance and master‑data management.
Experience with MDM tools (Informatica MDM, SAP MDG, Stibo, etc.).
Prior involvement in full‑cycle ERP implementations or post‑acquisition integrations.
Knowledge of supply chain, procurement, or financial business processes.
Familiarity with data governance frameworks and data privacy regulations (GDPR, CCPA).
Scripting/programming skills (Python, R, etc.) for advanced transformations.
Certifications in ERP or data management (SAP, Oracle, etc.).

Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.