Billing and Purchasing Analyst

We are seeking a detail-oriented and proactive Billing and Purchasing Analyst to support supply chain operation functions. The analyst will be responsible for preparing and submitting accurate customer invoices in compliance with contract requirements, collaborating with IT to resolve billing data issues, and monitoring contract compliance daily. Key duties include completing month-end closing tasks, reconciling billing data with revenue forecasts, and conducting quality assurance on billing processes.

The role also involves promptly addressing customer billing disputes and maintaining professional communication with customers. On the purchasing side, the analyst will update and maintain purchase order records and billing databases, track on-time delivery performance, calculate turnaround times for shipments, and document liquidated damages related to delivery delays or contract breaches. Coordination with vendors to manage purchase order fulfillment and support vendor management activities is essential.

Strong proficiency in Microsoft Office, particularly Excel and Power BI, is required for data analysis and reporting. The ideal candidate will have excellent organizational skills, the ability to work independently, and experience in billing and procurement processes.

 Daily duties include:

• Prepare and submit customer invoices accurately according to assigned contract requirements.
• Collaborate with IT to identify and resolve billing data issues.
• Monitor customer contracts daily to ensure billing compliance with contract terms.
• Complete month-end closing tasks, ensuring all assigned contract revenue is billed and minimizing revenue accruals.
• Reconcile billing data against revenue forecasts.
• Conduct quality assurance checks on billing processes to maintain accuracy.
• Respond to and resolve customer billing disputes promptly.
• Maintain professional communication with customers regarding billing matters.
• Update and maintain purchase order records and billing databases regularly.
• Track on-time delivery (OT) performance and calculate turnaround times (TAT) for shipments.
• Document and report liquidated damages related to delivery delays or contract breaches.
• Coordinate with vendors to manage purchase order fulfillment and resolve procurement issues.
• Support vendor management activities, including tracking vendor performance and communications.
• Utilize Microsoft Office tools, especially Excel and Power BI, to analyze data and generate reports.

Requirements:

• Detail oriented.
• Excellent PC skills, proficient in MS Excel, Access preferred.
• Experience in working with large databases and managing large data files.
• Excellent oral and written communications skills.
• Excellent analytical and problem-solving skills.
• Ability to manage multiple priorities and projects.
• 1+ years’ experience in a customer service/data analysis role.
• Demonstrated knowledge of Excel and Access or other data management experience.
  • 2+ years’ post secondary coursework work experience in a project/program coordinator/manager designing, utilizing data analysis in decision making.
  • 4 year degree with coursework in business, accounting, information technology (database management, modeling, visualization, and reporting)

Required Skills

• Business Analytics 
• Microsoft Excel (Pivot Tables, VLOOKUP), 
• Microsoft Power BI 
• Data Analytics 
• Data Mining 
• Finance 
• Project Communications 

Other Skills strongly desired

• Tableau 
• SQL 
• Python 
• Predictive Analytics 
• Big Data Analytics