Staff Accountant

City Electric Supply; Dallas (TX); On-site; USD 55,000 - 75,000; Full time

Benefits offered by this job

401(k) company match

Medical, dental, vision insurance

Paid time off

Job summary

City Electric Supply is seeking a detail-oriented Staff Accountant to support core accounting functions and financial reporting. The role emphasizes large data work, Excel automation, and close process improvements, with exposure to accounting leadership for career growth.

The position offers on-site work in Dallas, TX, with comprehensive benefits and opportunities to develop reporting processes and analytics within a growing, family-owned electrical wholesaler.

Qualifications

• Bachelor’s degree in accounting, finance, or related field.
• 1–4 years of accounting or finance experience (public or corporate).
• Strong understanding of GAAP.
• Experience with ERP/accounting systems (NetSuite, SAP, Oracle, QuickBooks, etc.).
• Advanced Microsoft Excel proficiency, including pivot tables and complex formulas, data validation, and automation.

Responsibilities

• Prepare and post journal entries; maintain general ledger.
• Perform monthly, quarterly, and year-end reconciliations.
• Analyze financial data using advanced Excel models and formulas.
• Develop and maintain complex Excel spreadsheets for reporting, forecasting, and variance analysis.
• Use pivot tables, XLOOKUP, INDEX-MATCH, SUMIFS, and nested formulas daily.
• Assist with month-end and year-end close processes.
• Prepare schedules for audits and internal reviews.
• Reconcile balance sheet and income statement accounts.
• Identify trends 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.

Skills

Excel proficiency

Analytical skills

Attention to detail

Problem-solving

Education

Bachelor's degree in accounting or finance

Tools

NetSuite

SAP

Oracle

QuickBooks

Power Query

Power Pivot

VBA

Job description

City Electric Supply (CES) - Onsite - 400 South Record Street, Dallas, TX 75202

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.

Education/Experience

• Bachelor’s degree in accounting, Finance, or related field.
• 1–4 years of accounting or finance experience (public or corporate).
• Strong understanding of GAAP.
• Experience with ERP/accounting systems (NetSuite, SAP, Oracle, QuickBooks, etc.).
• Advanced Microsoft Excel proficiency, including pivot tables and pivot charts, complex formulas and functions, large data set management, data validation and error checking, and spreadsheet automation and efficiency improvements is required.
• Experience automating reports or improving Excel-based workflows (preferred, not required).
• Exposure to Power Query, Power Pivot, or VBA (preferred, not required).
• High attention to detail and accuracy.
• Comfortable handling several accounting projects and month-end close tasks simultaneously.
• Strong analytical and problem-solving skills.

Benefits Offered:

• 401(k) company match program.
• Short-term and Long-term disability insurance.
• Basic and AD&D Life Insurance paid for by the company.
• Employee Assistance Program.
• Auto and Home Insurance discount.
• Paid Time Off and 7 paid Holidays.
• Paid Pregnancy, Parental, and Adoption Leave programs.
• Employee Discount Program.
• Training Programs.
• Internal growth opportunities in a fast-growing company.
• In some jurisdictions, state or local laws address sick leave or other leaves of absence. The Company complies with all such laws. This policy shall apply only to the extent it does not conflict with applicable law.

Supervisory Responsibility

This position has no supervisory responsibilities.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. This position is very active and requires standing, walking, bending, kneeling, stooping, and climbing. The employee must be able to lift and move items up to 50 pounds.

Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

EEO Statement

We are an Equal Employment Opportunity employer committed to providing equal opportunity in all of our employment practices, including selection, hiring, assignment, re-assignment, promotion, transfer, compensation, discipline, and termination. The Company prohibits discrimination, harassment, and retaliation in employment based on race; color; religion; genetic information; national origin; sex (including same sex); sexual orientation; gender identity; pregnancy, childbirth, or related medical conditions; age; disability or handicap; citizenship status; service member status; or any other category protected by federal, state, or local law. We support protected veterans and individuals with disabilities through our affirmative action program.

Attention Applicants

If you have a disability and need a reasonable accommodation to complete any part of the application process, or if you have difficulty accessing or using the online application process and need an alternative method, please contact us at [e-mail] or 1-855-571-2477.

City Electric Supply is a drug free workplace. For further information about CES, visit our website at www.cityelectricsupply.com.