STAFF ACCOUNTANT

Looking to start an exciting new career? City Electric Supply (CES) offers excellent career opportunities for people who are friendly and passionate about providing incredible customer service. Benefits include medical, dental, and vision insurance, 401K, paid time off, and internal growth opportunities.

About City Electric Supply CES is a family-owned electrical wholesaler with the benefits of a worldwide service network and the personal service of a neighborhood store. Our "customer service first" core value has allowed us to grow continually for over 65 years while keeping our founding principle of empowering people to make local business decisions. CES now employs more than 7,400 people at over 1,000 branches world-wide of which there are over 500 branches across North America. Our vision is to add 30-35 branches a year, while staying true to our Company values.

Summary City Electric Supply (CES) is seeking a detail-oriented Staff Accountant with exceptional Excel skills to support core accounting functions and financial reporting. This role is highly data-driven and ideal for someone who enjoys working with large datasets, building spreadsheets, and improving processes through automation and analysis. This position offers exposure to analytical accounting work, opportunities to enhance reporting processes, and visibility to accounting leadership, providing a strong foundation for career growth in accounting or financial analysis.

Essential Job Functions

• Prepare and post journal entries; maintain accurate general ledger records.
• Perform monthly, quarterly, and year-end account reconciliations.
• Analyze financial data using advanced Excel models and formulas.
• Develop, maintain, and improve complex Excel spreadsheets for reporting, forecasting, and variance analysis.
• Use pivot tables, XLOOKUP, INDEX-MATCH, SUMIFS, nested formulas, and conditional formatting daily.
• Assist with month-end and year-end close processes.
• Prepare supporting schedules for audits and internal reviews.
• Reconcile balance sheet and income statement accounts.
• Identify trends, discrepancies, and opportunities for process improvement through data analysis.
• Collaborate with cross-functional teams to ensure financial accuracy.
• Support ad hoc financial and operational analysis projects.