Financial Business Analyst Sr.

ARIZONA DEPARTMENT OF ADMINISTRATION Delivering results that matter by providing best in class support services. Financial Business Analyst Sr. Job Location: Enterprise Resource Planning (ERP) Division Primarily remote, with on-site attendance as required at times Remote work is within Arizona and is based upon the department's business needs and continual meeting of expected performance measures Main Office Location: 100 N 15th Ave, Ste 302, Phoenix, AZ 85007 Posting Details: Salary: Up to $93,251 Grade: 26 Open Until Business Needs Are Met Job Summary: The Arizona Department of Administration (ADOA), Enterprise Resource Planning (ERP) Division is seeking a dedicated and highly skilled Senior Business Analyst to provide advanced technical and functional expertise across the state’s comprehensive AZ360 Financial (FIN) software suite (CGI Advantage). In this critical role, the selected candidate will ensure systemic stability, operational efficiency, and standard compliance across core ledger operations, transactional processing, and specialized asset and funding modules. Operating at the intersection of data analytics and state financial operations, the Senior Business Analyst will craft ad hoc T-SQL queries, perform complex database extractions, and translate transactional data into strategic continuous process improvement initiatives across the enterprise. Candidates must possess advanced hands-on SQL capabilities, as a technical SQL skills assessment will be administered during the interview process to evaluate competency. Additionally, this position serves as the designated Lead Business Analyst on high-priority, cross-functional enterprise initiatives, spearheading the complex integration of external applications, data pipelines, and third-party vendor solutions into the AZ360 FIN (CGI Advantage) operational ecosystem. Functioning simultaneously as the Lead Testing Analyst, the incumbent will orchestrate robust quality assurance protocols, conduct release validation testing, and manage end-to-end defect tracking for major statewide system upgrades and custom patch deployments. The ERP Division invites analytical, results-driven leaders eager to maintain data integrity, drive innovation, and safeguard the stability of Arizona’s financial infrastructure to apply. The State of Arizona strives for a work culture that affords employees flexibility, autonomy, and trust. Across our many agencies, boards, and commissions, many State employees participate in the State’s Remote Work Program and are able to work remotely in their homes, in offices, and in hoteling spaces. All work, including remote work, should be performed within Arizona unless an exception is properly authorized in advance. Job Duties: Enterprise AZ360 Financial System Support: Serve as the primary functional analyst providing Tier-3 configuration and optimization support across all 28 integrated AZ360 Financial (CGI Advantage) operational subsystems, including core ledger controls, transactional processing, treasury, asset management, and lifecycle management modules. System Architecture Optimization: Conduct complex system impact analyses, execute routine configuration updates, and implement authorized designer changes to optimize statewide financial architecture and prevent modular silos. Agency Consultation & Parameter Triage: Consult with state agencies and business units to troubleshoot, refine, and align system parameters with evolving financial regulations, reporting requirements, and statewide accounting policies. Independently author, debug, and execute complex T-SQL queries and database extractions without reliance on database administrators to deliver ad hoc reporting. Test Execution Lead & Defect Governance: Serve as a functional lead providing task assignment and guidance to testing staff; lead Quality Assurance (QA), regression, and User Acceptance Testing (UAT) cycles for upgrades, custom patches, and emergency scripts. ServiceNow & Ticket Lifecycle Management: Oversee the team’s ServiceNow queue to triage, track, and resolve system tickets; govern the end-to-end defect tracking lifecycle, perform root-cause analysis, and represent the team during Change Control Board reviews. Statewide Initiative & Training Support: Coordinate project deliverables for the Arizona Management System (AMS), collaborate cross-functionally to design module training content, and author executive briefings, presentations, and technical documentation. System Integration Project Leadership: Lead cross-system integration projects by facilitating gap analyses, requirement matrices, and interface design sessions with internal IT, state agencies, and external vendors to maintain seamless data pipelines. Operational Flexibility: Maintain flexibility to work non-standard hours, including evenings and weekends, to support mission-critical system deployments, emergency patches, and strict fiscal year-end deadlines. Knowledge, Skills & Abilities (KSAs): Knowledge of: The integrated functionality, transactional logic, database schema relationships, and accounting controls across all core enterprise resource planning (ERP) modules and financial sub-systems. Relational database structures, enterprise data dictionaries, query optimization models, and standard T-SQL database syntax patterns within an ERP financial warehouse framework. Software Testing Life Cycle (STLC) frameworks, structured QA governance, release management practices, and defect tracking metrics (severity vs. priority) within an enterprise environment. Principles, lifecycle phases, and testing methodologies for data mapping, system integrations, and interface validation protocols between external applications and enterprise core ledgers. Skills in: Navigating, querying, and analyzing application tables and transactional workflows across overlapping financial functional domains to perform system configuration and maintenance. Advanced, hands-on mastery in writing, debugging, optimizing, and executing complex T-SQL queries (including nested joins, subqueries, and aggregations) to extract data from deep ERP financial warehouses. Structuring validation testing pipelines, running complex test scripts, and tracking software errors using enterprise issue-management tools (such as Jira or ServiceNow). Leading cross-functional project teams through complex software changes, identifying integration constraints, and mapping downstream impacts. Ability to: Analyze intricate financial process failures, isolate code errors from configuration faults, and recommend long-term system remediations. Analyze disjointed transactional data to spot bottlenecks, define foundational KPI metrics, and establish objective metrics to evaluate agency operational performance. Lead diverse user-group validation initiatives under compressed release windows and write clear, actionable defect logs for development teams. Manage competing project timelines, balance system upgrade priorities, and translate technical language for business stakeholders. Selective Preference(s): Education & Professional Experience: A Bachelor’s degree from an accredited college or university in Business Administration, Finance, Accounting, Management Information Systems (MIS), or a closely related field; OR five (5) years of progressive, professional-level experience in business analysis, system analysis, or financial systems operations. Preferred System Experience: Documented experience configuring, maintaining, or supporting public sector Enterprise Resource Planning (ERP) systems (e.g., CGI Advantage). Functional Domain Expertise: Strong hands-on background supporting financial management, cost accounting, budgetary control, or procurement modules within a complex enterprise environment Pre-Employment Requirements: Background and reference check, including state and federal criminal records fingerprint check If this position requires driving or the use of a vehicle as an essential function of the job to conduct State business, then the following requirements apply: Driver’s License Requirements. All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify). Benefits: The Arizona Department of Administration offers a comprehensive benefits package to include: Sick leave Vacation with 10 paid holidays per year Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child (pilot program) Health and dental insurance Retirement plan Life insurance and long-term disability insurance Optional employee benefits include short-term disability insurance, deferred compensation plans, and supplemental life insurance By providing the option of a full-time or part-time remote work schedule, employees enjoy improved work/life balance, report higher job satisfaction, and are more productive. Remote work is a management option and not an employee entitlement or right. An agency may terminate a remote work agreement at its discretion. Learn more about the Paid Parental Leave program here . For a complete list of benefits provided by The State of Arizona, please visit our benefits page Retirement : Participation in ASRS Lifetime Benefit Pension Plan after 26 weeks of employment Contact Us: If you have any questions please feel free to contact Christopher Langseth at [email protected] for assistance. The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer.