Financial Business Analyst Sr.

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 states 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 Arizonas 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 States 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.

• 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 teams 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 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.

• Education & Professional Experience: A Bachelors 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

• 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:Drivers License Requirements.

All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).

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 programhere. For a complete list of benefits provided by The State of Arizona please visit our benefits page

• Participation in ASRS Lifetime Benefit Pension Plan after 26 weeks of employment

• If you have any questions please feel free to contact Christopher Langseth at for assistance.
• The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer.