Level 3 IS Analyst

Kforce has a client that is seeking an Information Systems Analyst - Level 3 in Delray Beach, FL. Summary: 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. 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
• Bachelor's degree in a related field from a four-year college or university program and at least three years of related experience
• Experience using Business Intelligence/Data Visualization software (Power BI, Tableau, Dundas BI)
• Strong background in SQL and reporting (excel, a data visualization tool i.e. Tableau or Power BI)
• Knowledge and understanding of GAAP accounting
• Excellent analytical and reporting skills
• Excellent computer and problem-solving skills
• Excellent organizational skills with attention to detail and accuracy
• Exceptional skills in Excel including pivots, advanced formula writing and ODBC SQL queries
• Able to create and maintain report designs in Access and/or SSRS
• 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 with Newstar accounting system and/or BuildPro homebuilding system is a plus