Overview
Skills
Job Details
100% Remote - Opening for CGI Advantage Analyst (ERP Integration Lead Analyst)
Introduction:
As a CGI Advantage Analyst (ERP Integration Lead Analyst), you will play a critical role in supporting the implementation and integration of the CAPPS STARR system, SaaS solution (Advantage) provided by the vendor CGI. This position collaborates closely with both CPA Information Technology and Fiscal Management teams to analyze, document, and validate system and reporting requirements ensuring alignment with enterprise architecture and business needs.
The analyst will support system integration efforts with legacy platforms such as USAS and TINS, coordinate technical discussions, requirements gathering sessions, and translate business needs into clear technical specifications. Vendor coordination and lifecycle support are essential components of this role.
Responsibilities:
- Provide advanced support and enhancement for financial systems, including general ledger and reporting functions within a SaaS ERP platform.
- Collaborate with internal and external teams to analyze requirements and deliver technical solutions aligned with financial business processes.
- Analyze system architecture and data flows to support financial integrations, configuration decisions, performance tuning, and issue resolution.
- Design, implement, and maintain financial data integrations, including ETL processes, APIs, web services, and secure file exchanges between CGI Advantage and external enterprise systems.
- Manage and troubleshoot financial inbound and outbound interfaces, ensuring reconciliation, auditability, and compliance with Interface Control Documents (ICDs).
- Develop, manage, and support financial reporting and dashboards using Power BI and Advantage-native reporting tools to ensure accurate, timely financial data delivery.
- Perform complex troubleshooting of financial transactions, balances, and data discrepancies, coordinating across application, infrastructure, security, and vendor teams.
- Support integration testing, regression testing, and User Acceptance Testing (UAT) for financial system changes, including validation of financial calculations, posting logic, and reporting outputs.
- Document technical designs, financial data mappings, test results, and resolution outcomes in accordance with CPA documentation standards.
- Ensure system security, access controls, and data transmission processes meet CPA and state financial compliance standards, including secure handling of sensitive financial data.
- Participate in Agile supporting sprint planning, defect triage, and continuous improvement initiatives.
- Participate in an on-call rotation to support financial system availability and critical processing cycles.
Requirements:
Required Skills:
- Knowledge of configuration vs. customization boundaries in SaaS environments.
- Familiarity with CGI Advantage Admin tools and role/permission management.
- Proficiency in managing and troubleshooting inbound/outbound data interfaces, including knowledge of interface control documents (ICDs).
- Working knowledge of middleware platforms or tools for API orchestration (e.g., Apache Camel).
- Experience with Power BI, or Advantage-native reporting tools (e.g., Advantage Insight, Data View, or other embedded BI).
- Familiarity with Test Savvy or similar platforms used for SaaS regression and UAT tracking.
- Ability to create test scenarios, test scripts, and validate system outputs based on business requirements.
- SQL for data validation and queries.
- Microsoft Excel and macros for data preparation.
- SFTP/PGP tools for secure file exchanges.
Preferred Skills:
- Experience with Jira and Confluence.
- Knowledge of Snowflake or similar cloud-based data platforms.
- Experience designing or supporting Power BI dashboards or Advantage-native reporting tools.
- Experience using SaaS testing tools, such as Test Savvy, for regression and UAT tracking.
- Knowledge of USAS, TINS, and SPA legacy financial systems.