Data Processing Representative [207841]

Aquent; Portland (OR); On-site; USD 55,000 - 60,000; Full time

Benefits offered by this job

Paid Holidays (6)

Medical and Dental Insurance

PTO – Vacation + Sick time

Retirement 401(k), Company Match and Profit Sharing

Job summary

A leading data solutions provider in Portland, OR, is seeking a Data Processing Representative responsible for the integrity and preparation of client data for mail and print production. Applicants should be detail-oriented with advanced Excel skills and the ability to manage multiple data streams. The position offers competitive hourly pay and various benefits, including medical insurance and a retirement plan. This role requires onsite work in Portland and offers no remote options.

Qualifications

• Advanced MS Excel skills with familiarity in functions like VLOOKUP/XLOOKUP and Pivot Tables.
• Must maintain near-perfect accuracy when handling sensitive client data.
• Ability to effectively clean and organize raw data for production use.

Responsibilities

• Cleansing and normalizing data using Excel.
• Performing complex data manipulation and ensuring integrity.
• Troubleshooting inconsistencies in client files.

Skills

Advanced MS Excel Skills

Attention to Detail

Analytical Mindset

Organizational Skills

Adaptability

Tools

BCC Mail Manager

Adobe Creative Suite

Job description

The Data Processing Representative is responsible for the integrity, cleansing, and preparation of client data for large-scale mail and print production. While we use industry-specific postal software, expert-level proficiency in Microsoft Excel is the most critical requirement for this role. We are looking for a detail-oriented “data sleuth” who can transform messy client files into organized, production-ready databases.

Employment status: This is a non-exempt, hourly full time position. Hourly pay (approx $26.50-29/hr) will be based on a salary ($55-60K). Workers also qualify for overtime hours. This is direct-hire placement. There is no end-date.

Candidates MUST be local to Portland, OR area. Work sponsorship or transfer will NOT be provided.

Key Excel & Data Responsibilities

• Data Cleansing & Normalization: Use Excel to import, scrub, and format various client data types. This includes splitting strings (e.g., separating names from addresses), assigning salutations, and standardizing currency/decimal formats.
• Complex Data Manipulation: Perform “Merge/Purges” across multiple files, identify and remove duplicates, and isolate sensitive information (IDs, account numbers, etc.) to ensure data integrity.
• Logic-Driven Formatting: Create labeling lists and variable data sequences for complex merges based on specific client business rules.
• Data Troubleshooting: Analyze client files for inconsistencies or malformed addresses; coordinate with Sales and Customer Service teams when data needs to be re-exported or corrected.

Secondary Duties (Training Provided)

• Postal Software Operations: Learn to utilize BCC Mail Manager and Windowbook to run files through USPS databases (CASS/NCOA) and prepare presorted mailing lists.
• Compliance & Liaison: Coordinate with the USPS Postal Liaison to ensure jobs meet “Seamless” e-induction requirements and postal regulations.
• Variable Data Design: Use Adobe InDesign and plugins to merge cleansed data into visual layouts, ensuring fonts and scales match client specifications.
• Documentation: Maintain detailed logs of client-specific processing templates and software update procedures.

Requirements & Qualifications

• Advanced MS Excel Skills: Comfort with advanced functions (VLOOKUP/XLOOKUP, Pivot Tables, formulas, If/Then statements, and Text-to-Columns).
• Strong Attention to Detail: A “near-perfect” accuracy rate is required when handling sensitive client information and postal barcodes.
• Analytical Mindset: The ability to look at a raw data file and determine the most efficient way to “clean” it for production.
• Highly Organized: Ability to manage multiple data streams and deadlines simultaneously.
• A Sense of Humor: We work hard and value a positive, adaptable team culture!
• Note: Experience with BCC Mail Manager, Adobe Creative Suite, or USPS Postal One! is a significant plus, but we are willing to train the right candidate who possesses elite Excel and data-entry skills.

Benefits Include

• Paid Holidays (6)
• Medical and Dental Insurance
• AFLAC Plan(s)
• PTO – Vacation + Sick time
• Employee Referral Bonus
• Retirement 401(k), Company Match and Profit Sharing
• Continuation of Benefits Following Separation

Interview Process

2-3 onsite interviews with management

Client Description

Printing and mailing production company

Other Requirements

• MUST be able to work onsite 5x week in Portland, OR