Title: FINANCIAL INFORMATION SPEC Location: United States-Virginia-Virginia Beach Job Number: 240003KA Job Summary: Serves as database administrator with responsibility for the design development implementation and support of Essbase OLAP databases. Duties and Responsibilities: - Programs and maintains a number of Financial Information System reports and dashboards used by many end-users in various sub-departments. Provides technical assistance to users creating reports using the Financial Information System. - Develop ad hoc reports to support decision making. Provide insights into financial trends, variances, and performance metrics to key stakeholders. - Manage and reconcile assigned general ledger accounts. Record financial transactions in the general ledger. Analyze balance sheets. - Utilizes SQL software to extract monthly financial data from Financial Information System and loads into Oracle Hyperion Essbase database. Ensures timely and accurate data capture. Verifies Essbase database balances to the Financial Information System. - Prepares monthly NEXCOM Flash Reports for all business lines using data from the Accounting system and adjusting for accounts not processed in time for the Flash report. Prepares Final operating statements for all NEXCOM business lines and posts financial reports to the intranet (HUB). - Works with budget analysts to consolidate budget submissions from field activities. Assists budget analysts with loading field budgets into the Accounting system. Assists in preparation of briefings for Code F. Utilizes Data Warehouse, financial information systems application, Excel and other software packages to produce slides, charts and customized reports for use in presentations to facilitate decision-making. Conducts special studies and analyses as directed. - Serve as a point-of-contact for functional area and assists subject matter experts (SMEs) with ensuring data integrity, testing of system changes, report writing and analysis of data flows for process improvement opportunities. - Support system upgrades, system patches, testing and other technical projects as assigned. Partners with Code I and F teams, and vendor(s) as required to ensure training, processes and system procedures are in place to fulfill NEXCOM Financial Information and operational strategies in the most effective and efficient manner. - Identify opportunities for process automation and efficiency improvements within financial systems and workflows. - Maintain data integrity in Financial Information systems by running queries and analyzing data. Assists in the design and content management of Code F websites, including but not limited to the Financial Information Management pages on the intranet (HUB). - Employ strong communication skills, both verbal and written, to create both internal and external customer relationships. - Research business requests, including gathering functional requirements, design documentation, user acceptance testing and documentation. - Assists or leads in troubleshooting potential and/or current challenges of technology. Performs other related duties as assigned. Qualifications: GENERAL EXPERIENCE: Three years of responsible experience performing FINANCE or ACCOUNTING work that enabled the applicant to gain a general understanding of Financial Information Systems, functions, disciplines, relationships, and administrative software for accomplishing work; the ability to analyze problems, apply sound judgment in assessing practical implications of alternative solutions and resolving the problems presented; and the ability to communicate effectively with others, both orally and in writing. OR SUBSTITUTION OF EDUCATION FOR EXPERIENCE: 4 year bachelors degree for 3 years of general experience. AND SPECIALIZED EXPERIENCE: Three years of progressive experience in a finance or accounting department with responsibilities that include financial reporting, transaction reconciliations, and analysis of operating results to ensure accurate posting and compliance with GAAP. Strong knowledge of General Ledger processes, including researching discrepancies, performing reconciliations, and making necessary corrections. Experience with automated accounting systems, including analyzing data flows and recommending improvements to enhance data integrity. Proven experience in implementing, upgrading, or replacing financial systems, preferably in retail or wholesale organizations, focusing on process improvement and successful system transitions. Excellent analytical, problem-solving, and communication skills to support financial operations and system improvements. Preferred Experience: Advanced level of skill in MS Excel and demonstrated experience in project management. Job: Financial/Accounting