Data Analyst - ERP & Master Data

Bendel

Cleveland (OH)

On-site

USD 90,000 - 100,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Free HSA health plan
401(k) with company match
Dental, vision, and optional coverages
Life, LTC, and AD&D insurance
Employee Assistance Program

Job summary

TransTech is seeking a Data Analyst – ERP & Master Data in Cleveland, OH to lead the data workstream for an ERP consolidation onto IFS Cloud. You will extract, profile, cleanse and map legacy data, drive sign-off with business owners, and own master data governance post go-live.

The role requires hands-on ERP data experience, strong SQL/Excel, and familiarity with Python/PySpark, Power Query and modern data platforms. Collaboration with Finance, Operations, and IT is essential.

Qualifications

  • Bachelor’s degree or equivalent experience in a related field
  • Five+ years in data analysis, data management or business systems in manufacturing/fabrication
  • Hands-on data workstream ownership on at least one full ERP implementation (extraction, cleansing, mapping, mock loads, reconciliation)

Responsibilities

  • Own data workstream for ERP implementation, including extraction, profiling and readiness gates
  • Profile and cleanse master and transactional data from legacy systems
  • Design source-to-target mappings and transformation specs for data objects
  • Build and maintain data cleansing and enrichment routines in SQL, Python, Fabric notebooks
  • Prepare mock loads, cutover rehearsals and production cutover with sign-off
  • Develop data governance pipelines and governance model post go-live
  • Automate data preparation and reconciliation with SQL, Python/PySpark and Power Query
  • Enable ERP data quality and governance across the enterprise

Skills

Advanced SQL
Excel
Python/PySpark
Power Query

Education

Bachelor’s degree in Information Systems, Computer Science, Data Analytics, accounting/finance, supply chain or related field

Tools

Git
Azure DevOps
Power BI
Microsoft Fabric
Azure Synapse
Databricks
SYSPRO
Syteline/CloudSuite Industrial
Infor Visual

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Data Analyst - ERP & Master Data

Full- Time Professional Cleveland, OH, US

Salary Range: $90,000.00 To $100,000.00 Annually

Position Title:

Data Analyst – ERP & Master Data

Reports To:

Director of Data & Business Analytics

Company Overview

TransTech provides custom-engineered and fabricated solutions for liquids and gas processing, storage, TransTech is a leading provider of specialized infrastructure and custom-engineered equipment for diverse industries. Our expansive capacity and technical expertise enable large-scale production of complex, high-quality equipment while meeting rigorous quality and safety standards.

TransTech’s companies provide comprehensive solutions for gas and liquid processing, storage, transfer, and utilization, adhering to ASME, API, and TEMA standards to ensure reliability and precision in every project.

From individual services to full project solutions, TransTech’s teams deliver expert engineering, fabrication, construction, operations and maintenance, supporting projects nationally and internationally. We help customers achieve impactful, sustainable results with a commitment to safety, community, and environmental responsibility.

Job Summary

This role reports to the Director of Data & Business Analytics as a key member of the TransTech Data & Analytics team, working directly with Finance, Operations, Supply Chain and IT leadership across all business units and with our ERP implementation partners.

TransTech is consolidating the separate ERP systems of its business units onto a single enterprise platform (IFS Cloud), and data readiness is the single largest determinant of whether that program succeeds. The Data Analyst will be the hands‑on data lead for the implementation: owning the extraction, profiling, cleansing, mapping, transformation, mock loading and reconciliation of legacy master and transactional data into IFS, and driving business owners to sign off on data they will live with for the next decade.

Following go‑live, the role becomes the permanent owner of enterprise master data governance (Item, Customer, Vendor and related domains) and of the data engineering pipelines that bring ERP data into TransTech’s Microsoft Fabric platform and Power BI reporting. The intended growth path is from ERP data lead into a Senior or Lead Data Engineer or Data Architect role within Data & Analytics, with leadership opportunities also open in ERP and Business Systems, Finance, or Operations.

The ideal candidate has been through at least one full ERP implementation as the person responsible for the data, understands manufacturing and fabrication data end to end (items, BOMs, routings, customers, vendors, inventory, open orders, GL), and combines rigorous attention to detail with the credibility to challenge business owners and the pragmatism to get to a decision. They are equally at home in a modern data engineering toolset: repeatable pipelines and notebooks, Git, an agile backlog, and AI assistants used to move faster without compromising accuracy.

Essential Duties and Responsibilities
ERP Data Migration & Readiness
  • Serve as TransTech’s data lead for the ERP implementation, owning the data workstream plan, deliverables and readiness gates with the implementation partner and program management.
  • Extract and profile master and transactional data from legacy systems (SYSPRO, Syteline/CloudSuite Industrial and others), quantifying volumes, completeness, duplication and quality issues by domain.
  • Build and maintain source-to-target mapping and transformation specifications for each data object (Item/Part, BOM, Routing, Customer, Vendor, Chart of Accounts, Inventory, Open AR/AP, Open Sales and Purchase Orders, Fixed Assets, Employees) against the IFS Cloud data model and load templates.
  • Design and execute cleansing, de‑duplication, standardization and enrichment routines in SQL, Python and Fabric notebooks; track 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; run 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 (OneStream, Salesforce, Procore, Smartsheet, Fabric).
Master Data Governance
  • Lead harmonization of Item, Customer and Vendor master data across business units (numbering and naming standards, required attributes, hierarchies, cross‑references) and facilitate the cross‑BU decisions needed to converge on one standard.
  • Establish and operate the post‑go‑live governance model: 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 act as the enterprise escalation point for master data questions.
  • Design, build and operate the pipelines that land source‑system data in Microsoft Fabric (mirroring, Data Factory pipelines, Dataflows, PySpark/SQL notebooks) across Bronze, Silver and Gold layers, including incremental loads, orchestration, monitoring and automated data quality checks.
  • Build the ERP extracts and Silver/Gold models that replace legacy business‑unit reporting after go‑live, ensuring continuity of executive and operational Power BI reporting through cutover, and validate that reported figures reconcile to the ERP.
  • Automate recurring data preparation, validation and reconciliation with SQL, Python/PySpark and Power Query, replacing manual and spreadsheet‑based processes with tested, scheduled code.
  • Apply software engineering practices to data work: Git‑based version control in Azure DevOps, pull requests and code review, dev/test/prod promotion, and documentation as code.
Ways of Working, Training & Documentation
  • Work within the team’s agile delivery model (user stories, sprint planning, backlog refinement, reviews and retrospectives in Azure DevOps), breaking migration and governance work into estimable, demonstrable increments.
  • Use AI tools (Microsoft Copilot, ChatGPT, Claude, AI‑assisted coding) as a routine part of profiling, code generation, documentation and analysis, with sound judgment about validating outputs before they are relied on.
  • Develop and maintain data standards, data dictionaries, mapping documents, runbooks and end‑user guides; train and coach business data owners, stewards and analysts; and mentor other members of the Data & Analytics team.
Education and/or Experience
  • 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: 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; 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, and experience 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.
Personal Attributes
  • Highest level of integrity and ethics.
  • Exceptional attention to detail; Strong use of validation to source systems is a must.
  • Comfortable owning outcomes in an ambiguous, fast‑moving program environment with firm deadlines.
  • Forges strong cross‑functional partnerships and drives business owners to timely decisions.
  • Explains complex data concepts, trade‑offs and results clearly to non‑technical managers and executives.
  • Engineering mindset and continuous improvement orientation: prefers repeatable, tested, version‑controlled solutions over one‑off fixes.
  • Curious, self‑directed learner who adopts new tools quickly, including generative AI, and shares what works with the team.
  • Works independently with minimal supervision, leads others through change, and interacts effectively at all levels of the organization with a service attitude.
Benefits Designed to Work for You
  • 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 our Employee Assistance Program
  • Discounts on gyms, shopping & entertainment
  • Health benefits kick in fast – first of the month after 30 days
Time Off

We offer a variety of paid time off options to support rest, wellness, and personal needs:

  • Paid Time Off
  • Paid Holidays

This organization provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst - ERP & Master Data
Data Analyst - ERP & Master Data

TransTech Group • Cleveland (MO)

On-site
USD 90,000 - 100,000
Free HSA health plan
401(k) with company match
Dental, vision, and insurance
+4
Data Analyst - ERP & Master Data
Data Analyst - ERP & Master Data

TransTech Group • Cleveland (OH)

On-site
USD 90,000 - 100,000
401(k) with match
Health benefits
Paid time off
Senior Manager, Enterprise Systems
Senior Manager, Enterprise Systems

TransTech Group • Cleveland (OH)

Hybrid
USD 140,000 - 170,000
Free health plan
401(k) with company match
Dental & Vision coverage
+2
Human Resources Manager
Human Resources Manager

TransTech Group • Waco (TX)

Hybrid
USD 70,000 - 100,000
Health benefits package
401(k) with company match
Paid time off
+1
Production Manager
Production Manager

Transtech Fabrication • McGregor (TX)

On-site
USD 90,000 - 130,000
Free HSA health plan or traditional P
401(k) with generous company match
Dental, vision, and optional coverage
+4
Human Resources Manager
Human Resources Manager

TransTech Fabrication, Inc. • Charlotte (NC)

Hybrid
USD 85,000 - 110,000
Free HSA health plan
401(k) with company match
Dental & vision
+3
Production Manager
Production Manager

TransTech Group • McGregor (TX)

On-site
USD 90,000 - 120,000
Free HSA health plan
401(k) with company match
Dental, vision, and optional coverage
+3
Data Engineer: Build Scalable Pipelines & Trusted Data
Data Engineer: Build Scalable Pipelines & Trusted Data

Sakata Ornamentals • Burlington (WA)

On-site
USD 110,000 - 125,000
Health insurance
401(k) Program + Company Match
Holiday Bonus
+2
Human Resources Manager
Human Resources Manager

Transtech Fabrication • Charlotte (NC)

Hybrid
USD 75,000 - 110,000
Technical and Integrations Lead, ERP/WMS
Technical and Integrations Lead, ERP/WMS

ICP Group • Tampa (FL)

On-site
USD 80,000 - 100,000
Competitive benefits