Revenue Systems Analyst- Dearborn

Auto Warehousing Company; Dearborn (MI); Hybrid; USD 55,000 - 86,000; Full time

Benefits offered by this job

Health insurance

401K plan

EAP

Auto discounts

Fitness reimbursement

Job summary

Auto Warehousing Company (AWC) in Dearborn, MI, is seeking a Revenue Systems Analyst for our Midwest Regional Office with a hybrid schedule (3 days a week in-office). The role focuses on revenue systems processes, data analysis, and financial system integrations using CORS, VIPS, SQL tools, NetSuite, and customers' systems.

The ideal candidate has 2+ years in operations or data analysis, strong Excel skills, and the ability to work cross-functionally with Operations and IT.

Qualifications

• 2+ years of experience in operations, data analysis, or related roles with demonstrated growth; experience in accounting or financial environments is preferred
• Proficiency in Microsoft Excel
• Strong problem-solving, logical reasoning, and attention to detail
• Ability to multi-task, work independently, and adapt under pressure
• Self-starter with a positive, team-oriented attitude and excellent organizational skills
• Strong communication and customer service skills, with the ability to interact professionally with co-workers, management, vendors, and customers
• Flexibility to work occasional overtime to meet deadlines
• Dependable with good attendance and a professional, positive demeanor

Responsibilities

• Serve as a liaison between Operations and IT departments in reviewing and reconciling operational and revenue related data issues.
• While serving as a liaison, encourage good financial processes for Operations to follow, working with Operations managers to ensure their locations follow those processes.
• Continually work to enhance the proprietary system's functionality, reports, and processes.
• Research and resolve payment issues on customer accounts.
• Create ad hoc reports and extract field data using programs such as CORS, VIPS, SQL tools and other internal or external revenue-related systems.
• Monitor facilities to ensure exception reports are being reviewed timely.
• Improve existing processes and develop new processes as needed for reconciling customers that autopay.
• Support Operations on the timing and process for manual invoicing to customers and review to ensure processes are being followed.
• Monitor/resolve open vouchers, unvouchered services, rate differences, and other CORS exception reports for customers and/or facilities.
• Partner directly with customers on complex or non-standard billing scenarios.
• Work with Operations and IT to create queries, services, and service triggers.
• Perform other duties as assigned.

Skills

Problem solving

Attention to detail

Communication

Multi-tasking

Teamwork

Tools

Microsoft Excel

Job description

Auto Warehousing (AWC) has been family-owned and operated for more than 50 years and is North America's leader in finished vehicle logistics. Our mission is to service customer vehicles safely, efficiently, with quality and pride. Our Associates are the reason for our success, and developing their talent remains critical to our future.

AWC is hiring a Revenue Systems Analyst for our Midwest Regional Office location in Dearborn MI with a hybrid work setting including 3 days a week at our Dearborn MI office. We pay weekly and the successful candidate's actual pay will be based on various factors, such as qualifications, experience, internal equity, and market considerations.

AWC offers a generous benefits package supporting both physical and mental wellbeing. Benefits include -health insurance for associates, spouses and children; basic life and AD&D insurance; disability insurance; EAP; auto discounts; fitness reimbursement; a 401K plan with company contribution; and several voluntary benefits. AWC corporate staff have paid holidays, floating holidays, vacation and sick accruals, bereavement leave and jury duty leave.

Purpose

The Revenue Systems Analyst is responsible for assigned daily revenue systems processes, including some database analysis and financial systems integration using programs such as CORS, VIPS, SQL tools, NetSuite and customers' various proprietary systems. The primary duties for this position include maintaining services and monitoring transactions to ensure revenue is recorded and invoiced properly and that payment is received appropriately and timely.

Essential Duties

• Serve as a liaison between Operations and IT departments in reviewing and reconciling operational and revenue related data issues.
• While serving as a liaison, encourage good financial processes for Operations to follow, working with Operations managers to ensure their locations follow those processes.
• Continually work to enhance the proprietary system's functionality, reports, and processes.
• Research and resolve payment issues on customer accounts.
• Create ad hoc reports and extract field data using programs such as CORS, VIPS, SQL tools and other internal or external revenue-related systems.
• Monitor facilities to ensure exception reports are being reviewed timely.
• Improve existing processes and develop new processes as needed for reconciling customers that autopay.
• Support Operations on the timing and process for manual invoicing to customers and review to ensure processes are being followed.
• Monitor/resolve open vouchers, unvouchered services, rate differences, and other CORS exception reports for customers and/or facilities.
• Partner directly with customers on complex or non-standard billing scenarios.
• Work with Operations and IT to create queries, services, and service triggers.
• Perform other duties as assigned.

Minimum Education and Experience Requirements

• 2+ years of experience in operations, data analysis, or related roles with demonstrated growth; experience in accounting or financial environments is preferred
• Proficiency in Microsoft Excel
• Strong problem-solving, logical reasoning, and attention to detail
• Ability to multi-task, work independently, and adapt under pressure
• Self-starter with a positive, team-oriented attitude and excellent organizational skills
• Strong communication and customer service skills, with the ability to interact professionally with co-workers, management, vendors, and customers
• Flexibility to work occasional overtime to meet deadlines
• Dependable with good attendance and a professional, positive demeanor

Physical Demands

• Standing – 10% of time
• Walking – 5% of time
• Sitting – 85% of time
• Speaking – to customers and AWC staff members
• Hearing – Telephone, meetings, conference calls
• Seeing – Data entry source documents

Disclaimer

The above statements are intended to describe the general nature and level of work being performed by employees assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of employees assigned to this position.

AWC is an Equal Employment Opportunity (EEO) employer and does not discriminate on the basis of race, color, national origin, religion, gender, age, veteran status, political affiliation, sexual orientation, marital status, disability, or any other protected class with respect to employment opportunities.