Job Title: QA/RC Data Administrator

Job Description

The QA/RC Data Administrator will ensure the integrity, accuracy, and standardization of the Master Consignee List (MCL) used in regulatory reporting and market actions. This role is crucial for maintaining data consistency across multiple ERP systems, including D365, and supports traceability and efficient responses to regulatory requirements such as FDA and Health Canada reporting.

Responsibilities

• Maintain and update the Master Consignee List (MCL), ensuring full traceability and version control.
• Reconcile discrepancies between Installed Base, Sales Orders, and Shipment data across multiple datasets.
• Investigate and resolve data integrity issues, including duplicate records, misassigned quantities, and mismatched values.
• Collaborate with IT, Sales, and Operations SMEs to standardize data extraction and formatting processes.
• Integrate serial numbers, invoice data, and contact information into the MCL for complete traceability.
• Support the automation of data reconciliation and reporting processes.
• Manage and consolidate data from multiple databases into a unified global master.
• Assist in reducing address complexity for regulatory submissions by standardizing customer names, addresses, and contact details.
• Provide monthly reports to the FDA and other regulatory bodies.
• Serve as a liaison between the QA/RC team and cross-functional departments to ensure data accuracy and compliance.
• Document and communicate progress on data issues and resolutions to the Senior Quality Engineer.

Essential Skills

• Advanced Microsoft Excel skills (pivot tables, VLOOKUP/XLOOKUP, Power Query, etc.).
• Familiarity with ERP systems, especially Microsoft Dynamics 365 (D365).
• Strong analytical and problem-solving skills.
• Understanding of data governance and regulatory compliance.
• Excellent communication and collaboration skills.
• Ability to manage large datasets and complex data relationships.

Additional Skills & Qualifications

• Associate degree required; Bachelor’s degree in Data Analytics, Information Systems, or a related field preferred.
• 2–4 years of experience in data administration, quality assurance, or regulatory compliance.
• Experience working with cross-functional teams and large-scale data reconciliation projects.

Work Environment

This position is 100% remote and requires 20 hours of work per week.