The core values of Central Consolidated, Inc. are respect, integrity, safety, care for assets (employees and clients), improvement, and teamwork. We deliver quality and value to our commercial and industrial customers by providing a broad range of mechanical, custom fabrication, controls, and fire protection services utilizing our experienced staff, engineering capabilities, and design build innovations. Our primary corporate objective is to respond to the needs of our clients as well as the impact of economic and industry trends by staying at the leading edge of technology. One of Central’s greatest achievements is the longevity and loyalty of our workforce. We pride ourselves on taking care of people, our customers, our employees, and our community. Together We’re Smarter!

We are currently seeking an experienced Accounting Business Analyst to join our Wichita, KS team!

Job Responsibilities:

1. 40% : Perform core accounting operations and financial processes to ensure timely, accurate financial reporting and operational support.

Tasks may include:

• Maintain and reconcile General Ledger accounts
• Support monthly and year-end close processes, including account reconciliations and financial reporting
• Prepare and compile month-end reports and adjusting entries required to support financial projections, job reviews, and proper WIP accrual
• Monitor cash management activities, including collections, non-billed work orders, and cash application
• Prepare and assist with tax compliance reporting, including Sales and Use Tax and Quarterly/Annual filings
• Maintain and update fixed asset schedules
• Manage inventory records and perform inventory reconciliations
• Assist with preparation and support for audits (EOY financial review, Workers’ Compensation and General Liability Insurance Premium, Union, and Government reporting)
• Record General Journal Entries (GJEs) and Job Cost Transfers (JCTs) to maintain General Ledger integrity throughout the month
• Maintain working knowledge of billing processes (work order, AIA, and Fire billing), Payroll, Accounts Payable, and Accounts Receivable to provide backup support as needed

2. 35%: Develop, maintain, and enhance business system reporting and data analysis to support operational visibility and strategic decision-making. 

Tasks may include:

• Execute SQL queries to extract and validate operational and financial data
• Build, maintain, and optimize reports and dashboards using Spreadsheet Server, Power BI, or comparable reporting tools to support leadership visibility
• Document report logic, maintain internal data dictionaries, and establish reporting best practices
• Maintain awareness of ERP reporting capabilities and recommend improvements to business intelligence systems
• Support the evaluation and migration of legacy Crystal Reports into modern reporting platforms, such as SSRS or Paginated Reports, based on evolving system needs
• Perform data cleansing, validation, and organization to improve reporting accuracy and reliability
• Develop and implement automated data integrity checks and validation processes to proactively maintain reporting accuracy
• Collaborate with IT and system administrators to optimize data storage structures and reporting workflows
• Assist with ad hoc data analysis projects to support department heads and leadership initiatives
• Troubleshoot and resolve data source and reporting issues to maintain report functionality and reliability
• Establish and enforce internal data governance standards to ensure reporting consistency and data stewardship
• Manage and audit user access permissions for reporting datasets, tools, and dashboards to maintain security and data integrity

3. 15%: Drive business systems improvement initiatives by identifying new technologies, optimizing reporting workflows, and supporting internal training efforts to enhance operational efficiency and data literacy.

Tasks may include:

• Research and recommend new technologies, tools, or processes to improve accounting, financial reporting, and operational workflows
• Support the implementation, integration, and adoption of new systems, integrations, or reporting tools in collaboration with IT and leadership
• Design and deliver user training sessions or materials to promote adoption of reporting tools and data analysis capabilities
• Gather feedback from users and identify areas for continuous improvement in business systems and reporting processes
• Assist with documenting new system workflows, standard operating procedures (SOPs), and reporting guidelines
• Monitor industry trends in ERP systems, business intelligence, and automation tools to inform strategic technology planning
• Provide on-site assistance for troubleshooting system, reporting, and business software issues in coordination with external IT support
• Develop and implement a software renewal tracking system to proactively manage licensing for business systems, reporting tools, and related technologies

4.  5%: Maintain awareness of data security best practices and confidentiality standards, supporting efforts to protect financial, operational, and employee information

Tasks may include:

• Handle sensitive financial and operational data in accordance with company confidentiality policies
• Support efforts to protect the integrity and security of reporting systems, user access permission, and stored data
• Assist with identifying potential risks or vulnerabilities in reporting workflows and recommend mitigation strategies
• Collaborate with the IT Manager to promote secure practices around system access, reporting, and document storage

5.  5%: Serve as a resource for strategic finance, operations, and technology initiatives to support project execution and the management of key internal and external relationships.

Tasks may include:

• Assist in the execution of strategic projects related to financial operations, business systems, reporting enhancements, and technology improvements
• Support the Controller and CFO in maintaining and strengthening relationships with key external partners, including banks, bonding companies, insurance brokers, and auditors
• Provide research, reporting, and operational support for strategic planning activities and initiatives
• Collaborate with the IT Manager as needed to support technology initiatives, system upgrades, and process improvements
• Assist with gathering, organizing, and preparing documentation for audits, renewals, or regulatory reviews as needed
• Perform other duties, responsibilities, and special projects as assigned to support the overall success of the Finance Department and the organization

Requirements:

EDUCATION:

• Required: Bachelor’s degree in Accounting, Finance, or a related field with demonstrated accounting experience. 
• Preferred: Coursework or certifications in Data Analytics, Business Intelligence, or Information Systems is a plus.

EXPERIENCE:

• Preferred: Prior experience in accounting, including general ledger management, reconciliations, and financial reporting. 
• Candidates without prior full-time experience will be considered if they demonstrate strong accounting knowledge, technical aptitude, and readiness to contribute in a hybrid accounting and data-driven role.
• Additional preference given to:
• Experience with construction-specific processes such as AIA billing, WIP schedules, and job costing
• Reporting and data analysis using SQL, Power BI, Spreadsheet Server, or comparable tools
• Experience building and customizing reports using SSRS (SQL Server Reporting Services) or Paginated Reports
• Demonstrated ability to evaluate, recommend, and support the adoption of new technologies
• Exposure to ERP/reporting system integrations, upgrades, or transitions
• Familiarity with Vista (Trimble Viewpoint) or similar construction ERP platforms
• Involvement in managing data governance practices, system documentation, or software licensing and renewals
• Experience cleansing, validating, and organizing data, and implementing automated integrity checks to ensure accuracy and reliability in financial and operational reporting

SKILLS:

• Strong understanding of GAAP and financial reporting standards
• High attention to detail and commitment to data accuracy
• Proficiency with Microsoft Excel (pivot tables, formulas, data validation)
• Familiarity with SQL, Power BI, or other reporting and analytical tools
• Analytical mindset with strong problem-solving skills
• Ability to take initiative, work independently, and follow through on assignments
• Willingness to evaluate and improve existing processes
• Ability to document procedures and reporting logic clearly
• Ability to explain reporting tools and concepts to non-technical users
• Team player with a flexible, adaptable attitude
• Strong verbal and written communication skills
• Comfortable handling sensitive and confidential information
• Ability to identify and organize the necessary resources to meet tight deadlines and achieve superior results
• Able to manage multiple deadlines and prioritize work in a dynamic environment

LICENSE:

• Valid Kansas driver’s license and a good driving record, required.

OTHER:

• Must be available to work hours outside of normal office hours as required.

WORK CONDITIONS:

Prolonged periods sitting at a desk and working on a computer. Must be able to lift up to 15 pounds at times. Frequent use of manual dexterity and visualization of a computer screen through the day. This position is based on-site at our Wichita, KS office. Remote or hybrid arrangements are not currently supported.

To perform this job successfully, an individual must be able to complete all areas outlined for this position in a satisfactory manner. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The above statements are intended to describe the general nature and level of work being performed by most people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, duties, and requirements.