ERP Data Analyst: Master Data & Migration Lead

TransTech Group; Cleveland (MO); On-site; USD 90,000 - 100,000; Full time

Benefits offered by this job

Free HSA health plan

401(k) with company match

Dental, vision, and insurance

Life, LTD, and AD&D

Employee Assistance Program

Gym discounts

Paid time off

Job summary

TransTech is seeking a Data Analyst for ERP and Master Data in Cleveland, OH. You will lead data workstreams during the ERP implementation, owning extraction, cleansing, mapping and mock loading into IFS Cloud while coordinating with Finance, Operations and IT leadership.

After go-live you will own enterprise master data governance and data pipelines into Fabric with Power BI reporting. A background in manufacturing data and data engineering tools is essential for success.

Qualifications

• Bachelor’s degree in Information Systems or related field.
• 5+ years in data analysis, data management, or business systems in manufacturing.
• Experience owning data workstream in ERP implementations is required.
• Strong SQL, Excel and data governance knowledge.
• Hands-on data pipelines in Fabric, PySpark/SQL, and Power BI experience.

Responsibilities

• Serve as data lead for ERP implementation data workstream and readiness gates.
• Extract, profile, cleanse, map and transform legacy data to IFS Cloud.
• Design source-to-target mappings and load templates for data objects.
• Build data pipelines and automate data quality checks.
• Govern master data post go-live and ensure reporting continuity.

Skills

SQL

Python

Power BI

Git

Azure DevOps

Fabric notebooks

Education

Bachelor’s degree in Information Systems

Tools

IFS Cloud

SYSPRO

Syteline/CloudSuite

Azure Synapse

Databricks

Power Query

Job description

TransTech is seeking a Data Analyst for ERP and Master Data in Cleveland, OH. You will lead data workstreams during the ERP implementation, owning extraction, cleansing, mapping and mock loading into IFS Cloud while coordinating with Finance, Operations and IT leadership.

After go-live you will own enterprise master data governance and data pipelines into Fabric with Power BI reporting. A background in manufacturing data and data engineering tools is essential for success.