JOB DESCRIPTION
DESCRIPTION:
Duties: Develop and support the firm's automation initiatives to improve process efficiency and data accuracy. Build new process controls and strengthen the existing control framework to reinforce risk management and compliance. Coordinate the accounting of global real estate construction projects, including analysis, reconciliations, reporting, taxation adjustments, and fixed asset setup. Perform general ledger close and accounting activities, including preparing and reviewing journal entries, reconciliations, and related financial analysis. Review capital project expenditures to ensure appropriate accounting treatment in accordance with accounting principles and firm policies, including recording fixed assets. Reconcile capital and expense spending to the general ledger. Conduct analytical reviews of construction-in-progress projects to confirm the accuracy of balances and compliance with accounting standards. Review and improve key accounting processes to enhance operational efficiency and effectiveness. Provide financial information and analysis to management. Support internal and external audit activities and respond to audit inquiries. Develop and maintain communication with management and business partners to facilitate collaboration and information sharing. Perform compliance reviews of line-of-business solutions to ensure adherence to internal controls and policies. Perform analytical reviews and ad hoc analysis as assigned by management.
QUALIFICATIONS:
Minimum education and experience required: Bachelor's degree in Quantitative Management, Finance, Accounting, or related field of study plus five (5) years of experience in the job offered or as Financial Controller, Accounting Manager, or related occupation. The employer will alternatively accept a Master's degree in Quantitative Management, Finance, Accounting, or related field of study plus three (3) years of experience in the job offered or as Financial Controller, Accounting Manager, or related occupation.
Skills Required: This position requires three (3) years of experience with the following: Conducting data manipulation, data structuring, process flow design, and query optimization using Alteryx and Tableau; Developing and automating accounting workflows using Alteryx and Excel VBA; Performing financial reconciliation and financial reporting; Designing and developing complex Excel workbooks and multi-layer formulas using Excel, including lookup functions, pivot tables, data analysis add-ins, and VBA macros; Enhancing accounting controls through formula optimization, logic updates, and documentation using Alteryx and Excel; Performing general ledger close activities; Performing fixed asset acquisition and adjustment activities; Performing depreciation analysis. This position requires any amount of experience with the following: Conducting back-testing of automated processes and communicating results and remediation plans using Alteryx, Excel, OneNote, and PowerPoint; Conducting analytical reviews of accounting processes to identify automation and standardization opportunities; Determining accounting treatment for construction-in-progress project costs in accordance with GAAP; Supporting accounting system migrations and related process changes using SAP, Excel, Databricks, and Oracle Essbase; Designing and implementing updated process flows to address data integrity, compliance, and reporting requirements; Conducting exploratory data analysis using enterprise accounting databases such as SAP; Performing ad hoc audits and investigations of historical financial activities using enterprise databases such as SAP, CDGL, or real estate management platforms.
Job Location: 1111 Polaris Parkway, Columbus, OH 43240.
Full-Time. Salary: $98,007 - $115,000 per year.
