Office Services Administrator

Canon U.S.A., Inc.•St. Louis, MO

9d•$21 - $36•Onsite

About The Position

Conducts detailed expense account reconciliations and analysis to monitor and explain budget variances in order to ensure accurate financial reporting. This role is responsible for the end-to-end management of invoice lifecycles and user data reconciliation within the Calero/MDSL platforms, while simultaneously driving initiatives to automate manual workflows and reduce processing time.

Requirements

Typically requires general education and/or vocational training plus 4 to 6 years of related experience.
Professional experience with 3 to 4 years of financial analyst and report preparation.
Working knowledge of GAAP. SOX Compliance a plus.
Strong Word skills.
Advanced Excel: Expert-level proficiency in Microsoft Excel, including the ability to write Macros/VBA, build complex formulas (VLOOKUP, XLOOKUP, Index/Match), and design preformatted import templates.
Expense Management Platforms: Strong working knowledge of Telecom Expense Management (TEM) or Market Data Management platforms, specifically Calero and MDSL.
Attention to detail, proficient data entry and problem solving skills.
Financial and account analysis, report preparation, processing month-end financial reports and budgetary analysis and sales trend analysis.
Proactive reporting to manager for decisions.
Excellent analytical, organizational, communication, time management and written skills.

Responsibilities

Monitors Sales, Cost Of Sales and Overhead expense accounts to ensure accurate coding of invoices throughout the month, and during the month-end process.
Generates month-end reports, operating statements, financial and statistical analysis for variance budget to actual results for assigned accounts, departments and branches.
Prepares Management reports of MTD and YTD Activity for Zone and Regional locations.
Involvement in quarterly audit process in various Revenue and Overhead Expense accounts.
Responsible for daily process of Business Service activity and month end reporting structure.
Performs other projects and duties relating to billing, receivables and/or other regional activities that may be assigned.
Ensures current financial procedures are followed according to the processes defined by the Accounting Manager to ensure accurate financial reporting requirements are met, while achieving productivity goals.
Responsible for special assignments and/or projects, as required by management.
Process Improvement: Spearhead automation projects (Excel Macros, OCR assessment) to reduce manual workload and define long-term operational roadmaps.
Telecom Expense Management: Manage invoice entry and validation within Calero/MDSL, ensuring 100% accuracy in billing metadata and scope.
Data Reconciliation: Perform complex reconciliation of user entitlements against HR and MDM data, resolving discrepancies regarding termed or moved users.
Financial Analysis: Identify billing errors, manage vendor disputes, and execute precise cost allocations and charge adjustments for accurate financial reporting.

Benefits

Employee referral bonus
Employee discounts
“Dress for Your Day” attire program (casual is welcome, based on your job function)
Volunteer opportunities to give back to our local community
Swag! A Canon welcome kit and official merch you can’t get anywhere else
medical
dental
vision
401(k) Savings Plan
discretionary profit sharing
discretionary success sharing
educational assistance
recognition programs
vacation