Financial Systems Analyst
The Financial Systems Analyst serves as the Administrator for CNI’s budget and planning tool, currently Adaptive Insights. This position analyzes and resolves system issues and serves as a source of expertise required to develop and enhance new and existing models, reports, charts, analyses and metrics in addition to maintenance required to keep system information current.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Essential duties and responsibilities include the following. Other duties may be assigned.
Responsible for the integration of CNI Core Competencies into daily functions, including: commitment to integrity, knowledge / quality of work, supporting financial goals of the company, initiative / motivation, cooperation / relationships, problem analysis / discretion, accomplishing goals through organization, positive oral / written communication skills, leadership abilities, commitment to Affirmative Action, reliability / dependability, flexibility and ownership / accountability of actions taken.
Serves as an Adaptive system administrator and help desk analyst. Provides end user support. Develops and maintains desktop and user quick guides, FAQ’s, and user manuals.
Serves as the primary contact person regarding enhancement, support, training, and issue-resolution of our budgeting tool, Adaptive Insights.
Performs a variety of tasks as assigned by the Finance Manager, Compliance and Analysis. Researches, reviews, analyzes, compiles reports and maintains a variety of financial and accounting information, as assigned.
Assists with the review and analysis of costs budgeted and incurred for compliance with the Federal Acquisition Regulations (FAR).
Reviews financial information for data integrity and consistency with Cost Accounting Standards (CAS) as implemented by CNI.
Assists in the coordination of government related audit activities.
Develops informative and specialized reports for use by finance, management, operations and auditors. Reviews reports prior to release in order to ensure accuracy of information.
Supervises and coaches finance employees as assigned.
Works with business partners to run various scenarios, modeling for rates, allocations and pricing. Creates, maintains and produces various reports, analyses, metrics and dashboards. This includes process documentation, design, implementation and oversight of internal controls in connection with the finance team as well as training and education on all reporting.
Works closely with the finance management team to ensure business partner, board and executive reporting needs are being met using any data from the budget and planning tool.
Serve on various project teams as assigned and work on finance alignment to CNI strategic plan via capital budget planning and staffing.
Works with end users to document, with attention to detail, the business requirements and create technical solutions based on functional requirements.
Key team member in implementing budgets, forecasts, and reports within Adaptive Insights.
Responds to business support questions as it pertains to Adaptive and Adaptive Reporting.
Interfaces with senior management, business, and technology teams to drive the adoption of Adaptive Reporting.
Educates and guides users on effective and efficient approaches to utilizing models, tools, and data.
Provides technical guidance (design, model, configuration, troubleshooting, etc.) for the Adaptive tool.
Demonstrates high understanding of potential functional design issues by suggesting alternatives.
Effectively communicates issues and risks to the management team.
Completes Adaptive testing scenarios, and recommends system change requests to enhance functionalities. Participates on procurement systems working groups, and provides system briefings.
Conducts QA data quality reviews and analyses.
Develops management reports, system dashboards and other documents / records using Adaptive reporting methods.
Participates in all user acceptance testing (UAT) for Adaptive System upgrades.
Assists and provides resolutions to issues and provides guidance and procedure documentation.
Performs acceptance testing on all new and/or modified information systems.
Creates and keeps current application and end-user documentation. Provides training for all new and/or existing applications to end-users.
Ensures appropriate security measures are incorporated at the application level to protect sensitive information.
Supports internal project initiatives by providing operational knowledge / expertise to support project activities such as providing knowledge on interfaces/extensions, and processes.
Researches and diagnoses reported system problems or data inconsistencies reported by systems users.
Assists with identification requirements, and monitors the development of methods for the achievement of assigned systems interface or integration with other financial and non-financial systems. Maintains existing interfaces, and develops new interfaces, as necessary.
Serves as backup to Deltek CostPoint maintenance of system setups as it pertains to cost pool and service center allocations including home office direct allocations with associated multi jobs which will bridge the understanding of CostPoint and Adaptive.
Responsible for aiding in own self-development by being available and receptive to all training made available by the company.
Responsible for keeping own immediate work area in a neat and orderly condition to ensure safety of self and coworkers. Will report any unsafe conditions and/or practices to the appropriate supervisor and human resources. Will immediately correct any unsafe conditions to the best of own ability.
Plans daily activities within the guidelines of company policy, job description and supervisor’s instruction in such a way as to maximize personal output.
Bachelor's degree in Finance, Accounting, Computer Sciences or other applicable majors. Previous experience with system implementations. Experience with accounting (monthly close, budgeting and forecasting, consolidations, reporting, etc.), especially relating to long-range planning and forecasting.
CERTIFICATES, LICENSES, REGISTRATION
JOB SPECIFIC KNOWLEDGE / SKILLS / ABILITIES
Broad knowledge of data sources, data flow, systems interactions, advanced computer equipment and software applications, and advanced systems design techniques
Ability to mine data, identify underlying casual relationships and communicate to management through report, dashboard, charts and presentations
Proficient knowledge and understanding of a variety of concepts, practices and procedures related to computer systems and applications
Advanced knowledge and skills using Microsoft Office programs (i.e., Excel, Access, Word, Outlook, etc.)
Ability to identify / define viable technology solutions delivering required business capabilities
Ability to design highly reliable and scalable technology solutions
Ability to develop clear and thorough functional design specifications that drive effective solutions development
Solid analytical, critical thinking and problem-solving skills
Ability to effectively utilize available tools and resources to resolve issues
Excellent verbal and written communications skills enabling the persuasive presentation of proposed solutions
Ability to collaborate and drive consensus across a diverse group of customers with conflicting priorities
Ability to work effectively both individually and in a team environment
Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference and volume. Ability to apply concepts of basic algebra and geometry.
Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.
Ability to read, analyze, and interpret general business periodicals, professiona1journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.
SPECIAL PHYSICAL DEMANDS
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this job. Work is primarily performed in an office environment. Regularly required to sit. Regularly required use hands to finger, handle, or feel, reach with hands and arms to handle objects and operate tools, computer, and/or controls. Required to speak and hear. Occasionally required to stand, walk and stoop, kneel, crouch, or crawl. Must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, depth perception, and ability to adjust focus. Exposed to general office noise with computers printers and light traffic.