Data Analyst - Finance

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

Benefits offered by this job

Health coverage

401(k) plan

Paid time off

Job summary

Particle Measuring Systems in Niwot, Colorado, is seeking a Data Analyst (Finance) to support the global master data management initiative within our ERP transformation program. You will prepare, cleanse, and validate master data for migration to Infor CloudSuite, and partner with Finance, IT, and ERP vendors to ensure data readiness and governance.

The ideal candidate has 3–5 years in ERP data migration or master data management, advanced Excel skills, and experience with ERP systems such as

Qualifications

• 3 to 5 years of experience in 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.

Responsibilities

• Master Data Preparation: profile existing Product master data and identify quality issues; standardize master data according to approved rules; prepare data for migration into Infor CloudSuite.
• Data Cleansing & Enrichment: execute large-scale cleansing; validate chart of accounts, cost centers, suppliers, payment terms, currencies; resolve data quality issues.
• ERP Data Migration: prepare migration files; validate migrated data; reconcile source systems and Infor; support ERP cutover activities.
• Data Validation & Testing: support SIT/UAT; verify migrated data; troubleshoot data discrepancies.
• Cross-Functional Collaboration & Data Governance: work with Finance, Accounting, FP&A, Business Systems to define data standards and drive data quality improvements.

Skills

Excel proficiency

Data analysis

Attention to detail

Communication & collaboration

Tools

Infor CloudSuite

IFS

SAP

Oracle

Microsoft Dynamics

NetSuite

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.

Data Analyst (Finance)

Business Transformation Program

Niwot/Hybrid

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
• 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: $66,000 - $99,000, 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.