ERP Implementation Data Jobs

1 job found

Today

Data Analyst - ERP & Master Data

TransTech Group Cleveland, OH

Cleveland, OH

Today

Full time Business Intelligence Data Analysis Data Analytics

Apply Now

Job Description

TransTech Group is hiring a Data Analyst focused on ERP and master data to lead the data workstream for an IFS Cloud migration and to establish post go-live governance and data pipelines for enterprise reporting.

Key Responsibilities

Act as TransTech’s data lead for the ERP implementation, owning the data workstream plan, deliverables, and readiness gates in coordination with the implementation partner and program management.
Extract and profile master and transactional data from legacy systems including SYSPRO, Syteline/CloudSuite Industrial, and other sources, assessing data volumes, completeness, duplication, and quality issues by domain.
Create and maintain source-to-target mapping and transformation specifications for ERP data objects aligned to the IFS Cloud data model and load templates. Objects include Item/Part, BOM, Routing, Customer, Vendor, Chart of Accounts, Inventory, Open AR/AP, Open Sales and Purchase Orders, Fixed Assets, and Employees.
Design and execute cleansing, de-duplication, standardization, and enrichment routines using SQL, Python, and Fabric notebooks, tracking defects to closure with business data owners.
Prepare and execute mock loads, cutover rehearsals, and the production cutover. Reconcile counts, quantities, and financial values to source, conduct business validation and sign-off, and maintain the data issue log, decision log, and cutover checklist.
Support data-related integration requirements between IFS Cloud and surrounding systems including OneStream, Salesforce, Procore, Smartsheet, and Microsoft Fabric.
Lead master data harmonization for Items, Customers, and Vendors across business units, covering numbering and naming standards, required attributes, hierarchies, and cross-references to converge on a shared standard.
Establish and operate a post-go-live governance model, including data ownership and stewardship roles, create/change/retire workflows, approval controls, and standards documentation.
Define, measure, and publish data quality KPIs by domain and business unit, drive remediation, and serve as the enterprise escalation point for master data questions.
Design and operate pipelines that land source-system data in Microsoft Fabric across Bronze, Silver, and Gold layers, including incremental loads, orchestration, monitoring, and automated data quality checks.
Build ERP extracts and Silver/Gold models to replace legacy business-unit reporting after go-live, ensuring continuity of executive and operational Power BI reporting and validating that figures reconcile to the ERP.
Automate recurring data preparation, validation, and reconciliation using SQL, Python/PySpark, and Power Query, replacing manual and spreadsheet-based processes with tested, scheduled code.
Apply software engineering practices to data work, including Git-based version control in Azure DevOps, pull requests and code reviews, dev/test/prod promotion, and documentation as code.
Work within an agile delivery model using user stories, sprint planning, backlog refinement, reviews, and retrospectives in Azure DevOps, delivering migration and governance work in demonstrable increments.
Use AI tools such as Microsoft Copilot, ChatGPT, Claude, and AI-assisted coding as part of profiling, code generation, documentation, and analysis, with judgment to validate outputs before reliance.
Develop and maintain data standards, data dictionaries, mapping documents, runbooks, and end-user guides, and provide training, coaching, and mentorship to business data owners, stewards, analysts, and team members.

Required Qualifications

Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Accounting/Finance, Supply Chain, or a related field (or equivalent experience).
Five or more years of progressive data analysis, data management, or business systems experience in a manufacturing, fabrication, engineered-equipment, or industrial services environment.
Hands-on ownership of the data workstream on at least one full-lifecycle ERP implementation or migration, including extraction, cleansing, mapping, mock loads, reconciliation, and cutover (required).
Strong working knowledge of ERP data structures across manufacturing, supply chain, and finance, including item/part master, BOMs and routings, customer ship-to/bill-to structures, vendors, inventory and lot/serial data, open orders, and GL/sub-ledger balances.
Advanced SQL and Excel required; Python/PySpark and Power Query strongly preferred.
Hands-on experience building data pipelines and lakehouse or warehouse models on Microsoft Fabric, Azure Synapse, Databricks, or a comparable platform, with medallion architecture and Power BI familiarity preferred.
IFS Cloud experience strongly preferred; SYSPRO, Infor Syteline/CloudSuite Industrial, or Infor Visual experience also relevant.
Master data management or data governance experience, including consolidating multiple entities, sites, or acquired businesses onto a common platform, preferred.
Working knowledge of Git and Azure DevOps (or GitHub/Jira), experience on an agile/scrum team, and demonstrated use of AI assistants in day-to-day analytical and engineering work, preferred.

Technology Stack

IFS Cloud, SYSPRO, Syteline/CloudSuite Industrial
SQL, Python, Microsoft Fabric (Fabric notebooks), Power BI
Microsoft Copilot, ChatGPT, Claude
OneStream, Salesforce, Procore, Smartsheet
Data Factory pipelines, Dataflows, PySpark, Power Query
Git, Azure DevOps, Azure Synapse, Databricks, GitHub, Jira
Medallion architecture, Bronze, Silver, Gold

Benefits

Free HSA health plan or traditional PPO
401(k) with generous company match (Safe Harbor)
Dental, vision, and optional coverage like accident & critical illness insurance
HSA and FSA accounts to save on healthcare costs
Company-paid Life, Long Term Disability, and AD&D insurance
Confidential support for mental health, family matters, legal concerns, and more through the Employee Assistance Program
Discounts on gyms, shopping & entertainment
Health benefits kick in fast, first of the month after 30 days

Time Off

Paid Time Off
Paid Holidays
Bereavement Leave

View full job page →

Get ERP Implementation Data Jobs alerts

New ERP Implementation Data Jobs, daily.