Business Systems & Reporting Manager

The Phoenix Zoo; Phoenix (AZ); On-site; USD 84,000 - 105,000; Full time

Job summary

The Phoenix Zoo is seeking a Business Systems & Reporting Manager to oversee Galaxy ticketing systems, Salesforce, and the BI reporting stack. You will partner with the IT Director to analyze platforms, define business requirements, and implement improvements for efficiency and insight.

You will lead a small team, manage configurations, develop analytics, and train users on Tableau/SSRS/Power BI while ensuring data security and reliability.

Qualifications

• College degree in Computer Science, Information Technology or related field; 5 years related experience including 2 years leading a team.
• SQL certification or equivalent job experience required.
• Galaxy, Salesforce, and Tableau systems experience and certifications preferred.
• Ability to demonstrate basic PC desktop and hardware support troubleshooting skills.
• Ability to provide quality guest service to internal and external clients.
• Excellent written and verbal communications skills.
• Capable of being highly organized and efficient in a fast-paced, high-volume environment.
• Strong time management skills and ability to prioritize work.
• Ability to work well independently and in a team; build rapport with ACNC staff, members, donors and the general public.
• Ability to work occasional evenings and weekends.
• Ability to pass pre-employment background check and drug test.

Responsibilities

• Serve as primary system administrator for Galaxy and Salesforce.
• Configure, maintain and enhance the Galaxy ticketing system.
• Design and develop custom programming solutions within the Galaxy environment.
• Create and maintain ticketing products for admissions, memberships, and promotions.
• Develop and maintain Galaxy APIs, integrations, and third‑party interfaces.
• Develop reports in Tableau, SSRS, Power BI, and other BI tools.

Skills

SQL

Desktop troubleshooting

Guest service

Communication

Organization

Time management

Teamwork

Flexibility

Education

Bachelor's degree in Computer Science / Information Technology or related field

Tools

Galaxy

Salesforce

Tableau

Job description

Job Title: Business Systems & Reporting Manager

Department: Information Technology

Supervisor: Director of Information Technology

Supervises: Business Intelligence & Reporting Specialist, Business Systems Support Specialist

FLSA Status: Full Time, Regular, Exempt

Starting Salary: $84,321-$105,402 per year based on relevant experience and qualifications.

General Statement:

The Business Systems & Reporting Manager is responsible for the management and oversight of ACNC’s business critical systems, including Galaxy Ticketing Systems and SalesForce.

The BS&RM will work with the Director of Information Technology to analyze existing systems to identify areas for improvement, define associated business requirements, and provide solutions and recommend best practices that support organizational goals. In addition, this role manages and oversees the Business Systems ecosystem and related processes, ensuring effective system configuration, reporting and analytics development, ad-hoc SQL support, and end-user training.

Essential Duties:

• 1. Provides quality guest service to both internal and external guests by maintaining a WILD (friendly, helpful, positive and professional) working attitude and appearance.
• 2. Serves as the primary system administrator for Galaxy and Salesforce, which are ACNC’s current ticketing POS system and fundraising and development software.
• 3. Configures, maintains, and enhances the Galaxy ticketing system,
• 4. Designs and develops custom programming solutions within the Galaxy environment.
• 5. Creates and maintains ticketing products for general admission, membership, promotions, and packages.
• 6. Develops and maintains Galaxy APIs, integrations, and third-party interfaces.
• 7. Supports online ticket sales, group sales, memberships, special events, and point-of-sale operations.
• 8. Troubleshoots Galaxy application issues and coordinates with vendors when necessary.
• 9. Implements security controls, user roles, and system permissions.
• 10. Performs system testing and works closely with internal stakeholders to ensure training and testing is completed before deployment.
• 11. Leverages data analytics, reporting tools, and business intelligence platforms to transform organizational data into meaningful information that supports operational efficiency, financial sustainability, and strategic planning.
• 12. Creates and oversees Tableau, SSRS, Power BI or other reports to provide data driven insights, and implements and maintains system integrations to advance ACNC’s strategic goals.
• 13. Supervises Business Systems team with a focus on creating efficiencies, fostering collaboration, and developing talent, while consistently demonstrating strong leadership competencies and effectively leveraging soft skills such as communication, emotional intelligence, and adaptability to achieve organizational goals.
• 14. Responsible for the day-to-day operations, maintenance and future use of ACNC’s ticketing, fundraising and development software, and ecommerce related to these and other systems.
• 15. Analyzes existing systems for improvements, defines business requirements, and provides solutions and best practices.
• 16. Develops procedures and documentation to build organizational system knowledge and efficiency, which also serve as continuity tools related to intellectual assets.
• 17. Conducts ongoing configuration and monitoring of business-critical systems and related integrations. Maintains up to date test environments and develop test scripts to ensure thorough version evaluation.
• 18. Works with ACNC’s internal stakeholders to identify and prioritize reporting needs, and develops custom analytics to support the organization’s use of data driven insights
• 19. Documents business requirements and configures systems and related dependencies to support organizational needs.
• 20. Works with vendors to upgrade systems and remain up to date with current version releases.
• 21. Reviews documentation and identifies and implements new features that will improve organizational effectiveness and improve the user experience.
• 22. Assists the Director in supporting the efforts of all organizational units that rely on business system resources; including, Human Resources, Finance/Accounting, Guest Services, Membership, and Donor Relations.
• 23. Participates as an active member of user communities related to relevant systems and stays current while improving skills to add value to the organization.
• 24. Possesses a firm understanding of SQL concepts and continues to develop and grow this skill set.
• 25. Stays current on PCI requirements and maintains all elements of the environment in compliance with those standards.
• 26. Configures, administers, and supports the ecommerce sales environment, and has a solid understanding of related web technologies.
• 27. Configures, troubleshoots, and maintains all system related and custom hardware; including, ticket printers, scanners, PVC card printers, and receipt printers.

This is by no means an exhaustive list of all responsibilities, skills, duties, requirements, efforts, or working conditions associated with the job. Management reserves the right to revise the job or to require that other or different tasks be performed when circumstances change (e.g. emergencies, changes in personnel, workload, rush jobs, or technological developments.)

Qualifications:

• 1. College degree in Computer Science, Information Technology or related field preferred, and 5 years related experience including 2 years leading a team.
• 2. Relevant SQL certification or equivalent job experience required.
• 3. Galaxy, Salesforce, and Tableau systems experience and certifications preferred.
• 4. Ability to demonstrate basic PC desktop and hardware support troubleshooting skills.
• 5. Ability to provide quality guest service to both internal and external clients.
• 6. Excellent written and verbal communications skills.
• 7. Capable of being highly organized and efficient in a fast-paced, high volume work environment while maintaining accuracy.
• 8. Strong time management skills and ability to prioritize work.
• 9. Ability to work well both independently and within a team environment, and to establish and maintain excellent rapport with various individuals and groups including ACNC staff, members, donors and the general public.
• 10. Ability to work occasional evenings and weekends.
• 11. Ability to pass pre-employment background check and drug test.