ERS – Financial Systems Data Analyst

ERS is seeking a Financial Systems Data Analyst to perform routine to complex accounting, technical, and functional work to support the automated financial systems and data in the Finance Division. The role involves coordinating with other divisions and outside entities to define business requirements for various internal and external interfaces to the financial systems.

Requirements

• Collaborates with users to identify data and system requirements, develop functional/technical design specifications and solve complex operational problems.
• Collaborates with cross divisional teams to resolve data or system issues and implement automation or process improvement opportunities.
• Constructs variance and trend analyses and reconciliation tasks on Health Savings Account contributions, cash, accounts receivables, accounts payable general ledger and other finance data.
• Develops and maintains finance and investment reports, dashboards and data models using SQL, Spreadsheet Server, Tableau, Alteryx, Business Objects or similar application.
• Provides user support, testing and training for financial system enhancements or reporting solutions.
• Monitors system processes and exception reporting and advises on correcting errors in the following internal and external accounting interfaces between systems such as PeopleSoft Financials, ERS Online/Benefits, Eagle Investment Systems, Bank of New York (BNY) and Investment Accounting Reconciliations.
• Coordinates with cross divisional teams to resolve data or system issues.
• Performs reconciliations on Health Savings Account contributions, cash, accounts receivables, accounts payable general ledger and other finance data.
• Partners with the Finance data steward to support data compilation, research and analysis, and provides user support for financial reporting applications across multiple finance publications.
• Maintains finance and investment reports and dashboards, leveraging SQL and reporting tools such as Spreadsheet Server, Workiva, Tableau, Alteryx, Business Objects, or similar applications.
• Monitors system processes and exception reporting in the following internal and external accounting interfaces between systems such as PeopleSoft Financials, ERS Online/Benefits, Eagle Investment Systems, Bank of New York (BNY) and Investment Accounting Reconciliations.

Benefits

• Flexible work schedules
• Telework may not be awarded as a condition of hiring, new employees complete a 30 day fully onsite period before evaluation for a telework agreement

Tagged as: Data Analysis