ERP Master Data Analyst

RH Aero Systems; Mason (OH); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

Medical, dental, and vision plans

401k with employer match

HSA and FSA plans

Job summary

RH Aero Systems seeks a hands-on Master Data Specialist to drive enterprise master data management, financial analytics, and data governance across ERP initiatives. You will standardize vendor, customer, product, and other master data, validate records, and support data cleanup and migration during integrations and system upgrades.

You will also develop BI insights with Power BI, supporting KPI development and financial reporting while partnering with procurement, finance, IT, and compliance to

Qualifications

• Experience with master data management, data analysis, finance, procurement, and reporting functions.
• Experience with Power BI, including dashboard development, data modeling, Power Query, and DAX in a Microsoft platform.
• Understanding of financial reporting concepts such as GL accounts, cost centers, budgets, forecasts, actuals, accruals, payables, and variances.
• Experience with ERP systems such as SAP, Oracle, Microsoft Dynamics, Workday, NetSuite, Coupa, Ariba, or other procurement and supplier management platforms.
• Experience supporting vendor master data, supplier master data, procurement master data, accounts payable data, or supplier lifecycle management.
• Familiarity with supplier onboarding, vendor validation, tax documentation, payment controls, banking controls, procurement policies, and audit requirements.
• Knowledge of procurement and finance processes, including procure-to-pay, purchase orders, invoices, vendor payments, supplier performance, and spend reporting.
• Experience with MDM tools, data catalog tools, workflow tools, supplier management tools, or data quality platforms.
• Knowledge of SQL for querying and validating vendor, supplier, finance, and procurement data.
• Experience supporting finance transformation, procurement transformation, ERP implementation, supplier data migration, or process improvement projects.
• Familiarity with internal controls, audit requirements, compliance frameworks, segregation of duties, and vendor payment risk controls.
• Experience with Python, Alteryx, Power Automate, or other automation tools is a plus.

Responsibilities

• Create, update, validate, and deactivate customer, vendor, and supplier master data records according to policies and workflows.
• Evaluate the current integration landscape and help transition to controlled, scalable patterns.
• Investigate and resolve vendor and supplier master data issues affecting procurement and finance.
• Monitor vendor data quality metrics and propose corrective actions.
• Support data cleanup, rationalization, and migration during ERP implementations and system upgrades.
• Perform data quality checks to normalize records and correct inconsistencies.
• Partner with procurement, accounts payable, finance, supply chain, compliance, and IT to ensure data accuracy and controls.

Skills

Attention to detail

Analytical mindset

Stakeholder communication

Systems thinking

Ownership mindset

Data governance

Education

Bachelor’s degree in Business, Finance, Accounting, IS, Data Analytics, or related field

Tools

Power BI

SQL

ERP systems (SAP, Oracle, MS Dynamics, Workday, NetSuite, Coupa, Ariba)

MDM tools

Data quality platforms

Python

Alteryx

Power Automate

Data catalog tools

Job description

Job Summary

RH Aero is seeking a hands‑on Master Data Specialist to support enterprise master data management, financial analysis, global data compliance, and analytics transformation efforts tied to a major business integration and future ERP implementation.

This role will be central to improving the quality, consistency, and governance of master data across two legacy operating companies, including vendor, supplier, customer, product, financial, organizational, and reference data. The Master Data Specialist will help standardize data definitions, validate records, resolve data quality issues, support data cleanup and migration activities, and ensure master data is accurate, complete, and usable across finance, procurement, supply chain, operations, and reporting processes.

The role will also create and support BI analysis, financial reporting, KPI development, and business recommendations by turning trusted master data into actionable insights. This is not simply a data entry or report development role. It is a business‑facing master data and analytics role for someone who can work across systems, functions, and data domains to strengthen data integrity, improve decision‑making, and support future ERP and analytics capabilities.

Key Responsibilities

• Create, update, validate, and deactivate customer, vendor, and supplier master data records according to established policies, controls, and approval workflows.
• Evaluate the current integration landscape, including manual feeds, direct SQL access, and middleware processes, and help transition the organization to more controlled and scalable patterns.
• Investigate and resolve vendor and supplier master data issues that affect procurement, purchase orders, invoice processing, payments, reporting, spend analysis, supplier performance, and financial controls.
• Monitor vendor and supplier data quality metrics and recommend corrective actions to improve accuracy, compliance, and process efficiency.
• Support vendor and supplier data cleanup, rationalization, standardization, and migration activities during ERP implementations, system upgrades, mergers, acquisitions, or process improvement initiatives.
• Perform data quality checks to normalize records, missing fields, inconsistent naming conventions, incorrect payment information, inactive suppliers, and invalid mappings.
• Partner with procurement, accounts payable, finance, supply chain, compliance, and IT teams to ensure vendor and supplier data is accurate, complete, controlled, and aligned to business requirements.

Qualifications

• Experience with master data management, data analysis, finance, procurement, business operations, and reporting functions.
• Experience with Power BI, including dashboard development, data modeling, Power Query, and DAX in a Microsoft platform.
• Understanding of financial reporting concepts such as GL accounts, cost centers, profit centers, budgets, forecasts, actuals, accruals, payables, and variances.
• Experience with ERP systems such as SAP, Oracle, Microsoft Dynamics, Workday, NetSuite, Coupa, Ariba, or other procurement and supplier management platforms.
• Experience supporting vendor master data, supplier master data, procurement master data, accounts payable data, or supplier lifecycle management.
• Familiarity with supplier onboarding, vendor validation, tax documentation, payment controls, banking controls, procurement policies, and audit requirements.
• Knowledge of procurement and finance processes, including procure-to-pay, purchase orders, invoices, vendor payments, supplier performance, and spend reporting.
• Experience with MDM tools, data catalog tools, workflow tools, supplier management tools, or data quality platforms.
• Knowledge of SQL for querying and validating vendor, supplier, finance, and procurement data.
• Experience supporting finance transformation, procurement transformation, ERP implementation, supplier data migration, or process improvement projects.
• Familiarity with internal controls, audit requirements, compliance frameworks, segregation of duties, and vendor payment risk controls.
• Experience with Python, Alteryx, Power Automate, or other automation tools is a plus.

Education

• Bachelor’s degree in Business, Finance, Accounting, Information Systems, Data Analytics, Supply Chain, Procurement, or a related field. Equivalent practical experience in enterprise data engineering will also be considered.

Key Competencies

• Strong attention to detail and commitment to master data integrity.
• Ability to structure ambiguous data issues into practical, process‑driven solutions.
• Business‑facing communication and stakeholder management across finance, procurement, supply chain, operations, IT, and compliance.
• Analytical mindset with the ability to connect master data quality to financial reporting, procurement performance, supplier management, and operational decision‑making.
• Systems thinking across data, process, controls, reporting, and ERP platforms.
• Ownership mindset with strong follow‑through on data cleanup, validation, issue resolution, and stakeholder requests.

Other Information

We offer a comprehensive benefits package designed to support our team’s health, financial security, and overall well‑being. The company offers competitive medical, dental, and vision plans, HSA and FSA plans, mental health resources, and employee assistance programs. We offer paid parental leave, company‑paid long‑term disability, competitive 401k employer match, floating holiday, tuition reimbursement program, and other benefits.

We are committed to providing equal opportunities in employment. We value diversity and do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. The company participates in E‑Verify as required by law.