> Markdown version of [/jobs/ext/3034666-data-analyst-erp-master-data](https://www.wearedevelopers.com/jobs/ext/3034666-data-analyst-erp-master-data). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst - ERP & Master Data - **Company:** TransTech LLC - **Location:** Cleveland, OH, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Artificial Intelligence, Data Analysis, JIRA, Microsoft Azure, Business Systems, Spreadsheets, Cloud Computing, Cloud Database, Code Generation, Code Review, Information Systems, Data Architecture, Data Cleansing, Data Dictionary, Information Engineering, Data Governance, Data Structures, Github, IT Management, Python (Programming Language), Project Management Software, Routing, Scrum Methodology, Power BI, OneStream, Salesforce.Com, Software Engineering, SQL Databases, Transaction Data, Smartsheet, Microsoft Power Automate, Sql Optimization, Git, Powerquery, Microsoft Fabric, Pyspark, Information Technology, Syteline, Data Analytics, Data Management, Infor, Azure Synapse Analytics, GPT, Software Version Control, Data Pipelines, Legacy Systems, Databricks - **Published:** September 23, 2026 - **Apply:** https://www.thejobnetwork.com/job/bb42fdd5-82cb-410a-acc4-14c3979430d1/data-analyst-erp-master-data ## About the Role * 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. ## Description 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., 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. Data Engineering & Analytics: * 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. ## Related Videos - [ Evaluating AI models for code comprehension](https://www.wearedevelopers.com/videos/1462-evaluating-ai-models-for-code-comprehension) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Improving quality with Agentic AI with Rovo Dev and Xray](https://www.wearedevelopers.com/videos/2005-improving-quality-with-agentic-ai-with-rovo-dev-and-xray) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Speak, Code, Deploy: Transforming Developer Experience with Voice Commands](https://www.wearedevelopers.com/videos/1159-speak-code-deploy-transforming-developer-experience-with-voice-commands) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [A Guide to Green Tech and Green IT Careers](https://www.wearedevelopers.com/magazine/374-a-guide-to-green-tech-and-green-it-careers) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)