Code Catalog Analyst- Mars Veterinary Health
About The Position
The Code Catalog Analyst executes the daily operations of data authoring, maintenance, mapping, and reconciliation within enterprise code catalogs and reference data repositories. The role ensures accurate, complete, and timely master data records, with a focus on products and services inventory, pricing, item attributes, and packages, and resolves discrepancies to prevent downstream business-process failures. The position supports Mars Veterinary Health’s North America hub locations in Vancouver, Washington; Santa Monica, California; or Tampa, Florida, and requires working from a hub location. The analyst processes requests to create, update, or retire catalog entries; maintains reference tables, hierarchies, and mapping rules; and manages requests through implementation in practice management systems while meeting service-level agreements and metrics. The role also supports testing and uploads between the master code registry and target systems, monitors data quality, maintains catalog governance, and assists business, clinical, and operational stakeholders with master-data requests and mapping local data to the enterprise catalog. The analyst documents procedures and governance decisions, performs code-utilization analysis and exception reporting, identifies trends, and makes recommendations with downstream billing, revenue, discount, and reporting impacts in mind. The role also includes other duties as assigned.
Requirements
- Associate or bachelor’s degree in Business, Information Technology, or a related field.
- At least 4 years of relevant experience in data analysis, code catalog operations, or database maintenance.
Nice To Haves
- Veterinary medical informatics experience.
- Knowledge of medical informatics, particularly in the veterinary industry.
- Direct experience in a veterinary hospital as a medical practitioner, such as a Credentialed Veterinary Technician, Practice Manager, or DVM, including hands-on use of Practice Information Management Systems (PIMS) and code catalogs.
- Proficiency in SQL, including writing queries, joins, and data profiling.
- Advanced Microsoft Excel skills, including VLOOKUPs, pivot tables, and data-cleaning functions.
- Familiarity with data cataloging, master data management (MDM) software, or ERP data structures such as SAP or Oracle.
Responsibilities
- Live and exemplify the Five Principles of Mars, Inc. within self and team.
- Process requests for new, updated, or retired code catalog entries arising from product availability, lab partner changes, hospital requests, changes in medical procedures or services, and pricing bundles.
- Author, update, and validate reference tables, hierarchies, and mapping rules for products and services inventory, pricing, item attributes, inventory packages, coupons, and taxes.
- Manage code catalog requests from intake through implementation in practice management systems while meeting SLAs and metrics.
- Identify duplicate, overlapping, inconsistent, obsolete, and underutilized codes and opportunities for standardization.
- Support systems teams with testing and uploads between the master code registry and target practice management systems.
- Investigate, troubleshoot, and resolve coding errors, duplicate entries, and incorrect categorizations in catalog tools.
- Maintain catalog governance by validating requests against policies, approval requirements, and catalog standards.
- Support business data stewards, veterinary hospital staff, and operational teams with master-data requests, lookup tables, and standard definitions.
- Help business and clinical teams map local reference data to the global enterprise catalog.
- Make recommendations that account for downstream use, including potential effects on billing, revenue capture, discount application, and reporting.
- Document standard operating procedures for catalog data entry, standards, governance decisions, and veterinary informatics reference-data definitions.
- Provide code-utilization analysis, exception reporting, trend identification, metrics, and recommendations.
- Perform other duties as assigned.
Benefits
- Paid time off and holidays.
- Medical, dental, and vision insurance.
- Fertility and family-building assistance.
- Paid parental leave.
- Practice-paid basic life insurance.
- Practice-paid short- and long-term disability.
- 401(k) Savings Plan with automatic enrollment after 60 days and company match.
- Commuter benefits.
- Legal plan.
- Health Savings Account and Flexible Spending Account.
- Mental health support and resources.
- Paid volunteering.
- Optimum Wellness Plans® for up to three pets.
- Continuing education allowance and MED hours for eligible positions.
- Student debt relief for full-time DVMs.
- Discounts including Mars, PetSmart, Royal Canin, fitness, and cellular discounts.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
Associate degree
