Investments Analyst

Investments Accounting Systems Analyst Austin, TX
General Description: ERS is undertaking projects to evaluate and implement modern Investment Accounting and Reconciliation Systems that will improve the accuracy, efficiency, transparency, and compliance of investment operations and financial reporting. The Worker will contribute to the Finance division s assessment of potential system solutions, lead requirements gathering, and support the system selection process.

Following evaluation, the Worker will assist in implementing the selected system in alignment with ERS
investment accounting and finance business needs. This role will involve close collaboration with stakeholders across Finance, Investments, IT, and external vendors and will provide advisory support to ERS Finance management throughout the lifecycle of the projects.

Functional responsibilities:
Coordinate with functional and technical teams on business processes requiring cross-functional collaboration related to investment accounting.
Analyze current-state investment reconciliation workflows and recommend improvements or automation
opportunities within the new system.
Identify system data requirements for investment-related general ledger entries, valuations, performance, and reconciliation functions.
Support the development and validation of reconciliation reports and exception-based workflows for
investment data (e.g., custodial bank records, and accounting entries).
Participate in internal and vendor-led meetings related to the design, development, and implementation of the Investment Accounting and Reconciliation System.
Document business and technical requirements, configuration decisions, testing plans, and user procedures related to the reconciliation system.
Serve as a Subject Matter Expert (SME) for investment accounting and reconciliation during system design sessions with vendors and ERS staff.
Translate complex investment business requirements such as multi-asset reconciliation and transaction-level matching into system specifications.
Collaborate with ERS and vendor teams to configure system modules for trade capture, income accruals, settlement processing, and reconciliation matching logic.
Assist in data conversion activities, including the setup of test environments populated with historical
investment balances and transactions.
Monitor functional and integration testing of the reconciliation engine and document results, ensuring
resolution of identified issues.
Design and propose solutions that align with ERS enterprise architecture, internal controls, and information security policies.
Adhere to ERS standard operating procedures related to approvals, reviews, change control, and agile
project governance.
Develop comprehensive system documentation and process diagrams using Microsoft Visio or Sparx
Enterprise Architect.
Create user training materials and conduct knowledge transfer to ERS Investment and Finance staff for
ongoing reconciliation system maintenance and operations.
Complete all required information security training as administered by ERS.

WORKER SKILLS AND QUALIFICATIONS

Minimum Required:
Years Skills/Experience
10 Experience in system or data analysis, including evaluating and reverse-engineering business processes

10 Experience identifying alternative system solutions and conducting feasibility analyses to support system selection

8 Experience in accounting or finance, specifically supporting or performing functions related to investment operations, reporting, or system integration.

6 Experience with ERP or specialized financial systems related to investment operations and reconciliation

Preferred

Experience with strategic analysis or planning methods such as business capability mapping, process modeling, or enterprise analysis to support alignment between business needs and system solutions
Experience working on technology projects with or within a state government agency
Experience in Microsoft Access, VBA, SQL, and XML for reconciliation,data transformation, or reporting in the financial domain.
Able to identify and define the tasks and deliverables to be incorporated into the overall solutions delivery work plan.
Demonstrated high level of integrity, ability to work with ambiguity, and strong sense of confidence to deliver on responsibilities.
Must have excellent documentation and communication skills.