Data Analyst - Finance

Particle Measuring Systems; Boulder (CO); Hybrid; USD 65,000 - 95,000; Full time

Job summary

Particle Measuring Systems in Colorado is seeking a Data Analyst (Finance) to join the Program Nexus Master Data Management team. You will help modernize business processes, implement Infor CloudSuite, and establish enterprise master data management practices to ensure accurate, standardized data for ERP migration.

You will collaborate with Finance, IT, and ERP partners to drive data governance, quality, and migration readiness across critical data domains and processes.

Qualifications

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

Responsibilities

• Master Data Preparation: profile product master data and identify quality issues.
• Data Cleansing & Enrichment: execute large-scale cleansing and validate accounts data.
• ERP Data Migration: prepare migration files, support mock conversions, reconcile migrated data.
• Data Validation & Testing: support SIT/UAT, verify migrated data and resolve discrepancies.
• Cross-Functional Collaboration & Data Governance: collaborate with Finance and ERP teams to ensure data readiness.
• Product Master Data Focus Areas: maintain product data quality across key domains.

Skills

ERP Data Migration

Master Data Management

Data Analysis

Financial Systems

ERP Implementation

Tools

Microsoft Excel

Power Query

XLOOKUP/VLOOKUP

Pivot Tables

Data Validation

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 (Finance)

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), establish enterprise master data management practices, and improve the quality of data that drives business decisions. Working closely with Finance 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 Finance master data standards and contribute to metadata and data dictionary development.
• Data Cleansing & Enrichment
  • Execute large‑scale data cleansing activities.
  • Validate chart of accounts, cost centers, suppliers, payment terms, currencies and other Finance master data to ensure migration readiness.
  • Resolve data quality issues in partnership with business stakeholders.
  • Eliminate duplicate records, complete missing attributes, and improve overall data accuracy and consistency.
• ERP Data Migration
  • Prepare migration files and support multiple mock conversions.
  • Validate migrated data and perform reconciliation between source systems and Infor.
  • 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 Finance, Accounting, FP&A, Business Systems, 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 Chart of Accounts, Cost Centers, General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Banking, Tax, Payment Terms, Financial Dimensions, Currency, and Intercompany.
  • Continuously evaluate processes for improvements in efficiency, quality, and safety.

Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mandatory Mand.

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.
• E