Accounting Business Analyst

at Central Consolidated Inc in Wichita, Kansas, United States

Job Description

ESSENTIAL RESPONSIBILITIES/JOB TASKS

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