Revenue Systems Analyst- Dearborn

autowc; Dearborn (MI); Hybrid; USD 65,000 - 90,000; Full time

Benefits offered by this job

Health insurance

401K plan

Paid holidays

Vacation accruals

Job summary

Auto Warehousing (AWC) in Dearborn, MI seeks a Revenue Systems Analyst to manage daily revenue systems processes and integrations (CORS, VIPS, SQL, NetSuite). Hybrid work: 3 days in-office at Dearborn.

You will reconcile data between Operations and IT, generate ad hoc reports, resolve payment issues, and help optimize revenue workflows. Requires 2+ years in data/operations and strong Excel skills.

Qualifications

• 2+ years in operations or data analysis
• Proficiency in Microsoft Excel
• Strong problem-solving and attention to detail
• Excellent communication and customer service skills
• Ability to multi-task and work independently

Responsibilities

• Serve as liaison between Operations and IT to reconcile data issues
• Develop ad hoc reports using CORS, VIPS, SQL tools
• Monitor revenue transactions to ensure proper invoicing and timely payments
• Improve revenue-related processes and develop new workflows
• Collaborate with customers on complex billing scenarios
• Create queries, services, and triggers with IT
• Perform other duties as assigned

Skills

Analytical thinking

Attention to detail

Excel proficiency

Communication skills

Teamwork

Tools

CORS

VIPS

SQL tools

NetSuite

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

Check physical demands that apply

Describe job responsibilities that require physical demands checked

• 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.