Accounting Business Analyst

This job was posted by https://www.kansasworks.com : For more

information, please see: https://www.kansasworks.com/jobs/13261972

***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 pr cesses

• 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 p