Data Analyst - Products

RXinsider LTD.; Colorado; Hybrid; USD 66,000 - 99,000; Full time

Benefits offered by this job

Health coverage

401(k) retirement plan

Vacation, holiday, and leave policies

Tuition reimbursement

Employee recognition programs

Employee assistance programs

Onsite clinic (CO employees)

Job summary

Particle Measuring Systems in Niwot, Colorado (Hybrid) is seeking a Data Analyst (Products) to join the Master Data Management initiative. You will prepare, cleanse, and validate product data for the Infor CloudSuite ERP migration and work with cross-functional teams to ensure data quality and readiness.

The role emphasizes collaboration with Operations, IT, and ERP partners, with a focus on establishing data standards, metadata dictionaries, and governance practices to support a global

Qualifications

• 3 to 5 years of experience in ERP Data Migration, Master Data Management, or Data Analysis.
• Advanced Excel skills including Power Query, XLOOKUP/VLOOKUP, Pivot Tables and Data Validation.
• Experience with ERP systems such as Infor, IFS, SAP, Oracle, Microsoft Dynamics, or NetSuite.
• Strong analytical thinking, attention to detail and collaborative communication.

Responsibilities

• Master Data Preparation: profile product master data, identify quality issues and standardize data.
• Data Cleansing & Enrichment: execute large-scale cleansing, resolve quality issues, complete attributes.
• ERP Data Migration: prepare migration files, validate data, support mock conversions and cutover.
• Data Validation & Testing: support SIT/UAT, verify migrated data and reconcile discrepancies.
• Cross-Functional Collaboration & Data Governance: work with Ops, IT, and ERP teams to ensure data standards and governance.

Skills

Data analysis

ERP data migration

Advanced Excel

Problem solving

Attention to detail

Communication

Tools

Infor

SAP

Oracle

Microsoft Dynamics

Power BI

SQL

ETL tools

Job description

Do you want to be part of a business that genuinely values entrepreneurialism, innovation and individual accountability? We focus on our customers and are proud of the difference our technology makes. We partner with some of the biggest manufacturing companies in the world and our technical innovations are used to enhance well-known brands across multiple industries.

Title Data Analyst (Products)

Department Business Transformation Program

Location Niwot/Hybrid

Reports To Data Architect

About Us

Established in 1972, Particle Measuring Systems is a global leader for micro-contamination monitoring equipment improving the performance of clean manufactures in the semiconductor and pharmaceutical industries. We’re a growing technology company in Niwot, Colorado, the heart of the Rocky Mountains. We offer an exceptional and rewarding work environment in a great place to live. Our employees enjoy challenging projects in the development and manufacture of light scattering particle counters and diverse technologies and applications.

The Role

As a member of the Program Nexus Master Data Management team, you will play a key role in one of the company's most strategic initiatives—a global business transformation program that will modernize our business processes, implement Infor CloudSuite Industrial Enterprise (LN) ERP, establish enterprise master data management practices, and improve the quality of data that drives business decisions.

Working closely with Operations Global Process Owners, Business SMEs, IT, and the ERP implementation partner, this individual will ensure master data is accurate, standardized, complete, and ready for successful migration into the new ERP platform. Your work will directly contribute to the successful implementation of our next-generation business systems.

Job Responsibilities

Master Data Preparation

• Profile existing Product master data and identify quality issues.
• Analyze duplicate, incomplete, and inconsistent records.
• Standardize master data according to approved business rules.
• Prepare data for migration into Infor CloudSuite.
• Support establishment of Product master data standards and contribute to metadata and data dictionary development.

Data Cleansing & Enrichment

• Execute large-scale data cleansing activities.
• Resolve data quality issues in partnership with business stakeholders.
• Eliminate duplicate records, complete missing attributes, and improve overall data accuracy and consistency.
• Validate Product master data and related attributes to ensure migration readiness.

ERP Data Migration

• Prepare migration files and support multiple mock conversions.
• Validate migrated data and perform reconciliation between source systems and Infor CloudSuite.
• Investigate migration exceptions and coordinate issue resolution with implementation partners.
• Support ERP cutover activities and deployment readiness.

Data Validation & Testing

• Support System Integration Testing (SIT) and User Acceptance Testing (UAT).
• Validate migrated data, verify record accuracy, and reconcile discrepancies.
• Assist with defect identification, troubleshooting, and resolution.

Cross-Functional Collaboration & Data Governance

• Partner with Engineering, Manufacturing, Supply Chain, Product Management, Operations, IT, and ERP implementation teams to support master data readiness and business process transformation.
• Collaborate with Global Process Owners, SMEs, and Super Users to define data standards, resolve data issues, and ensure alignment with business requirements.
• Drive continuous improvement of data quality, governance practices, and migration processes.

Product Master Data Focus Areas

• Maintain and improve the quality, consistency, and governance of critical product data domains, including Item Master, Bills of Material (BOMs), Routings, Product Configurations, Product Hierarchies, Engineering Attributes, Units of Measure, Product Lifecycle, Revision Control, and Manufacturing Data.
• Continuously evaluate processes for improvements in efficiency, quality, and safety
• This job description is not intended to be all-inclusive. Responsibilities may evolve over time, and other related duties may be assigned to meet the ongoing needs of the company.

Required Qualifications

• 3 to 5 years of experience in one or more of the following:
  • ERP Data Migration
  • Master Data Management
  • Data Analysis
  • Financial Systems
  • ERP Implementation
• Advanced Microsoft Excel skills, including Power Query, XLOOKUP/VLOOKUP, Pivot Tables, Data Validation, and large dataset analysis.
• Experience working with enterprise ERP systems such as Infor, IFS, SAP, Oracle, Microsoft Dynamics, or NetSuite.
• Strong analytical thinking and problem-solving abilities.
• Exceptional attention to detail.
• Excellent communication and collaboration skills.
• Ability to manage multiple priorities
• Comfortable challenging inconsistent business data

Preferred Qualifications

• Experience supporting ERP implementations in manufacturing, distribution, or supply chain environments.
• Experience with ETL tools, data migration utilities, SQL, Power BI, Azure Data Factory, or Infor Data Mesh.

Work Environment & Physical Requirements

• This role primarily operates in an office/lab/manufacturing environment. Must be able to sit, stand, and use a computer for extended periods of time
• Occasional lifting of up to 20 lbs. may be required
• Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of this role

Compensation & Benefits

• Competitive base salary range: $66000 - 99000, depending on experience
  • Our compensation philosophy: we offer competitive pay based on market data, including local, national, and industry benchmarks. For new hires, offers are generally within the established min- to mid-point of the range for the role, with flexibility to recognize experience, skills, and education. Our approach ensures fair pay internally while remaining competitive externally and allows room for growth.
• Comprehensive benefits package:
  • Health coverage: medical, dental, vision, fsa, onsite clinic (CO employees), life insurance
  • 401(k) retirement plan with company match
  • Vacation, holiday, and leave policies
  • Tuition reimbursement, Employee recognition programs, Employee assistance programs

Particle Measuring Systems is proud to be an Equal Opportunity Employer and are committed to building an inclusive and supportive workplace where everyone can thrive.