Information Systems Analyst - Level 3

Kforce•Delray Beach, FL

35d

About The Position

The Information Systems Analyst is a liaison position with the objective of integrating application systems to meet the needs of operations and accounting. This role must utilize expertise in systems and accounting as well as have the aptitude to understand operations to be successful.

Requirements

Bachelor's degree in a related field from a four-year college or university program and at least three years of related experience
Excellent analytical and reporting skills
Excellent computer and problem-solving skills
Exceptional skill in Excel including pivots, advanced formula writing and ODBC SQL queries
Strong background in SQL and reporting (excel, a data visualization tool i.e. Tableau or Power BI)
Able to create and maintain report designs in Access and/or SSRS
Knowledge and understanding of GAAP accounting
Excellent organizational skills with attention to detail and accuracy
Ability to multi-task successfully and respond to internal/external customers in a timely manner
Ability to be an effective team member and display initiative
Experience using Business Intelligence/Data Visualization software (Power BI, Tableau, Dundas BI)

Nice To Haves

Experience with Newstar accounting system and/or BuildPro homebuilding system is a plus

Responsibilities

Provide user support for accounting and operating application systems
Develop custom systematic and ad-hoc financial, audit, or analytical reports upon request for operations, accounting, and management
Maintain integrity and controls of application systems and identify potential weaknesses (i.e. job cost/GL code mapping)
Provide processing support for various activities (i.e. project/phase/lot setups, periodic recurring processes, budget/inventory uploads)
Develop and maintain resource tools, databases, and templates for accounting and operations (i.e. job cost reports, blackbooks, consolidated financial tiered reports, closing templates, payroll templates, land database, etc.)
Maintain systems integration with proformas for all divisions
Analyze, research, troubleshoot and resolve data discrepancies or inconsistencies with accounting and operations
Write SQL ad hoc queries for reporting needs
Build VBA programs for both Microsoft Access and Microsoft Excel
Work within SQL Server and Microsoft Access databases
Data analysis and assessment of database infrastructure
Creation and maintenance of management dashboards within Business Intelligence software