Data Quality Analyst

Data Quality Analyst

Are you a driven professional with a background in payroll who would like to work in a quickly evolving environment? Do you thrive in the details of high-volume transactional environments? Are you seeking career growth? Off Duty Management is seeking a detail-oriented Data Quality Analyst to join our Accounting Department. This role focuses on ensuring data accuracy, completeness, and consistency across spreadsheets. This position also reviews and validates shift data for 1099 contract employees (non-W2), ensuring accuracy by reconciling payroll data between our proprietary scheduling software and agency policies. The ideal candidate is a collaborative team player with a solution-driven mindset and strong attention to detail. This role requires proficiency in navigating multiple software platforms and spreadsheets to ensure timely and accurate contractor payments. We are committed to delivering exceptional customer experience and value team members who thrive in a collaborative environment. The right candidate excels at managing multiple tasks, adapting to changing priorities, and contributing to our company's success.

Responsibilities:

• Update contractor profiles by entering any changes to officers' profiles, such as banking information and mailing addresses, to ensure each individual is payroll-ready.
• Analyze complex formulas and LOOKUPs to troubleshoot calculations and guarantee consistency.
• Analyze data validation reports to pinpoint the root causes of recurring spreadsheet errors.
• Proficient in creating and executing macros to automate repetitive tasks and improve workflow efficiency
• Prepare payroll logs, validate officer, vehicle, and vendor-specific records to ensure pay/invoice rates comply with agency contracts.
• Examine internal scheduling docs to ensure shift details align with the agency's guidelines.
• Verify mileage submissions to ensure officers are not entering odometer readings and confirm the validity of high mileage associated with escort assignments or long-distance travel.
• Investigate significant variances between scheduled and actual hours, confirm compliance with agency-specific rounding rules and minimum shift requirements.
• Escalate unresolved discrepancies by creating/tracking internal support tickets.
• Successfully collaborate with other departments to complete assigned tasks efficiently and accurately.
• Handle payroll inquiries via phone and email, including providing 1099 forms to contract employees upon request.
• Perform general office tasks, including answering calls, managing files, handling inbox communications, and completing other assigned duties.

Requirements:

• Strong experience using spreadsheets for large-scale data management, reporting, and analysis.
• Advanced Microsoft Excel skills, including formulas, pivot tables, LOOKUPs, sorting, and data validation to investigate complex payroll or billing data.
• Proven ability to analyze data using critical thinking to identify discrepancies such as incorrect employee information, system errors, or manual entry mistakes.
• High level of accuracy and attention to detail with the ability to detect payroll, billing, and rate inconsistencies.
• Experience reviewing payroll records, billing data, or rates in a professional environment.
• Ability to analyze and interpret policies and rate agreements to ensure compliance.
• Excellent organizational and documentation skills to maintain accurate records and audit trails.
• Effective verbal and written communication skills for collaborating with internal teams and escalating issues when necessary.
• Strong customer service mindset when supporting internal and external stakeholders and resolving inquiries.
• Ability to work under pressure and meet strict daily payroll deadlines.
• Comfortable working in fast-paced environments while managing multiple tasks and priorities.
• Adaptable to changing payroll structures, policies, and diverse payroll schedules.
• Ability to collaborate effectively within a team while maintaining a solution-oriented approach.
• Flexible and capable of transitioning between tasks to provide backup support when needed.

Experience & Education:

• Minimum of 2–3 years of experience in payroll processing, 1099 contractor payments, or accounts payable/receivable.
• Strong attention to detail with a proven track record of accuracy.
• Ability to work efficiently and accurately in a fast-paced environment.
• Excellent organizational, analytical, and problem-solving skills.
• Prior experience with data analysis or reporting is preferred.
• A high school diploma is required; an associate or bachelor's degree in accounting, finance, or business is a plus.

Benefits:

• Paid Time Off
• Health/Dental/Vision Insurance
• 401(k)

Job Type: Full-Time / Monday – Friday: 8 am – 5 pm

Off Duty Management is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran, or disability status.

This Organization Participates in E-Verify.