Investments Accounting Systems Analyst - Texas Remote

Investments Accounting Systems Analyst

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 transactionlevel 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

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