STAFF ACCOUNTANT

City Electric Supply; United States; On-site; USD 55,000 - 75,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401K

Paid time off

Internal growth opportunities

Job 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 and visibility to accounting leadership, providing a strong foundation for career growth.

Qualifications

• Proven ability to build and maintain complex Excel models for reporting and forecasting.
• Strong attention to detail and accuracy in financial data.
• Ability to analyze large datasets and identify trends and variances.
• Collaborate with cross-functional teams to ensure financial accuracy and timely reporting.

Responsibilities

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

Skills

Excel proficiency

Attention to detail

Analytical thinking

Cross-functional collaboration

Tools

Excel

Pivot tables

XLOOKUP

INDEX-MATCH

SUMIFS

Conditional formatting

Job description

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.